APPS.OPI_DBI_INV_VALUE_UTL_PKG dependencies on OPI_DBI_ONH_QTY_STG

Line 105: SELECT /*+ parallel (opi_dbi_onh_qty_stg) */

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
108: WHERE transaction_source ='MMT'
109: UNION

Line 107: FROM opi_dbi_onh_qty_stg

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
108: WHERE transaction_source ='MMT'
109: UNION
110: SELECT /*+ parallel (opi_dbi_opm_inv_stg) */
111: DISTINCT organization_id, transaction_date

Line 147: SELECT /*+ parallel (opi_dbi_onh_qty_stg) */

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
150: WHERE transaction_source ='MMT'
151: UNION

Line 149: FROM opi_dbi_onh_qty_stg

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
150: WHERE transaction_source ='MMT'
151: UNION
152: SELECT /*+ parallel (opi_dbi_opm_inv_stg) */
153: DISTINCT organization_id, transaction_date

Line 317: SELECT /*+ parallel (opi_dbi_onh_qty_stg) */

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
320: WHERE transaction_source ='MMT'
321: UNION

Line 319: FROM opi_dbi_onh_qty_stg

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
320: WHERE transaction_source ='MMT'
321: UNION
322: SELECT /*+ parallel (opi_dbi_opm_inv_stg) */
323: DISTINCT organization_id, transaction_date