[Home] [Help]
2573: -- Bug 5025018. Updated tax attribute mappings
2574: ,ph.org_id --rounding_bill_to_party_id
2575: ,(SELECT pvs.party_site_id from po_vendor_sites_all pvs --rndg_ship_from_party_site_id
2576: WHERE pvs.vendor_site_id=ph.vendor_site_id)
2577: FROM po_headers_all ph, zx_lines_det_factors zxldet, fnd_currencies fc
2578: WHERE ph.po_header_id = p_po_header_id_tbl(i)
2579: AND fc.currency_code = ph.currency_code
2580: -- Conditions for getting Additional Tax Attributes
2581: -- Note that the po_header_id is of current document being processed,
2579: AND fc.currency_code = ph.currency_code
2580: -- Conditions for getting Additional Tax Attributes
2581: -- Note that the po_header_id is of current document being processed,
2582: -- not of any source document. Get the first row obtained from join
2583: -- with zx_lines_det_factors because that table is denormalized
2584: AND zxldet.trx_id(+) = ph.po_header_id
2585: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
2586: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.PO_ENTITY_CODE
2587: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
2795: -- Conditions for getting Additional Tax Attributes
2796: -- Copy from Planned PO if its a newly created Scheduled Release
2797: -- ELSE simply copy from existing release header (ie. in case of a
2798: -- shipment split or regular blanket/scheduled release create/update
2799: LEFT OUTER JOIN zx_lines_det_factors zxldet
2800: ON ((pr.po_header_id = zxldet.trx_id
2801: AND PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
2802: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code
2803: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code
2983: ,zxldet.default_taxation_country --default_taxation_country
2984: ,DECODE(p_calling_program, --icx_session_id
2985: 'DETERMINE_RECOVERY_REQ', null,
2986: FND_GLOBAL.session_id)
2987: FROM po_requisition_headers_all prh, zx_lines_det_factors zxldet
2988: WHERE prh.requisition_header_id = p_requisition_header_id
2989: -- Conditions for getting Additional Tax Attributes
2990: -- Note that the req_header_id is of current document being processed,
2991: -- not of any source document. Get the first row obtained from join
2988: WHERE prh.requisition_header_id = p_requisition_header_id
2989: -- Conditions for getting Additional Tax Attributes
2990: -- Note that the req_header_id is of current document being processed,
2991: -- not of any source document. Get the first row obtained from join
2992: -- with zx_lines_det_factors because that table is denormalized
2993: AND zxldet.trx_id(+) = prh.requisition_header_id
2994: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
2995: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.REQ_ENTITY_CODE
2996: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE
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
3615: -- currently processed. Join with trx_line_id itself is unique
3616: -- because the document type has been classified with
3617: -- event_class_code and line_location_id will always be unique
3618: -- whether PO shipment or Release shipment
3619: LEFT OUTER JOIN zx_lines_det_factors zxldet ON
3620: ((PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
3621: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code
3622: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code
3623: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type
3658: populate_zx_lines_with_rel_cal which populates the data in zx_transaction_lines_gt
3659: only when the shipments is received or billed or shipped. This has been done for these
3660: shipments to skip the call to get_default_tax_attribs as per the EB Tax suggestion in bug
3661: 11665348 to fulfill requirement by PO PM team to retain the tax on received/billed shipments.
3662: These 2 procedures uses a join for zx_lines_det_factors and po_line_locations_all
3663: ON line_location_id instead of original_shipment_id as we need to pass value of
3664: input_tax_classification_code for receioved/billed PO shipments as per the suggestion
3665: of EB Tax team in bug 11711366
3666: */
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
4264: LEFT OUTER JOIN mtl_system_items_b msib
4265: ON (pl.item_id = msib.inventory_item_id
4266: AND pl.org_id = msib.organization_id)
4267: ,po_line_locations_all pll
4268: LEFT OUTER JOIN zx_lines_det_factors zxldet ON
4269: -- Bug#12622509: The performance of the SQL is very bad, as FULL TABLE
4270: -- SCAN is performed on the table zx_lines_det_factors.
4271: (PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
4272: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code
4266: AND pl.org_id = msib.organization_id)
4267: ,po_line_locations_all pll
4268: LEFT OUTER JOIN zx_lines_det_factors zxldet ON
4269: -- Bug#12622509: The performance of the SQL is very bad, as FULL TABLE
4270: -- SCAN is performed on the table zx_lines_det_factors.
4271: (PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
4272: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code
4273: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code
4274: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type
4280: -- currently processed. Join with trx_line_id itself is unique
4281: -- because the document type has been classified with
4282: -- event_class_code and line_location_id will always be unique
4283: -- whether PO shipment or Release shipment
4284: LEFT OUTER JOIN zx_lines_det_factors zxldet ON
4285: ((PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
4286: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code
4287: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code
4288: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type
4541: --Bug 5632300. Parameter to confirm that tax classification is overridden
4542:
4543: -- Bug 14155908: When the req split is done passing the user_upd_det_factors_flag
4544: -- to zx_transaction_lines_gt as that of the parent req line's value in
4545: -- zx_lines_det_factors table.
4546: ,Decode (p_calling_program,
4547: 'REQUISITION_MODIFY', zxldet.user_upd_det_factors_flag,
4548: 'REQIMPORT', NVL2(PRL.TAX_NAME,'Y',NULL))
4549: ,prl.destination_organization_id --Bug#6902111
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