eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_JAIN23C1_XMLP_PKG dependencies on JAI_CMN_RG_23AC_I_TRXS

Line 70: JAI_CMN_RG_23AC_I_TRXS

66: SELECT
67: QUANTITY_RECEIVED
68: INTO RCVD_QTY
69: FROM
70: JAI_CMN_RG_23AC_I_TRXS
71: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
72: AND LOCATION_ID = P_LOCATION_ID
73: AND SLNO = SLNO_1
74: AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1

Line 86: JAI_CMN_RG_23AC_I_TRXS

82: SELECT
83: OTH_RECEIPT_QUANTITY
84: INTO RCVD_QTY
85: FROM
86: JAI_CMN_RG_23AC_I_TRXS
87: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
88: AND LOCATION_ID = P_LOCATION_ID
89: AND SLNO = SLNO_1
90: AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1

Line 113: JAI_CMN_RG_23AC_I_TRXS

109: SELECT
110: QUANTITY_RECEIVED
111: INTO RCVD_QTY
112: FROM
113: JAI_CMN_RG_23AC_I_TRXS
114: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
115: AND LOCATION_ID = P_LOCATION_ID
116: AND SLNO = SLNO_1
117: AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1

Line 129: JAI_CMN_RG_23AC_I_TRXS

125: SELECT
126: EXCISE_INVOICE_NO
127: INTO INV_ID
128: FROM
129: JAI_CMN_RG_23AC_I_TRXS
130: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
131: AND LOCATION_ID = P_LOCATION_ID
132: AND SLNO = SLNO_1
133: AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1

Line 145: JAI_CMN_RG_23AC_I_TRXS

141: SELECT
142: OTH_RECEIPT_QUANTITY
143: INTO RCVD_QTY
144: FROM
145: JAI_CMN_RG_23AC_I_TRXS
146: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
147: AND LOCATION_ID = P_LOCATION_ID
148: AND SLNO = SLNO_1
149: AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1

Line 161: JAI_CMN_RG_23AC_I_TRXS

157: SELECT
158: OTH_RECEIPT_ID_REF
159: INTO INV_ID
160: FROM
161: JAI_CMN_RG_23AC_I_TRXS
162: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
163: AND LOCATION_ID = P_LOCATION_ID
164: AND SLNO = SLNO_1
165: AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1

Line 186: JAI_CMN_RG_23AC_I_TRXS

182: SELECT
183: QUANTITY_RECEIVED
184: INTO RCVD_QTY
185: FROM
186: JAI_CMN_RG_23AC_I_TRXS
187: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
188: AND LOCATION_ID = P_LOCATION_ID
189: AND SLNO = SLNO_1
190: AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1

Line 202: JAI_CMN_RG_23AC_I_TRXS

198: SELECT
199: EXCISE_INVOICE_DATE
200: INTO INV_DT
201: FROM
202: JAI_CMN_RG_23AC_I_TRXS
203: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
204: AND LOCATION_ID = P_LOCATION_ID
205: AND SLNO = SLNO_1
206: AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1

Line 218: JAI_CMN_RG_23AC_I_TRXS

214: SELECT
215: OTH_RECEIPT_QUANTITY
216: INTO RCVD_QTY
217: FROM
218: JAI_CMN_RG_23AC_I_TRXS
219: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
220: AND LOCATION_ID = P_LOCATION_ID
221: AND SLNO = SLNO_1
222: AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1

Line 234: JAI_CMN_RG_23AC_I_TRXS

230: SELECT
231: OTH_RECEIPT_DATE
232: INTO INV_DT
233: FROM
234: JAI_CMN_RG_23AC_I_TRXS
235: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
236: AND LOCATION_ID = P_LOCATION_ID
237: AND SLNO = SLNO_1
238: AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1

Line 255: LN_ADD_CVD JAI_CMN_RG_23AC_I_TRXS.ADDITIONAL_CVD%TYPE := 0;

251: B_ED NUMBER;
252: A_ED NUMBER;
253: O_ED NUMBER;
254: S_INV_ID VARCHAR2(30);
255: LN_ADD_CVD JAI_CMN_RG_23AC_I_TRXS.ADDITIONAL_CVD%TYPE := 0;
256: BEGIN
257: BEGIN
258: SELECT
259: NVL(BASIC_ED

Line 269: JAI_CMN_RG_23AC_I_TRXS

265: NVL(ADDITIONAL_CVD
266: ,0)
267: INTO B_ED,A_ED,O_ED,LN_ADD_CVD
268: FROM
269: JAI_CMN_RG_23AC_I_TRXS
270: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
271: AND LOCATION_ID = P_LOCATION_ID
272: AND SLNO = SLNO_1
273: AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1

Line 287: JAI_CMN_RG_23AC_I_TRXS

283: SELECT
284: SALES_INVOICE_NO
285: INTO S_INV_ID
286: FROM
287: JAI_CMN_RG_23AC_I_TRXS
288: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
289: AND LOCATION_ID = P_LOCATION_ID
290: AND SLNO = SLNO_1
291: AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1

Line 305: LN_ADD_CVD JAI_CMN_RG_23AC_I_TRXS.ADDITIONAL_CVD%TYPE := 0;

301: B_ED NUMBER;
302: A_ED NUMBER;
303: O_ED NUMBER;
304: S_INV_DT DATE;
305: LN_ADD_CVD JAI_CMN_RG_23AC_I_TRXS.ADDITIONAL_CVD%TYPE := 0;
306: BEGIN
307: BEGIN
308: SELECT
309: NVL(BASIC_ED

Line 319: JAI_CMN_RG_23AC_I_TRXS

315: NVL(ADDITIONAL_CVD
316: ,0)
317: INTO B_ED,A_ED,O_ED,LN_ADD_CVD
318: FROM
319: JAI_CMN_RG_23AC_I_TRXS
320: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
321: AND LOCATION_ID = P_LOCATION_ID
322: AND SLNO = SLNO_1
323: AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1

Line 337: JAI_CMN_RG_23AC_I_TRXS

333: SELECT
334: SALES_INVOICE_DATE
335: INTO S_INV_DT
336: FROM
337: JAI_CMN_RG_23AC_I_TRXS
338: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
339: AND LOCATION_ID = P_LOCATION_ID
340: AND SLNO = SLNO_1
341: AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1

Line 356: LN_ADD_CVD JAI_CMN_RG_23AC_I_TRXS.ADDITIONAL_CVD%TYPE := 0;

352: B_ED NUMBER;
353: A_ED NUMBER;
354: O_ED NUMBER;
355: S_INV_QTY NUMBER;
356: LN_ADD_CVD JAI_CMN_RG_23AC_I_TRXS.ADDITIONAL_CVD%TYPE := 0;
357: CURSOR C_FETCH_QTY_FOR_RTV IS
358: SELECT
359: ABS(QUANTITY_RECEIVED)
360: FROM

Line 361: JAI_CMN_RG_23AC_I_TRXS

357: CURSOR C_FETCH_QTY_FOR_RTV IS
358: SELECT
359: ABS(QUANTITY_RECEIVED)
360: FROM
361: JAI_CMN_RG_23AC_I_TRXS
362: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
363: AND LOCATION_ID = P_LOCATION_ID
364: AND SLNO = SLNO_1
365: AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1

Line 380: JAI_CMN_RG_23AC_I_TRXS

376: NVL(ADDITIONAL_CVD
377: ,0)
378: INTO B_ED,A_ED,O_ED,LN_ADD_CVD
379: FROM
380: JAI_CMN_RG_23AC_I_TRXS
381: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
382: AND LOCATION_ID = P_LOCATION_ID
383: AND SLNO = SLNO_1
384: AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1

Line 398: JAI_CMN_RG_23AC_I_TRXS

394: SELECT
395: SALES_INVOICE_QUANTITY
396: INTO S_INV_QTY
397: FROM
398: JAI_CMN_RG_23AC_I_TRXS
399: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
400: AND LOCATION_ID = P_LOCATION_ID
401: AND SLNO = SLNO_1
402: AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1