Select Poh.SEGMENT1 Purchase_Order_Number,Pol.QUANTITY, Pol.UNIT_PRICE,
jpt.TAX_RATE, Jpt.TAX_TYPE,Jpt.TAX_AMOUNT, Jct.TAX_DESCRFROMJAI_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