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.OPI_DBI_INV_VALUE_UTL_PKG dependencies on OPI_DBI_INV_BEG_STG

Line 101: SELECT /+ parallel (opi_dbi_inv_beg_stg) /

97: SELECT /*+ parallel (opi_dbi_wip_stg) */
98: DISTINCT organization_id, transaction_date
99: FROM opi_dbi_wip_stg
100: UNION
101: SELECT /*+ parallel (opi_dbi_inv_beg_stg) */
102: DISTINCT organization_id, transaction_date
103: FROM opi_dbi_inv_beg_stg
104: UNION
105: SELECT /*+ parallel (opi_dbi_onh_qty_stg) */

Line 103: FROM opi_dbi_inv_beg_stg

99: FROM opi_dbi_wip_stg
100: UNION
101: SELECT /*+ parallel (opi_dbi_inv_beg_stg) */
102: DISTINCT organization_id, transaction_date
103: FROM opi_dbi_inv_beg_stg
104: UNION
105: SELECT /*+ parallel (opi_dbi_onh_qty_stg) */
106: DISTINCT organization_id, transaction_date
107: FROM opi_dbi_onh_qty_stg

Line 143: SELECT /+ parallel (opi_dbi_inv_beg_stg) /

139: SELECT /*+ parallel (opi_dbi_wip_stg) */
140: DISTINCT organization_id, transaction_date
141: FROM opi_dbi_wip_stg
142: UNION
143: SELECT /*+ parallel (opi_dbi_inv_beg_stg) */
144: DISTINCT organization_id, transaction_date
145: FROM opi_dbi_inv_beg_stg
146: UNION
147: SELECT /*+ parallel (opi_dbi_onh_qty_stg) */

Line 145: FROM opi_dbi_inv_beg_stg

141: FROM opi_dbi_wip_stg
142: UNION
143: SELECT /*+ parallel (opi_dbi_inv_beg_stg) */
144: DISTINCT organization_id, transaction_date
145: FROM opi_dbi_inv_beg_stg
146: UNION
147: SELECT /*+ parallel (opi_dbi_onh_qty_stg) */
148: DISTINCT organization_id, transaction_date
149: FROM opi_dbi_onh_qty_stg

Line 313: SELECT /+ parallel (opi_dbi_inv_beg_stg) /

309: SELECT /*+ parallel (opi_dbi_wip_stg) */
310: DISTINCT organization_id, transaction_date
311: FROM opi_dbi_wip_stg
312: UNION
313: SELECT /*+ parallel (opi_dbi_inv_beg_stg) */
314: DISTINCT organization_id, transaction_date
315: FROM opi_dbi_inv_beg_stg
316: UNION
317: SELECT /*+ parallel (opi_dbi_onh_qty_stg) */

Line 315: FROM opi_dbi_inv_beg_stg

311: FROM opi_dbi_wip_stg
312: UNION
313: SELECT /*+ parallel (opi_dbi_inv_beg_stg) */
314: DISTINCT organization_id, transaction_date
315: FROM opi_dbi_inv_beg_stg
316: UNION
317: SELECT /*+ parallel (opi_dbi_onh_qty_stg) */
318: DISTINCT organization_id, transaction_date
319: FROM opi_dbi_onh_qty_stg