APPS.GMI_RIWIN_XMLP_PKG dependencies on IC_LOCT_INV

Line 12: IC_LOCT_INV ILI

8: SUM(LOCT_ONHAND)
9: INTO WHSEQTY
10: FROM
11: IC_ITEM_MST ITM,
12: IC_LOCT_INV ILI
13: WHERE ITM.ITEM_ID = ILI.ITEM_ID
14: AND ILI.DELETE_MARK = 0
15: AND ITM.DELETE_MARK = 0
16: AND ILI.WHSE_CODE = WHSCODE

Line 29: IC_LOCT_INV ILI

25: SUM(LOCT_ONHAND)
26: INTO TOTALQTY
27: FROM
28: IC_ITEM_MST ITM,
29: IC_LOCT_INV ILI
30: WHERE ITM.ITEM_ID = ILI.ITEM_ID
31: AND ILI.DELETE_MARK = 0
32: AND ITM.DELETE_MARK = 0
33: AND ITM.ITEM_ID = TOTAL_QTYFORMULA.ITEM_ID;

Line 50: IC_LOCT_INV ILI

46: NVL(SUM(LOCT_ONHAND2),0)
47: INTO WHSEQTY2
48: FROM
49: IC_ITEM_MST ITM,
50: IC_LOCT_INV ILI
51: WHERE ITM.ITEM_ID = ILI.ITEM_ID
52: AND ILI.DELETE_MARK = 0
53: AND ITM.DELETE_MARK = 0
54: AND ILI.WHSE_CODE = WHSCODE

Line 67: IC_LOCT_INV ILI

63: NVL(SUM(LOCT_ONHAND2),0)
64: INTO TOTALQTY2
65: FROM
66: IC_ITEM_MST ITM,
67: IC_LOCT_INV ILI
68: WHERE ITM.ITEM_ID = ILI.ITEM_ID
69: AND ILI.DELETE_MARK = 0
70: AND ITM.DELETE_MARK = 0
71: AND ITM.ITEM_ID = TOTAL_QTY2FORMULA.ITEM_ID;