DBA Data[Home] [Help]

APPS.WMS_RULES_WORKBENCH_PVT dependencies on MFG_LOOKUPS

Line 138: FROM mfg_lookups_v

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

Line 510: from mfg_lookups ml

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