DBA Data[Home] [Help]

APPS.INV_INV_LOVS dependencies on MTL_TRANSACTION_REASONS

Line 603: FROM mtl_transaction_reasons

599: OPEN x_reason_lov FOR
600: SELECT reason_name
601: , description
602: , reason_id
603: FROM mtl_transaction_reasons
604: WHERE reason_name LIKE (p_reason)
605: AND nvl(DISABLE_DATE,SYSDATE+1) > SYSDATE ;
606: END;
607:

Line 625: FROM mtl_transaction_reasons

621: OPEN x_reason_lov FOR
622: SELECT reason_name
623: , description
624: , reason_id
625: FROM mtl_transaction_reasons
626: WHERE reason_name LIKE (p_reason)
627: AND nvl(DISABLE_DATE,SYSDATE+1) > SYSDATE
628: -- nsrivast, invconv , transaction reason security
629: AND ( NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'N'