APPS.ENG_VALIDATE_ECO dependencies on ENG_REVISED_ITEMS

Line 183: (select revised_item_id from eng_revised_items

179: CURSOR eng_item_cur IS
180: SELECT 'y'
181: FROM mtl_system_items
182: WHERE inventory_item_id =
183: (select revised_item_id from eng_revised_items
184: where change_notice = p_change_notice
185: and organization_id = organization_id)
186: AND organization_id = p_organization_id
187: AND eng_item_flag = 'Y';

Line 251: FROM eng_revised_items

247:
248: l_ri_exists NUMBER := 0;
249: CURSOR GetRevisedItems IS
250: SELECT 'x'
251: FROM eng_revised_items
252: WHERE change_notice = p_ECO_rec.ECO_Name
253: AND organization_id = p_Unexp_ECO_rec.organization_id;
254: BEGIN
255:

Line 308: , ENG_REVISED_ITEMS eri1

304: SELECT 'Rev Comp referencing Seq Num exists'
305: FROM SYS.DUAL
306: WHERE EXISTS (SELECT NULL
307: FROM ENG_ENGINEERING_CHANGES eec1
308: , ENG_REVISED_ITEMS eri1
309: , ENG_REVISED_ITEMS eri2
310: WHERE eri1.revised_item_id = eri2.revised_item_id
311: AND eri1.organization_id = eec1.organization_id
312: AND eri1.change_notice = eec1.change_notice

Line 309: , ENG_REVISED_ITEMS eri2

305: FROM SYS.DUAL
306: WHERE EXISTS (SELECT NULL
307: FROM ENG_ENGINEERING_CHANGES eec1
308: , ENG_REVISED_ITEMS eri1
309: , ENG_REVISED_ITEMS eri2
310: WHERE eri1.revised_item_id = eri2.revised_item_id
311: AND eri1.organization_id = eec1.organization_id
312: AND eri1.change_notice = eec1.change_notice
313: AND eec1.change_notice <> p_eco_name

Line 490: FROM eng_revised_items

486:
487: l_ri_exists NUMBER := 0;
488: CURSOR GetRevisedItems IS
489: SELECT 'x'
490: FROM eng_revised_items
491: WHERE change_notice = p_ECO_rec.ECO_Name
492: AND organization_id = p_Unexp_ECO_rec.organization_id;
493:
494: l_ri_sched_exists NUMBER := 0;

Line 497: FROM eng_revised_items

493:
494: l_ri_sched_exists NUMBER := 0;
495: CURSOR GetScheduledRevItems IS
496: SELECT 'x'
497: FROM eng_revised_items
498: WHERE change_notice = p_ECO_rec.ECO_Name
499: AND organization_id = p_Unexp_ECO_rec.organization_id
500: AND status_type = 4;
501:

Line 1195: FROM eng_revised_items

1191: and sequence_number<> -1;
1192:
1193: CURSOR revised_items_for_eco( p_change_id NUMBER) IS
1194: SELECT STATUS_TYPE ,scheduled_date
1195: FROM eng_revised_items
1196: WHERE eng_revised_items.change_id = p_change_id;
1197:
1198:
1199:

Line 1196: WHERE eng_revised_items.change_id = p_change_id;

1192:
1193: CURSOR revised_items_for_eco( p_change_id NUMBER) IS
1194: SELECT STATUS_TYPE ,scheduled_date
1195: FROM eng_revised_items
1196: WHERE eng_revised_items.change_id = p_change_id;
1197:
1198:
1199:
1200: ----Bug 2908248