APPS.PO_TAX_INTERFACE_PVT dependencies on FND_CURRENCIES

Line 2392: FROM po_headers_all ph, zx_lines_det_factors zxldet, fnd_currencies fc

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
2395: -- Conditions for getting Additional Tax Attributes
2396: -- Note that the po_header_id is of current document being processed,

Line 2500: FROM po_headers_all ph, fnd_currencies fc

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;
2503:
2504: END populate_header_po;

Line 2608: ,fnd_currencies fc

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
2608: ,fnd_currencies fc
2609: ,po_releases_all pr
2610: -- Conditions for getting Additional Tax Attributes
2611: -- Copy from Planned PO if its a newly created Scheduled Release
2612: -- ELSE simply copy from existing release header (ie. in case of a

Line 2728: FROM po_releases_all pr, po_headers_all ph, fnd_currencies fc

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
2731: AND fc.currency_code = ph.currency_code;
2732:

Line 3668: mtl_system_items_b msib, fnd_currencies fc

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
3672: -- Do not put a condition on zxldet.trx_id here because that would

Line 3688: -- Join with fnd_currencies for currency information

3684: AND pvs.vendor_site_id(+) = prl.vendor_site_id
3685: -- Join with items table for item information
3686: AND msib.inventory_item_id(+) = prl.item_id
3687: AND msib.organization_id(+) = prl.org_id
3688: -- Join with fnd_currencies for currency information
3689: AND fc.currency_code(+) = prl.currency_code
3690: -- Conditions that determine that requisition line is 'Active'
3691: AND nvl(prl.modified_by_agent_flag, 'N') = 'N'
3692: AND nvl(prl.cancel_flag, 'N') = 'N'