DBA Data[Home] [Help]

APPS.JA_JAINMCENCG_EXC_XMLP_PKG dependencies on RCV_TRANSACTIONS

Line 91: RCV_TRANSACTIONS RT,

87: RTL.TAX_RATE TR,
88: RT.SHIPMENT_LINE_ID,
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

Line 121: RCV_TRANSACTIONS

117: IF RECEIPT_ID IS NOT NULL THEN
118: FOR qty_rec IN (SELECT
119: PRIMARY_QUANTITY
120: FROM
121: RCV_TRANSACTIONS
122: WHERE TRANSACTION_ID = TO_NUMBER(CF_QTYFORMULAFORMULA.RECEIPT_ID)) LOOP
123: V_QTY := QTY_REC.PRIMARY_QUANTITY;
124: END LOOP;
125: ELSE