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_WMS_WAA_PKG dependencies on MTL_TRANSACTION_REASONS

Line 869: ,mtl_transaction_reasons mtr

865: ,tasks.completion_date completion_date
866: ,wmx.reason_id reason_id
867: FROM opi_dbi_wms_tasks_stg tasks
868: ,wms_exceptions wmx
869: ,mtl_transaction_reasons mtr
870: WHERE wmx.task_id = tasks.transaction_temp_id
871: AND tasks.task_type = 1
872: AND tasks.is_parent = 'Y'
873: AND mtr.reason_id = wmx.reason_id

Line 892: ,mtl_transaction_reasons mtr

888: ,wmx.reason_id reason_id
889: FROM opi_dbi_wms_op_stg ops
890: ,wms_exceptions wmx
891: ,opi_dbi_wms_tasks_stg tasks
892: ,mtl_transaction_reasons mtr
893: WHERE tasks.op_plan_instance_id = ops.op_plan_instance_id
894: AND tasks.task_type in (2,8)
895: AND wmx.task_id = tasks.transaction_temp_id
896: AND tasks.organization_id = ops.organization_id

Line 1397: ,mtl_transaction_reasons mtr

1393: ,tasks.completion_date completion_date
1394: ,wmx.reason_id reason_id
1395: FROM opi_dbi_wms_tasks_stg tasks
1396: ,wms_exceptions wmx
1397: ,mtl_transaction_reasons mtr
1398: WHERE wmx.task_id = tasks.transaction_temp_id
1399: AND tasks.task_type = 1
1400: AND tasks.is_parent = 'Y'
1401: AND mtr.reason_id = wmx.reason_id

Line 1418: ,mtl_transaction_reasons mtr

1414: ,wmx.reason_id reason_id
1415: FROM opi_dbi_wms_op_stg ops
1416: ,wms_exceptions wmx
1417: ,wms_dispatched_tasks_history wdth
1418: ,mtl_transaction_reasons mtr
1419: WHERE wdth.op_plan_instance_id = ops.op_plan_instance_id
1420: AND wdth.task_type in (2,8)
1421: AND wdth.transaction_temp_id IS NOT NULL
1422: AND wmx.task_id = wdth.transaction_temp_id