APPS.WMS_TASK_DISPATCH_LOV dependencies on MTL_TRANSACTION_REASONS

Line 966: FROM mtl_transaction_reasons

962: inv_trx_util_pub.trace( 'WMS_Task_Dispatch_LOV - GET_REASONS_LOV - p_reason type' || p_reason_type || 'p_concat_segments -' || p_concat_segments , '~~~~ ', 1); --/* Bug 9448490 Lot Substitution Project */
963:
964: OPEN x_reasons FOR
965: SELECT reason_name,description, reason_id
966: FROM mtl_transaction_reasons
967: WHERE reason_type=p_reason_type
968: AND nvl(DISABLE_DATE, SYSDATE+1) > SYSDATE
969: AND reason_name LIKE (p_concat_segments || '%') --12970028
970: ORDER BY reason_name;

Line 989: FROM mtl_transaction_reasons

985: mydebug('In GET_LPN_ITEMS_LOV fnd_global.resp_id:' || fnd_global.resp_id || '...fnd_profile.value_wnps_INV_TRANS_REASON_SECURITY:'||fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'));
986: mydebug('In p_txn_type_id :' || p_txn_type_id);
987: OPEN x_reasons FOR
988: SELECT reason_name,description, reason_id
989: FROM mtl_transaction_reasons
990: WHERE reason_type=p_reason_type
991: AND nvl(DISABLE_DATE, SYSDATE+1) > SYSDATE
992: AND reason_name LIKE p_concat_segments || '%' -- Bug 14369838
993: -- nsrivast, invconv , transaction reason security

Line 1005: FROM mtl_transaction_reasons

1001: )-- select ends
1002: ) -- and condn ends ,-- nsrivast, invconv
1003: UNION ALL -- Bug 14369838
1004: SELECT reason_name,description, reason_id
1005: FROM mtl_transaction_reasons
1006: WHERE reason_type=p_reason_type
1007: AND nvl(DISABLE_DATE, SYSDATE+1) > SYSDATE
1008: AND reason_name LIKE p_concat_segments || '%'
1009: -- nsrivast, invconv , transaction reason security

Line 1510: FROM mtl_transaction_reasons

1506:
1507: BEGIN
1508: SELECT COUNT(reason_name)
1509: INTO l_reason_count
1510: FROM mtl_transaction_reasons
1511: WHERE reason_type = p_reason_type -- Picking
1512: AND Nvl(DISABLE_DATE, SYSDATE+1) > SYSDATE
1513: AND Decode(reason_context_code,
1514: 'CP', l_cp_allowed,

Line 1533: FROM mtl_transaction_reasons

1529: OPEN x_reasons FOR
1530: SELECT reason_name, description,
1531: reason_id, reason_context_code,
1532: workflow_name, workflow_process, l_reason_count
1533: FROM mtl_transaction_reasons
1534: WHERE reason_type = p_reason_type -- Picking
1535: AND Nvl(DISABLE_DATE, Sysdate+1) > Sysdate
1536: AND Decode(reason_context_code,
1537: 'CP', l_cp_allowed,

Line 1612: FROM mtl_transaction_reasons

1608: SELECT COUNT(reason_name)
1609: INTO l_reason_count
1610: FROM ( -- Added for Bug 14319939
1611: select reason_name -- Added for Bug 14319939
1612: FROM mtl_transaction_reasons
1613: WHERE reason_type = p_reason_type -- Picking
1614: AND Nvl(DISABLE_DATE, SYSDATE+1) > SYSDATE
1615: AND Decode(reason_context_code,
1616: 'CP', l_cp_allowed,

Line 1637: FROM mtl_transaction_reasons

1633: )-- select ends
1634: ) -- and condn ends ,-- nsrivast, invconv
1635: UNION ALL -- Added for bug 14319939 start
1636: SELECT reason_name
1637: FROM mtl_transaction_reasons
1638: WHERE reason_type = p_reason_type
1639: AND NVL(DISABLE_DATE, SYSDATE+1) > SYSDATE
1640: AND Decode(reason_context_code,
1641: 'CP', l_cp_allowed,

Line 1669: FROM mtl_transaction_reasons

1665: OPEN x_reasons FOR
1666: SELECT reason_name, description,
1667: reason_id, reason_context_code,
1668: workflow_name, workflow_process, l_reason_count
1669: FROM mtl_transaction_reasons
1670: WHERE reason_type = p_reason_type -- Picking
1671: AND Nvl(DISABLE_DATE, Sysdate+1) > Sysdate
1672: AND Decode(reason_context_code,
1673: 'CP', l_cp_allowed,

Line 1696: FROM mtl_transaction_reasons

1692: UNION ALL -- Bug 14319939 start
1693: SELECT reason_name, description,
1694: reason_id, reason_context_code,
1695: workflow_name, workflow_process, l_reason_count
1696: FROM mtl_transaction_reasons
1697: WHERE reason_type = p_reason_type
1698: AND NVL(DISABLE_DATE, SYSDATE+1) > SYSDATE
1699: AND Decode(reason_context_code,
1700: 'CP', l_cp_allowed,