Dependent Parameters in Oracle BIP
This video explain how to create dependent parameters for data set in Oracle Fusion BIP.
#OracleBIP
#OracleFusion
#OracleReporting
#Oracle
Link for the Oracle Fusion Tables video : • Navigation for Oracle Fusion Tables and We...
Main Extraction Query:
SELECT psv.vendor_name,
hps.party_site_name "Address Name",
hp.Country,
hp.Address1,
hp.Address2,
hp.Address3,
hp.address4,
hp.city,
hp.postal_code,
hp.state,
hp.province,
hp.county,
hp.email_address,
hpsu.SITE_USE_TYPE,
hpsu.status
FROM poz_suppliers_v psv,
HZ_PARTY_SITES hps,
hz_parties hp ,
HZ_PARTY_SITE_USES hpsu
WHERE psv.party_id =hps.party_id
AND hps.party_id =hp.party_id
AND hp.IDEN_ADDR_PARTY_SITE_ID = hpsu.party_site_id
AND psv.vendor_name = nvl(:P_Supplier_Name, psv.vendor_name)
AND hps.party_site_name = nvl(:P_Supplier_Address, hps.party_site_name)
Supplier LOV:
Select psv.vendor_name from poz_suppliers_v psv
Supplier Address LOV:
Select hps.party_site_name
from HZ_PARTY_SITES hps,
poz_suppliers_v psv where
hps.party_id = psv.party_id
and psv.vendor_name = :P_Supplier_Name