Oracle r12 Purchase Order Tax Query

Oracle r12 Purchase Order Tax Query

Hi friends , we are going to discuss about Oracle r12 Purchase Order Tax Query. We will share the detail sql query which helps to extract the complete purchase order details including PO tax details in oracle apps. This is the complete sql query to extract the purchase order tax details in oracle apps. This is one of the most important frequently used sql query to extract the Purchase order informations in oracle r12. To extract the Purchase order tax details , we need to use the Tax Details starting with 'ZX'. These ZX tables helps to store all Tax Related informations as well the transnational tax details in Oracle apps r12. Here below we are sharing the complete Purchase Order Tax Query and the important purchase order tax tables in oracle r12.

Important Tables related to  Purchase Order Tax Query

1.ZX_LINES_DET_FACTORS

2.ZX_LINES

Detail Oracle r12 Purchase Order Tax Query

Here below is the detail purchase order tax query , which helps to extract the complete purchase order details with purchase order tax informations in Oracle apps r12.

select poh.segment1, pol.line_num,poll.shipment_num,
poh.comments,msi.segment1 "Item Code",
pol.item_description,
pol.unit_meas_lookup_code "UOM",
pol.base_unit_price, pol.unit_price, pol.quantity,
(pol.unit_price * pol.quantity) "Line Amount",
zxd.input_tax_classification_code, zxd.user_defined_fisc_class
from ZX_LINES_DET_FACTORS zxd,
zx_lines zxl,
po_headers_all poh,
po_lines_all pol,
po_line_locations_all poll,
mtl_system_items_b msi,
po_distributions_all pda
where poh.po_header_id = pol.po_header_id 
and pol.po_line_id = poll.po_line_id 
and zxd.trx_id = zxl.trx_id 
and zxl.trx_id = poll.po_header_id 
and zxd.entity_code = 'PURCHASE_ORDER' 
and poh.segment1 = :P_PO_NUMBER
and pda.po_header_id = poh.po_header_id
and pda.po_line_id = pol.po_line_id
and pda.destination_organization_id = msi.organization_id(+)

Oracle r12 Purchase Order Tax Query