APPS.JA_JAINRG1_XMLP_PKG dependencies on JAI_CMN_RG_I_TRXS

Line 111: JAI_CMN_RG_I_TRXS

107: CURSOR PACKED_CUR IS
108: SELECT
109: BALANCE_PACKED
110: FROM
111: JAI_CMN_RG_I_TRXS
112: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
113: AND LOCATION_ID = P_LOCATION_ID
114: AND FIN_YEAR = FIN_YEAR_1
115: AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1

Line 121: JAI_CMN_RG_I_TRXS

117: CURSOR C_PREV_YR_BAL(P_ORGN_ID IN NUMBER,P_LOC_ID IN NUMBER,P_FIN_YEAR IN NUMBER,P_ITEM_ID IN NUMBER) IS
118: SELECT
119: BALANCE_PACKED
120: FROM
121: JAI_CMN_RG_I_TRXS
122: WHERE ORGANIZATION_ID = P_ORGN_ID
123: AND LOCATION_ID = P_LOC_ID
124: AND FIN_YEAR = P_FIN_YEAR
125: AND INVENTORY_ITEM_ID = P_ITEM_ID

Line 130: JAI_CMN_RG_I_TRXS

126: AND SLNO = (
127: SELECT
128: MAX(SLNO)
129: FROM
130: JAI_CMN_RG_I_TRXS
131: WHERE ORGANIZATION_ID = P_ORGN_ID
132: AND LOCATION_ID = P_LOC_ID
133: AND FIN_YEAR = P_FIN_YEAR
134: AND INVENTORY_ITEM_ID = P_ITEM_ID );

Line 215: JAI_CMN_RG_I_TRXS

211: CURSOR PACKED_CUR IS
212: SELECT
213: BALANCE_LOOSE
214: FROM
215: JAI_CMN_RG_I_TRXS
216: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
217: AND LOCATION_ID = P_LOCATION_ID
218: AND FIN_YEAR = FIN_YEAR_1
219: AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1

Line 225: JAI_CMN_RG_I_TRXS

221: CURSOR C_PREV_YR_BAL(P_ORGN_ID IN NUMBER,P_LOC_ID IN NUMBER,P_FIN_YEAR IN NUMBER,P_ITEM_ID IN NUMBER) IS
222: SELECT
223: BALANCE_LOOSE
224: FROM
225: JAI_CMN_RG_I_TRXS
226: WHERE ORGANIZATION_ID = P_ORGN_ID
227: AND LOCATION_ID = P_LOC_ID
228: AND FIN_YEAR = P_FIN_YEAR
229: AND INVENTORY_ITEM_ID = P_ITEM_ID

Line 234: JAI_CMN_RG_I_TRXS

230: AND SLNO = (
231: SELECT
232: MAX(SLNO)
233: FROM
234: JAI_CMN_RG_I_TRXS
235: WHERE ORGANIZATION_ID = P_ORGN_ID
236: AND LOCATION_ID = P_LOC_ID
237: AND FIN_YEAR = P_FIN_YEAR
238: AND INVENTORY_ITEM_ID = P_ITEM_ID );

Line 501: JAI_CMN_RG_I_TRXS

497: CURSOR C_ISSUE_TYPE IS
498: SELECT
499: ISSUE_TYPE
500: FROM
501: JAI_CMN_RG_I_TRXS
502: WHERE REGISTER_ID = REGISTER_ID_1;
503: LV_ISSUE_TYPE JAI_CMN_RG_I_TRXS.ISSUE_TYPE%TYPE;
504: CURSOR C_SHIPMENT_CESS_AMT IS
505: SELECT

Line 503: LV_ISSUE_TYPE JAI_CMN_RG_I_TRXS.ISSUE_TYPE%TYPE;

499: ISSUE_TYPE
500: FROM
501: JAI_CMN_RG_I_TRXS
502: WHERE REGISTER_ID = REGISTER_ID_1;
503: LV_ISSUE_TYPE JAI_CMN_RG_I_TRXS.ISSUE_TYPE%TYPE;
504: CURSOR C_SHIPMENT_CESS_AMT IS
505: SELECT
506: JSPTL.TAX_RATE CESS_RATE
507: FROM