DBA Data[Home] [Help]

APPS.OPI_DBI_WIP_COMP_OPM_PKG dependencies on IC_TRAN_PND

Line 72: ic_tran_pnd

68: orgn_code,
69: item_id,
70: SUM(trans_qty) trans_qty
71: FROM
72: ic_tran_pnd
73: WHERE
74: doc_type = 'PROD'
75: AND line_type IN (1,2)
76: AND completed_ind = 1

Line 171: * ic_tran_pnd.gl_posted_ind = 0 (rather than 1)

167: Differences between this procedure and collect_opm_LED_current:
168:
169: * target table is opi_dbi_opm_wip_TST_current (rather than ... LED_current)
170: * subr table is gl_subr_TST (rather than gl_subr_LED)
171: * ic_tran_pnd.gl_posted_ind = 0 (rather than 1)
172:
173: Noting these differences here makes it possible to propagate maintenance to the
174: led_current procedure by copying it and applying the differences. This is a
175: good practice, because the procedures as so similar.

Line 200: ic_tran_pnd

196: orgn_code,
197: item_id,
198: SUM(trans_qty) trans_qty
199: FROM
200: ic_tran_pnd
201: WHERE
202: doc_type = 'PROD'
203: AND line_type IN (1,2)
204: AND completed_ind = 1