DBA Data[Home] [Help]

APPS.INV_UI_RCV_LOVS dependencies on MTL_TRANS_REASON_SECURITY

Line 1048: reason_id IN (SELECT reason_id FROM mtl_trans_reason_security mtrs

1044: AND reason_name LIKE (p_reason_code)
1045: -- nsrivast, invconv , transaction reason security
1046: AND ( NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'N'
1047: OR
1048: reason_id IN (SELECT reason_id FROM mtl_trans_reason_security mtrs
1049: WHERE(( responsibility_id = fnd_global.resp_id OR NVL(responsibility_id, -1) = -1 )
1050: AND
1051: ( mtrs.transaction_type_id = p_txn_type_id OR NVL(mtrs.transaction_type_id, -1) = -1 )
1052: )-- where ends