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.WMS_TXNRSN_ACTIONS_PUB dependencies on MTL_TRANSACTION_REASONS

Line 2403: FROM mtl_transaction_reasons

2399: THEN
2400: BEGIN
2401: SELECT 1
2402: INTO l_wf
2403: FROM mtl_transaction_reasons
2404: WHERE reason_id = p_qty_rsn_id
2405: AND workflow_name IS NOT NULL
2406: AND workflow_name <> ' '
2407: AND workflow_process IS NOT NULL

Line 2964: l_workflow_name mtl_transaction_reasons.workflow_name%TYPE;

2960: l_subinventory_code wms_exceptions.subinventory_code%TYPE;
2961: l_locator_id NUMBER;
2962: l_lpn_id NUMBER;
2963: l_lot_number mtl_lot_numbers.lot_number%TYPE;
2964: l_workflow_name mtl_transaction_reasons.workflow_name%TYPE;
2965: l_workflow_process mtl_transaction_reasons.workflow_process%TYPE;
2966: l_user_id NUMBER := fnd_global.user_id;
2967:
2968: BEGIN

Line 2965: l_workflow_process mtl_transaction_reasons.workflow_process%TYPE;

2961: l_locator_id NUMBER;
2962: l_lpn_id NUMBER;
2963: l_lot_number mtl_lot_numbers.lot_number%TYPE;
2964: l_workflow_name mtl_transaction_reasons.workflow_name%TYPE;
2965: l_workflow_process mtl_transaction_reasons.workflow_process%TYPE;
2966: l_user_id NUMBER := fnd_global.user_id;
2967:
2968: BEGIN
2969: x_return_status := 'S';