Featured post

Functionality of Segment Value Inheritance ESS Process

  The Segment Value Inheritance process simplifies the maintenance of the chart of accounts. When the characteristics of values in the value...

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.