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_VENDORS

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

2549: --Bug 5474336. Pass mau to EBTax
2550: ,fc.minimum_accountable_unit --minimum_accountable_unit
2551: ,NVL(fc.precision, 2) --precision
2552: ,PO_CORE_S.get_default_legal_entity_id(ph.org_id) --legal_entity_id
2553: ,(SELECT pv.party_id FROM po_vendors pv --rounding_ship_from_party_id
2554: WHERE pv.vendor_id=ph.vendor_id)
2555: ,DECODE(p_calling_program, --default_taxation_country
2556: 'COPY_DOCUMENT', null,
2557: zxldet.default_taxation_country)

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

2661: --Bug 5474336. Pass mau to EBTax
2662: ,fc.minimum_accountable_unit --minimum_accountable_unit
2663: ,NVL(fc.precision, 2) --precision
2664: ,PO_CORE_S.get_default_legal_entity_id(ph.org_id) --legal_entity_id
2665: ,(SELECT pv.party_id FROM po_vendors pv --rounding_ship_from_party_id
2666: WHERE pv.vendor_id=ph.vendor_id)
2667: ,null --default_taxation_country
2668: ,'N' --quote_flag
2669: ,ph.segment1 --trx_number

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

2766: --Bug 5474336. Pass mau to EBTax
2767: ,fc.minimum_accountable_unit --minimum_accountable_unit
2768: ,NVL(fc.precision, 2) --precision
2769: ,PO_CORE_S.get_default_legal_entity_id(pr.org_id) --legal_entity_id
2770: ,(SELECT pv.party_id FROM po_vendors pv --rounding_ship_from_party_id
2771: WHERE pv.vendor_id=ph.vendor_id)
2772: ,zxldet.default_taxation_country --default_taxation_country
2773: ,'N' --quote_flag
2774: ,ph.segment1 --trx_number

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

2889: --Bug 5474336. Pass mau to EBTax
2890: ,fc.minimum_accountable_unit --minimum_accountable_unit
2891: ,NVL(fc.precision, 2) --precision
2892: ,PO_CORE_S.get_default_legal_entity_id(pr.org_id) --legal_entity_id
2893: ,(SELECT pv.party_id FROM po_vendors pv --rounding_ship_from_party_id
2894: WHERE pv.vendor_id=ph.vendor_id)
2895: ,null --default_taxation_country
2896: ,'N' --quote_flag
2897: ,ph.segment1 --trx_number

Line 3294: zx_lines_det_factors zxldet, po_vendors pv,

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

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

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

Line 3954: zx_lines_det_factors zxldet, po_vendors pv,

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

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

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

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

Line 6770: (SELECT party_id FROM po_vendors --rounding_ship_from_party_id

6766: PO_CONSTANTS_SV.PO_ADJUSTED,
6767: ph.po_header_id,
6768: sysdate, -- dummy value
6769: PO_CORE_S.get_default_legal_entity_id(ph.org_id),
6770: (SELECT party_id FROM po_vendors --rounding_ship_from_party_id
6771: WHERE vendor_id=ph.vendor_id)
6772: FROM po_headers_all ph
6773: WHERE ph.po_header_id = p_document_id;
6774:

Line 6851: (SELECT party_id FROM po_vendors --rounding_ship_from_party_id

6847: PO_CONSTANTS_SV.PO_ADJUSTED,
6848: ph.po_header_id,
6849: sysdate, -- dummy value
6850: PO_CORE_S.get_default_legal_entity_id(ph.org_id),
6851: (SELECT party_id FROM po_vendors --rounding_ship_from_party_id
6852: WHERE vendor_id=ph.vendor_id)
6853: FROM po_headers_all ph
6854: WHERE ph.po_header_id = p_document_id;
6855:

Line 6968: (SELECT party_id FROM po_vendors --rounding_ship_from_party_id

6964: PO_CONSTANTS_SV.REL_ADJUSTED,
6965: pr.po_release_id,
6966: sysdate, -- dummy value
6967: PO_CORE_S.get_default_legal_entity_id(pr.org_id),
6968: (SELECT party_id FROM po_vendors --rounding_ship_from_party_id
6969: WHERE vendor_id=ph.vendor_id)
6970: FROM po_releases_all pr, po_headers_all ph
6971: WHERE pr.po_release_id = p_document_id
6972: AND pr.po_header_id = ph.po_header_id;