PO Tax Table in Oracle Apps

PO Tax Table in Oracle Apps

Hi Friends , We are going to discuss about PO Tax table in Oracle Apps. PO Tax tables helps to store the Purchase order tax details in Oracle Apps. We will get the applied taxes information on PO's using these PO tax tables in Oracle Apps. We need these PO tax tables details , if we want to develop the custom Purchase order reports in Oracle apps. These PO tax tables helps to extract the Purchase order transaction tax details in Oracle apps. We will get the complete PO tax related informations from these PO tax tables in Oracle Apps. We will share the most important PO tax tables in Oracle apps. Please find below the details about PO Tax Table in Oracle Apps.

PO Tax Table in Oracle Apps

2 Important PO Tax Table in Oracle Apps

1.ZX_LINES_DET_FACTORS

2.ZX_LINES

Details SQL Query using PO Tax Table in Oracle Apps

Here below is the complete details level sql query which helps to fetch and extract the po tax details using PO Tax Table in Oracle Apps.

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,
zxl.tax_rate,
zxl.taxable_amt
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(+)

PO Tax Table in Oracle Apps