APPS.OPI_DBI_INV_VALUE_UTL_PKG dependencies on OPI_DBI_INTRANSIT_STG

Line 93: SELECT /*+ parallel (opi_dbi_intransit_stg) */

89: (SELECT /*+ parallel (opi_dbi_onhand_stg) */
90: DISTINCT organization_id, transaction_date
91: FROM opi_dbi_onhand_stg
92: UNION
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) */

Line 95: FROM opi_dbi_intransit_stg

91: FROM opi_dbi_onhand_stg
92: UNION
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

Line 135: SELECT /*+ parallel (opi_dbi_intransit_stg) */

131: (SELECT /*+ parallel (opi_dbi_onhand_stg) */
132: DISTINCT organization_id, transaction_date
133: FROM opi_dbi_onhand_stg
134: UNION
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) */

Line 137: FROM opi_dbi_intransit_stg

133: FROM opi_dbi_onhand_stg
134: UNION
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

Line 305: SELECT /*+ parallel (opi_dbi_intransit_stg) */

301: (SELECT /*+ parallel (opi_dbi_onhand_stg) */
302: DISTINCT organization_id, transaction_date
303: FROM opi_dbi_onhand_stg
304: UNION
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) */

Line 307: FROM opi_dbi_intransit_stg

303: FROM opi_dbi_onhand_stg
304: UNION
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