APPS.GMI_GMILTGEN_XMLP_PKG dependencies on IC_ITEM_MST

Line 11: IC_ITEM_MST IM,

7: SELECT
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

Line 75: L_ITEM_NO IC_ITEM_MST.ITEM_NO%TYPE;

71: END AFTERREPORT;
72:
73: FUNCTION ITEM_NOFORMULA(ITEM_ID IN NUMBER
74: ,LOT_ID IN NUMBER) RETURN CHAR IS
75: L_ITEM_NO IC_ITEM_MST.ITEM_NO%TYPE;
76: CURSOR CUR_DOCDTL IS
77: SELECT
78: TRANS_DATE,
79: DOC_TYPE,

Line 201: IC_ITEM_MST IM,

197: IL.QC_GRADE,
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;

Line 274: L_ITEM_NO IC_ITEM_MST.ITEM_NO%TYPE;

270: FUNCTION I_ITEM_NOFORMULA(ITEM_ID2 IN NUMBER
271: ,LOT_ID3 IN NUMBER
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

Line 286: IC_ITEM_MST IM,

282: IL.LOT_NO,
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;

Line 484: L_UOM IC_ITEM_MST.ITEM_UM%TYPE;

480: RETURN (L_SPEC);
481: END QC_SPECFORMULA;
482:
483: FUNCTION UOMFORMULA(ITEM_ID1 IN NUMBER) RETURN CHAR IS
484: L_UOM IC_ITEM_MST.ITEM_UM%TYPE;
485: BEGIN
486: SELECT
487: ITEM_UM,
488: ITEM_UM2

Line 491: IC_ITEM_MST

487: ITEM_UM,
488: ITEM_UM2
489: INTO L_UOM,UOM2
490: FROM
491: IC_ITEM_MST
492: WHERE ITEM_ID = ITEM_ID1;
493: RETURN (L_UOM);
494: END UOMFORMULA;
495: