eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ENG_REVISED_ITEM_UTIL dependencies on ENG_REVISED_ITEMS

Line 60: from ENG_REVISED_ITEMS eri

56: and bor2.alternate_routing_designator is not null))
57: or
58: (bor.alternate_routing_designator is not null))
59: and not exists (select null
60: from ENG_REVISED_ITEMS eri
61: where eri.organization_id = bor.organization_id
62: and eri.bill_sequence_id = bor.routing_sequence_id
63: and eri.change_notice <> p_change_notice
64: );

Line 162: From eng_revised_items eri

158: Select 'x' dummy
159: From dual
160: Where not exists (
161: Select null
162: From eng_revised_items eri
163: Where eri.change_notice = p_change_notice
164: And eri.organization_id = p_organization_id
165: And eri.status_type not in (6, 5));
166:

Line 172: From eng_revised_items eri

168: Select 'x' dummy
169: From dual
170: Where exists (
171: Select null
172: From eng_revised_items eri
173: Where eri.change_notice = p_change_notice
174: And eri.organization_id = p_organization_id
175: And eri.status_type = 6);
176: BEGIN

Line 321: from ENG_REVISED_ITEMS eri

317: and mriv.change_notice is null))
318: or
319: (bor.alternate_routing_designator is not null))
320: and not exists (select null
321: from ENG_REVISED_ITEMS eri
322: where eri.organization_id = bor.organization_id
323: and eri.routing_sequence_id = bor.routing_sequence_id
324: and eri.revised_item_sequence_id <> rev_item_seq
325: and eri.status_type <> 5);

Line 357: from eng_revised_items I

353: where REVISED_ITEM_SEQUENCE_ID = rev_item_seq);*/
354: -- Added revision_id to where clause for performance bug 4251776
355: delete from MTL_ITEM_REVISIONS_TL
356: where revision_id IN (select new_item_revision_id
357: from eng_revised_items I
358: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
359: DELETE FROM MTL_ITEM_REVISIONS_B I
360: where revision_id IN (select new_item_revision_id
361: from eng_revised_items I

Line 361: from eng_revised_items I

357: from eng_revised_items I
358: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
359: DELETE FROM MTL_ITEM_REVISIONS_B I
360: where revision_id IN (select new_item_revision_id
361: from eng_revised_items I
362: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
363: /*WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq;*/
364:
365:

Line 385: FROM ENG_REVISED_ITEMS R

381: AND B2.ASSEMBLY_ITEM_ID = B.ASSEMBLY_ITEM_ID
382: AND B2.ALTERNATE_BOM_DESIGNATOR IS NOT NULL))
383: OR
384: (NOT EXISTS (SELECT NULL
385: FROM ENG_REVISED_ITEMS R
386: WHERE R.ORGANIZATION_ID = B.ORGANIZATION_ID
387: AND R.BILL_SEQUENCE_ID = B.BILL_SEQUENCE_ID
388: AND R.REVISED_ITEM_SEQUENCE_ID <> rev_item_seq
389: AND R.STATUS_TYPE <> 5)));

Line 396: UPDATE ENG_REVISED_ITEMS R

392:
393: -- If bill was deleted, then unset the bill_sequence_id on the revised item
394:
395: if (SQL%ROWCOUNT > 0) then
396: UPDATE ENG_REVISED_ITEMS R
397: SET BILL_SEQUENCE_ID = ''
398: , cancel_comments = cancel_comments
399: , cancellation_date = SYSDATE
400: WHERE R.REVISED_ITEM_SEQUENCE_ID = rev_item_seq;

Line 493: FROM ENG_REVISED_ITEMS eri

489: AND bor2.ALTERNATE_ROUTING_DESIGNATOR IS NOT NULL))
490: OR
491: (bor1.ALTERNATE_ROUTING_DESIGNATOR IS NOT NULL
492: AND NOT EXISTS (SELECT NULL
493: FROM ENG_REVISED_ITEMS eri
494: WHERE eri.ORGANIZATION_ID = bor1.ORGANIZATION_ID
495: AND eri.ROUTING_SEQUENCE_ID = bor1.ROUTING_SEQUENCE_ID
496: AND eri.CHANGE_NOTICE <> change_order)));*/
497:

Line 504: UPDATE ENG_REVISED_ITEMS eri

500: -- If routing was deleted, then unset the routing_sequence_id on the revised item
501:
502: --if (SQL%ROWCOUNT > 0) then
503: IF (l_del_rtg_header = 1) THEN -- Bug 3668603
504: UPDATE ENG_REVISED_ITEMS eri
505: SET routing_sequence_id = ''
506: , cancel_comments = cancel_comments
507: , cancellation_date = SYSDATE
508: WHERE eri.REVISED_ITEM_SEQUENCE_ID = rev_item_seq;

Line 699: UPDATE ENG_REVISED_ITEMS

695: x_err_text => l_err_text);
696: END IF;
697: END IF;
698:
699: UPDATE ENG_REVISED_ITEMS
700: SET new_item_revision_id = l_new_item_rev_id,
701: new_lifecycle_state_id = l_new_life_cycle_state_id
702: WHERE REVISED_ITEM_SEQUENCE_ID = p_revised_item_seq_id;
703:

Line 773: UPDATE ENG_REVISED_ITEMS

769: p_control_rec.caller_type <> 'FORM'
770: THEN
771: BEGIN
772: l_stmt_num := 1;
773: UPDATE ENG_REVISED_ITEMS
774: SET CHANGE_NOTICE = p_revised_item_rec.eco_name
775: , ORGANIZATION_ID = p_rev_item_unexp_rec.organization_id
776: , REVISED_ITEM_ID = p_rev_item_unexp_rec.revised_item_id
777: , LAST_UPDATE_DATE = SYSDATE

Line 996: ENG_REVISED_ITEMS_PKG.Delete_Item_Revisions

992: -- exists
993: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Deleting Item Revisions . . .'); END IF;
994:
995: l_stmt_num := 3;
996: ENG_REVISED_ITEMS_PKG.Delete_Item_Revisions
997: ( x_change_notice =>
998: p_revised_item_rec.eco_name
999: , x_organization_id =>
1000: p_rev_item_unexp_rec.organization_id

Line 1029: /* ENG_REVISED_ITEMS_PKG.Update_Item_Revisions

1025:
1026:
1027: l_stmt_num := 4;
1028:
1029: /* ENG_REVISED_ITEMS_PKG.Update_Item_Revisions
1030: ( x_revision =>
1031: p_revised_item_rec.updated_revised_item_revision
1032: -- , x_scheduled_date => p_revised_item_rec.new_effective_date
1033: , x_scheduled_date =>

Line 1128: ENG_REVISED_ITEMS_PKG.Insert_Item_Revisions

1124:
1125: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Inserting Item Revisions . . .'); END IF;
1126: l_stmt_num := 5;
1127: IF (p_revised_item_rec.new_effective_date is NULL) THEN
1128: ENG_REVISED_ITEMS_PKG.Insert_Item_Revisions
1129: ( x_inventory_item_id =>
1130: p_rev_item_unexp_rec.revised_item_id
1131: , x_organization_id =>
1132: p_rev_item_unexp_rec.organization_id

Line 1147: ENG_REVISED_ITEMS_PKG.Insert_Item_Revisions

1143: , x_revision_description =>
1144: p_revised_item_rec.new_revised_item_rev_desc
1145: );
1146: ELSE
1147: ENG_REVISED_ITEMS_PKG.Insert_Item_Revisions
1148: ( x_inventory_item_id =>
1149: p_rev_item_unexp_rec.revised_item_id
1150: , x_organization_id =>
1151: p_rev_item_unexp_rec.organization_id

Line 1319: ENG_REVISED_ITEMS_PKG.Update_Inventory_Components

1315: l_stmt_num := 6;
1316:
1317: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Updating effective daste for child rev comps . . .'); END IF;
1318:
1319: ENG_REVISED_ITEMS_PKG.Update_Inventory_Components
1320: ( x_change_notice =>
1321: p_revised_item_rec.eco_name
1322: , x_bill_sequence_id =>
1323: p_rev_item_unexp_rec.bill_sequence_id

Line 1618: INSERT INTO ENG_REVISED_ITEMS

1614: p_control_rec.validation_controller = 'MAIN_EFFECTS')
1615: OR
1616: p_control_rec.caller_type <> 'FORM'
1617: THEN
1618: INSERT INTO ENG_REVISED_ITEMS
1619: (
1620: CHANGE_NOTICE
1621: , ORGANIZATION_ID
1622: , REVISED_ITEM_ID

Line 1817: ENG_REVISED_ITEMS_PKG.Insert_Item_Revisions

1813: p_revised_item_rec.new_revised_item_revision <> FND_API.G_MISS_CHAR
1814: )
1815: THEN
1816: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Inserting item revisions . . . '); END IF;
1817: ENG_REVISED_ITEMS_PKG.Insert_Item_Revisions
1818: ( x_inventory_item_id =>
1819: p_rev_item_unexp_rec.revised_item_id
1820: , x_organization_id =>
1821: p_rev_item_unexp_rec.organization_id

Line 1918: ENG_REVISED_ITEMS_PKG.Create_BOM

1914: );
1915:
1916: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Creating Altenate BOM . . .'); END IF;
1917:
1918: ENG_REVISED_ITEMS_PKG.Create_BOM
1919: ( x_assembly_item_id =>
1920: p_rev_item_unexp_rec.revised_item_id
1921: , x_organization_id =>
1922: p_rev_item_unexp_rec.organization_id

Line 1942: UPDATE ENG_REVISED_ITEMS

1938:
1939: -- Added by MK on 02/15/2001 for Bug#1647352
1940: -- Set Bill Sequence Id to Revised Item table
1941: --
1942: UPDATE ENG_REVISED_ITEMS
1943: SET bill_sequence_id = p_rev_item_unexp_rec.bill_sequence_id
1944: , last_update_date = SYSDATE -- Last Update Date
1945: , last_updated_by = l_user_id -- Last Updated By
1946: , last_update_login = l_login_id -- Last Update Login

Line 2081: FROM eng_revised_items

2077:
2078: INTO l_change_notice, l_organization_id, l_revised_item_id,
2079: l_revised_item_sequence_id, l_bill_sequence_id
2080: , l_routing_sequence_id -- Added by MK
2081: FROM eng_revised_items
2082: WHERE revised_item_sequence_id = p_revised_item_sequence_id;
2083:
2084: DELETE FROM ENG_REVISED_ITEMS
2085: WHERE REVISED_ITEM_SEQUENCE_ID = p_revised_item_sequence_id;

Line 2084: DELETE FROM ENG_REVISED_ITEMS

2080: , l_routing_sequence_id -- Added by MK
2081: FROM eng_revised_items
2082: WHERE revised_item_sequence_id = p_revised_item_sequence_id;
2083:
2084: DELETE FROM ENG_REVISED_ITEMS
2085: WHERE REVISED_ITEM_SEQUENCE_ID = p_revised_item_sequence_id;
2086:
2087: x_return_status := FND_API.G_RET_STS_SUCCESS;
2088:

Line 2106: ENG_REVISED_ITEMS_PKG.Delete_Details

2102: RETURN;
2103: END;
2104:
2105: BEGIN
2106: ENG_REVISED_ITEMS_PKG.Delete_Details
2107: ( x_organization_id => l_organization_id
2108: , x_revised_item_id => l_revised_item_id
2109: , x_revised_item_sequence_id => p_revised_item_sequence_id
2110: , x_bill_sequence_id => l_bill_sequence_id

Line 2302: FROM ENG_REVISED_ITEMS

2298: , l_revised_item_rec.routing_comment
2299: , l_revised_item_rec.eco_for_production -- Added by MK on 10/06/00
2300: , l_rev_item_unexp_rec.CHANGE_ID --Added ON 12/12/02
2301: , l_rev_item_unexp_rec.status_code -- Added for bug 3618676
2302: FROM ENG_REVISED_ITEMS
2303: WHERE revised_item_id = p_revised_item_id
2304: AND organization_id = p_organization_id
2305: AND change_notice = p_change_notice
2306: AND NVL(new_item_revision, 'NONE') = NVL(p_new_item_revision, 'NONE')

Line 2464: FROM eng_revised_items

2460:
2461: CURSOR c_revised_item (cp_revised_item_sequence_id NUMBER) IS
2462: SELECT revised_item_id, bill_sequence_id, routing_sequence_id,
2463: change_notice, organization_id
2464: FROM eng_revised_items
2465: WHERE revised_item_sequence_id = cp_revised_item_sequence_id;
2466:
2467: l_rev_item c_revised_item%ROWTYPE;
2468: -- R12 Changes for common BOM

Line 2475: , cp_revised_item_seq_id eng_revised_items.revised_item_sequence_id%TYPE

2471: -- Cursor to Fetch all source bill's component changes that are being updated
2472: -- by reschedule
2473: CURSOR c_source_components(
2474: cp_change_notice eng_engineering_changes.change_notice%TYPE
2475: , cp_revised_item_seq_id eng_revised_items.revised_item_sequence_id%TYPE
2476: , cp_bill_sequence_id bom_structures_b.bill_sequence_id%TYPE) IS
2477: SELECT bcb.component_sequence_id
2478: FROM bom_components_b bcb
2479: WHERE bcb.CHANGE_NOTICE = cp_change_notice

Line 2658: FROM eng_revised_items

2654: CURSOR c_revised_item (cp_revised_item_sequence_id NUMBER) IS
2655: SELECT change_notice, organization_id, revised_item_id, disposition_type
2656: , early_schedule_date, status_type, bill_sequence_id, mrp_active
2657: , DESCRIPTIVE_TEXT, change_id, ALTERNATE_BOM_DESIGNATOR, status_code
2658: FROM eng_revised_items
2659: WHERE revised_item_sequence_id = cp_revised_item_sequence_id;
2660:
2661: l_old_revised_item_rec c_revised_item%ROWTYPE;
2662: l_revised_item_rec Eng_Eco_Pub.Revised_Item_Rec_Type;

Line 2681: SELECT eng_revised_items_s.NEXTVAL INTO x_new_revised_item_seq_id FROM dual;

2677: --
2678: -- Generate a sequence_number for the new revised item
2679: -- Copy only attributes required for creation of revised item context
2680: --
2681: SELECT eng_revised_items_s.NEXTVAL INTO x_new_revised_item_seq_id FROM dual;
2682: l_revised_item_rec.eco_name := l_old_revised_item_rec.change_notice;
2683: l_rev_item_unexp_rec.organization_id := l_old_revised_item_rec.organization_id;
2684: l_rev_item_unexp_rec.revised_item_id := l_old_revised_item_rec.revised_item_id;
2685: l_revised_item_rec.disposition_type := l_old_revised_item_rec.disposition_type;