APPS.OPI_DBI_INV_VALUE_UTL_PKG dependencies on OPI_DBI_WIP_STG

Line 97: SELECT /*+ parallel (opi_dbi_wip_stg) */

93: SELECT /*+ parallel (opi_dbi_intransit_stg) */
94: DISTINCT organization_id, transaction_date
95: FROM opi_dbi_intransit_stg
96: UNION
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) */

Line 99: FROM opi_dbi_wip_stg

95: FROM opi_dbi_intransit_stg
96: UNION
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

Line 139: SELECT /*+ parallel (opi_dbi_wip_stg) */

135: SELECT /*+ parallel (opi_dbi_intransit_stg) */
136: DISTINCT organization_id, transaction_date
137: FROM opi_dbi_intransit_stg
138: UNION
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) */

Line 141: FROM opi_dbi_wip_stg

137: FROM opi_dbi_intransit_stg
138: UNION
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

Line 309: SELECT /*+ parallel (opi_dbi_wip_stg) */

305: SELECT /*+ parallel (opi_dbi_intransit_stg) */
306: DISTINCT organization_id, transaction_date
307: FROM opi_dbi_intransit_stg
308: UNION
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) */

Line 311: FROM opi_dbi_wip_stg

307: FROM opi_dbi_intransit_stg
308: UNION
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