DBA Data[Home] [Help]

APPS.INV_TRANSACTION_LOVS dependencies on MTL_TRANSACTION_TYPES

Line 35: from mtl_transaction_types

31: p_transaction_source_type_id IN NUMBER) IS
32: begin
33: open x_motxntypeLOV FOR
34: select transaction_type_id, transaction_type_name, description, transaction_action_id
35: from mtl_transaction_types
36: where transaction_source_type_id = p_transaction_Source_type_id;
37: END GET_TXN_TYPES;
38:
39:

Line 47: from mtl_transaction_types

43: p_Transaction_Type_Name IN VARCHAR2) IS
44: BEGIN
45: OPEN x_txntypeLOV FOR
46: select transaction_type_id,transaction_type_name,description
47: from mtl_transaction_types
48: where transaction_action_id = p_Transaction_Action_Id and
49: transaction_source_type_id = p_Transaction_Source_Type_Id and
50: transaction_type_name like p_Transaction_Type_Name;
51: