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 MTL_RTG_ITEM_REVISIONS

Line 1265: -- update rev item's new revision in MTL_RTG_ITEM_REVISIONS

1261: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_ITEM_REVISIONS updated ... ' );
1262: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1263: END IF ;
1264:
1265: -- update rev item's new revision in MTL_RTG_ITEM_REVISIONS
1266: UPDATE MTL_RTG_ITEM_REVISIONS
1267: SET effectivity_date = p_effectivity_date,
1268: last_update_date = sysdate
1269: WHERE change_notice = x_change_notice

Line 1266: UPDATE MTL_RTG_ITEM_REVISIONS

1262: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1263: END IF ;
1264:
1265: -- update rev item's new revision in MTL_RTG_ITEM_REVISIONS
1266: UPDATE MTL_RTG_ITEM_REVISIONS
1267: SET effectivity_date = p_effectivity_date,
1268: last_update_date = sysdate
1269: WHERE change_notice = x_change_notice
1270: AND organization_id = x_organization_id

Line 1290: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_RTG_ITEM_REVISIONS updated ... ' );

1286: AND msi.bom_item_type in (X_Model, X_OptionClass,
1287: X_Planning, X_Standard)));
1288:
1289: IF FND_API.to_Boolean( p_debug ) THEN
1290: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_RTG_ITEM_REVISIONS updated ... ' );
1291: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1292: END IF ;
1293:
1294:

Line 1611: -- update rev item's new revision in MTL_RTG_ITEM_REVISIONS

1607: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_ITEM_REVISIONS updated ... ' );
1608: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1609: END IF ;
1610:
1611: -- update rev item's new revision in MTL_RTG_ITEM_REVISIONS
1612: UPDATE MTL_RTG_ITEM_REVISIONS
1613: SET effectivity_date = p_effectivity_date,
1614: last_update_date = sysdate
1615: WHERE change_notice = x_change_notice

Line 1612: UPDATE MTL_RTG_ITEM_REVISIONS

1608: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1609: END IF ;
1610:
1611: -- update rev item's new revision in MTL_RTG_ITEM_REVISIONS
1612: UPDATE MTL_RTG_ITEM_REVISIONS
1613: SET effectivity_date = p_effectivity_date,
1614: last_update_date = sysdate
1615: WHERE change_notice = x_change_notice
1616: AND organization_id = x_organization_id

Line 1636: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_RTG_ITEM_REVISIONS updated ... ' );

1632: AND msi.bom_item_type in (X_Model, X_OptionClass,
1633: X_Planning, X_Standard)));
1634:
1635: IF FND_API.to_Boolean( p_debug ) THEN
1636: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_RTG_ITEM_REVISIONS updated ... ' );
1637: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1638: END IF ;
1639:
1640:

Line 1909: DELETE FROM MTL_RTG_ITEM_REVISIONS rev

1905:
1906:
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