DBA Data[Home] [Help]

APPS.PO_ASL_API_PUB dependencies on PO_VENDOR_SITES_ALL

Line 1442: FROM po_vendor_sites_all pvs

1438:
1439: UPDATE po_approved_supplier_list_gt past
1440: SET past.vendor_site_id =
1441: (SELECT pvs.vendor_site_id
1442: FROM po_vendor_sites_all pvs
1443: WHERE pvs.vendor_site_code = past.vendor_site_dsp
1444: AND pvs.vendor_id = past.vendor_id
1445: AND pvs.org_id = past.owning_organization_id
1446: AND ROWNUM < 2)

Line 1740: FROM po_vendor_sites_all pvs

1736:
1737: UPDATE po_asl_attributes_gt paa
1738: SET paa.vendor_site_id =
1739: (SELECT pvs.vendor_site_id
1740: FROM po_vendor_sites_all pvs
1741: WHERE pvs.vendor_site_code = paa.vendor_site_dsp
1742: AND pvs.vendor_id = paa.vendor_id
1743: AND pvs.org_id IN
1744: (SELECT owning_organization_id