[Home] [Help]
APPS.GML_PORIRUSR_XMLP_PKG dependencies on IC_LOTS_MST
Line 46: IC_LOTS_MST LM
42: SELECT
43: LOT_NO
44: INTO V_LOT
45: FROM
46: IC_LOTS_MST LM
47: WHERE LM.ITEM_ID = LOT_NOFORMULA.ITEM_ID
48: AND LM.LOT_ID = LOT_NOFORMULA.LOT_ID;
49: RETURN (V_LOT);
50: RETURN NULL;
Line 64: IC_LOTS_MST LM
60: SELECT
61: SUBLOT_NO
62: INTO V_SUBLOT
63: FROM
64: IC_LOTS_MST LM
65: WHERE LM.ITEM_ID = SUBLOT_NOFORMULA.ITEM_ID
66: AND LM.LOT_ID = SUBLOT_NOFORMULA.LOT_ID;
67: RETURN (V_SUBLOT);
68: RETURN NULL;