APPS.OPI_DBI_INV_VALUE_UTL_PKG dependencies on OPI_DBI_ONHAND_STG

Line 89: (SELECT /*+ parallel (opi_dbi_onhand_stg) */

85: conv.transaction_date) transaction_date,
86: conv.f_currency_code
87: FROM opi_dbi_conversion_rates conv,
88: mtl_parameters mp,
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) */

Line 91: FROM opi_dbi_onhand_stg

87: FROM opi_dbi_conversion_rates conv,
88: mtl_parameters mp,
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

Line 131: (SELECT /*+ parallel (opi_dbi_onhand_stg) */

127: conv.transaction_date) transaction_date,
128: conv.f_currency_code
129: FROM opi_dbi_conversion_rates conv,
130: mtl_parameters mp,
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) */

Line 133: FROM opi_dbi_onhand_stg

129: FROM opi_dbi_conversion_rates conv,
130: mtl_parameters mp,
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

Line 301: (SELECT /*+ parallel (opi_dbi_onhand_stg) */

297: g_created_by,
298: g_last_updated_by,
299: g_last_update_login
300: FROM
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) */

Line 303: FROM opi_dbi_onhand_stg

299: g_last_update_login
300: FROM
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