DBA Data[Home] [Help]

APPS.INV_UI_RCV_LOVS dependencies on MTL_TRANSACTION_REASONS

Line 1052: FROM mtl_transaction_reasons

1048: IS
1049: BEGIN
1050: OPEN x_getReasonCodesLOV FOR
1051: SELECT reason_name ,description ,reason_id
1052: FROM mtl_transaction_reasons
1053: WHERE NVL(disable_date,SYSDATE + 1) > SYSDATE
1054: AND reason_name LIKE (p_reason_code)
1055: ORDER BY upper(reason_name);
1056:

Line 1072: FROM mtl_transaction_reasons

1068: IS
1069: BEGIN
1070: OPEN x_getReasonCodesLOV FOR
1071: SELECT reason_name ,description ,reason_id
1072: FROM mtl_transaction_reasons
1073: WHERE NVL(disable_date,SYSDATE + 1) > SYSDATE
1074: AND reason_name LIKE (p_reason_code)
1075: -- nsrivast, invconv , transaction reason security
1076: AND ( NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'N'