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_OPM_INV_STG

Line 110: SELECT /+ parallel (opi_dbi_opm_inv_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
112: FROM opi_dbi_opm_inv_stg) to_conv -- Only change
113: WHERE nvl (conv.conversion_rate, -999) < 0 -- null is not fine
114: AND mp.organization_id = to_conv.organization_id

Line 112: FROM opi_dbi_opm_inv_stg) to_conv -- Only change

108: WHERE transaction_source ='MMT'
109: UNION
110: SELECT /*+ parallel (opi_dbi_opm_inv_stg) */
111: DISTINCT organization_id, transaction_date
112: FROM opi_dbi_opm_inv_stg) to_conv -- Only change
113: WHERE nvl (conv.conversion_rate, -999) < 0 -- null is not fine
114: AND mp.organization_id = to_conv.organization_id
115: AND conv.transaction_date (+) = to_conv.transaction_date
116: AND conv.organization_id (+) = to_conv.organization_id

Line 152: SELECT /+ parallel (opi_dbi_opm_inv_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
154: FROM opi_dbi_opm_inv_stg) to_conv
155: WHERE nvl (conv.sec_conversion_rate, 999) < 0 -- null is fine
156: AND mp.organization_id = to_conv.organization_id

Line 154: FROM opi_dbi_opm_inv_stg) to_conv

150: WHERE transaction_source ='MMT'
151: UNION
152: SELECT /*+ parallel (opi_dbi_opm_inv_stg) */
153: DISTINCT organization_id, transaction_date
154: FROM opi_dbi_opm_inv_stg) to_conv
155: WHERE nvl (conv.sec_conversion_rate, 999) < 0 -- null is fine
156: AND mp.organization_id = to_conv.organization_id
157: AND conv.transaction_date (+) = to_conv.transaction_date
158: AND conv.organization_id (+) = to_conv.organization_id)

Line 322: SELECT /+ parallel (opi_dbi_opm_inv_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
324: FROM opi_dbi_opm_inv_stg
325: ) to_conv,
326: (SELECT /*+ leading (hoi) full (hoi) use_hash (gsob)

Line 324: FROM opi_dbi_opm_inv_stg

320: WHERE transaction_source ='MMT'
321: UNION
322: SELECT /*+ parallel (opi_dbi_opm_inv_stg) */
323: DISTINCT organization_id, transaction_date
324: FROM opi_dbi_opm_inv_stg
325: ) to_conv,
326: (SELECT /*+ leading (hoi) full (hoi) use_hash (gsob)
327: parallel (hoi) parallel (gsob)*/
328: DISTINCT hoi.organization_id, gsob.currency_code