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 280: UPDATE eng_revised_items

276: ELSE
277: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('setting x_request_id' );
278: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' x_request_id = ' || to_char(x_request_id) );
279: IF (p_rev_item_seq_id IS NOT NULL ) THEN
280: UPDATE eng_revised_items
281: SET implementation_req_id = x_request_id
282: WHERE revised_item_sequence_id = p_rev_item_seq_id;
283: ELSE
284: UPDATE eng_engineering_changes

Line 454: From Eng_Revised_Items eri

450: -- and return an error message
451: /*
452: Select count(*)
453: Into l_dummy_counter
454: From Eng_Revised_Items eri
455: Where eri.change_id = p_change_id
456: And eri.status_type not in ( 5, -- CANCELLED
457: 6, -- IMPLEMENTED
458: 9, -- IMPLEMENTATION_IN_PROGRESS

Line 1075: Update Eng_Revised_Items eri

1071: INTO x_change_notice, x_organization_id
1072: FROM eng_engineering_changes
1073: WHERE change_id = p_change_id;
1074:
1075: Update Eng_Revised_Items eri
1076: Set eri.scheduled_date = p_effectivity_date,
1077: eri.last_update_date = sysdate,
1078: eri.last_updated_by = x_user_id,
1079: eri.last_update_login = x_login_id

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

1091: And msi.bom_item_type in (X_Model, X_OptionClass, X_Planning, X_Standard)
1092: );
1093:
1094: IF FND_API.to_Boolean( p_debug ) THEN
1095: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Eng_Revised_Items updated ... ' );
1096: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1097: END IF ;
1098:
1099: IF SQL%FOUND THEN

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

1097: END IF ;
1098:
1099: IF SQL%FOUND THEN
1100: IF FND_API.to_Boolean( p_debug ) THEN
1101: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_REVISED_ITEMS rows found, updating: ' );
1102: END IF ;
1103:
1104: -- Insert records in the history table
1105: Insert into Eng_Current_Scheduled_Dates(

Line 1134: From eng_revised_items eri,

1130: eng_current_scheduled_dates_s.nextval,
1131: p_requestor_id,
1132: substr(p_comment, 1, 240),
1133: eri.revised_item_sequence_id
1134: From eng_revised_items eri,
1135: mtl_system_items msi
1136: Where eri.change_id = p_change_id
1137: And eri.revised_item_id = msi.inventory_item_id
1138: And eri.organization_id = msi.organization_id

Line 1238: FROM eng_revised_items eri

1234: WHERE change_notice = x_change_notice
1235: AND organization_id = x_organization_id
1236: AND implementation_date is NULL
1237: AND (revised_item_sequence_id, revision_id) in (SELECT revised_item_sequence_id, new_item_revision_id
1238: FROM eng_revised_items eri
1239: WHERE change_id = p_change_id
1240: AND scheduled_date = p_effectivity_date
1241: AND new_item_revision is NOT NULL
1242: AND status_type not in ( 5, -- CANCELLED

Line 1273: FROM eng_revised_items eri

1269: WHERE change_notice = x_change_notice
1270: AND organization_id = x_organization_id
1271: AND implementation_date is NULL
1272: AND revised_item_sequence_id in (SELECT revised_item_sequence_id
1273: FROM eng_revised_items eri
1274: WHERE change_id = p_change_id
1275: AND scheduled_date = p_effectivity_date
1276: AND new_routing_revision is NOT NULL
1277: AND status_type not in ( 5, -- CANCELLED

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

1294:
1295:
1296: ELSE
1297: IF FND_API.to_Boolean( p_debug ) THEN
1298: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_REVISED_ITEMS rows NOT found. NO updates. ' );
1299: END IF ;
1300:
1301: END IF;
1302:

Line 1472: Update Eng_Revised_Items eri

1468: INTO x_change_notice, x_organization_id
1469: FROM eng_engineering_changes
1470: WHERE change_id = p_change_id;
1471:
1472: Update Eng_Revised_Items eri
1473: Set eri.scheduled_date = p_effectivity_date,
1474: eri.last_update_date = sysdate,
1475: eri.last_updated_by = x_user_id,
1476: eri.last_update_login = x_login_id

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

1488: And msi.bom_item_type in (X_Model, X_OptionClass, X_Planning, X_Standard)
1489: );
1490:
1491: IF FND_API.to_Boolean( p_debug ) THEN
1492: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Eng_Revised_Items updated ... ' );
1493: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1494: END IF ;
1495:
1496: IF SQL%FOUND THEN

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

1494: END IF ;
1495:
1496: IF SQL%FOUND THEN
1497: IF FND_API.to_Boolean( p_debug ) THEN
1498: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_REVISED_ITEMS rows found, updating: ' );
1499: END IF ;
1500:
1501:
1502: -- update revised components EFFECTIVITY_DATE

Line 1588: FROM eng_revised_items eri

1584: WHERE change_notice = x_change_notice
1585: AND organization_id = x_organization_id
1586: AND implementation_date is NULL
1587: AND (revised_item_sequence_id, revision_id) in (SELECT revised_item_sequence_id, new_item_revision_id
1588: FROM eng_revised_items eri
1589: WHERE change_id = p_change_id
1590: AND scheduled_date = p_effectivity_date
1591: AND new_item_revision is NOT NULL
1592: AND status_type not in ( 5, -- CANCELLED

Line 1619: FROM eng_revised_items eri

1615: WHERE change_notice = x_change_notice
1616: AND organization_id = x_organization_id
1617: AND implementation_date is NULL
1618: AND revised_item_sequence_id in (SELECT revised_item_sequence_id
1619: FROM eng_revised_items eri
1620: WHERE change_id = p_change_id
1621: AND scheduled_date = p_effectivity_date
1622: AND new_routing_revision is NOT NULL
1623: AND status_type not in ( 5, -- CANCELLED

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

1640:
1641:
1642: ELSE
1643: IF FND_API.to_Boolean( p_debug ) THEN
1644: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_REVISED_ITEMS rows NOT found. NO updates. ' );
1645: END IF ;
1646:
1647: END IF;
1648:

Line 1731: , ENG_REVISED_ITEMS ri

1727: -- Delete substitute operation resources of all pending revised items on ECO
1728: DELETE FROM BOM_SUB_OPERATION_RESOURCES sor
1729: WHERE EXISTS (SELECT NULL
1730: FROM BOM_OPERATION_SEQUENCES bos
1731: , ENG_REVISED_ITEMS ri
1732: WHERE sor.operation_sequence_id = bos.operation_sequence_id
1733: AND bos.implementation_date IS NULL
1734: AND bos.revised_item_sequence_id = ri.revised_item_sequence_id
1735: AND ri.status_type = 5 -- Cancelled

Line 1745: , ENG_REVISED_ITEMS ri

1741:
1742: DELETE FROM BOM_OPERATION_RESOURCES bor
1743: WHERE EXISTS (SELECT NULL
1744: FROM BOM_OPERATION_SEQUENCES bos
1745: , ENG_REVISED_ITEMS ri
1746: WHERE bor.operation_sequence_id = bos.operation_sequence_id
1747: AND bos.implementation_date IS NULL
1748: AND bos.revised_item_sequence_id = ri.revised_item_sequence_id
1749: AND ri.status_type = 5 -- Cancelled

Line 1886: , ENG_REVISED_ITEMS ri

1882: , SYSDATE -- Cancellation Date
1883: , substr(p_cancel_comments, 1, 240) -- Cancel Comments
1884: , p_original_system_ref
1885: FROM BOM_OPERATION_SEQUENCES bos
1886: , ENG_REVISED_ITEMS ri
1887: WHERE bos.implementation_date IS NULL
1888: AND bos.revised_item_sequence_id = ri.revised_item_sequence_id
1889: AND ri.status_type = 5 -- Cancelled
1890: AND ri.organization_id = p_org_id

Line 1898: FROM ENG_REVISED_ITEMS ri

1894: -- Delete the rows from bom_operation_sequences
1895:
1896: DELETE FROM BOM_OPERATION_SEQUENCES bos
1897: WHERE EXISTS (SELECT NULL
1898: FROM ENG_REVISED_ITEMS ri
1899: WHERE bos.implementation_date IS NULL
1900: AND bos.revised_item_sequence_id = ri.revised_item_sequence_id
1901: AND ri.status_type = 5 -- Cancelled
1902: AND ri.organization_id = p_org_id

Line 1911: FROM ENG_REVISED_ITEMS ri

1907: -- Delete routing revisions created by revised items on ECO
1908:
1909: DELETE FROM MTL_RTG_ITEM_REVISIONS rev
1910: WHERE EXISTS (SELECT NULL
1911: FROM ENG_REVISED_ITEMS ri
1912: WHERE rev.implementation_date IS NULL
1913: AND rev.revised_item_sequence_id = ri.revised_item_sequence_id
1914: AND ri.status_type = 5 -- Cancelled
1915: AND ri.organization_id = p_org_id

Line 1924: FROM ENG_REVISED_ITEMS ri

1920: -- nothing else references this
1921:
1922: DELETE FROM BOM_OPERATIONAL_ROUTINGS bor
1923: WHERE EXISTS ( SELECT NULL
1924: FROM ENG_REVISED_ITEMS ri
1925: WHERE bor.routing_sequence_id = ri.change_notice
1926: AND bor.routing_sequence_id = ri.routing_sequence_id
1927: AND TRUNC(ri.last_update_date) = TRUNC(SYSDATE)
1928: AND ri.status_type = 5 -- Cancelled

Line 1948: FROM ENG_REVISED_ITEMS ri2

1944: )
1945: OR
1946: ( bor.alternate_routing_designator IS NOT NULL
1947: AND NOT EXISTS( SELECT NULL
1948: FROM ENG_REVISED_ITEMS ri2
1949: WHERE ri2.organization_id = bor.organization_id
1950: AND ri2.routing_sequence_id = bor.routing_sequence_id
1951: AND ri2.change_notice <> p_eco_name )
1952: )) ;

Line 1958: UPDATE ENG_REVISED_ITEMS ri

1954:
1955: -- If routing was deleted, then unset the routing_sequence_id on the revised items
1956: IF SQL%FOUND THEN
1957:
1958: UPDATE ENG_REVISED_ITEMS ri
1959: SET routing_sequence_id = ''
1960: , program_id = p_prog_id
1961: , program_application_id = p_prog_appid
1962: , original_system_reference = p_original_system_ref

Line 1999: UPDATE ENG_REVISED_ITEMS

1995: BEGIN
1996:
1997: -- Set cancellation date of all pending revised items on ECO
1998:
1999: UPDATE ENG_REVISED_ITEMS
2000: SET CANCELLATION_DATE = SYSDATE,
2001: STATUS_TYPE = 5,
2002: REQUEST_ID = request_id,
2003: PROGRAM_ID = prog_id,

Line 2017: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI

2013:
2014: DELETE FROM BOM_SUBSTITUTE_COMPONENTS SC
2015: WHERE SC.COMPONENT_SEQUENCE_ID IN
2016: (SELECT IC.COMPONENT_SEQUENCE_ID
2017: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI
2018: WHERE RI.ORGANIZATION_ID = org_id
2019: AND RI.CHANGE_NOTICE = change_order
2020: AND IC.REVISED_ITEM_SEQUENCE_ID = RI.REVISED_ITEM_SEQUENCE_ID
2021: AND IC.IMPLEMENTATION_DATE IS NULL);

Line 2028: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI

2024:
2025: DELETE FROM BOM_REFERENCE_DESIGNATORS RD
2026: WHERE RD.COMPONENT_SEQUENCE_ID IN
2027: (SELECT IC.COMPONENT_SEQUENCE_ID
2028: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI
2029: WHERE RI.ORGANIZATION_ID = org_id
2030: AND RI.CHANGE_NOTICE = change_order
2031: AND IC.REVISED_ITEM_SEQUENCE_ID = RI.REVISED_ITEM_SEQUENCE_ID
2032: AND IC.IMPLEMENTATION_DATE IS NULL);

Line 2154: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI

2150: prog_id,
2151: prog_appid,
2152: orig_sysref,
2153: IC.BASIS_TYPE
2154: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI
2155: WHERE RI.ORGANIZATION_ID = org_id
2156: AND RI.CHANGE_NOTICE = change_order
2157: AND IC.CHANGE_NOTICE = RI.CHANGE_NOTICE
2158: AND IC.REVISED_ITEM_SEQUENCE_ID = RI.REVISED_ITEM_SEQUENCE_ID

Line 2168: FROM ENG_REVISED_ITEMS ERI

2164: DELETE FROM BOM_INVENTORY_COMPONENTS IC
2165: WHERE CHANGE_NOTICE = change_order
2166: AND IMPLEMENTATION_DATE IS NULL
2167: AND REVISED_ITEM_SEQUENCE_ID IN (SELECT REVISED_ITEM_SEQUENCE_ID
2168: FROM ENG_REVISED_ITEMS ERI
2169: WHERE ERI.ORGANIZATION_ID = org_id
2170: AND ERI.CHANGE_NOTICE = change_order
2171: AND ERI.STATUS_TYPE = 5);
2172:

Line 2183: FROM ENG_REVISED_ITEMS R

2179: AND ORGANIZATION_ID = org_id
2180: AND IMPLEMENTATION_DATE IS NULL
2181: AND INVENTORY_ITEM_ID IN
2182: (SELECT REVISED_ITEM_ID
2183: FROM ENG_REVISED_ITEMS R
2184: WHERE R.CHANGE_NOTICE = change_order
2185: AND R.ORGANIZATION_ID = org_id
2186: AND R.REVISED_ITEM_SEQUENCE_ID = I.REVISED_ITEM_SEQUENCE_ID
2187: AND R.CANCELLATION_DATE IS NOT NULL));

Line 2195: FROM ENG_REVISED_ITEMS R

2191: WHERE CHANGE_NOTICE = change_order
2192: AND ORGANIZATION_ID = org_id
2193: AND IMPLEMENTATION_DATE IS NULL
2194: AND INVENTORY_ITEM_ID IN (SELECT REVISED_ITEM_ID
2195: FROM ENG_REVISED_ITEMS R
2196: WHERE R.CHANGE_NOTICE = change_order
2197: AND R.ORGANIZATION_ID = org_id
2198: AND R.REVISED_ITEM_SEQUENCE_ID = I.REVISED_ITEM_SEQUENCE_ID
2199: AND R.CANCELLATION_DATE IS NOT NULL);

Line 2208: FROM ENG_REVISED_ITEMS ERI

2204: -- nothing else references this
2205:
2206: DELETE FROM BOM_BILL_OF_MATERIALS B
2207: WHERE B.BILL_SEQUENCE_ID in (SELECT BILL_SEQUENCE_ID
2208: FROM ENG_REVISED_ITEMS ERI
2209: WHERE ORGANIZATION_ID = org_id
2210: AND CHANGE_NOTICE = change_order
2211: AND STATUS_TYPE = 5
2212: AND TRUNC(LAST_UPDATE_DATE) = trunc(sysdate))

Line 2228: FROM ENG_REVISED_ITEMS R

2224: AND B2.ALTERNATE_BOM_DESIGNATOR IS NOT NULL))
2225: OR
2226: (B.ALTERNATE_BOM_DESIGNATOR IS NOT NULL
2227: AND NOT EXISTS (SELECT NULL
2228: FROM ENG_REVISED_ITEMS R
2229: WHERE R.ORGANIZATION_ID = B.ORGANIZATION_ID
2230: AND R.BILL_SEQUENCE_ID = B.BILL_SEQUENCE_ID
2231: AND R.CHANGE_NOTICE <> change_order)));
2232:

Line 2235: UPDATE ENG_REVISED_ITEMS R

2231: AND R.CHANGE_NOTICE <> change_order)));
2232:
2233: -- If bill was deleted, then unset the bill_sequence_id on the revised items
2234: IF (SQL%ROWCOUNT > 0) THEN
2235: UPDATE ENG_REVISED_ITEMS R
2236: SET BILL_SEQUENCE_ID = '',
2237: REQUEST_ID = request_id,
2238: PROGRAM_ID = prog_id,
2239: PROGRAM_APPLICATION_ID = prog_appid,

Line 2504: UPDATE eng_revised_items eri

2500: l_oc_item_access := Eng_Globals.Get_OC_Item_Access;
2501: l_pln_item_access := Eng_Globals.Get_PLN_Item_Access;
2502: l_mdl_item_access := Eng_Globals.Get_MDL_Item_Access;
2503:
2504: UPDATE eng_revised_items eri
2505: SET eri.status_type = p_Unexp_ECO_rec.status_type,
2506: -- If ECO status is 'Scheduled', set Auto-Implement Date to SYSDATE, else NULL
2507: eri.auto_implement_date = decode(p_Unexp_ECO_rec.status_type, 4, SYSDATE, NULL),
2508: -- If ECO status is Hold, set MRP Active to No, else Yes

Line 3307: UPDATE eng_revised_items

3303: last_update_login = l_login_id
3304: WHERE change_id = p_change_id ;
3305:
3306: -- Set Open Rev Item to Scheduled
3307: UPDATE eng_revised_items
3308: SET status_type = 4 , -- Set Rev Item Status: Scheduled
3309: request_id = l_request_id ,
3310: last_update_date = SYSDATE ,
3311: last_updated_by = l_user_id ,

Line 3386: update eng_revised_items

3382: )
3383: is
3384: BEGIN
3385:
3386: update eng_revised_items
3387: set STATUS_TYPE = 1
3388: where CHANGE_ID = p_change_id;
3389:
3390: if (p_commit = FND_API.G_TRUE )

Line 4423: delete from eng_revised_items

4419: where ENTITY_ID1 = p_change_id
4420: and ENTITY_NAME = 'ENG_CHANGE' ;
4421:
4422:
4423: delete from eng_revised_items
4424: where change_id = p_change_id ;
4425:
4426:
4427: delete from eng_engineering_changes

Line 4494: from eng_revised_items REV1, eng_revised_items REV2

4490: IS
4491: -- begin of vamohan changes
4492: CURSOR chk_if_rev_item_occurs_twice IS
4493: select 'X'
4494: from eng_revised_items REV1, eng_revised_items REV2
4495: where REV1.change_id = p_change_id
4496: and REV2.change_id = p_change_id
4497: and REV1.organization_id = REV2.organization_id
4498: and REV1.revised_item_id = REV2.revised_item_id