APPS.MTL_RELATED_ITEMS_PVT dependencies on MFG_LOOKUPS

Line 528: FROM mfg_lookups

524: AND l_Rel_Item_Rec.RELATIONSHIP_TYPE_ID <> FND_API.G_MISS_NUM THEN
525:
526: BEGIN
527: SELECT 'x' INTO l_rel_type_exists
528: FROM mfg_lookups
529: WHERE lookup_type = 'MTL_RELATIONSHIP_TYPES'
530: AND enabled_flag = 'Y'
531: AND lookup_code >= 1
532: AND lookup_code = l_Rel_Item_Rec.RELATIONSHIP_TYPE_ID;

Line 549: ,p_table_name => 'MFG_LOOKUPS'

545: ,p_token_tbl => l_Token_Tbl
546: ,p_message_type => 'E'
547: ,p_entity_code => G_Entity_Code
548: ,p_entity_index => 1
549: ,p_table_name => 'MFG_LOOKUPS'
550: );
551: RAISE VALIDATION_ERROR;
552: END;
553: END IF;

Line 561: FROM mfg_lookups

557: AND l_Rel_Item_Rec.RELATIONSHIP_TYPE_ID_UPD_VAL <> FND_API.G_MISS_NUM THEN
558:
559: BEGIN
560: SELECT 'x' INTO l_rel_type_exists
561: FROM mfg_lookups
562: WHERE lookup_type = 'MTL_RELATIONSHIP_TYPES'
563: AND enabled_flag = 'Y'
564: AND lookup_code > =1
565: AND lookup_code = l_Rel_Item_Rec.RELATIONSHIP_TYPE_ID_UPD_VAL;

Line 582: ,p_table_name => 'MFG_LOOKUPS'

578: ,p_token_tbl => l_Token_Tbl
579: ,p_message_type => 'E'
580: ,p_entity_code => G_Entity_Code
581: ,p_entity_index => 1
582: ,p_table_name => 'MFG_LOOKUPS'
583: );
584: RAISE VALIDATION_ERROR;
585: END;
586: END IF;