Query to get PO Tax Details in Oracle Apps
Hi Friends , We are going to discuss the sql query to get PO tax details in Oracle apps. This sql Query will help to extract the complete PO informations including the PO tax details in Oracle Apps. Using this query , we will be able to get the complete PO tax details. This is one of the important sql query related to purchase order tax details. We will also share the Important Tables related to taxes which helps to store the PO tax details in Oracle Apps. In Oracle apps, we have the separate tax tables starting with 'ZX' which helps to store the complete tax details and transaction tax details in oracle apps. Please find below the complete query to get po tax details in oracle apps and the important tables related to PO taxes in oracle.
 |
| Query to get po tax details in Oracle Apps |
Important Tables used by query to get po tax details in oracle apps
1.ZX_LINES_DET_FACTORS
2.ZX_LINES
Complete SQL Query to get PO tax details in Oracle Apps
Here below is the complete details level sql query which helps to fetch and extract the po tax details in Oracle Apps.
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(+)
 |
| Query to get po tax details in Oracle Apps |
0 comments:
Post a Comment