APPS.WMS_TASK_DISPATCH_LOV dependencies on MTL_TRANS_REASON_SECURITY

Line 996: reason_id IN (SELECT reason_id FROM mtl_trans_reason_security mtrs

992: AND reason_name LIKE p_concat_segments || '%' -- Bug 14369838
993: -- nsrivast, invconv , transaction reason security
994: AND ( NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'N'
995: OR
996: reason_id IN (SELECT reason_id FROM mtl_trans_reason_security mtrs
997: WHERE(( responsibility_id = fnd_global.resp_id OR NVL(responsibility_id, -1) = -1 )
998: AND
999: ( mtrs.transaction_type_id = p_txn_type_id OR NVL(mtrs.transaction_type_id, -1) = -1 )
1000: )-- where ends

Line 1012: reason_id NOT IN (SELECT mtrs.reason_id FROM mtl_trans_reason_security mtrs )

1008: AND reason_name LIKE p_concat_segments || '%'
1009: -- nsrivast, invconv , transaction reason security
1010: AND NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'Y'
1011: AND
1012: reason_id NOT IN (SELECT mtrs.reason_id FROM mtl_trans_reason_security mtrs )
1013: ORDER BY reason_name;
1014:
1015: END get_reasons_lov;
1016:

Line 1628: reason_id IN (SELECT reason_id FROM mtl_trans_reason_security mtrs

1624: AND reason_name LIKE p_concat_segments || '%'
1625: -- nsrivast, invconv , transaction reason security
1626: AND ( NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'N'
1627: OR
1628: reason_id IN (SELECT reason_id FROM mtl_trans_reason_security mtrs
1629: WHERE(( responsibility_id = fnd_global.resp_id OR NVL(responsibility_id, -1) = -1 )
1630: AND
1631: ( mtrs.transaction_type_id = p_txn_type_id OR NVL(mtrs.transaction_type_id, -1) = -1 )
1632: )-- where ends

Line 1653: (SELECT mtrs.reason_id FROM mtl_trans_reason_security mtrs

1649: AND reason_name LIKE p_concat_segments || '%'
1650: -- nsrivast, invconv , transaction reason security
1651: AND NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'Y'
1652: AND reason_id NOT IN
1653: (SELECT mtrs.reason_id FROM mtl_trans_reason_security mtrs
1654: )
1655: ) -- Added for bug 14319939 end
1656: ;
1657: EXCEPTION

Line 1685: reason_id IN (SELECT reason_id FROM mtl_trans_reason_security mtrs

1681: AND reason_name LIKE p_concat_segments || '%'
1682: -- nsrivast, invconv , transaction reason security
1683: AND ( NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'N'
1684: OR
1685: reason_id IN (SELECT reason_id FROM mtl_trans_reason_security mtrs
1686: WHERE(( responsibility_id = fnd_global.resp_id OR NVL(responsibility_id, -1) = -1 )
1687: AND
1688: ( mtrs.transaction_type_id = p_txn_type_id OR NVL(mtrs.transaction_type_id, -1) = -1 )
1689: )-- where ends

Line 1712: (SELECT mtrs.reason_id FROM mtl_trans_reason_security mtrs

1708: AND reason_name LIKE p_concat_segments || '%'
1709: -- nsrivast, invconv , transaction reason security
1710: AND NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'Y'
1711: AND reason_id NOT IN
1712: (SELECT mtrs.reason_id FROM mtl_trans_reason_security mtrs
1713: ) -- Bug 14319939 end
1714: ORDER BY reason_name;
1715:
1716: END get_reasons_lov;