DBA Data[Home] [Help]

APPS.CS_INVENTORY_TXNS dependencies on MTL_TRANSACTION_TYPES

Line 67: FROM mtl_transaction_types

63: -- transaction_action_id = 1, the user should be allowed to inventory transactions
64:
65: SELECT transaction_action_id
66: INTO p_transaction_action_id
67: FROM mtl_transaction_types
68: WHERE transaction_type_id = to_number(fnd_profile.value_specific('CS_FIELD_SERVICE_TRANSACTION_TYPE'));
69:
70: IF p_transaction_action_id <> 1 THEN
71: p_error_flag := 'Y';

Line 111: FROM MTL_TRANSACTION_TYPES

107:
108: CURSOR Mtl_Txn_Details IS
109: SELECT Transaction_Source_Type_Id,
110: Transaction_Action_Id
111: FROM MTL_TRANSACTION_TYPES
112: WHERE TRANSACTION_TYPE_ID = p_transaction_Type_Id;
113:
114: CURSOR MTl_Item_Account IS
115: SELECT Cost_Of_Sales_Account