Wednesday 29 May 2013

PO Tax Sub Query

Select Poh.SEGMENT1 Purchase_Order_Number,Pol.QUANTITY, Pol.UNIT_PRICE,
jpt.TAX_RATE, Jpt.TAX_TYPE,Jpt.TAX_AMOUNT, Jct.TAX_DESCRFROM
JAI_PO_TAXES jpt

, JAI_CMN_TAXES_ALL jct
, Po_Headers_All Poh

, Po_lines_All Pol

WHERE

Jpt
.po_header_id = Poh.PO_HEADER_ID
And
Jpt.PO_LINE_ID = POl.PO_LINE_ID
And
Poh.PO_HEADER_ID = Pol.PO_HEADER_ID
And
Jpt.TAX_ID = Jct.TAX_ID

No comments:

Post a Comment