DBA Data[Home] [Help]

APPS.INV_INV_LOVS dependencies on MTL_TRANSACTION_TYPES

Line 902: FROM mtl_transaction_types

898: SELECT transaction_type_id
899: , transaction_type_name
900: , description
901: , transaction_action_id
902: FROM mtl_transaction_types
903: WHERE transaction_action_id = p_transaction_action_id
904: AND transaction_source_type_id = p_transaction_source_type_id
905: AND transaction_type_name LIKE (p_transaction_type_name)
906: AND transaction_type_id NOT IN (66, 67, 68)

Line 914: FROM mtl_transaction_types

910: SELECT transaction_type_id
911: , transaction_type_name
912: , description
913: , transaction_action_id
914: FROM mtl_transaction_types
915: WHERE transaction_action_id = p_transaction_action_id
916: AND transaction_source_type_id = p_transaction_source_type_id
917: AND transaction_type_name LIKE (p_transaction_type_name)
918: AND Nvl(disable_date,SYSDATE+1) > SYSDATE; -- Bug9394143, to filter the transaction types that are disabled