DBA Data[Home] [Help]

APPS.WMS_RULES_WORKBENCH_PVT dependencies on MFG_LOOKUPS

Line 137: FROM mfg_lookups_v

133: return l_return_type_name;
134: ELSIF (p_rule_type_code = 12) THEN -- Bug : 6682436
135: SELECT meaning
136: INTO l_return_type_name
137: FROM mfg_lookups_v
138: WHERE lookup_type = 'WMS_CARTONIZATION_ALGORITHMS'
139: AND lookup_code = p_return_type_id;
140: return l_return_type_name;
141: END IF;

Line 509: from mfg_lookups ml

505: Begin
506:
507: select ml.meaning
508: into l_transaction_action_name
509: from mfg_lookups ml
510: where ml.lookup_type = 'MTL_TRANSACTION_ACTION'
511: and ml.lookup_code = p_transaction_action_id ;
512:
513: Return l_transaction_action_name;