DBA Data[Home] [Help]

APPS.XLE_THIRDPARTY dependencies on PO_VENDOR_SITES_ALL

Line 70: FROM PO_VENDOR_SITES_ALL pvs,

66: pvs.zip,
67: pvs.province,
68: pvs.country,
69: pvs.state
70: FROM PO_VENDOR_SITES_ALL pvs,
71: PO_VENDORS pv
72: WHERE pv.vendor_id=p_business_entity_id
73: AND pvs.vendor_site_id=p_business_entity_site_id
74: AND pvs.country=p_country

Line 92: FROM PO_VENDOR_SITES_ALL pvs,

88: pvs.zip,
89: pvs.province,
90: pvs.country,
91: pvs.state
92: FROM PO_VENDOR_SITES_ALL pvs,
93: PO_VENDORS pv
94: WHERE pv.vendor_id=p_business_entity_id
95: AND pvs.tax_reporting_site_flag='Y'
96: AND pvs.country=p_country