APPS.WMS_WORKFLOW_WRAPPERS dependencies on MTL_TRANSACTION_REASONS

Line 421: FROM mtl_transaction_reasons

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

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

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

Line 980: FROM MTL_TRANSACTION_REASONS

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