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

Line 907: FROM mtl_transaction_reasons

903: BEGIN
904:
905: OPEN x_reasons FOR
906: SELECT reason_name,description, reason_id
907: FROM mtl_transaction_reasons
908: WHERE reason_type=p_reason_type
909: AND nvl(DISABLE_DATE, SYSDATE+1) > SYSDATE
910: AND reason_name LIKE (p_concat_segments)
911: ORDER BY reason_name;

Line 929: FROM mtl_transaction_reasons

925: BEGIN
926:
927: OPEN x_reasons FOR
928: SELECT reason_name,description, reason_id
929: FROM mtl_transaction_reasons
930: WHERE reason_type=p_reason_type
931: AND nvl(DISABLE_DATE, SYSDATE+1) > SYSDATE
932: AND reason_name LIKE (p_concat_segments)
933: -- nsrivast, invconv , transaction reason security

Line 1428: FROM mtl_transaction_reasons

1424:
1425: BEGIN
1426: SELECT COUNT(reason_name)
1427: INTO l_reason_count
1428: FROM mtl_transaction_reasons
1429: WHERE reason_type = p_reason_type -- Picking
1430: AND Nvl(DISABLE_DATE, SYSDATE+1) > SYSDATE
1431: AND Decode(reason_context_code,
1432: 'CP', l_cp_allowed,

Line 1450: FROM mtl_transaction_reasons

1446: OPEN x_reasons FOR
1447: SELECT reason_name, description,
1448: reason_id, reason_context_code,
1449: workflow_name, workflow_process, l_reason_count
1450: FROM mtl_transaction_reasons
1451: WHERE reason_type = p_reason_type -- Picking
1452: AND Nvl(DISABLE_DATE, Sysdate+1) > Sysdate
1453: AND Decode(reason_context_code,
1454: 'CP', l_cp_allowed,

Line 1516: FROM mtl_transaction_reasons

1512:
1513: BEGIN
1514: SELECT COUNT(reason_name)
1515: INTO l_reason_count
1516: FROM mtl_transaction_reasons
1517: WHERE reason_type = p_reason_type -- Picking
1518: AND Nvl(DISABLE_DATE, SYSDATE+1) > SYSDATE
1519: AND Decode(reason_context_code,
1520: 'CP', l_cp_allowed,

Line 1549: FROM mtl_transaction_reasons

1545: OPEN x_reasons FOR
1546: SELECT reason_name, description,
1547: reason_id, reason_context_code,
1548: workflow_name, workflow_process, l_reason_count
1549: FROM mtl_transaction_reasons
1550: WHERE reason_type = p_reason_type -- Picking
1551: AND Nvl(DISABLE_DATE, Sysdate+1) > Sysdate
1552: AND Decode(reason_context_code,
1553: 'CP', l_cp_allowed,