89: RTL.TAX_TYPE
90: FROM
91: RCV_TRANSACTIONS RT,
92: JAI_RCV_LINE_TAXES RTL,
93: JAI_CMN_TAXES_ALL JTC
94: WHERE RT.TRANSACTION_ID = TO_NUMBER(RECEIPT_ID)
95: AND JTC.TAX_ID = RTL.TAX_ID
96: AND RT.SHIPMENT_LINE_ID = RTL.SHIPMENT_LINE_ID
97: AND NVL(RTL.TAX_AMOUNT