DBA Data[Home] [Help]

APPS.INV_INV_LOVS dependencies on MTL_TRANSACTION_REASONS

Line 581: FROM mtl_transaction_reasons

577: OPEN x_reason_lov FOR
578: SELECT reason_name
579: , description
580: , reason_id
581: FROM mtl_transaction_reasons
582: WHERE reason_name LIKE (p_reason)
583: AND nvl(DISABLE_DATE,SYSDATE+1) > SYSDATE ;
584: END;
585:

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: -- nsrivast, invconv , transaction reason security
607: AND ( NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'N'