DBA Data[Home] [Help]

APPS.INV_UI_RCV_LOVS dependencies on MTL_TRANSACTION_REASONS

Line 1022: FROM mtl_transaction_reasons

1018: IS
1019: BEGIN
1020: OPEN x_getReasonCodesLOV FOR
1021: SELECT reason_name ,description ,reason_id
1022: FROM mtl_transaction_reasons
1023: WHERE NVL(disable_date,SYSDATE + 1) > SYSDATE
1024: AND reason_name LIKE (p_reason_code)
1025: ORDER BY upper(reason_name);
1026:

Line 1042: FROM mtl_transaction_reasons

1038: IS
1039: BEGIN
1040: OPEN x_getReasonCodesLOV FOR
1041: SELECT reason_name ,description ,reason_id
1042: FROM mtl_transaction_reasons
1043: WHERE NVL(disable_date,SYSDATE + 1) > SYSDATE
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'