SELECT        T2.SITE_ID, T2.PART_ID, T2.ENGINEERING_MSTR, T2.PRIMARY_WHS_ID, T2.PRIMARY_LOC_ID, T2.BACKFLUSH_WHS_ID, T2.BACKFLUSH_LOC_ID, T2.INSPECT_WHS_ID, T2.INSPECT_LOC_ID,
                         T2.UNIT_PRICE, T2.UNIT_MATERIAL_COST, T2.UNIT_LABOR_COST, T2.WHSALE_UNIT_COST, T2.BURDEN_PERCENT, T2.BURDEN_PER_UNIT, T2.EXCISE_UNIT_PRICE, T2.PURC_BUR_PERCENT,
                         T2.UNIT_BURDEN_COST, T2.FIXED_COST, T2.UNIT_SERVICE_COST, T2.NEW_MATERIAL_COST, T2.NEW_LABOR_COST, T2.NEW_BURDEN_COST, T2.NEW_SERVICE_COST, T2.NEW_BURDEN_PERCENT,
                         T2.NEW_BURDEN_PERUNIT, T2.PURC_BUR_PER_UNIT, T2.NEW_FIXED_COST, T2.LAST_ABC_DATE, T2.IS_RATE_BASED, T1.DESCRIPTION, T1.STOCK_UM, T1.COMMODITY_CODE, T1.MFG_NAME,
                         T1.MFG_PART_ID, T1.WEIGHT, T1.WEIGHT_UM, T1.DRAWING_ID, T1.DRAWING_REV_NO, T1.PRIVATE_UM_CONV, T1.NMFC_CODE_ID, T1.PACKAGE_TYPE, T1.ADD_FORECAST, T1.PIECE_TRACKED,
                         T1.LENGTH_REQD, T1.WIDTH_REQD, T1.HEIGHT_REQD, T1.DIMENSIONS_UM, T1.SHIP_DIMENSIONS, T1.DRAWING_FILE, T1.NET_WEIGHT_2, T1.GROSS_WEIGHT_2, T1.WEIGHT_UM_2, T1.VOLUME,
                         T1.VOLUME_UM, T1.ROLL_FORECAST, T1.PRIMARY_SOURCE, T1.LABEL_UM, T1.HTS_CODE, T1.DEF_ORIG_COUNTRY, T1.MATERIAL_CODE, T1.DEF_LBL_FORMAT_ID, T1.VOLATILE_LEADTIME,
                         T1.LT_PLUS_DAYS, T1.LT_MINUS_DAYS, T1.CASE_QTY, T1.PALLET_QTY, T1.ECN_REVISION, T1.REVISION_ID, T1.STAGE_ID, T1.ECN_REV_CONTROL, T1.IS_KIT, T1.UNIV_PLAN_MATERIAL,
                         T1.RLS_NEAR_DAYS, T1.SUGG_RLS_NEAR_DAYS, T1.CONTROLLED_BY_ICS, T1.PRICE_GROUP, T1.DEF_PACKAGE_QTY, T1.DEF_PACKAGE_CAP, T1.DEF_SLS_TAX_GRP_ID, ISNULL(T2.PLANNING_LEADTIME,
                         T1.PLANNING_LEADTIME) AS PLANNING_LEADTIME, ISNULL(T2.ORDER_POLICY, T1.ORDER_POLICY) AS ORDER_POLICY, ISNULL(T2.ORDER_POINT, T1.ORDER_POINT) AS ORDER_POINT,
                         ISNULL(T2.ORDER_UP_TO_QTY, T1.ORDER_UP_TO_QTY) AS ORDER_UP_TO_QTY, ISNULL(T2.SAFETY_STOCK_QTY, T1.SAFETY_STOCK_QTY) AS SAFETY_STOCK_QTY, ISNULL(T2.FIXED_ORDER_QTY,
                         T1.FIXED_ORDER_QTY) AS FIXED_ORDER_QTY, ISNULL(T2.DAYS_OF_SUPPLY, T1.DAYS_OF_SUPPLY) AS DAYS_OF_SUPPLY, ISNULL(T2.MINIMUM_ORDER_QTY, T1.MINIMUM_ORDER_QTY)
                         AS MINIMUM_ORDER_QTY, ISNULL(T2.MAXIMUM_ORDER_QTY, T1.MAXIMUM_ORDER_QTY) AS MAXIMUM_ORDER_QTY, ISNULL(T2.PRODUCT_CODE, T1.PRODUCT_CODE) AS PRODUCT_CODE,
                         ISNULL(T2.FABRICATED, T1.FABRICATED) AS FABRICATED, ISNULL(T2.PURCHASED, T1.PURCHASED) AS PURCHASED, ISNULL(T2.STOCKED, T1.STOCKED) AS STOCKED, ISNULL(T2.DETAIL_ONLY,
                         T1.DETAIL_ONLY) AS DETAIL_ONLY, ISNULL(T2.DEMAND_HISTORY, T1.DEMAND_HISTORY) AS DEMAND_HISTORY, ISNULL(T2.TOOL_OR_FIXTURE, T1.TOOL_OR_FIXTURE) AS TOOL_OR_FIXTURE,
                         ISNULL(T2.CONSUMABLE, T1.CONSUMABLE) AS CONSUMABLE, ISNULL(T2.INSPECTION_REQD, T1.INSPECTION_REQD) AS INSPECTION_REQD, ISNULL(T2.DEMAND_FENCE_1, T1.DEMAND_FENCE_1)
                         AS DEMAND_FENCE_1, ISNULL(T2.DEMAND_FENCE_2, T1.DEMAND_FENCE_2) AS DEMAND_FENCE_2, ISNULL(T2.PLANNER_USER_ID, T1.PLANNER_USER_ID) AS PLANNER_USER_ID,
                         ISNULL(T2.BUYER_USER_ID, T1.BUYER_USER_ID) AS BUYER_USER_ID, ISNULL(T2.ABC_CODE, T1.ABC_CODE) AS ABC_CODE, ISNULL(T2.ANNUAL_USAGE_QTY, T1.ANNUAL_USAGE_QTY)
                         AS ANNUAL_USAGE_QTY, ISNULL(T2.INVENTORY_LOCKED, T1.INVENTORY_LOCKED) AS INVENTORY_LOCKED, ISNULL(T2.PREF_VENDOR_ID, T1.PREF_VENDOR_ID) AS PREF_VENDOR_ID,
                         ISNULL(T2.MRP_REQUIRED, T1.MRP_REQUIRED) AS MRP_REQUIRED, ISNULL(T2.MRP_EXCEPTIONS, T1.MRP_EXCEPTIONS) AS MRP_EXCEPTIONS, ISNULL(T2.AUTO_BACKFLUSH, T1.AUTO_BACKFLUSH)
                         AS AUTO_BACKFLUSH, ISNULL(T2.EFF_DATE_PRICE, T1.EFF_DATE_PRICE) AS EFF_DATE_PRICE, ISNULL(T2.MAT_GL_ACCT_ID, T1.MAT_GL_ACCT_ID) AS MAT_GL_ACCT_ID, ISNULL(T2.LAB_GL_ACCT_ID,
                         T1.LAB_GL_ACCT_ID) AS LAB_GL_ACCT_ID, ISNULL(T2.BUR_GL_ACCT_ID, T1.BUR_GL_ACCT_ID) AS BUR_GL_ACCT_ID, ISNULL(T2.SER_GL_ACCT_ID, T1.SER_GL_ACCT_ID) AS SER_GL_ACCT_ID,
                         ISNULL(T2.QTY_ON_HAND, T1.QTY_ON_HAND) AS QTY_ON_HAND, ISNULL(T2.QTY_AVAILABLE_ISS, T1.QTY_AVAILABLE_ISS) AS QTY_AVAILABLE_ISS, ISNULL(T2.QTY_AVAILABLE_MRP,
                         T1.QTY_AVAILABLE_MRP) AS QTY_AVAILABLE_MRP, ISNULL(T2.QTY_ON_ORDER, T1.QTY_ON_ORDER) AS QTY_ON_ORDER, ISNULL(T2.QTY_IN_DEMAND, T1.QTY_IN_DEMAND) AS QTY_IN_DEMAND,
                         ISNULL(T2.QTY_COMMITTED, T1.QTY_COMMITTED) AS QTY_COMMITTED, ISNULL(T2.TARIFF_CODE, T1.TARIFF_CODE) AS TARIFF_CODE, ISNULL(T2.TARIFF_TYPE, T1.TARIFF_TYPE) AS TARIFF_TYPE,
                         ISNULL(T2.VAT_CODE, T1.VAT_CODE) AS VAT_CODE, ISNULL(T2.ORIG_COUNTRY_ID, T1.ORIG_COUNTRY_ID) AS ORIG_COUNTRY_ID, ISNULL(T2.INTRASTAT_EXEMPT, T1.intrastat_exempt)
                         AS INTRASTAT_EXEMPT, ISNULL(T2.STATUS, T1.STATUS) AS STATUS, ISNULL(T2.STATUS_EFF_DATE, T1.STATUS_EFF_DATE) AS STATUS_EFF_DATE, ISNULL(T2.USE_SUPPLY_BEF_LT,
                         T1.USE_SUPPLY_BEF_LT) AS USE_SUPPLY_BEF_LT, ISNULL(T2.MINIMUM_LEADTIME, T1.MINIMUM_LEADTIME) AS MINIMUM_LEADTIME, ISNULL(T2.LEADTIME_BUFFER, T1.LEADTIME_BUFFER)
                         AS LEADTIME_BUFFER, ISNULL(T2.EMERGENCY_STOCKPCT, T1.EMERGENCY_STOCKPCT) AS EMERGENCY_STOCKPCT, ISNULL(T2.REPLENISH_LEVEL, T1.REPLENISH_LEVEL) AS REPLENISH_LEVEL,
                         ISNULL(T2.MIN_BATCH_SIZE, T1.MIN_BATCH_SIZE) AS MIN_BATCH_SIZE, ISNULL(T2.YELLOW_STOCKPCT, T1.YELLOW_STOCKPCT) AS YELLOW_STOCKPCT, ISNULL(T2.MRP_EXCEPTION_INFO,
                         T1.MRP_EXCEPTION_INFO) AS MRP_EXCEPTION_INFO, ISNULL(T2.MULTIPLE_ORDER_QTY, T1.MULTIPLE_ORDER_QTY) AS MULTIPLE_ORDER_QTY, ISNULL(T2.LAST_IMPLODE_DATE,
                         T1.LAST_IMPLODE_DATE) AS LAST_IMPLODE_DATE, ISNULL(T2.MRO_CLASS, T1.MRO_CLASS) AS MRO_CLASS, ISNULL(T2.UDF_LAYOUT_ID, T1.UDF_LAYOUT_ID) AS UDF_LAYOUT_ID, ISNULL(T2.USER_1,
                         T1.USER_1) AS USER_1, ISNULL(T2.USER_2, T1.USER_2) AS USER_2, ISNULL(T2.USER_3, T1.USER_3) AS USER_3, ISNULL(T2.USER_4, T1.USER_4) AS USER_4, ISNULL(T2.USER_5, T1.USER_5) AS USER_5,
                         ISNULL(T2.USER_6, T1.USER_6) AS USER_6, ISNULL(T2.USER_7, T1.USER_7) AS USER_7, ISNULL(T2.USER_8, T1.USER_8) AS USER_8, ISNULL(T2.USER_9, T1.USER_9) AS USER_9, ISNULL(T2.USER_10,
                         T1.USER_10) AS USER_10, ISNULL(T2.BUFFER_PROFILE_ID, T1.BUFFER_PROFILE_ID) AS BUFFER_PROFILE_ID, ISNULL(T2.ADU_HORIZON, T1.ADU_HORIZON) AS ADU_HORIZON, ISNULL(T2.ASR_LEADTIME,
                         T1.ASR_LEADTIME) AS ASR_LEADTIME, ISNULL(T2.ONHAND_ALERT_RED_PCT, T1.ONHAND_ALERT_RED_PCT) AS ONHAND_ALERT_RED_PCT, ISNULL(T2.PROCESS_TYPE, T1.PROCESS_TYPE)
                         AS PROCESS_TYPE, ISNULL(T2.BID_RATE_CATEGORY_ID, T1.BID_RATE_CATEGORY_ID) AS BID_RATE_CATEGORY_ID, ISNULL(T2.CREATE_DATE, T1.CREATE_DATE) AS CREATE_DATE,
                         ISNULL(T2.MODIFY_DATE, T1.MODIFY_DATE) AS MODIFY_DATE, T1.ROWID, T1.ID
FROM            dbo.PART AS T1 INNER JOIN
                         dbo.PART_SITE AS T2 ON T1.ID = T2.PART_ID