710: AND eri.revised_item_id = p_revised_item_id
711: AND eri.revised_item_id = msiv.inventory_item_id
712: AND eri.organization_id = msiv.organization_id
713: AND decode(msiv.bom_item_type ,
714: 4 , nvl(FND_PROFILE.value('ENG:STANDARD_ITEM_ECN_ACCESS'), 1) ,
715: 3 , nvl(FND_PROFILE.value('ENG:PLANNING_ITEM_ECN_ACCESS'), 1) ,
716: 2 , nvl(FND_PROFILE.value('ENG:MODEL_ITEM_ECN_ACCESS'), 1) ,
717: 1 , nvl(FND_PROFILE.value('ENG:MODEL_ITEM_ECN_ACCESS'), 1) , 1) = 1
718: AND (eri.status_type = 1
711: AND eri.revised_item_id = msiv.inventory_item_id
712: AND eri.organization_id = msiv.organization_id
713: AND decode(msiv.bom_item_type ,
714: 4 , nvl(FND_PROFILE.value('ENG:STANDARD_ITEM_ECN_ACCESS'), 1) ,
715: 3 , nvl(FND_PROFILE.value('ENG:PLANNING_ITEM_ECN_ACCESS'), 1) ,
716: 2 , nvl(FND_PROFILE.value('ENG:MODEL_ITEM_ECN_ACCESS'), 1) ,
717: 1 , nvl(FND_PROFILE.value('ENG:MODEL_ITEM_ECN_ACCESS'), 1) , 1) = 1
718: AND (eri.status_type = 1
719: OR (eri.status_type = 10
712: AND eri.organization_id = msiv.organization_id
713: AND decode(msiv.bom_item_type ,
714: 4 , nvl(FND_PROFILE.value('ENG:STANDARD_ITEM_ECN_ACCESS'), 1) ,
715: 3 , nvl(FND_PROFILE.value('ENG:PLANNING_ITEM_ECN_ACCESS'), 1) ,
716: 2 , nvl(FND_PROFILE.value('ENG:MODEL_ITEM_ECN_ACCESS'), 1) ,
717: 1 , nvl(FND_PROFILE.value('ENG:MODEL_ITEM_ECN_ACCESS'), 1) , 1) = 1
718: AND (eri.status_type = 1
719: OR (eri.status_type = 10
720: AND EXISTS
713: AND decode(msiv.bom_item_type ,
714: 4 , nvl(FND_PROFILE.value('ENG:STANDARD_ITEM_ECN_ACCESS'), 1) ,
715: 3 , nvl(FND_PROFILE.value('ENG:PLANNING_ITEM_ECN_ACCESS'), 1) ,
716: 2 , nvl(FND_PROFILE.value('ENG:MODEL_ITEM_ECN_ACCESS'), 1) ,
717: 1 , nvl(FND_PROFILE.value('ENG:MODEL_ITEM_ECN_ACCESS'), 1) , 1) = 1
718: AND (eri.status_type = 1
719: OR (eri.status_type = 10
720: AND EXISTS
721: (SELECT 1
968: AND eri.revised_item_id = msiv.inventory_item_id
969: AND eri.organization_id = msiv.organization_id
970: -- 1: revised item privilege based on profile access values
971: AND decode(msiv.bom_item_type ,
972: 4 , nvl(FND_PROFILE.value('ENG:STANDARD_ITEM_ECN_ACCESS'), 1) ,
973: 3 , nvl(FND_PROFILE.value('ENG:PLANNING_ITEM_ECN_ACCESS'), 1) ,
974: 2 , nvl(FND_PROFILE.value('ENG:MODEL_ITEM_ECN_ACCESS'), 1) ,
975: 1 , nvl(FND_PROFILE.value('ENG:MODEL_ITEM_ECN_ACCESS'), 1) , 1) = 1
976: -- 2: revised item status check
969: AND eri.organization_id = msiv.organization_id
970: -- 1: revised item privilege based on profile access values
971: AND decode(msiv.bom_item_type ,
972: 4 , nvl(FND_PROFILE.value('ENG:STANDARD_ITEM_ECN_ACCESS'), 1) ,
973: 3 , nvl(FND_PROFILE.value('ENG:PLANNING_ITEM_ECN_ACCESS'), 1) ,
974: 2 , nvl(FND_PROFILE.value('ENG:MODEL_ITEM_ECN_ACCESS'), 1) ,
975: 1 , nvl(FND_PROFILE.value('ENG:MODEL_ITEM_ECN_ACCESS'), 1) , 1) = 1
976: -- 2: revised item status check
977: AND (eri.status_type = 1
970: -- 1: revised item privilege based on profile access values
971: AND decode(msiv.bom_item_type ,
972: 4 , nvl(FND_PROFILE.value('ENG:STANDARD_ITEM_ECN_ACCESS'), 1) ,
973: 3 , nvl(FND_PROFILE.value('ENG:PLANNING_ITEM_ECN_ACCESS'), 1) ,
974: 2 , nvl(FND_PROFILE.value('ENG:MODEL_ITEM_ECN_ACCESS'), 1) ,
975: 1 , nvl(FND_PROFILE.value('ENG:MODEL_ITEM_ECN_ACCESS'), 1) , 1) = 1
976: -- 2: revised item status check
977: AND (eri.status_type = 1
978: OR (eri.status_type = 10
971: AND decode(msiv.bom_item_type ,
972: 4 , nvl(FND_PROFILE.value('ENG:STANDARD_ITEM_ECN_ACCESS'), 1) ,
973: 3 , nvl(FND_PROFILE.value('ENG:PLANNING_ITEM_ECN_ACCESS'), 1) ,
974: 2 , nvl(FND_PROFILE.value('ENG:MODEL_ITEM_ECN_ACCESS'), 1) ,
975: 1 , nvl(FND_PROFILE.value('ENG:MODEL_ITEM_ECN_ACCESS'), 1) , 1) = 1
976: -- 2: revised item status check
977: AND (eri.status_type = 1
978: OR (eri.status_type = 10
979: AND EXISTS