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_ICR04_XMLP_PKG dependencies on IC_TRAN_CMP

Line 17: IC_TRAN_CMP T,

13: SELECT
14: SUM(T.TRANS_QTY)
15: INTO COMPLETED_TRANS_QTY
16: FROM
17: IC_TRAN_CMP T,
18: PM_MATL_DTL M
19: WHERE DOC_TYPE_1 in ( 'ADJI' , 'ADJR' , 'PICY' , 'PIPH' , 'REPI' , 'REPR' )
20: AND REASON_CODE_1 in (
21: SELECT

Line 43: IC_TRAN_CMP T,

39: SELECT
40: SUM(T.TRANS_QTY)
41: INTO REAS_TRANS_QTY
42: FROM
43: IC_TRAN_CMP T,
44: SY_REAS_CDS R
45: WHERE T.TRANS_DATE >= FROM_DATE
46: AND T.TRANS_DATE <= TO_DATE
47: AND R.FLOW_TYPE = 0

Line 118: IC_TRAN_CMP T,

114: SELECT
115: SUM(T.TRANS_QTY)
116: INTO COMPLETED_TRANS_QTY
117: FROM
118: IC_TRAN_CMP T,
119: PM_MATL_DTL M
120: WHERE DOC_TYPE_1 in ( 'ADJI' , 'ADJR' , 'PICY' , 'PIPH' , 'REPI' , 'REPR' )
121: AND REASON_CODE_1 in (
122: SELECT

Line 150: IC_TRAN_CMP T,

146: SELECT
147: SUM(T.TRANS_QTY)
148: INTO REAS_TRANS_QTY
149: FROM
150: IC_TRAN_CMP T,
151: SY_REAS_CDS R
152: WHERE T.TRANS_DATE >= (
153: SELECT
154: BEGIN_DATE