APPS.GMI_GMILTGEN_XMLP_PKG dependencies on IC_LOTS_MST

Line 12: IC_LOTS_MST IL

8: IM.ITEM_ID,
9: IL.LOT_ID
10: FROM
11: IC_ITEM_MST IM,
12: IC_LOTS_MST IL
13: WHERE IM.ITEM_NO = P_ITEM_NO
14: AND IM.ITEM_ID = IL.ITEM_ID
15: AND IL.LOT_NO = P_LOT_NO
16: AND ( P_SUBLOT_NO IS NULL

Line 181: IC_LOTS_MST

177: WHERE VENDOR_ID = (
178: SELECT
179: SHIPVEND_ID
180: FROM
181: IC_LOTS_MST
182: WHERE ITEM_ID = ITEM_NOFORMULA.ITEM_ID
183: AND LOT_ID = ITEM_NOFORMULA.LOT_ID );
184: BEGIN
185: BEGIN

Line 202: IC_LOTS_MST IL

198: IL.VENDOR_LOT_NO
199: INTO L_ITEM_NO,ITEM_DESC,SHELF_LIFE,RETEST_INTERVAL,LOT_NO,SUBLOT_NO,INV_CLASS,INV_TYPE,EXPIRE_DATE,RETEST_DATE,GRADE,VEND_LOT_NO
200: FROM
201: IC_ITEM_MST IM,
202: IC_LOTS_MST IL
203: WHERE IM.ITEM_ID = ITEM_NOFORMULA.ITEM_ID
204: AND IL.LOT_ID = ITEM_NOFORMULA.LOT_ID
205: AND IM.ITEM_ID = IL.ITEM_ID;
206: OPEN CUR_DOCDTL;

Line 276: L_LOT_NO IC_LOTS_MST.LOT_NO%TYPE;

272: ,CIR_FLG1 IN VARCHAR2
273: ,LEVEL_NO1 IN NUMBER) RETURN CHAR IS
274: L_ITEM_NO IC_ITEM_MST.ITEM_NO%TYPE;
275: I NUMBER := 1;
276: L_LOT_NO IC_LOTS_MST.LOT_NO%TYPE;
277: L_SUBLOT_NO IC_LOTS_MST.SUBLOT_NO%TYPE;
278: BEGIN
279: SELECT
280: IM.ITEM_NO,

Line 277: L_SUBLOT_NO IC_LOTS_MST.SUBLOT_NO%TYPE;

273: ,LEVEL_NO1 IN NUMBER) RETURN CHAR IS
274: L_ITEM_NO IC_ITEM_MST.ITEM_NO%TYPE;
275: I NUMBER := 1;
276: L_LOT_NO IC_LOTS_MST.LOT_NO%TYPE;
277: L_SUBLOT_NO IC_LOTS_MST.SUBLOT_NO%TYPE;
278: BEGIN
279: SELECT
280: IM.ITEM_NO,
281: IM.ITEM_DESC1,

Line 287: IC_LOTS_MST IL

283: IL.SUBLOT_NO
284: INTO L_ITEM_NO,I_ITEM_DESC,I_LOT_NO,I_SUBLOT_NO
285: FROM
286: IC_ITEM_MST IM,
287: IC_LOTS_MST IL
288: WHERE IM.ITEM_ID = ITEM_ID2
289: AND IL.LOT_ID = LOT_ID3
290: AND IM.ITEM_ID = IL.ITEM_ID;
291: IF I_SUBLOT_NO IS NOT NULL THEN