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 ZX_LINES_DET_FACTORS

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 2398: -- with zx_lines_det_factors because that table is denormalized

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,
2397: -- not of any source document. Get the first row obtained from join
2398: -- with zx_lines_det_factors because that table is denormalized
2399: AND zxldet.trx_id(+) = ph.po_header_id
2400: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
2401: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.PO_ENTITY_CODE
2402: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE

Line 2614: LEFT OUTER JOIN zx_lines_det_factors zxldet

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
2613: -- shipment split or regular blanket/scheduled release create/update
2614: LEFT OUTER JOIN zx_lines_det_factors zxldet
2615: ON ((pr.po_header_id = zxldet.trx_id
2616: AND PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
2617: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code
2618: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code

Line 2802: FROM po_requisition_headers_all prh, zx_lines_det_factors zxldet

2798: ,zxldet.default_taxation_country --default_taxation_country
2799: ,DECODE(p_calling_program, --icx_session_id
2800: 'DETERMINE_RECOVERY_REQ', null,
2801: FND_GLOBAL.session_id)
2802: FROM po_requisition_headers_all prh, zx_lines_det_factors zxldet
2803: WHERE prh.requisition_header_id = p_requisition_header_id
2804: -- Conditions for getting Additional Tax Attributes
2805: -- Note that the req_header_id is of current document being processed,
2806: -- not of any source document. Get the first row obtained from join

Line 2807: -- with zx_lines_det_factors because that table is denormalized

2803: WHERE prh.requisition_header_id = p_requisition_header_id
2804: -- Conditions for getting Additional Tax Attributes
2805: -- Note that the req_header_id is of current document being processed,
2806: -- not of any source document. Get the first row obtained from join
2807: -- with zx_lines_det_factors because that table is denormalized
2808: AND zxldet.trx_id(+) = prh.requisition_header_id
2809: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
2810: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.REQ_ENTITY_CODE
2811: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE

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 3415: LEFT OUTER JOIN zx_lines_det_factors zxldet ON

3411: -- currently processed. Join with trx_line_id itself is unique
3412: -- because the document type has been classified with
3413: -- event_class_code and line_location_id will always be unique
3414: -- whether PO shipment or Release shipment
3415: LEFT OUTER JOIN zx_lines_det_factors zxldet ON
3416: ((PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
3417: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code
3418: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code
3419: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type

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