DBA Data[Home] [Help]

APPS.WMS_TXNREASONS_PUB dependencies on MTL_TRANSACTION_REASONS

Line 123: -- get workflow_name and workflow_process from mtl_transaction_reasons.

119:
120: IF (l_debug = 1) THEN
121: mdebug('Before Select WORKFLOW_NAME, WORKFLOW_PROCESS ');
122: END IF;
123: -- get workflow_name and workflow_process from mtl_transaction_reasons.
124: -- This is needed to create the workflow process
125: SELECT WORKFLOW_NAME, WORKFLOW_PROCESS
126: INTO l_workflow_name, l_workflow_process
127: FROM MTL_TRANSACTION_REASONS

Line 127: FROM MTL_TRANSACTION_REASONS

123: -- get workflow_name and workflow_process from mtl_transaction_reasons.
124: -- This is needed to create the workflow process
125: SELECT WORKFLOW_NAME, WORKFLOW_PROCESS
126: INTO l_workflow_name, l_workflow_process
127: FROM MTL_TRANSACTION_REASONS
128: WHERE P_REASON_ID = REASON_ID ;
129:
130: IF (l_debug = 1) THEN
131: mdebug('Workflow name is: '|| l_workflow_name);