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 2390: ,(SELECT pvs.party_site_id from po_vendor_sites_all pvs --rndg_ship_from_party_site_id

2386: AND rownum=1),
2387: null)
2388: -- Bug 5025018. Updated tax attribute mappings
2389: ,ph.org_id --rounding_bill_to_party_id
2390: ,(SELECT pvs.party_site_id from po_vendor_sites_all pvs --rndg_ship_from_party_site_id
2391: WHERE pvs.vendor_site_id=ph.vendor_site_id)
2392: FROM po_headers_all ph, zx_lines_det_factors zxldet, fnd_currencies fc
2393: WHERE ph.po_header_id = p_po_header_id_tbl(i)
2394: AND fc.currency_code = ph.currency_code

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

2494: AND rownum=1),
2495: null)
2496: -- Bug 5025018. Updated tax attribute mappings
2497: ,ph.org_id --rounding_bill_to_party_id
2498: ,(SELECT pvs.party_site_id from po_vendor_sites_all pvs --rndg_ship_from_party_site_id
2499: WHERE pvs.vendor_site_id=ph.vendor_site_id)
2500: FROM po_headers_all ph, fnd_currencies fc
2501: WHERE ph.po_header_id = p_po_header_id
2502: AND fc.currency_code = ph.currency_code;

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

2599: AND rownum=1),
2600: null)
2601: -- Bug 5025018. Updated tax attribute mappings
2602: ,pr.org_id --rounding_bill_to_party_id
2603: ,(SELECT pvs.party_site_id from po_vendor_sites_all pvs --rndg_ship_from_party_site_id
2604: WHERE pvs.vendor_site_id=ph.vendor_site_id)
2605: -- Using OUTER JOIN in FROM clause syntax here because (+) operator
2606: -- is not flexible enough to be used inside an OR condition
2607: FROM po_headers_all ph

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

2722: AND rownum=1),
2723: null)
2724: -- Bug 5025018. Updated tax attribute mappings
2725: ,ph.org_id --rounding_bill_to_party_id
2726: ,(SELECT pvs.party_site_id from po_vendor_sites_all pvs --rndg_ship_from_party_site_id
2727: WHERE pvs.vendor_site_id=ph.vendor_site_id)
2728: FROM po_releases_all pr, po_headers_all ph, fnd_currencies fc
2729: WHERE pr.po_release_id = p_po_release_id
2730: AND pr.po_header_id = ph.po_header_id

Line 2967: ,(SELECT pvs.location_id from po_vendor_sites_all pvs /* 6524317 - Passing Location Id as Bill From Location Id */

2963: ,(SELECT hzps.location_id --ship_from_location_id
2964: FROM hz_party_sites hzps
2965: WHERE hzps.party_site_id = pvs.party_site_id)
2966: ,ph.bill_to_location_id --bill_to_location_id
2967: ,(SELECT pvs.location_id from po_vendor_sites_all pvs /* 6524317 - Passing Location Id as Bill From Location Id */
2968: WHERE pvs.vendor_site_id=ph.vendor_site_id)
2969: -- Get account id from first distribution, if created
2970: -- otherwise from the expense account of the item
2971: ,NVL((SELECT pd.code_combination_id --account_ccid

Line 3104: po_vendor_sites_all pvs, mtl_system_items_b msib

3100: AND pll.tax_name IS NOT NULL)
3101: ,pll.ship_to_organization_id --Bug#6902111
3102: FROM po_headers_all ph, po_lines_all pl, po_line_locations_all pll,
3103: zx_lines_det_factors zxldet, po_vendors pv,
3104: po_vendor_sites_all pvs, mtl_system_items_b msib
3105: WHERE ph.po_header_id = pll.po_header_id
3106: AND pl.po_line_id = pll.po_line_id
3107: AND pll.tax_attribute_update_code IS NOT NULL
3108: AND pll.tax_attribute_update_code <> 'DIST_DELETE'

Line 3270: ,(SELECT pvs.location_id from po_vendor_sites_all pvs /* 6524317 - Passing Location Id as Bill From Location Id */

3266: ,(SELECT hzps.location_id --ship_from_location_id
3267: FROM hz_party_sites hzps
3268: WHERE hzps.party_site_id = pvs.party_site_id)
3269: ,ph.bill_to_location_id --bill_to_location_id
3270: ,(SELECT pvs.location_id from po_vendor_sites_all pvs /* 6524317 - Passing Location Id as Bill From Location Id */
3271: WHERE pvs.vendor_site_id=ph.vendor_site_id)
3272: -- Get account id from first distribution, if created
3273: -- otherwise from the expense account of the item
3274: ,NVL((SELECT pd.code_combination_id --account_ccid

Line 3400: LEFT OUTER JOIN po_vendor_sites_all pvs

3396: FROM po_releases_all pr
3397: ,po_headers_all ph
3398: -- Join with vendor tables to get party and party site information
3399: LEFT OUTER JOIN po_vendors pov ON (ph.vendor_id = pov.vendor_id)
3400: LEFT OUTER JOIN po_vendor_sites_all pvs
3401: ON (ph.vendor_site_id = pvs.vendor_site_id)
3402: ,po_lines_all pl--Blanket/Scheduled header and line
3403: -- Join with items table for item information
3404: LEFT OUTER JOIN mtl_system_items_b msib

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

3663: WHERE p_calling_program = 'REQIMPORT'
3664: AND prl.tax_name IS NOT NULL)
3665: ,prl.destination_organization_id --Bug#6902111
3666: FROM po_requisition_headers_all prh, po_requisition_lines_all prl,
3667: zx_lines_det_factors zxldet, po_vendors pv, po_vendor_sites_all pvs,
3668: mtl_system_items_b msib, fnd_currencies fc
3669: WHERE prh.requisition_header_id = p_requisition_header_id
3670: AND prh.requisition_header_id = prl.requisition_header_id
3671: -- Conditions for getting Additional Tax Attributes