Featured post

General Ledger Revaluation

General Ledger Revaluation Account balances denominated in foreign currencies are adjusted through the revaluation procedure. Revaluat...

Wednesday, 9 August 2017

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

Please review my topic and update your comments

Note: only a member of this blog may post a comment.