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 851: mtl_system_items_vl WHERE inventory_item_id = l_line_item_id;

847: loop
848: fetch c_line_item_cursor INTO l_line_item_id;
849: --get style item id for the line item
850: SELECT nvl(STYLE_ITEM_ID, -999) INTO l_style_item_id FROM
851: mtl_system_items_vl WHERE inventory_item_id = l_line_item_id;
852: -- if there is no style item id, then line item shall be an non-style item
853: IF (l_style_item_id = -999) THEN
854: l_sku_item_ind := false;
855: END IF;

Line 896: from mtl_system_items_vl

892: where entity_name = 'EGO_ITEM'
893: and change_id = p_change_id;
894: cursor c_sku_items(item_id varchar2) is
895: select distinct inventory_item_id
896: from mtl_system_items_vl
897: where style_item_id = item_id;
898: style_flag mtl_system_items_vl.STYLE_ITEM_FLAG%type;
899: l_change_id eng_engineering_changes.change_id%type;
900: nums number;

Line 898: style_flag mtl_system_items_vl.STYLE_ITEM_FLAG%type;

894: cursor c_sku_items(item_id varchar2) is
895: select distinct inventory_item_id
896: from mtl_system_items_vl
897: where style_item_id = item_id;
898: style_flag mtl_system_items_vl.STYLE_ITEM_FLAG%type;
899: l_change_id eng_engineering_changes.change_id%type;
900: nums number;
901: BEGIN
902:

Line 908: FROM mtl_system_items_vl

904: for change_line in c_line_item_cursor loop
905: if change_line.item_id is not null then
906: SELECT STYLE_ITEM_FLAG
907: into style_flag
908: FROM mtl_system_items_vl
909: WHERE inventory_item_id = change_line.item_id
910: and rownum <= 1;
911: if style_flag = 'Y' then
912: for sku_items in c_sku_items(change_line.item_id) loop

Line 964: l_item_approval_status MTL_SYSTEM_ITEMS.approval_status%TYPE;

960: l_change_line_id ENG_CHANGE_SUBJECTS.change_line_id%TYPE;
961: l_pk1_value ENG_CHANGE_SUBJECTS.pk1_value%TYPE;
962: l_pk2_value ENG_CHANGE_SUBJECTS.pk2_value%TYPE;
963: l_pk3_value ENG_CHANGE_SUBJECTS.pk3_value%TYPE;
964: l_item_approval_status MTL_SYSTEM_ITEMS.approval_status%TYPE;
965: l_sfa_item VARCHAR2(1000);
966:
967: BEGIN
968: x_sfa_line_items_exists := '';

Line 979: 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;

975: l_pk3_value := line_items.pk3_value;
976:
977: BEGIN
978: -- We need to reset the Line status and Item approval status only for the Lines rejected in the NIR.
979: 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;
980: IF 'R' = l_item_approval_status THEN
981: -- Update Item Approval Status
982: Update_Item_Approval_Status(p_change_id, line_items.change_line_id, p_item_approval_status, l_ret_status);
983: -- Update Line Item Status

Line 987: FROM MTL_SYSTEM_ITEMS_KFV

983: -- Update Line Item Status
984: UPDATE eng_change_lines SET STATUS_CODE = 1 WHERE change_line_id = l_change_line_id;
985: ELSE
986: SELECT CONCATENATED_SEGMENTS INTO l_sfa_item
987: FROM MTL_SYSTEM_ITEMS_KFV
988: WHERE inventory_item_id = l_pk1_value
989: AND organization_id = l_pk2_value
990: AND LAST_SUBMITTED_NIR_ID <> p_change_id;
991: