eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_TAX_INTERFACE_PVT dependencies on HZ_PARTY_SITES

Line 3155: FROM hz_party_sites hzps

3151: ,pvs.party_site_id --ship_from_party_site_id
3152: ,pvs.party_site_id --bill_from_party_site_id
3153: ,pll.ship_to_location_id --ship_to_location_id
3154: ,(SELECT hzps.location_id --ship_from_location_id
3155: FROM hz_party_sites hzps
3156: WHERE hzps.party_site_id = pvs.party_site_id)
3157: ,ph.bill_to_location_id --bill_to_location_id
3158: ,(SELECT pvs.location_id from po_vendor_sites_all pvs /* 6524317 - Passing Location Id as Bill From Location Id */
3159: WHERE pvs.vendor_site_id=ph.vendor_site_id)

Line 3471: FROM hz_party_sites hzps

3467: ,pvs.party_site_id --ship_from_party_site_id
3468: ,pvs.party_site_id --bill_from_party_site_id
3469: ,pll.ship_to_location_id --ship_to_location_id
3470: ,(SELECT hzps.location_id --ship_from_location_id
3471: FROM hz_party_sites hzps
3472: WHERE hzps.party_site_id = pvs.party_site_id)
3473: ,ph.bill_to_location_id --bill_to_location_id
3474: ,(SELECT pvs.location_id from po_vendor_sites_all pvs /* 6524317 - Passing Location Id as Bill From Location Id */
3475: WHERE pvs.vendor_site_id=ph.vendor_site_id)

Line 3815: FROM hz_party_sites hzps

3811: ,pvs.party_site_id --ship_from_party_site_id
3812: ,pvs.party_site_id --bill_from_party_site_id
3813: ,pll.ship_to_location_id --ship_to_location_id
3814: ,(SELECT hzps.location_id --ship_from_location_id
3815: FROM hz_party_sites hzps
3816: WHERE hzps.party_site_id = pvs.party_site_id)
3817: ,ph.bill_to_location_id --bill_to_location_id
3818: ,(SELECT pvs.location_id from po_vendor_sites_all pvs /* 6524317 - Passing Location Id as Bill From Location Id */
3819: WHERE pvs.vendor_site_id=ph.vendor_site_id)

Line 4127: FROM hz_party_sites hzps

4123: ,pvs.party_site_id --ship_from_party_site_id
4124: ,pvs.party_site_id --bill_from_party_site_id
4125: ,pll.ship_to_location_id --ship_to_location_id
4126: ,(SELECT hzps.location_id --ship_from_location_id
4127: FROM hz_party_sites hzps
4128: WHERE hzps.party_site_id = pvs.party_site_id)
4129: ,ph.bill_to_location_id --bill_to_location_id
4130: ,(SELECT pvs.location_id from po_vendor_sites_all pvs /* 6524317 - Passing Location Id as Bill From Location Id */
4131: WHERE pvs.vendor_site_id=ph.vendor_site_id)

Line 4461: FROM hz_party_sites hzps

4457: ,pvs.party_site_id --ship_from_party_site_id
4458: ,pvs.party_site_id --bill_from_party_site_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 */