[Home] [Help]
187: l_created_by NUMBER;
188: BEGIN
189: l_created_by := 1;
190:
191: UPDATE MTL_SYSTEM_ITEMS_INTERFACE I
192: SET
193: ( I.LAST_UPDATED_BY,
194: I.CREATED_BY,
195: I.SUMMARY_FLAG,
1015: , NVL(I.TRADE_ITEM_DESCRIPTOR ,M.TRADE_ITEM_DESCRIPTOR )
1016: , NVL(I.STYLE_ITEM_FLAG ,M.STYLE_ITEM_FLAG )
1017: , NVL(I.STYLE_ITEM_ID ,M.STYLE_ITEM_ID )
1018: FROM
1019: mtl_system_items_interface M
1020: WHERE
1021: M.inventory_item_id = item_id AND
1022: M.organization_id = master_org_id AND
1023: M.set_process_id = xset_id AND
1078: l_created_by := 1 ;
1079:
1080: SELECT primary_unit_of_measure, primary_uom_code
1081: INTO l_Primary_Unit_of_Measure, l_Primary_UOM_Code
1082: FROM MTL_SYSTEM_ITEMS_INTERFACE
1083: WHERE rowid = p_rowid;
1084:
1085: IF (l_Primary_UOM_Code IS NULL AND l_Primary_Unit_of_Measure IS NOT NULL) THEN
1086: /*Bug: 4932464 Perf Issue replaced mtl_all_primary_uoms_vv with mtl_units_of_measure_tl
1107: END;
1108:
1109: END IF;
1110:
1111: UPDATE MTL_SYSTEM_ITEMS_INTERFACE I
1112: SET
1113: ( I.LAST_UPDATED_BY,
1114: I.CREATED_BY,
1115: I.SUMMARY_FLAG,
1935: , NVL(I.TRADE_ITEM_DESCRIPTOR ,M.TRADE_ITEM_DESCRIPTOR )
1936: , NVL(I.STYLE_ITEM_FLAG ,M.STYLE_ITEM_FLAG )
1937: , NVL(I.STYLE_ITEM_ID ,M.STYLE_ITEM_ID )
1938: FROM
1939: mtl_system_items_tl MT
1940: , mtl_system_items_b M
1941: WHERE
1942: M.inventory_item_id = item_id
1943: AND M.organization_id = master_org_id
1936: , NVL(I.STYLE_ITEM_FLAG ,M.STYLE_ITEM_FLAG )
1937: , NVL(I.STYLE_ITEM_ID ,M.STYLE_ITEM_ID )
1938: FROM
1939: mtl_system_items_tl MT
1940: , mtl_system_items_b M
1941: WHERE
1942: M.inventory_item_id = item_id
1943: AND M.organization_id = master_org_id
1944: AND MT.INVENTORY_ITEM_ID = M.INVENTORY_ITEM_ID
1982: IS
1983:
1984: CURSOR c_ego_intf_rows IS
1985: SELECT tl.column_value
1986: FROM ego_interface_tl tl, mtl_system_items_interface msii
1987: WHERE tl.unique_id = msii.transaction_id
1988: AND tl.set_process_id = msii.set_process_id
1989: AND UPPER(tl.table_name) = 'MTL_SYSTEM_ITEMS_INTERFACE'
1990: AND UPPER(tl.column_name) = 'DESCRIPTION'
1985: SELECT tl.column_value
1986: FROM ego_interface_tl tl, mtl_system_items_interface msii
1987: WHERE tl.unique_id = msii.transaction_id
1988: AND tl.set_process_id = msii.set_process_id
1989: AND UPPER(tl.table_name) = 'MTL_SYSTEM_ITEMS_INTERFACE'
1990: AND UPPER(tl.column_name) = 'DESCRIPTION'
1991: AND tl.language = USERENV('LANG')
1992: AND msii.rowid = p_rowid;
1993:
2057: l_style_item_id,
2058: l_Primary_Unit_of_Measure,
2059: l_Primary_UOM_Code,
2060: l_item_catalog_group_id
2061: FROM mtl_system_items_interface I
2062: WHERE I.rowid = p_rowid;
2063:
2064: SELECT starting_revision
2065: INTO l_revision
2089: IF ( l_Primary_Unit_of_Measure IS NULL ) THEN
2090: IF (l_style_item_flag = 'N' ) THEN
2091: SELECT primary_unit_of_measure
2092: INTO l_Primary_Unit_Of_Measure
2093: FROM mtl_system_items_b
2094: WHERE inventory_item_id = l_style_item_id
2095: AND organization_id = l_org_id;
2096: ELSE
2097: l_Primary_Unit_of_Measure := uom_default;
2127:
2128: l_created_by := -1;
2129:
2130: IF (l_style_item_flag = 'N' ) THEN
2131: UPDATE MTL_SYSTEM_ITEMS_INTERFACE I
2132: SET (
2133: I.DESCRIPTION,
2134: I.LAST_UPDATED_BY,
2135: I.CREATED_BY,
2419: NVL(I.DOWNLOADABLE_FLAG, M.DOWNLOADABLE_FLAG),
2420: NVL(I.INDIVISIBLE_FLAG, M.INDIVISIBLE_FLAG),
2421: NVL(I.GDSN_OUTBOUND_ENABLED_FLAG,M.GDSN_OUTBOUND_ENABLED_FLAG),
2422: NVL(I.TRADE_ITEM_DESCRIPTOR, M.TRADE_ITEM_DESCRIPTOR)
2423: FROM mtl_system_items M
2424: WHERE M.inventory_item_id = l_style_item_id
2425: AND M.organization_id = l_org_id
2426: )
2427: WHERE I.ROWID = p_rowid;
2426: )
2427: WHERE I.ROWID = p_rowid;
2428: l_ret_status := 0;
2429: ELSE
2430: UPDATE MTL_SYSTEM_ITEMS_INTERFACE I
2431: SET
2432: I.LAST_UPDATED_BY = org_id,
2433: I.CREATED_BY = l_created_by,
2434: I.SUMMARY_FLAG = NVL(I.SUMMARY_FLAG, 'N'), --Bug: 4918974