APPS.GMI_ICR04_XMLP_PKG dependencies on IC_TRAN_PND

Line 62: IC_TRAN_PND T,

58: SELECT
59: SUM(T.TRANS_QTY)
60: INTO PENDING_TRANS_QTY
61: FROM
62: IC_TRAN_PND T,
63: PM_MATL_DTL M
64: WHERE T.TRANS_DATE >= FROM_DATE
65: AND T.TRANS_DATE <= TO_DATE
66: AND T.DOC_TYPE = 'PROD'

Line 83: IC_TRAN_PND T,

79: SELECT
80: SUM(T.TRANS_QTY)
81: INTO REASP_TRANS_QTY
82: FROM
83: IC_TRAN_PND T,
84: SY_REAS_CDS R
85: WHERE T.TRANS_DATE >= FROM_DATE
86: AND T.TRANS_DATE <= TO_DATE
87: AND R.FLOW_TYPE = 0

Line 175: IC_TRAN_PND T,

171: SELECT
172: SUM(T.TRANS_QTY)
173: INTO PENDING_TRANS_QTY
174: FROM
175: IC_TRAN_PND T,
176: PM_MATL_DTL M
177: WHERE T.TRANS_DATE >= (
178: SELECT
179: BEGIN_DATE

Line 202: IC_TRAN_PND T,

198: SELECT
199: SUM(T.TRANS_QTY)
200: INTO REASP_TRANS_QTY
201: FROM
202: IC_TRAN_PND T,
203: SY_REAS_CDS R
204: WHERE T.TRANS_DATE >= (
205: SELECT
206: BEGIN_DATE