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_ECO_UTIL dependencies on ENG_REVISED_ITEMS

Line 337: UPDATE eng_revised_items

333: ELSE
334: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('setting x_request_id' );
335: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' x_request_id = ' || to_char(x_request_id) );
336: IF (p_rev_item_seq_id IS NOT NULL ) THEN
337: UPDATE eng_revised_items
338: SET implementation_req_id = x_request_id
339: WHERE revised_item_sequence_id = p_rev_item_seq_id;
340: ELSE
341: UPDATE eng_engineering_changes

Line 514: From Eng_Revised_Items eri

510: -- and return an error message
511: /*
512: Select count(*)
513: Into l_dummy_counter
514: From Eng_Revised_Items eri
515: Where eri.change_id = p_change_id
516: And eri.status_type not in ( 5, -- CANCELLED
517: 6, -- IMPLEMENTED
518: 9, -- IMPLEMENTATION_IN_PROGRESS

Line 830: From Eng_Revised_Items eri

826: -- and return an error message
827: /*
828: Select count(*)
829: Into l_dummy_counter
830: From Eng_Revised_Items eri
831: Where eri.change_id = p_change_id
832: And eri.status_type not in ( 5, -- CANCELLED
833: 6, -- IMPLEMENTED
834: 9, -- IMPLEMENTATION_IN_PROGRESS

Line 1462: Update Eng_Revised_Items eri

1458: INTO x_change_notice, x_organization_id
1459: FROM eng_engineering_changes
1460: WHERE change_id = p_change_id;
1461:
1462: Update Eng_Revised_Items eri
1463: Set eri.scheduled_date = p_effectivity_date,
1464: eri.last_update_date = sysdate,
1465: eri.last_updated_by = x_user_id,
1466: eri.last_update_login = x_login_id

Line 1482: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Eng_Revised_Items updated ... ' );

1478: And msi.bom_item_type in (X_Model, X_OptionClass, X_Planning, X_Standard)
1479: );
1480:
1481: IF FND_API.to_Boolean( p_debug ) THEN
1482: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Eng_Revised_Items updated ... ' );
1483: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1484: END IF ;
1485:
1486: IF SQL%FOUND THEN

Line 1488: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_REVISED_ITEMS rows found, updating: ' );

1484: END IF ;
1485:
1486: IF SQL%FOUND THEN
1487: IF FND_API.to_Boolean( p_debug ) THEN
1488: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_REVISED_ITEMS rows found, updating: ' );
1489: END IF ;
1490:
1491: -- Insert records in the history table
1492: Insert into Eng_Current_Scheduled_Dates(

Line 1521: From eng_revised_items eri,

1517: eng_current_scheduled_dates_s.nextval,
1518: p_requestor_id,
1519: substr(p_comment, 1, 240),
1520: eri.revised_item_sequence_id
1521: From eng_revised_items eri,
1522: mtl_system_items msi
1523: Where eri.change_id = p_change_id
1524: And eri.revised_item_id = msi.inventory_item_id
1525: And eri.organization_id = msi.organization_id

Line 1625: FROM eng_revised_items eri

1621: WHERE change_notice = x_change_notice
1622: AND organization_id = x_organization_id
1623: AND implementation_date is NULL
1624: AND (revised_item_sequence_id, revision_id) in (SELECT revised_item_sequence_id, new_item_revision_id
1625: FROM eng_revised_items eri
1626: WHERE change_id = p_change_id
1627: AND scheduled_date = p_effectivity_date
1628: AND new_item_revision is NOT NULL
1629: AND status_type not in ( 5, -- CANCELLED

Line 1660: FROM eng_revised_items eri

1656: WHERE change_notice = x_change_notice
1657: AND organization_id = x_organization_id
1658: AND implementation_date is NULL
1659: AND revised_item_sequence_id in (SELECT revised_item_sequence_id
1660: FROM eng_revised_items eri
1661: WHERE change_id = p_change_id
1662: AND scheduled_date = p_effectivity_date
1663: AND new_routing_revision is NOT NULL
1664: AND status_type not in ( 5, -- CANCELLED

Line 1685: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_REVISED_ITEMS rows NOT found. NO updates. ' );

1681:
1682:
1683: ELSE
1684: IF FND_API.to_Boolean( p_debug ) THEN
1685: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_REVISED_ITEMS rows NOT found. NO updates. ' );
1686: END IF ;
1687:
1688: END IF;
1689:

Line 1780: l_organization_id eng_revised_items.organization_id%TYPE;

1776: X_Standard NUMBER := 4;
1777: x_change_notice VARCHAR2(10);
1778: x_organization_id NUMBER;
1779: -- bug 14548151
1780: l_organization_id eng_revised_items.organization_id%TYPE;
1781: l_revision eng_revised_items.new_item_revision%TYPE;
1782: l_item_id eng_revised_items.revised_item_id%TYPE;
1783: l_max_smaller_eff_date mtl_item_revisions_b.effectivity_date%TYPE;
1784: l_min_bigger_eff_date mtl_item_revisions_b.effectivity_date%TYPE;

Line 1781: l_revision eng_revised_items.new_item_revision%TYPE;

1777: x_change_notice VARCHAR2(10);
1778: x_organization_id NUMBER;
1779: -- bug 14548151
1780: l_organization_id eng_revised_items.organization_id%TYPE;
1781: l_revision eng_revised_items.new_item_revision%TYPE;
1782: l_item_id eng_revised_items.revised_item_id%TYPE;
1783: l_max_smaller_eff_date mtl_item_revisions_b.effectivity_date%TYPE;
1784: l_min_bigger_eff_date mtl_item_revisions_b.effectivity_date%TYPE;
1785: -- bug 14548151 end

Line 1782: l_item_id eng_revised_items.revised_item_id%TYPE;

1778: x_organization_id NUMBER;
1779: -- bug 14548151
1780: l_organization_id eng_revised_items.organization_id%TYPE;
1781: l_revision eng_revised_items.new_item_revision%TYPE;
1782: l_item_id eng_revised_items.revised_item_id%TYPE;
1783: l_max_smaller_eff_date mtl_item_revisions_b.effectivity_date%TYPE;
1784: l_min_bigger_eff_date mtl_item_revisions_b.effectivity_date%TYPE;
1785: -- bug 14548151 end
1786:

Line 1808: SELECT organization_id, new_item_revision, revised_item_id FROM eng_revised_items

1804: AND bcb.IMPLEMENTATION_DATE IS NULL;
1805:
1806: -- bug 14548151
1807: CURSOR c_item_revisions IS
1808: SELECT organization_id, new_item_revision, revised_item_id FROM eng_revised_items
1809: WHERE change_id = p_change_id
1810: AND implementation_date is NULL; -- fix bug 14620669, do not check the implemented Revised Item
1811: -- bug 14548151 end
1812:

Line 1899: Update Eng_Revised_Items eri

1895: INTO x_change_notice, x_organization_id
1896: FROM eng_engineering_changes
1897: WHERE change_id = p_change_id;
1898:
1899: Update Eng_Revised_Items eri
1900: Set eri.scheduled_date = p_effectivity_date,
1901: eri.last_update_date = sysdate,
1902: eri.last_updated_by = x_user_id,
1903: eri.last_update_login = x_login_id

Line 1919: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Eng_Revised_Items updated ... ' );

1915: And msi.bom_item_type in (X_Model, X_OptionClass, X_Planning, X_Standard)
1916: );
1917:
1918: IF FND_API.to_Boolean( p_debug ) THEN
1919: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Eng_Revised_Items updated ... ' );
1920: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1921: END IF ;
1922:
1923: IF SQL%FOUND THEN

Line 1925: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_REVISED_ITEMS rows found, updating: ' );

1921: END IF ;
1922:
1923: IF SQL%FOUND THEN
1924: IF FND_API.to_Boolean( p_debug ) THEN
1925: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_REVISED_ITEMS rows found, updating: ' );
1926: END IF ;
1927:
1928:
1929: -- update revised components EFFECTIVITY_DATE

Line 2015: FROM eng_revised_items eri

2011: WHERE change_notice = x_change_notice
2012: AND organization_id = x_organization_id
2013: AND implementation_date is NULL
2014: AND (revised_item_sequence_id, revision_id) in (SELECT revised_item_sequence_id, new_item_revision_id
2015: FROM eng_revised_items eri
2016: WHERE change_id = p_change_id
2017: AND scheduled_date = p_effectivity_date
2018: AND new_item_revision is NOT NULL
2019: AND status_type not in ( 5, -- CANCELLED

Line 2046: FROM eng_revised_items eri

2042: WHERE change_notice = x_change_notice
2043: AND organization_id = x_organization_id
2044: AND implementation_date is NULL
2045: AND revised_item_sequence_id in (SELECT revised_item_sequence_id
2046: FROM eng_revised_items eri
2047: WHERE change_id = p_change_id
2048: AND scheduled_date = p_effectivity_date
2049: AND new_routing_revision is NOT NULL
2050: AND status_type not in ( 5, -- CANCELLED

Line 2071: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_REVISED_ITEMS rows NOT found. NO updates. ' );

2067:
2068:
2069: ELSE
2070: IF FND_API.to_Boolean( p_debug ) THEN
2071: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_REVISED_ITEMS rows NOT found. NO updates. ' );
2072: END IF ;
2073:
2074: END IF;
2075:

Line 2158: , ENG_REVISED_ITEMS ri

2154: -- Delete substitute operation resources of all pending revised items on ECO
2155: DELETE FROM BOM_SUB_OPERATION_RESOURCES sor
2156: WHERE EXISTS (SELECT NULL
2157: FROM BOM_OPERATION_SEQUENCES bos
2158: , ENG_REVISED_ITEMS ri
2159: WHERE sor.operation_sequence_id = bos.operation_sequence_id
2160: AND bos.implementation_date IS NULL
2161: AND bos.revised_item_sequence_id = ri.revised_item_sequence_id
2162: AND ri.status_type = 5 -- Cancelled

Line 2172: , ENG_REVISED_ITEMS ri

2168:
2169: DELETE FROM BOM_OPERATION_RESOURCES bor
2170: WHERE EXISTS (SELECT NULL
2171: FROM BOM_OPERATION_SEQUENCES bos
2172: , ENG_REVISED_ITEMS ri
2173: WHERE bor.operation_sequence_id = bos.operation_sequence_id
2174: AND bos.implementation_date IS NULL
2175: AND bos.revised_item_sequence_id = ri.revised_item_sequence_id
2176: AND ri.status_type = 5 -- Cancelled

Line 2313: , ENG_REVISED_ITEMS ri

2309: , SYSDATE -- Cancellation Date
2310: , substr(p_cancel_comments, 1, 240) -- Cancel Comments
2311: , p_original_system_ref
2312: FROM BOM_OPERATION_SEQUENCES bos
2313: , ENG_REVISED_ITEMS ri
2314: WHERE bos.implementation_date IS NULL
2315: AND bos.revised_item_sequence_id = ri.revised_item_sequence_id
2316: AND ri.status_type = 5 -- Cancelled
2317: AND ri.organization_id = p_org_id

Line 2325: FROM ENG_REVISED_ITEMS ri

2321: -- Delete the rows from bom_operation_sequences
2322:
2323: DELETE FROM BOM_OPERATION_SEQUENCES bos
2324: WHERE EXISTS (SELECT NULL
2325: FROM ENG_REVISED_ITEMS ri
2326: WHERE bos.implementation_date IS NULL
2327: AND bos.revised_item_sequence_id = ri.revised_item_sequence_id
2328: AND ri.status_type = 5 -- Cancelled
2329: AND ri.organization_id = p_org_id

Line 2338: FROM ENG_REVISED_ITEMS ri

2334: -- Delete routing revisions created by revised items on ECO
2335:
2336: DELETE FROM MTL_RTG_ITEM_REVISIONS rev
2337: WHERE EXISTS (SELECT NULL
2338: FROM ENG_REVISED_ITEMS ri
2339: WHERE rev.implementation_date IS NULL
2340: AND rev.revised_item_sequence_id = ri.revised_item_sequence_id
2341: AND ri.status_type = 5 -- Cancelled
2342: AND ri.organization_id = p_org_id

Line 2351: FROM ENG_REVISED_ITEMS ri

2347: -- nothing else references this
2348:
2349: DELETE FROM BOM_OPERATIONAL_ROUTINGS bor
2350: WHERE EXISTS ( SELECT NULL
2351: FROM ENG_REVISED_ITEMS ri
2352: WHERE bor.routing_sequence_id = ri.change_notice
2353: AND bor.routing_sequence_id = ri.routing_sequence_id
2354: AND TRUNC(ri.last_update_date) = TRUNC(SYSDATE)
2355: AND ri.status_type = 5 -- Cancelled

Line 2375: FROM ENG_REVISED_ITEMS ri2

2371: )
2372: OR
2373: ( bor.alternate_routing_designator IS NOT NULL
2374: AND NOT EXISTS( SELECT NULL
2375: FROM ENG_REVISED_ITEMS ri2
2376: WHERE ri2.organization_id = bor.organization_id
2377: AND ri2.routing_sequence_id = bor.routing_sequence_id
2378: AND ri2.change_notice <> p_eco_name )
2379: )) ;

Line 2385: UPDATE ENG_REVISED_ITEMS ri

2381:
2382: -- If routing was deleted, then unset the routing_sequence_id on the revised items
2383: IF SQL%FOUND THEN
2384:
2385: UPDATE ENG_REVISED_ITEMS ri
2386: SET routing_sequence_id = ''
2387: , program_id = p_prog_id
2388: , program_application_id = p_prog_appid
2389: , original_system_reference = p_original_system_ref

Line 2426: UPDATE ENG_REVISED_ITEMS

2422: BEGIN
2423:
2424: -- Set cancellation date of all pending revised items on ECO
2425:
2426: UPDATE ENG_REVISED_ITEMS
2427: SET CANCELLATION_DATE = SYSDATE,
2428: STATUS_TYPE = 5,
2429: REQUEST_ID = request_id,
2430: PROGRAM_ID = prog_id,

Line 2444: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI

2440:
2441: DELETE FROM BOM_SUBSTITUTE_COMPONENTS SC
2442: WHERE SC.COMPONENT_SEQUENCE_ID IN
2443: (SELECT IC.COMPONENT_SEQUENCE_ID
2444: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI
2445: WHERE RI.ORGANIZATION_ID = org_id
2446: AND RI.CHANGE_NOTICE = change_order
2447: AND IC.REVISED_ITEM_SEQUENCE_ID = RI.REVISED_ITEM_SEQUENCE_ID
2448: AND IC.IMPLEMENTATION_DATE IS NULL);

Line 2455: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI

2451:
2452: DELETE FROM BOM_REFERENCE_DESIGNATORS RD
2453: WHERE RD.COMPONENT_SEQUENCE_ID IN
2454: (SELECT IC.COMPONENT_SEQUENCE_ID
2455: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI
2456: WHERE RI.ORGANIZATION_ID = org_id
2457: AND RI.CHANGE_NOTICE = change_order
2458: AND IC.REVISED_ITEM_SEQUENCE_ID = RI.REVISED_ITEM_SEQUENCE_ID
2459: AND IC.IMPLEMENTATION_DATE IS NULL);

Line 2581: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI

2577: prog_id,
2578: prog_appid,
2579: orig_sysref,
2580: IC.BASIS_TYPE
2581: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI
2582: WHERE RI.ORGANIZATION_ID = org_id
2583: AND RI.CHANGE_NOTICE = change_order
2584: AND IC.CHANGE_NOTICE = RI.CHANGE_NOTICE
2585: AND IC.REVISED_ITEM_SEQUENCE_ID = RI.REVISED_ITEM_SEQUENCE_ID

Line 2595: FROM ENG_REVISED_ITEMS ERI

2591: DELETE FROM BOM_INVENTORY_COMPONENTS IC
2592: WHERE CHANGE_NOTICE = change_order
2593: AND IMPLEMENTATION_DATE IS NULL
2594: AND REVISED_ITEM_SEQUENCE_ID IN (SELECT REVISED_ITEM_SEQUENCE_ID
2595: FROM ENG_REVISED_ITEMS ERI
2596: WHERE ERI.ORGANIZATION_ID = org_id
2597: AND ERI.CHANGE_NOTICE = change_order
2598: AND ERI.STATUS_TYPE = 5);
2599:

Line 2610: FROM ENG_REVISED_ITEMS R

2606: AND ORGANIZATION_ID = org_id
2607: AND IMPLEMENTATION_DATE IS NULL
2608: AND INVENTORY_ITEM_ID IN
2609: (SELECT REVISED_ITEM_ID
2610: FROM ENG_REVISED_ITEMS R
2611: WHERE R.CHANGE_NOTICE = change_order
2612: AND R.ORGANIZATION_ID = org_id
2613: AND R.REVISED_ITEM_SEQUENCE_ID = I.REVISED_ITEM_SEQUENCE_ID
2614: AND R.CANCELLATION_DATE IS NOT NULL));

Line 2622: FROM ENG_REVISED_ITEMS R

2618: WHERE CHANGE_NOTICE = change_order
2619: AND ORGANIZATION_ID = org_id
2620: AND IMPLEMENTATION_DATE IS NULL
2621: AND INVENTORY_ITEM_ID IN (SELECT REVISED_ITEM_ID
2622: FROM ENG_REVISED_ITEMS R
2623: WHERE R.CHANGE_NOTICE = change_order
2624: AND R.ORGANIZATION_ID = org_id
2625: AND R.REVISED_ITEM_SEQUENCE_ID = I.REVISED_ITEM_SEQUENCE_ID
2626: AND R.CANCELLATION_DATE IS NOT NULL);

Line 2635: FROM ENG_REVISED_ITEMS ERI

2631: -- nothing else references this
2632:
2633: DELETE FROM BOM_BILL_OF_MATERIALS B
2634: WHERE B.BILL_SEQUENCE_ID in (SELECT BILL_SEQUENCE_ID
2635: FROM ENG_REVISED_ITEMS ERI
2636: WHERE ORGANIZATION_ID = org_id
2637: AND CHANGE_NOTICE = change_order
2638: AND STATUS_TYPE = 5
2639: AND TRUNC(LAST_UPDATE_DATE) = trunc(sysdate))

Line 2655: FROM ENG_REVISED_ITEMS R

2651: AND B2.ALTERNATE_BOM_DESIGNATOR IS NOT NULL))
2652: OR
2653: (B.ALTERNATE_BOM_DESIGNATOR IS NOT NULL
2654: AND NOT EXISTS (SELECT NULL
2655: FROM ENG_REVISED_ITEMS R
2656: WHERE R.ORGANIZATION_ID = B.ORGANIZATION_ID
2657: AND R.BILL_SEQUENCE_ID = B.BILL_SEQUENCE_ID
2658: AND R.CHANGE_NOTICE <> change_order)));
2659:

Line 2662: UPDATE ENG_REVISED_ITEMS R

2658: AND R.CHANGE_NOTICE <> change_order)));
2659:
2660: -- If bill was deleted, then unset the bill_sequence_id on the revised items
2661: IF (SQL%ROWCOUNT > 0) THEN
2662: UPDATE ENG_REVISED_ITEMS R
2663: SET BILL_SEQUENCE_ID = '',
2664: REQUEST_ID = request_id,
2665: PROGRAM_ID = prog_id,
2666: PROGRAM_APPLICATION_ID = prog_appid,

Line 2931: UPDATE eng_revised_items eri

2927: l_oc_item_access := Eng_Globals.Get_OC_Item_Access;
2928: l_pln_item_access := Eng_Globals.Get_PLN_Item_Access;
2929: l_mdl_item_access := Eng_Globals.Get_MDL_Item_Access;
2930:
2931: UPDATE eng_revised_items eri
2932: SET eri.status_type = p_Unexp_ECO_rec.status_type,
2933: -- If ECO status is 'Scheduled', set Auto-Implement Date to SYSDATE, else NULL
2934: eri.auto_implement_date = decode(p_Unexp_ECO_rec.status_type, 4, SYSDATE, NULL),
2935: -- If ECO status is Hold, set MRP Active to No, else Yes

Line 3736: UPDATE eng_revised_items

3732: last_update_login = l_login_id
3733: WHERE change_id = p_change_id ;
3734:
3735: -- Set Open Rev Item to Scheduled
3736: UPDATE eng_revised_items
3737: SET status_type = 4 , -- Set Rev Item Status: Scheduled
3738: request_id = l_request_id ,
3739: last_update_date = SYSDATE ,
3740: last_updated_by = l_user_id ,

Line 3815: update eng_revised_items

3811: )
3812: is
3813: BEGIN
3814:
3815: update eng_revised_items
3816: set STATUS_TYPE = 1
3817: where CHANGE_ID = p_change_id;
3818:
3819: if (p_commit = FND_API.G_TRUE )

Line 4852: delete from eng_revised_items

4848: where ENTITY_ID1 = p_change_id
4849: and ENTITY_NAME = 'ENG_CHANGE' ;
4850:
4851:
4852: delete from eng_revised_items
4853: where change_id = p_change_id ;
4854:
4855:
4856: delete from eng_engineering_changes

Line 4923: from eng_revised_items REV1, eng_revised_items REV2

4919: IS
4920: -- begin of vamohan changes
4921: CURSOR chk_if_rev_item_occurs_twice IS
4922: select 'X'
4923: from eng_revised_items REV1, eng_revised_items REV2
4924: where REV1.change_id = p_change_id
4925: and REV2.change_id = p_change_id
4926: and REV1.organization_id = REV2.organization_id
4927: and REV1.revised_item_id = REV2.revised_item_id