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 1652: -- update rev item's new revision in MTL_RTG_ITEM_REVISIONS

1648: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_ITEM_REVISIONS updated ... ' );
1649: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1650: END IF ;
1651:
1652: -- update rev item's new revision in MTL_RTG_ITEM_REVISIONS
1653: UPDATE MTL_RTG_ITEM_REVISIONS
1654: SET effectivity_date = p_effectivity_date,
1655: last_update_date = sysdate
1656: WHERE change_notice = x_change_notice

Line 1653: UPDATE MTL_RTG_ITEM_REVISIONS

1649: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1650: END IF ;
1651:
1652: -- update rev item's new revision in MTL_RTG_ITEM_REVISIONS
1653: UPDATE MTL_RTG_ITEM_REVISIONS
1654: SET effectivity_date = p_effectivity_date,
1655: last_update_date = sysdate
1656: WHERE change_notice = x_change_notice
1657: AND organization_id = x_organization_id

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

1673: AND msi.bom_item_type in (X_Model, X_OptionClass,
1674: X_Planning, X_Standard)));
1675:
1676: IF FND_API.to_Boolean( p_debug ) THEN
1677: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_RTG_ITEM_REVISIONS updated ... ' );
1678: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1679: END IF ;
1680:
1681:

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

2034: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_ITEM_REVISIONS updated ... ' );
2035: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
2036: END IF ;
2037:
2038: -- update rev item's new revision in MTL_RTG_ITEM_REVISIONS
2039: UPDATE MTL_RTG_ITEM_REVISIONS
2040: SET effectivity_date = p_effectivity_date,
2041: last_update_date = sysdate
2042: WHERE change_notice = x_change_notice

Line 2039: UPDATE MTL_RTG_ITEM_REVISIONS

2035: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
2036: END IF ;
2037:
2038: -- update rev item's new revision in MTL_RTG_ITEM_REVISIONS
2039: UPDATE MTL_RTG_ITEM_REVISIONS
2040: SET effectivity_date = p_effectivity_date,
2041: last_update_date = sysdate
2042: WHERE change_notice = x_change_notice
2043: AND organization_id = x_organization_id

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

2059: AND msi.bom_item_type in (X_Model, X_OptionClass,
2060: X_Planning, X_Standard)));
2061:
2062: IF FND_API.to_Boolean( p_debug ) THEN
2063: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_RTG_ITEM_REVISIONS updated ... ' );
2064: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
2065: END IF ;
2066:
2067:

Line 2336: DELETE FROM MTL_RTG_ITEM_REVISIONS rev

2332:
2333:
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