APPS.WMS_WORKFLOW_WRAPPERS dependencies on MTL_TRANSACTION_REASONS

Line 420: FROM mtl_transaction_reasons

416: -- given the reason id, get reason name
417: IF p_reason_name IS NULL THEN
418: SELECT reason_name
419: INTO l_reason_name
420: FROM mtl_transaction_reasons
421: WHERE reason_id = p_reason_id;
422: ELSE
423: l_reason_name := p_reason_name;
424: END IF;

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

970:
971: IF (l_debug = 1) THEN
972: mdebug('Before Select WORKFLOW_NAME, WORKFLOW_PROCESS ');
973: END IF;
974: -- get workflow_name and workflow_process from mtl_transaction_reasons.
975: -- This is needed to create the workflow process
976: SELECT WORKFLOW_NAME, WORKFLOW_PROCESS
977: INTO l_workflow_name, l_workflow_process
978: FROM MTL_TRANSACTION_REASONS

Line 978: FROM MTL_TRANSACTION_REASONS

974: -- get workflow_name and workflow_process from mtl_transaction_reasons.
975: -- This is needed to create the workflow process
976: SELECT WORKFLOW_NAME, WORKFLOW_PROCESS
977: INTO l_workflow_name, l_workflow_process
978: FROM MTL_TRANSACTION_REASONS
979: WHERE REASON_ID = P_REASON_ID ;
980:
981: IF (l_debug = 1) THEN
982: mdebug('Workflow name is: '|| l_workflow_name);