DBA Data[Home] [Help]

APPS.ENG_REVISED_ITEMS_PKG dependencies on STANDARD

Line 737: 4 , nvl(FND_PROFILE.value('ENG:STANDARD_ITEM_ECN_ACCESS'), 1) ,

733: AND eri.revised_item_id = p_revised_item_id
734: AND eri.revised_item_id = msiv.inventory_item_id
735: AND eri.organization_id = msiv.organization_id
736: AND decode(msiv.bom_item_type ,
737: 4 , nvl(FND_PROFILE.value('ENG:STANDARD_ITEM_ECN_ACCESS'), 1) ,
738: 3 , nvl(FND_PROFILE.value('ENG:PLANNING_ITEM_ECN_ACCESS'), 1) ,
739: 2 , nvl(FND_PROFILE.value('ENG:MODEL_ITEM_ECN_ACCESS'), 1) ,
740: 1 , nvl(FND_PROFILE.value('ENG:MODEL_ITEM_ECN_ACCESS'), 1) , 1) = 1
741: AND (eri.status_type = 1

Line 995: 4 , nvl(FND_PROFILE.value('ENG:STANDARD_ITEM_ECN_ACCESS'), 1) ,

991: AND eri.revised_item_id = msiv.inventory_item_id
992: AND eri.organization_id = msiv.organization_id
993: -- 1: revised item privilege based on profile access values
994: AND decode(msiv.bom_item_type ,
995: 4 , nvl(FND_PROFILE.value('ENG:STANDARD_ITEM_ECN_ACCESS'), 1) ,
996: 3 , nvl(FND_PROFILE.value('ENG:PLANNING_ITEM_ECN_ACCESS'), 1) ,
997: 2 , nvl(FND_PROFILE.value('ENG:MODEL_ITEM_ECN_ACCESS'), 1) ,
998: 1 , nvl(FND_PROFILE.value('ENG:MODEL_ITEM_ECN_ACCESS'), 1) , 1) = 1
999: -- 2: revised item status check