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_JOB_TXN_STG_PKG dependencies on MTL_PARAMETERS

Line 81: mtl_parameters mp,

77: C_EURO_MISSING_AT_START, g_euro_start_date,
78: conv.transaction_date) transaction_date,
79: conv.f_currency_code func_currency_code
80: FROM opi_dbi_muv_conv_rates conv,
81: mtl_parameters mp,
82: (SELECT
83: DISTINCT organization_id,
84: trunc (transaction_date) transaction_date
85: FROM OPI_DBI_JOBS_TXN_STG) to_conv

Line 103: mtl_parameters mp,

99: C_EURO_MISSING_AT_START, g_euro_start_date,
100: conv.transaction_date) transaction_date,
101: conv.f_currency_code func_currency_code
102: FROM opi_dbi_muv_conv_rates conv,
103: mtl_parameters mp,
104: (SELECT
105: DISTINCT organization_id,
106: trunc (transaction_date) transaction_date
107: FROM OPI_DBI_JOBS_TXN_STG) to_conv

Line 480: , MTL_PARAMETERS mtp

476: , s_program_application_id
477: , s_request_id
478: FROM OPI_DBI_RUN_LOG_CURR LOG
479: , MTL_MATERIAL_TRANSACTIONS MMT
480: , MTL_PARAMETERS mtp
481: WHERE 1 = 1
482: AND MMT.transaction_action_id IN (1, 27, 31, 32, 30) -- Issue, Receipt, Completion, Return,Scrap
483: AND MMT.transaction_source_type_id = 5 -- Jobs abd Schedules
484: AND MMT.ORGANiZATION_ID = mtp.organization_id

Line 517: , MTL_PARAMETERS mtp

513: , s_program_application_id
514: , s_request_id
515: FROM OPI_DBI_RUN_LOG_CURR LOG
516: , MTL_MATERIAL_TRANSACTIONS MMT
517: , MTL_PARAMETERS mtp
518: WHERE 1 = 1
519: AND MMT.transaction_action_id IN (1, 27, 31, 32, 30) -- Issue, Receipt, Completion, Return,Scrap
520: AND MMT.transaction_source_type_id = 5 -- Jobs abd Schedules
521: AND MMT.ORGANiZATION_ID = mtp.organization_id