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 PO_VENDOR_SITES_ALL

Line 2575: ,(SELECT pvs.party_site_id from po_vendor_sites_all pvs --rndg_ship_from_party_site_id

2571: AND rownum=1),
2572: null)
2573: -- Bug 5025018. Updated tax attribute mappings
2574: ,ph.org_id --rounding_bill_to_party_id
2575: ,(SELECT pvs.party_site_id from po_vendor_sites_all pvs --rndg_ship_from_party_site_id
2576: WHERE pvs.vendor_site_id=ph.vendor_site_id)
2577: FROM po_headers_all ph, zx_lines_det_factors zxldet, fnd_currencies fc
2578: WHERE ph.po_header_id = p_po_header_id_tbl(i)
2579: AND fc.currency_code = ph.currency_code

Line 2683: ,(SELECT pvs.party_site_id from po_vendor_sites_all pvs --rndg_ship_from_party_site_id

2679: AND rownum=1),
2680: null)
2681: -- Bug 5025018. Updated tax attribute mappings
2682: ,ph.org_id --rounding_bill_to_party_id
2683: ,(SELECT pvs.party_site_id from po_vendor_sites_all pvs --rndg_ship_from_party_site_id
2684: WHERE pvs.vendor_site_id=ph.vendor_site_id)
2685: FROM po_headers_all ph, fnd_currencies fc
2686: WHERE ph.po_header_id = p_po_header_id
2687: AND fc.currency_code = ph.currency_code;

Line 2788: ,(SELECT pvs.party_site_id from po_vendor_sites_all pvs --rndg_ship_from_party_site_id

2784: AND rownum=1),
2785: null)
2786: -- Bug 5025018. Updated tax attribute mappings
2787: ,pr.org_id --rounding_bill_to_party_id
2788: ,(SELECT pvs.party_site_id from po_vendor_sites_all pvs --rndg_ship_from_party_site_id
2789: WHERE pvs.vendor_site_id=ph.vendor_site_id)
2790: -- Using OUTER JOIN in FROM clause syntax here because (+) operator
2791: -- is not flexible enough to be used inside an OR condition
2792: FROM po_headers_all ph

Line 2911: ,(SELECT pvs.party_site_id from po_vendor_sites_all pvs --rndg_ship_from_party_site_id

2907: AND rownum=1),
2908: null)
2909: -- Bug 5025018. Updated tax attribute mappings
2910: ,ph.org_id --rounding_bill_to_party_id
2911: ,(SELECT pvs.party_site_id from po_vendor_sites_all pvs --rndg_ship_from_party_site_id
2912: WHERE pvs.vendor_site_id=ph.vendor_site_id)
2913: FROM po_releases_all pr, po_headers_all ph, fnd_currencies fc
2914: WHERE pr.po_release_id = p_po_release_id
2915: AND pr.po_header_id = ph.po_header_id

Line 3158: ,(SELECT pvs.location_id from po_vendor_sites_all pvs /* 6524317 - Passing Location Id as Bill From 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)
3160: -- Get account id from first distribution, if created
3161: -- otherwise from the expense account of the item
3162: ,NVL((SELECT pd.code_combination_id --account_ccid

Line 3295: po_vendor_sites_all pvs, mtl_system_items_b msib

3291: AND pll.tax_name IS NOT NULL)
3292: ,pll.ship_to_organization_id --Bug#6902111
3293: FROM po_headers_all ph, po_lines_all pl, po_line_locations_all pll,
3294: zx_lines_det_factors zxldet, po_vendors pv,
3295: po_vendor_sites_all pvs, mtl_system_items_b msib
3296: WHERE ph.po_header_id = pll.po_header_id
3297: AND pl.po_line_id = pll.po_line_id
3298: ---Bug# 13091627 : Condition added to exclude the Release shipments for BLANKET/PLANNED PO
3299: AND pll.po_release_id IS NULL

Line 3474: ,(SELECT pvs.location_id from po_vendor_sites_all pvs /* 6524317 - Passing Location Id as Bill From 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)
3476: -- Get account id from first distribution, if created
3477: -- otherwise from the expense account of the item
3478: ,NVL((SELECT pd.code_combination_id --account_ccid

Line 3604: LEFT OUTER JOIN po_vendor_sites_all pvs

3600: FROM po_releases_all pr
3601: ,po_headers_all ph
3602: -- Join with vendor tables to get party and party site information
3603: LEFT OUTER JOIN po_vendors pov ON (ph.vendor_id = pov.vendor_id)
3604: LEFT OUTER JOIN po_vendor_sites_all pvs
3605: ON (ph.vendor_site_id = pvs.vendor_site_id)
3606: ,po_lines_all pl--Blanket/Scheduled header and line
3607: -- Join with items table for item information
3608: LEFT OUTER JOIN mtl_system_items_b msib

Line 3818: ,(SELECT pvs.location_id from po_vendor_sites_all pvs /* 6524317 - Passing Location Id as Bill From 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)
3820: -- Get account id from first distribution, if created
3821: -- otherwise from the expense account of the item
3822: ,NVL((SELECT pd.code_combination_id --account_ccid

Line 3955: po_vendor_sites_all pvs, mtl_system_items_b msib

3951: AND pll.tax_name IS NOT NULL)
3952: ,pll.ship_to_organization_id --Bug#6902111
3953: FROM po_headers_all ph, po_lines_all pl, po_line_locations_all pll,
3954: zx_lines_det_factors zxldet, po_vendors pv,
3955: po_vendor_sites_all pvs, mtl_system_items_b msib
3956: WHERE ph.po_header_id = pll.po_header_id
3957: AND pl.po_line_id = pll.po_line_id
3958: ---Bug# 13091627 : Condition added to exclude the Release shipments for BLANKET/PLANNED PO
3959: AND pll.po_release_id IS NULL

Line 4130: ,(SELECT pvs.location_id from po_vendor_sites_all pvs /* 6524317 - Passing Location Id as Bill From 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)
4132: -- Get account id from first distribution, if created
4133: -- otherwise from the expense account of the item
4134: ,NVL((SELECT pd.code_combination_id --account_ccid

Line 4260: LEFT OUTER JOIN po_vendor_sites_all pvs

4256: FROM po_releases_all pr
4257: ,po_headers_all ph
4258: -- Join with vendor tables to get party and party site information
4259: LEFT OUTER JOIN po_vendors pov ON (ph.vendor_id = pov.vendor_id)
4260: LEFT OUTER JOIN po_vendor_sites_all pvs
4261: ON (ph.vendor_site_id = pvs.vendor_site_id)
4262: ,po_lines_all pl--Blanket/Scheduled header and line
4263: -- Join with items table for item information
4264: LEFT OUTER JOIN mtl_system_items_b msib

Line 4465: , (SELECT pvs.location_id from po_vendor_sites_all pvs /* 8752470 - Passing Location Id as Bill 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
4468: ,prl.vendor_site_id --ship_third_pty_acct_site_id
4469: ,null --historical_flag

Line 4551: zx_lines_det_factors zxldet, po_vendors pv, po_vendor_sites_all pvs,

4547: 'REQUISITION_MODIFY', zxldet.user_upd_det_factors_flag,
4548: 'REQIMPORT', NVL2(PRL.TAX_NAME,'Y',NULL))
4549: ,prl.destination_organization_id --Bug#6902111
4550: FROM po_requisition_headers_all prh, po_requisition_lines_all prl,
4551: zx_lines_det_factors zxldet, po_vendors pv, po_vendor_sites_all pvs,
4552: mtl_system_items_b msib, fnd_currencies fc
4553: WHERE prh.requisition_header_id = p_requisition_header_id
4554: AND prh.requisition_header_id = prl.requisition_header_id
4555: -- Conditions for getting Additional Tax Attributes