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.GMI_RIWIN_XMLP_PKG dependencies on IC_ITEM_MST

Line 11: IC_ITEM_MST ITM,

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

Line 28: IC_ITEM_MST ITM,

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

Line 49: IC_ITEM_MST ITM,

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

Line 66: IC_ITEM_MST ITM,

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