Oracle Reports (MOSC)

MOSC Banner

How to reference Parameters in submit request screen

edited Sep 22, 2013 9:28AM in Oracle Reports (MOSC) 4 commentsAnswered ✓
I have developed a custom report and i deployed it in E-business Suite ,Payable responsibilityalso i created many parameter for this report for example
 (organization_id , supplier_no , supplier_site_no)

after that i designed LOV or value set for every parameter through the responsibility System Admin. in oracle EBS
What i need now is how to reference column in value set or LOV with the previous LOV

for instance :
the first LOV that retrieve the supplier_no as following :
   
  select VENDOR_ID,segment1,VENDOR_NAME  
                from ap_suppliers 

the second LOV that retrieve the supplier_site as following 

    select VENDOR_SITE_ID,VENDOR_SITE_CODE  from

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center