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_ENGINEERING_CHANGES

Line 203: UPDATE ENG_ENGINEERING_CHANGES

199: For X_NewStatus in CheckStatusEco loop
200:
201: -- Change ECO status to implemented.
202:
203: UPDATE ENG_ENGINEERING_CHANGES
204: SET IMPLEMENTATION_DATE = SYSDATE,
205: STATUS_TYPE = 6,
206: LAST_UPDATED_BY = p_user_id,
207: LAST_UPDATE_LOGIN = p_login

Line 227: UPDATE ENG_ENGINEERING_CHANGES

223: if (X_EcoStatus = 5) then
224:
225: -- Change ECO status to canceled.
226:
227: UPDATE ENG_ENGINEERING_CHANGES
228: SET CANCELLATION_DATE = SYSDATE,
229: STATUS_TYPE = 5,
230: LAST_UPDATED_BY = p_user_id,
231: LAST_UPDATE_LOGIN = p_login

Line 695: FROM eng_engineering_changes

691: BEGIN
692:
693: SELECT 1
694: INTO l_fetch_lifecycle
695: FROM eng_engineering_changes
696: WHERE nvl(plm_or_erp_change , 'PLM') = 'PLM'
697: AND change_notice = p_change_notice
698: AND organization_id = p_org_id;
699:

Line 2498: cp_change_notice eng_engineering_changes.change_notice%TYPE

2494: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2495: -- Cursor to Fetch all source bill's component changes that are being updated
2496: -- by reschedule
2497: CURSOR c_source_components(
2498: cp_change_notice eng_engineering_changes.change_notice%TYPE
2499: , cp_revised_item_seq_id eng_revised_items.revised_item_sequence_id%TYPE
2500: , cp_bill_sequence_id bom_structures_b.bill_sequence_id%TYPE) IS
2501: SELECT bcb.component_sequence_id
2502: FROM bom_components_b bcb