Creating Dependent Parameters In Oracle EBS R12 Reports

 

Creating Dependent Parameters In Oracle EBS R12 Reports

Query For Report :

Select     asup.vendor_id,     asup.vendor_name,     asup.segment1,     aia.invoice_num,     aia.invoice_amount from     ap_suppliers asup,     ap_invoices_all aia Where     1=1     and asup.vendor_id=aia.vendor_id     and asup.vendor_id=NVL(:P_SUP_NAME,asup.vendor_id)     and aia.invoice_id=NVL(:P_INV_NUM,aia.invoice_id)     ;

 

 

XX_SUP_NAME

Char

240

Table

 

AP_SUPPLIERS

VENDOR_NAME  Varchar2  240

VENDOR_ID  Number 20

SEGMENT1

 

 

 

 

 

 

 

 

 

 

 

XX_INV

Char

50

Table

 

AP_INVOICES_ALL

INVOICE_NUM   Varchar2   240

INVOICE_ID   Number  22

Where/Order By : WHERE VENDOR_ID = :$FLEX$.XX_SUP_NAME