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
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