DBA Data[Home] [Help]

APPS.PO_TAX_INTERFACE_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 4463: ,(SELECT location_id FROM hr_all_organization_units --bill_to_location_id

4459: ,prl.deliver_to_location_id --ship_to_location_id
4460: ,(SELECT hzps.location_id --ship_from_location_id
4461: FROM hz_party_sites hzps
4462: WHERE hzps.party_site_id = pvs.party_site_id)
4463: ,(SELECT location_id FROM hr_all_organization_units --bill_to_location_id
4464: WHERE organization_id=prh.org_id)
4465: , (SELECT pvs.location_id from po_vendor_sites_all pvs /* 8752470 - Passing Location Id as Bill From Location Id */
4466: WHERE pvs.vendor_site_id=prl.vendor_site_id)
4467: ,prl.vendor_id --ship_third_pty_acct_id