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_NIR_UTIL_PKG dependencies on MTL_SYSTEM_ITEMS

Line 853: l_item_approval_status MTL_SYSTEM_ITEMS.approval_status%TYPE;

849: l_change_line_id ENG_CHANGE_SUBJECTS.change_line_id%TYPE;
850: l_pk1_value ENG_CHANGE_SUBJECTS.pk1_value%TYPE;
851: l_pk2_value ENG_CHANGE_SUBJECTS.pk2_value%TYPE;
852: l_pk3_value ENG_CHANGE_SUBJECTS.pk3_value%TYPE;
853: l_item_approval_status MTL_SYSTEM_ITEMS.approval_status%TYPE;
854: l_sfa_item VARCHAR2(1000);
855:
856: BEGIN
857: x_sfa_line_items_exists := '';

Line 868: SELECT approval_status INTO l_item_approval_status FROM MTL_SYSTEM_ITEMS WHERE inventory_item_id = l_pk1_value AND organization_id = l_pk2_value;

864: l_pk3_value := line_items.pk3_value;
865:
866: BEGIN
867: -- We need to reset the Line status and Item approval status only for the Lines rejected in the NIR.
868: SELECT approval_status INTO l_item_approval_status FROM MTL_SYSTEM_ITEMS WHERE inventory_item_id = l_pk1_value AND organization_id = l_pk2_value;
869: IF 'R' = l_item_approval_status THEN
870: -- Update Item Approval Status
871: Update_Item_Approval_Status(p_change_id, line_items.change_line_id, p_item_approval_status, l_ret_status);
872: -- Update Line Item Status

Line 876: FROM MTL_SYSTEM_ITEMS_KFV

872: -- Update Line Item Status
873: UPDATE eng_change_lines SET STATUS_CODE = 1 WHERE change_line_id = l_change_line_id;
874: ELSE
875: SELECT CONCATENATED_SEGMENTS INTO l_sfa_item
876: FROM MTL_SYSTEM_ITEMS_KFV
877: WHERE inventory_item_id = l_pk1_value
878: AND organization_id = l_pk2_value
879: AND LAST_SUBMITTED_NIR_ID <> p_change_id;
880: