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.

[Home] [Help]

APPS.PO_TAX_INTERFACE_PVT dependencies on PO_VENDORS

Line 2368: ,(SELECT pv.party_id FROM po_vendors pv --rounding_ship_from_party_id

2364: --Bug 5474336. Pass mau to EBTax
2365: ,fc.minimum_accountable_unit --minimum_accountable_unit
2366: ,NVL(fc.precision, 2) --precision
2367: ,PO_CORE_S.get_default_legal_entity_id(ph.org_id) --legal_entity_id
2368: ,(SELECT pv.party_id FROM po_vendors pv --rounding_ship_from_party_id
2369: WHERE pv.vendor_id=ph.vendor_id)
2370: ,DECODE(p_calling_program, --default_taxation_country
2371: 'COPY_DOCUMENT', null,
2372: zxldet.default_taxation_country)

Line 2480: ,(SELECT pv.party_id FROM po_vendors pv --rounding_ship_from_party_id

2476: --Bug 5474336. Pass mau to EBTax
2477: ,fc.minimum_accountable_unit --minimum_accountable_unit
2478: ,NVL(fc.precision, 2) --precision
2479: ,PO_CORE_S.get_default_legal_entity_id(ph.org_id) --legal_entity_id
2480: ,(SELECT pv.party_id FROM po_vendors pv --rounding_ship_from_party_id
2481: WHERE pv.vendor_id=ph.vendor_id)
2482: ,null --default_taxation_country
2483: ,'N' --quote_flag
2484: ,ph.segment1 --trx_number

Line 2585: ,(SELECT pv.party_id FROM po_vendors pv --rounding_ship_from_party_id

2581: --Bug 5474336. Pass mau to EBTax
2582: ,fc.minimum_accountable_unit --minimum_accountable_unit
2583: ,NVL(fc.precision, 2) --precision
2584: ,PO_CORE_S.get_default_legal_entity_id(pr.org_id) --legal_entity_id
2585: ,(SELECT pv.party_id FROM po_vendors pv --rounding_ship_from_party_id
2586: WHERE pv.vendor_id=ph.vendor_id)
2587: ,zxldet.default_taxation_country --default_taxation_country
2588: ,'N' --quote_flag
2589: ,ph.segment1 --trx_number

Line 2708: ,(SELECT pv.party_id FROM po_vendors pv --rounding_ship_from_party_id

2704: --Bug 5474336. Pass mau to EBTax
2705: ,fc.minimum_accountable_unit --minimum_accountable_unit
2706: ,NVL(fc.precision, 2) --precision
2707: ,PO_CORE_S.get_default_legal_entity_id(pr.org_id) --legal_entity_id
2708: ,(SELECT pv.party_id FROM po_vendors pv --rounding_ship_from_party_id
2709: WHERE pv.vendor_id=ph.vendor_id)
2710: ,null --default_taxation_country
2711: ,'N' --quote_flag
2712: ,ph.segment1 --trx_number

Line 3103: zx_lines_det_factors zxldet, po_vendors pv,

3099: WHERE p_calling_program = 'PDOI'
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

Line 3399: LEFT OUTER JOIN po_vendors pov ON (ph.vendor_id = pov.vendor_id)

3395: -- is not flexible enough to be used inside an OR condition
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

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

Line 5862: (SELECT party_id FROM po_vendors --rounding_ship_from_party_id

5858: PO_CONSTANTS_SV.PO_ADJUSTED,
5859: ph.po_header_id,
5860: sysdate, -- dummy value
5861: PO_CORE_S.get_default_legal_entity_id(ph.org_id),
5862: (SELECT party_id FROM po_vendors --rounding_ship_from_party_id
5863: WHERE vendor_id=ph.vendor_id)
5864: FROM po_headers_all ph
5865: WHERE ph.po_header_id = p_document_id;
5866:

Line 5943: (SELECT party_id FROM po_vendors --rounding_ship_from_party_id

5939: PO_CONSTANTS_SV.PO_ADJUSTED,
5940: ph.po_header_id,
5941: sysdate, -- dummy value
5942: PO_CORE_S.get_default_legal_entity_id(ph.org_id),
5943: (SELECT party_id FROM po_vendors --rounding_ship_from_party_id
5944: WHERE vendor_id=ph.vendor_id)
5945: FROM po_headers_all ph
5946: WHERE ph.po_header_id = p_document_id;
5947:

Line 6060: (SELECT party_id FROM po_vendors --rounding_ship_from_party_id

6056: PO_CONSTANTS_SV.REL_ADJUSTED,
6057: pr.po_release_id,
6058: sysdate, -- dummy value
6059: PO_CORE_S.get_default_legal_entity_id(pr.org_id),
6060: (SELECT party_id FROM po_vendors --rounding_ship_from_party_id
6061: WHERE vendor_id=ph.vendor_id)
6062: FROM po_releases_all pr, po_headers_all ph
6063: WHERE pr.po_release_id = p_document_id
6064: AND pr.po_header_id = ph.po_header_id;