APPS.JA_JAINVAR_XMLP_PKG dependencies on JAI_CMN_RG_PLA_TRXS

Line 39: JAI_CMN_RG_PLA_TRXS A

35: CURSOR FOLIO_NUM2(V_INVENTORY_ITEM_ID IN NUMBER) IS
36: SELECT
37: TO_CHAR(A.INVENTORY_ITEM_ID) || '/' || TO_CHAR(A.SLNO)
38: FROM
39: JAI_CMN_RG_PLA_TRXS A
40: WHERE A.EXCISE_INVOICE_NO = EXCISE_INVOICE_NO
41: AND A.INVENTORY_ITEM_ID = V_INVENTORY_ITEM_ID;
42: BEGIN
43: IF NVL(AUTO_INVOICE_FLAG

Line 119: JAI_CMN_RG_PLA_TRXS A

115: CURSOR EXCISE_AMOUNT2 IS
116: SELECT
117: DR_ADDITIONAL_ED
118: FROM
119: JAI_CMN_RG_PLA_TRXS A
120: WHERE A.EXCISE_INVOICE_NO = CF_5FORMULA.EXCISE_INVOICE_NO
121: AND A.INVENTORY_ITEM_ID = CF_5FORMULA.INVENTORY_ITEM_ID;
122: V_ADDITIONAL_ED NUMBER;
123: BEGIN

Line 153: JAI_CMN_RG_PLA_TRXS A

149: CURSOR EXCISE_AMOUNT2 IS
150: SELECT
151: DR_OTHER_ED
152: FROM
153: JAI_CMN_RG_PLA_TRXS A
154: WHERE A.EXCISE_INVOICE_NO = CF_6FORMULA.EXCISE_INVOICE_NO
155: AND A.INVENTORY_ITEM_ID = CF_6FORMULA.INVENTORY_ITEM_ID;
156: V_OTHER_ED NUMBER;
157: BEGIN

Line 425: JAI_CMN_RG_PLA_TRXS A

421: CURSOR SLNO2(V_INVENTORY_ITEM_ID IN NUMBER) IS
422: SELECT
423: A.SLNO
424: FROM
425: JAI_CMN_RG_PLA_TRXS A
426: WHERE A.EXCISE_INVOICE_NO = CF_17FORMULA.EXCISE_INVOICE_NO
427: AND A.INVENTORY_ITEM_ID = CF_17FORMULA.V_INVENTORY_ITEM_ID;
428: CURSOR GET_PICKING_LINE_ID_CUR IS
429: SELECT