1. Tables and Views for SCM
  2. EGP_SYSTEM_ITEMS_BV

EGP_SYSTEM_ITEMS_BV

Details

  • Schema: FUSION

  • Object owner: EGP

  • Object type: VIEW

Columns

Name

INVENTORY_ITEM_ID

ORGANIZATION_ID

PRIMARY_UOM_CODE

ITEM_TYPE

INVENTORY_ITEM_STATUS_CODE

ALLOWED_UNITS_LOOKUP_CODE

ITEM_CATALOG_GROUP_ID

INVENTORY_ITEM_FLAG

STOCK_ENABLED_FLAG

MTL_TRANSACTIONS_ENABLED_FLAG

CHECK_SHORTAGES_FLAG

REVISION_QTY_CONTROL_CODE

RESERVABLE_TYPE

SHELF_LIFE_CODE

SHELF_LIFE_DAYS

CYCLE_COUNT_ENABLED_FLAG

NEGATIVE_MEASUREMENT_ERROR

POSITIVE_MEASUREMENT_ERROR

LOT_CONTROL_CODE

AUTO_LOT_ALPHA_PREFIX

START_AUTO_LOT_NUMBER

SERIAL_NUMBER_CONTROL_CODE

AUTO_SERIAL_ALPHA_PREFIX

START_AUTO_SERIAL_NUMBER

LOCATION_CONTROL_CODE

RESTRICT_SUBINVENTORIES_CODE

RESTRICT_LOCATORS_CODE

BOM_ITEM_TYPE

BASE_ITEM_ID

EFFECTIVITY_CONTROL

ENGINEERING_ITEM_ID

PRODUCT_FAMILY_ITEM_ID

AUTO_CREATED_CONFIG_FLAG

COSTING_ENABLED_FLAG

INVENTORY_ASSET_FLAG

DEFAULT_INCLUDE_IN_ROLLUP_FLAG

STD_LOT_SIZE

PURCHASING_ITEM_FLAG

PURCHASING_ENABLED_FLAG

MUST_USE_APPROVED_VENDOR_FLAG

ALLOW_ITEM_DESC_UPDATE_FLAG

NEGOTIATION_REQUIRED_FLAG

OUTSIDE_OPERATION_FLAG

OUTSIDE_OPERATION_UOM_TYPE

TAXABLE_FLAG

PURCHASING_TAX_CODE

BUYER_ID

UNIT_OF_ISSUE

RECEIVE_CLOSE_TOLERANCE

INVOICE_CLOSE_TOLERANCE

UN_NUMBER_ID

HAZARD_CLASS_ID

LIST_PRICE_PER_UNIT

MARKET_PRICE

PRICE_TOLERANCE_PERCENT

ROUNDING_FACTOR

RECEIPT_DAYS_EXCEPTION_CODE

DAYS_EARLY_RECEIPT_ALLOWED

DAYS_LATE_RECEIPT_ALLOWED

ALLOW_SUBSTITUTE_RECEIPTS_FLAG

ALLOW_UNORDERED_RECEIPTS_FLAG

ALLOW_EXPRESS_DELIVERY_FLAG

QTY_RCV_EXCEPTION_CODE

QTY_RCV_TOLERANCE

RECEIVING_ROUTING_ID

ENFORCE_SHIP_TO_LOCATION_CODE

WEIGHT_UOM_CODE

UNIT_WEIGHT

VOLUME_UOM_CODE

UNIT_VOLUME

CONTAINER_ITEM_FLAG

VEHICLE_ITEM_FLAG

CONTAINER_TYPE_CODE

INTERNAL_VOLUME

MAXIMUM_LOAD_WEIGHT

MINIMUM_FILL_PERCENT

INVENTORY_PLANNING_CODE

PLANNER_CODE

PLANNING_MAKE_BUY_CODE

MIN_MINMAX_QUANTITY

MAX_MINMAX_QUANTITY

MINIMUM_ORDER_QUANTITY

MAXIMUM_ORDER_QUANTITY

ORDER_COST

CARRYING_COST

SOURCE_TYPE

SOURCE_ORGANIZATION_ID

SOURCE_SUBINVENTORY

MRP_SAFETY_STOCK_CODE

SAFETY_STOCK_BUCKET_DAYS

MRP_SAFETY_STOCK_PERCENT

FIXED_ORDER_QUANTITY

FIXED_DAYS_SUPPLY

FIXED_LOT_MULTIPLIER

MRP_PLANNING_CODE

ATO_FORECAST_CONTROL

PLANNING_EXCEPTION_SET

END_ASSEMBLY_PEGGING_FLAG

SHRINKAGE_RATE

ROUNDING_CONTROL_TYPE

ACCEPTABLE_EARLY_DAYS

REPETITIVE_PLANNING_FLAG

OVERRUN_PERCENTAGE

ACCEPTABLE_RATE_INCREASE

ACCEPTABLE_RATE_DECREASE

MRP_CALCULATE_ATP_FLAG

AUTO_REDUCE_MPS

PLANNING_TIME_FENCE_CODE

PLANNING_TIME_FENCE_DAYS

DEMAND_TIME_FENCE_CODE

DEMAND_TIME_FENCE_DAYS

RELEASE_TIME_FENCE_CODE

RELEASE_TIME_FENCE_DAYS

PREPROCESSING_LEAD_TIME

FULL_LEAD_TIME

POSTPROCESSING_LEAD_TIME

FIXED_LEAD_TIME

VARIABLE_LEAD_TIME

CUM_MANUFACTURING_LEAD_TIME

CUMULATIVE_TOTAL_LEAD_TIME

LEAD_TIME_LOT_SIZE

BUILD_IN_WIP_FLAG

WIP_SUPPLY_TYPE

WIP_SUPPLY_SUBINVENTORY

WIP_SUPPLY_LOCATOR_ID

OVERCOMPLETION_TOLERANCE_TYPE

OVERCOMPLETION_TOLERANCE_VALUE

CUSTOMER_ORDER_FLAG

CUSTOMER_ORDER_ENABLED_FLAG

SHIPPABLE_ITEM_FLAG

INTERNAL_ORDER_FLAG

INTERNAL_ORDER_ENABLED_FLAG

SO_TRANSACTIONS_FLAG

PICK_COMPONENTS_FLAG

ATP_FLAG

REPLENISH_TO_ORDER_FLAG

ATP_RULE_ID

ATP_COMPONENTS_FLAG

SHIP_MODEL_COMPLETE_FLAG

PICKING_RULE_ID

COLLATERAL_FLAG

DEFAULT_SHIPPING_ORG

RETURNABLE_FLAG

RETURN_INSPECTION_REQUIREMENT

OVER_SHIPMENT_TOLERANCE

UNDER_SHIPMENT_TOLERANCE

OVER_RETURN_TOLERANCE

UNDER_RETURN_TOLERANCE

INVOICEABLE_ITEM_FLAG

INVOICE_ENABLED_FLAG

ACCOUNTING_RULE_ID

INVOICING_RULE_ID

TAX_CODE

PAYMENT_TERMS_ID

COVERAGE_SCHEDULE_ID

SERVICE_DURATION

SERVICE_DURATION_PERIOD_CODE

SERVICEABLE_PRODUCT_FLAG

SERVICE_STARTING_DELAY

MATERIAL_BILLABLE_FLAG

WH_UPDATE_DATE

SUMMARY_FLAG

ENABLED_FLAG

START_DATE_ACTIVE

END_DATE_ACTIVE

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE16

ATTRIBUTE17

ATTRIBUTE18

ATTRIBUTE19

ATTRIBUTE20

ATTRIBUTE21

ATTRIBUTE22

ATTRIBUTE23

ATTRIBUTE24

ATTRIBUTE25

ATTRIBUTE26

ATTRIBUTE27

ATTRIBUTE28

ATTRIBUTE29

ATTRIBUTE30

GLOBAL_ATTRIBUTE_CATEGORY

GLOBAL_ATTRIBUTE1

GLOBAL_ATTRIBUTE2

GLOBAL_ATTRIBUTE3

GLOBAL_ATTRIBUTE4

GLOBAL_ATTRIBUTE5

GLOBAL_ATTRIBUTE6

GLOBAL_ATTRIBUTE7

GLOBAL_ATTRIBUTE8

GLOBAL_ATTRIBUTE9

GLOBAL_ATTRIBUTE10

EQUIPMENT_TYPE

RECOVERED_PART_DISP_CODE

DEFECT_TRACKING_ON_FLAG

EVENT_FLAG

ELECTRONIC_FLAG

DOWNLOADABLE_FLAG

COMMS_NL_TRACKABLE_FLAG

ASSET_CREATION_CODE

COMMS_ACTIVATION_REQD_FLAG

ORDERABLE_ON_WEB_FLAG

BACK_ORDERABLE_FLAG

WEB_STATUS

INDIVISIBLE_FLAG

DIMENSION_UOM_CODE

UNIT_LENGTH

UNIT_WIDTH

UNIT_HEIGHT

BULK_PICKED_FLAG

LOT_STATUS_ENABLED

DEFAULT_LOT_STATUS_ID

SERIAL_STATUS_ENABLED

DEFAULT_SERIAL_STATUS_ID

LOT_SPLIT_ENABLED

LOT_MERGE_ENABLED

INVENTORY_CARRY_PENALTY

OPERATION_SLACK_PENALTY

FINANCING_ALLOWED_FLAG

EAM_ITEM_TYPE

EAM_ACTIVITY_TYPE_CODE

EAM_ACTIVITY_CAUSE_CODE

EAM_ACT_NOTIFICATION_FLAG

EAM_ACT_SHUTDOWN_STATUS

DUAL_UOM_CONTROL

SECONDARY_UOM_CODE

DUAL_UOM_DEVIATION_HIGH

DUAL_UOM_DEVIATION_LOW

CONTRACT_ITEM_TYPE_CODE

SERV_REQ_ENABLED_CODE

SERV_BILLING_ENABLED_FLAG

PLANNED_INV_POINT_FLAG

LOT_TRANSLATE_ENABLED

DEFAULT_SO_SOURCE_TYPE

CREATE_SUPPLY_FLAG

SUBSTITUTION_WINDOW_CODE

SUBSTITUTION_WINDOW_DAYS

IB_ITEM_INSTANCE_CLASS

CONFIG_MODEL_TYPE

LOT_SUBSTITUTION_ENABLED

MINIMUM_LICENSE_QUANTITY

EAM_ACTIVITY_SOURCE_CODE

CURRENT_PHASE_ID

OBJECT_VERSION_NUMBER

TRACKING_QUANTITY_IND

ONT_PRICING_QTY_SOURCE

SECONDARY_DEFAULT_IND

OPTION_SPECIFIC_SOURCED

APPROVAL_STATUS

VMI_MINIMUM_UNITS

VMI_MINIMUM_DAYS

VMI_MAXIMUM_UNITS

VMI_MAXIMUM_DAYS

VMI_FIXED_ORDER_QUANTITY

SO_AUTHORIZATION_FLAG

CONSIGNED_FLAG

ASN_AUTOEXPIRE_FLAG

VMI_FORECAST_TYPE

FORECAST_HORIZON

EXCLUDE_FROM_BUDGET_FLAG

DAYS_TGT_INV_SUPPLY

DAYS_TGT_INV_WINDOW

DAYS_MAX_INV_SUPPLY

DAYS_MAX_INV_WINDOW

DRP_PLANNED_FLAG

CRITICAL_COMPONENT_FLAG

CONTINOUS_TRANSFER

CONVERGENCE

DIVERGENCE

CONFIG_ORGS

CONFIG_MATCH

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

REQUEST_ID

LOT_DIVISIBLE_FLAG

GRADE_CONTROL_FLAG

DEFAULT_GRADE

CHILD_LOT_FLAG

PARENT_CHILD_GENERATION_FLAG

CHILD_LOT_PREFIX

CHILD_LOT_STARTING_NUMBER

CHILD_LOT_VALIDATION_FLAG

COPY_LOT_ATTRIBUTE_FLAG

RECIPE_ENABLED_FLAG

PROCESS_COSTING_ENABLED_FLAG

RETEST_INTERVAL

EXPIRATION_ACTION_INTERVAL

EXPIRATION_ACTION_CODE

MATURITY_DAYS

HOLD_DAYS

PROCESS_QUALITY_ENABLED_FLAG

PROCESS_EXECUTION_ENABLED_FLAG

PROCESS_SUPPLY_SUBINVENTORY

PROCESS_SUPPLY_LOCATOR_ID

PROCESS_YIELD_SUBINVENTORY

PROCESS_YIELD_LOCATOR_ID

HAZARDOUS_MATERIAL_FLAG

CAS_NUMBER

CHARGE_PERIODICITY_CODE

REPAIR_LEADTIME

REPAIR_YIELD

PREPOSITION_POINT

REPAIR_PROGRAM

SUBCONTRACTING_COMPONENT

OUTSOURCED_ASSEMBLY

GDSN_OUTBOUND_ENABLED_FLAG

TRADE_ITEM_DESCRIPTOR

STYLE_ITEM_ID

STYLE_ITEM_FLAG

LAST_SUBMITTED_NIR_ID

PROGRAM_NAME

PROGRAM_APP_NAME

ACD_TYPE

CHANGE_LINE_ID

VERSION_ID

VERSION_START_DATE

VERSION_END_DATE

IMPLEMENTATION_DATE

CHANGE_BIT_MAP

TEMPLATE_ITEM_FLAG

QSC_SALES_PRODUCT_TYPE

MATCH_APPROVAL_LEVEL

INVOICE_MATCH_OPTION

DEFAULT_TEMPLATE_FLAG

INSPECTION_REQUIRED_FLAG

RECEIPT_REQUIRED_FLAG

ASSET_CATEGORY_ID

EXPENSE_ACCOUNT

SALES_ACCOUNT

CURRENT_PHASE_CODE

ITEM_NUMBER

SALES_PRODUCT_TYPE

ELIGIBILITY_COMPATIBILITY_RULE

JOB_DEFINITION_NAME

JOB_DEFINITION_PACKAGE

DQ_SEMANTIC_KEY

DQ_REQUIRED_FLAG

THREAD_ID

INVENTORY_ORGANIZATION_ID

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_NUMBER6

ATTRIBUTE_NUMBER7

ATTRIBUTE_NUMBER8

ATTRIBUTE_NUMBER9

ATTRIBUTE_NUMBER10

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_TIMESTAMP1

ATTRIBUTE_TIMESTAMP2

ATTRIBUTE_TIMESTAMP3

ATTRIBUTE_TIMESTAMP4

ATTRIBUTE_TIMESTAMP5

GLOBAL_ATTRIBUTE11

GLOBAL_ATTRIBUTE12

GLOBAL_ATTRIBUTE13

GLOBAL_ATTRIBUTE14

GLOBAL_ATTRIBUTE15

GLOBAL_ATTRIBUTE16

GLOBAL_ATTRIBUTE17

GLOBAL_ATTRIBUTE18

GLOBAL_ATTRIBUTE19

GLOBAL_ATTRIBUTE20

GLOBAL_ATTRIBUTE_NUMBER1

GLOBAL_ATTRIBUTE_NUMBER2

GLOBAL_ATTRIBUTE_NUMBER3

GLOBAL_ATTRIBUTE_NUMBER4

GLOBAL_ATTRIBUTE_NUMBER5

GLOBAL_ATTRIBUTE_DATE1

GLOBAL_ATTRIBUTE_DATE2

GLOBAL_ATTRIBUTE_DATE3

GLOBAL_ATTRIBUTE_DATE4

GLOBAL_ATTRIBUTE_DATE5

ASSET_TRACKED_FLAG

ASSET_CLASS

SERVICE_DURATION_TYPE_CODE

SERVICE_START_TYPE_CODE

START_UPON_MILESTONE_CODE

SERVICE_START_DELAY

ALLOW_SUSPEND_FLAG

ALLOW_TERMINATE_FLAG

REQUIRES_FULFILLMENT_LOC_FLAG

REQUIRES_ITM_ASSOCIATION_FLAG

SALES_PRODUCT_SUB_TYPE

BACK_TO_BACK_ENABLED

CONTRACT_MANUFACTURING

SAFETY_STOCK_PLANNING_METHOD

DEMAND_PERIOD

DAYS_OF_COVER

OUTSIDE_PROCESS_SERVICE_FLAG

ALLOW_MAINTENANCE_ASSET_FLAG

ENABLE_GENEALOGY_TRACKING_FLAG

COMPLETENESS_SCORE

CSS_ENABLED_FLAG

ENGINEERED_ITEM_FLAG

FORCE_PURCHASE_LEAD_TIME_FLAG

REPLACEMENT_TYPE

PUBLIC_FLAG

HARD_PEGGING_LEVEL

COMN_SUPPLY_PRJ_DEMAND_FLAG

ENABLE_IOT_FLAG

EXPENDITURE_TYPE_ID

PRIMARY_IMAGE_URL

PACKAGING_STRING_ID

CREATE_SUPPLY_AFTER_DATE

CREATE_FIXED_ASSET

UNDER_COMPL_TOLERANCE_TYPE

UNDER_COMPL_TOLERANCE_VALUE

REPAIR_TRANSACTION_CODE

CREATED_FROM_ITEM_ID

CREATED_FROM_REVISION_ID

ITEM_OBJECT_TYPE

Query

SQL_Statement

SELECT

IO.INVENTORY_ITEM_ID,

IO.ORGANIZATION_ID,

B.PRIMARY_UOM_CODE,

B.ITEM_TYPE,

B.INVENTORY_ITEM_STATUS_CODE,

B.ALLOWED_UNITS_LOOKUP_CODE,

B.ITEM_CATALOG_GROUP_ID,

B.INVENTORY_ITEM_FLAG,

B.STOCK_ENABLED_FLAG,

B.MTL_TRANSACTIONS_ENABLED_FLAG,

B.CHECK_SHORTAGES_FLAG,

B.REVISION_QTY_CONTROL_CODE,

B.RESERVABLE_TYPE,

B.SHELF_LIFE_CODE,

B.SHELF_LIFE_DAYS,

B.CYCLE_COUNT_ENABLED_FLAG,

B.NEGATIVE_MEASUREMENT_ERROR,

B.POSITIVE_MEASUREMENT_ERROR,

B.LOT_CONTROL_CODE,

B.AUTO_LOT_ALPHA_PREFIX,

B.START_AUTO_LOT_NUMBER,

B.SERIAL_NUMBER_CONTROL_CODE,

B.AUTO_SERIAL_ALPHA_PREFIX,

B.START_AUTO_SERIAL_NUMBER,

B.LOCATION_CONTROL_CODE,

B.RESTRICT_SUBINVENTORIES_CODE,

B.RESTRICT_LOCATORS_CODE,

B.BOM_ITEM_TYPE,

B.BASE_ITEM_ID,

B.EFFECTIVITY_CONTROL,

B.ENGINEERING_ITEM_ID,

B.PRODUCT_FAMILY_ITEM_ID,

B.AUTO_CREATED_CONFIG_FLAG,

B.COSTING_ENABLED_FLAG,

B.INVENTORY_ASSET_FLAG,

B.DEFAULT_INCLUDE_IN_ROLLUP_FLAG,

B.STD_LOT_SIZE,

B.PURCHASING_ITEM_FLAG,

B.PURCHASING_ENABLED_FLAG,

B.MUST_USE_APPROVED_VENDOR_FLAG,

B.ALLOW_ITEM_DESC_UPDATE_FLAG,

B.NEGOTIATION_REQUIRED_FLAG,

B.OUTSIDE_OPERATION_FLAG,

B.OUTSIDE_OPERATION_UOM_TYPE,

B.TAXABLE_FLAG,

B.PURCHASING_TAX_CODE,

B.BUYER_ID,

B.UNIT_OF_ISSUE,

B.RECEIVE_CLOSE_TOLERANCE,

B.INVOICE_CLOSE_TOLERANCE,

B.UN_NUMBER_ID,

B.HAZARD_CLASS_ID,

B.LIST_PRICE_PER_UNIT,

B.MARKET_PRICE,

B.PRICE_TOLERANCE_PERCENT,

B.ROUNDING_FACTOR,

B.RECEIPT_DAYS_EXCEPTION_CODE,

B.DAYS_EARLY_RECEIPT_ALLOWED,

B.DAYS_LATE_RECEIPT_ALLOWED,

B.ALLOW_SUBSTITUTE_RECEIPTS_FLAG,

B.ALLOW_UNORDERED_RECEIPTS_FLAG,

B.ALLOW_EXPRESS_DELIVERY_FLAG,

B.QTY_RCV_EXCEPTION_CODE,

B.QTY_RCV_TOLERANCE,

B.RECEIVING_ROUTING_ID,

B.ENFORCE_SHIP_TO_LOCATION_CODE,

B.WEIGHT_UOM_CODE,

B.UNIT_WEIGHT,

B.VOLUME_UOM_CODE,

B.UNIT_VOLUME,

B.CONTAINER_ITEM_FLAG,

B.VEHICLE_ITEM_FLAG,

B.CONTAINER_TYPE_CODE,

B.INTERNAL_VOLUME,

B.MAXIMUM_LOAD_WEIGHT,

B.MINIMUM_FILL_PERCENT,

B.INVENTORY_PLANNING_CODE,

B.PLANNER_CODE,

B.PLANNING_MAKE_BUY_CODE,

B.MIN_MINMAX_QUANTITY,

B.MAX_MINMAX_QUANTITY,

B.MINIMUM_ORDER_QUANTITY,

B.MAXIMUM_ORDER_QUANTITY,

B.ORDER_COST,

B.CARRYING_COST,

B.SOURCE_TYPE,

B.SOURCE_ORGANIZATION_ID,

B.SOURCE_SUBINVENTORY,

B.MRP_SAFETY_STOCK_CODE,

B.SAFETY_STOCK_BUCKET_DAYS,

B.MRP_SAFETY_STOCK_PERCENT,

B.FIXED_ORDER_QUANTITY,

B.FIXED_DAYS_SUPPLY,

B.FIXED_LOT_MULTIPLIER,

B.MRP_PLANNING_CODE,

B.ATO_FORECAST_CONTROL,

B.PLANNING_EXCEPTION_SET,

B.END_ASSEMBLY_PEGGING_FLAG,

B.SHRINKAGE_RATE,

B.ROUNDING_CONTROL_TYPE,

B.ACCEPTABLE_EARLY_DAYS,

B.REPETITIVE_PLANNING_FLAG,

B.OVERRUN_PERCENTAGE,

B.ACCEPTABLE_RATE_INCREASE,

B.ACCEPTABLE_RATE_DECREASE,

B.MRP_CALCULATE_ATP_FLAG,

B.AUTO_REDUCE_MPS,

B.PLANNING_TIME_FENCE_CODE,

B.PLANNING_TIME_FENCE_DAYS,

B.DEMAND_TIME_FENCE_CODE,

B.DEMAND_TIME_FENCE_DAYS,

B.RELEASE_TIME_FENCE_CODE,

B.RELEASE_TIME_FENCE_DAYS,

B.PREPROCESSING_LEAD_TIME,

B.FULL_LEAD_TIME,

B.POSTPROCESSING_LEAD_TIME,

B.FIXED_LEAD_TIME,

B.VARIABLE_LEAD_TIME,

B.CUM_MANUFACTURING_LEAD_TIME,

B.CUMULATIVE_TOTAL_LEAD_TIME,

B.LEAD_TIME_LOT_SIZE,

B.BUILD_IN_WIP_FLAG,

B.WIP_SUPPLY_TYPE,

B.WIP_SUPPLY_SUBINVENTORY,

B.WIP_SUPPLY_LOCATOR_ID,

B.OVERCOMPLETION_TOLERANCE_TYPE,

B.OVERCOMPLETION_TOLERANCE_VALUE,

B.CUSTOMER_ORDER_FLAG,

B.CUSTOMER_ORDER_ENABLED_FLAG,

B.SHIPPABLE_ITEM_FLAG,

B.INTERNAL_ORDER_FLAG,

B.INTERNAL_ORDER_ENABLED_FLAG,

B.SO_TRANSACTIONS_FLAG,

B.PICK_COMPONENTS_FLAG,

B.ATP_FLAG,

B.REPLENISH_TO_ORDER_FLAG,

B.ATP_RULE_ID,

B.ATP_COMPONENTS_FLAG,

B.SHIP_MODEL_COMPLETE_FLAG,

B.PICKING_RULE_ID,

B.COLLATERAL_FLAG,

B.DEFAULT_SHIPPING_ORG,

B.RETURNABLE_FLAG,

B.RETURN_INSPECTION_REQUIREMENT,

B.OVER_SHIPMENT_TOLERANCE,

B.UNDER_SHIPMENT_TOLERANCE,

B.OVER_RETURN_TOLERANCE,

B.UNDER_RETURN_TOLERANCE,

B.INVOICEABLE_ITEM_FLAG,

B.INVOICE_ENABLED_FLAG,

B.ACCOUNTING_RULE_ID,

B.INVOICING_RULE_ID,

B.TAX_CODE,

B.PAYMENT_TERMS_ID,

B.COVERAGE_SCHEDULE_ID,

B.SERVICE_DURATION,

B.SERVICE_DURATION_PERIOD_CODE,

B.SERVICEABLE_PRODUCT_FLAG,

B.SERVICE_STARTING_DELAY,

B.MATERIAL_BILLABLE_FLAG,

B.WH_UPDATE_DATE,

B.SUMMARY_FLAG,

B.ENABLED_FLAG,

B.START_DATE_ACTIVE,

B.END_DATE_ACTIVE,

B.ATTRIBUTE_CATEGORY,

B.ATTRIBUTE1,

B.ATTRIBUTE2,

B.ATTRIBUTE3,

B.ATTRIBUTE4,

B.ATTRIBUTE5,

B.ATTRIBUTE6,

B.ATTRIBUTE7,

B.ATTRIBUTE8,

B.ATTRIBUTE9,

B.ATTRIBUTE10,

B.ATTRIBUTE11,

B.ATTRIBUTE12,

B.ATTRIBUTE13,

B.ATTRIBUTE14,

B.ATTRIBUTE15,

B.ATTRIBUTE16,

B.ATTRIBUTE17,

B.ATTRIBUTE18,

B.ATTRIBUTE19,

B.ATTRIBUTE20,

B.ATTRIBUTE21,

B.ATTRIBUTE22,

B.ATTRIBUTE23,

B.ATTRIBUTE24,

B.ATTRIBUTE25,

B.ATTRIBUTE26,

B.ATTRIBUTE27,

B.ATTRIBUTE28,

B.ATTRIBUTE29,

B.ATTRIBUTE30,

B.GLOBAL_ATTRIBUTE_CATEGORY,

B.GLOBAL_ATTRIBUTE1,

B.GLOBAL_ATTRIBUTE2,

B.GLOBAL_ATTRIBUTE3,

B.GLOBAL_ATTRIBUTE4,

B.GLOBAL_ATTRIBUTE5,

B.GLOBAL_ATTRIBUTE6,

B.GLOBAL_ATTRIBUTE7,

B.GLOBAL_ATTRIBUTE8,

B.GLOBAL_ATTRIBUTE9,

B.GLOBAL_ATTRIBUTE10,

B.EQUIPMENT_TYPE,

B.RECOVERED_PART_DISP_CODE,

B.DEFECT_TRACKING_ON_FLAG,

B.EVENT_FLAG,

B.ELECTRONIC_FLAG,

B.DOWNLOADABLE_FLAG,

B.COMMS_NL_TRACKABLE_FLAG,

B.ASSET_CREATION_CODE,

B.COMMS_ACTIVATION_REQD_FLAG,

B.ORDERABLE_ON_WEB_FLAG,

B.BACK_ORDERABLE_FLAG,

B.WEB_STATUS,

B.INDIVISIBLE_FLAG,

B.DIMENSION_UOM_CODE,

B.UNIT_LENGTH,

B.UNIT_WIDTH,

B.UNIT_HEIGHT,

B.BULK_PICKED_FLAG,

B.LOT_STATUS_ENABLED,

B.DEFAULT_LOT_STATUS_ID,

B.SERIAL_STATUS_ENABLED,

B.DEFAULT_SERIAL_STATUS_ID,

B.LOT_SPLIT_ENABLED,

B.LOT_MERGE_ENABLED,

B.INVENTORY_CARRY_PENALTY,

B.OPERATION_SLACK_PENALTY,

B.FINANCING_ALLOWED_FLAG,

B.EAM_ITEM_TYPE,

B.EAM_ACTIVITY_TYPE_CODE,

B.EAM_ACTIVITY_CAUSE_CODE,

B.EAM_ACT_NOTIFICATION_FLAG,

B.EAM_ACT_SHUTDOWN_STATUS,

B.DUAL_UOM_CONTROL,

B.SECONDARY_UOM_CODE,

B.DUAL_UOM_DEVIATION_HIGH,

B.DUAL_UOM_DEVIATION_LOW,

B.CONTRACT_ITEM_TYPE_CODE,

B.SERV_REQ_ENABLED_CODE,

B.SERV_BILLING_ENABLED_FLAG,

B.PLANNED_INV_POINT_FLAG,

B.LOT_TRANSLATE_ENABLED,

B.DEFAULT_SO_SOURCE_TYPE,

B.CREATE_SUPPLY_FLAG,

B.SUBSTITUTION_WINDOW_CODE,

B.SUBSTITUTION_WINDOW_DAYS,

B.IB_ITEM_INSTANCE_CLASS,

B.CONFIG_MODEL_TYPE,

B.LOT_SUBSTITUTION_ENABLED,

B.MINIMUM_LICENSE_QUANTITY,

B.EAM_ACTIVITY_SOURCE_CODE,

B.CURRENT_PHASE_ID,

B.OBJECT_VERSION_NUMBER,

B.TRACKING_QUANTITY_IND,

B.ONT_PRICING_QTY_SOURCE,

B.SECONDARY_DEFAULT_IND,

B.OPTION_SPECIFIC_SOURCED,

B.APPROVAL_STATUS,

B.VMI_MINIMUM_UNITS,

B.VMI_MINIMUM_DAYS,

B.VMI_MAXIMUM_UNITS,

B.VMI_MAXIMUM_DAYS,

B.VMI_FIXED_ORDER_QUANTITY,

B.SO_AUTHORIZATION_FLAG,

B.CONSIGNED_FLAG,

B.ASN_AUTOEXPIRE_FLAG,

B.VMI_FORECAST_TYPE,

B.FORECAST_HORIZON,

B.EXCLUDE_FROM_BUDGET_FLAG,

B.DAYS_TGT_INV_SUPPLY,

B.DAYS_TGT_INV_WINDOW,

B.DAYS_MAX_INV_SUPPLY,

B.DAYS_MAX_INV_WINDOW,

B.DRP_PLANNED_FLAG,

B.CRITICAL_COMPONENT_FLAG,

B.CONTINOUS_TRANSFER,

B.CONVERGENCE,

B.DIVERGENCE,

B.CONFIG_ORGS,

B.CONFIG_MATCH,

B.CREATION_DATE,

B.CREATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_LOGIN,

B.REQUEST_ID,

B.LOT_DIVISIBLE_FLAG,

B.GRADE_CONTROL_FLAG,

B.DEFAULT_GRADE,

B.CHILD_LOT_FLAG,

B.PARENT_CHILD_GENERATION_FLAG,

B.CHILD_LOT_PREFIX,

B.CHILD_LOT_STARTING_NUMBER,

B.CHILD_LOT_VALIDATION_FLAG,

B.COPY_LOT_ATTRIBUTE_FLAG,

B.RECIPE_ENABLED_FLAG,

B.PROCESS_COSTING_ENABLED_FLAG,

B.RETEST_INTERVAL,

B.EXPIRATION_ACTION_INTERVAL,

B.EXPIRATION_ACTION_CODE,

B.MATURITY_DAYS,

B.HOLD_DAYS,

B.PROCESS_QUALITY_ENABLED_FLAG,

B.PROCESS_EXECUTION_ENABLED_FLAG,

B.PROCESS_SUPPLY_SUBINVENTORY,

B.PROCESS_SUPPLY_LOCATOR_ID,

B.PROCESS_YIELD_SUBINVENTORY,

B.PROCESS_YIELD_LOCATOR_ID,

B.HAZARDOUS_MATERIAL_FLAG,

B.CAS_NUMBER,

B.CHARGE_PERIODICITY_CODE,

B.REPAIR_LEADTIME,

B.REPAIR_YIELD,

B.PREPOSITION_POINT,

B.REPAIR_PROGRAM,

B.SUBCONTRACTING_COMPONENT,

B.OUTSOURCED_ASSEMBLY,

B.GDSN_OUTBOUND_ENABLED_FLAG,

B.TRADE_ITEM_DESCRIPTOR,

B.STYLE_ITEM_ID,

B.STYLE_ITEM_FLAG,

B.LAST_SUBMITTED_NIR_ID,

B.PROGRAM_NAME,

B.PROGRAM_APP_NAME,

B.ACD_TYPE,

B.CHANGE_LINE_ID,

B.VERSION_ID,

B.VERSION_START_DATE,

B.VERSION_END_DATE,

B.IMPLEMENTATION_DATE,

B.CHANGE_BIT_MAP,

B.TEMPLATE_ITEM_FLAG,

B.QSC_SALES_PRODUCT_TYPE,

B.MATCH_APPROVAL_LEVEL,

B.INVOICE_MATCH_OPTION,

B.DEFAULT_TEMPLATE_FLAG,

B.INSPECTION_REQUIRED_FLAG,

B.RECEIPT_REQUIRED_FLAG,

B.ASSET_CATEGORY_ID,

B.EXPENSE_ACCOUNT,

B.SALES_ACCOUNT,

B.CURRENT_PHASE_CODE,

B.ITEM_NUMBER,

B.SALES_PRODUCT_TYPE,

B.ELIGIBILITY_COMPATIBILITY_RULE,

B.JOB_DEFINITION_NAME,

B.JOB_DEFINITION_PACKAGE,

B.DQ_SEMANTIC_KEY,

B.DQ_REQUIRED_FLAG,

B.THREAD_ID,

IO.INVENTORY_ORGANIZATION_ID,

B.ATTRIBUTE_NUMBER1,

B.ATTRIBUTE_NUMBER2,

B.ATTRIBUTE_NUMBER3,

B.ATTRIBUTE_NUMBER4,

B.ATTRIBUTE_NUMBER5,

B.ATTRIBUTE_NUMBER6,

B.ATTRIBUTE_NUMBER7,

B.ATTRIBUTE_NUMBER8,

B.ATTRIBUTE_NUMBER9,

B.ATTRIBUTE_NUMBER10,

B.ATTRIBUTE_DATE1,

B.ATTRIBUTE_DATE2,

B.ATTRIBUTE_DATE3,

B.ATTRIBUTE_DATE4,

B.ATTRIBUTE_DATE5,

B.ATTRIBUTE_TIMESTAMP1,

B.ATTRIBUTE_TIMESTAMP2,

B.ATTRIBUTE_TIMESTAMP3,

B.ATTRIBUTE_TIMESTAMP4,

B.ATTRIBUTE_TIMESTAMP5,

B.GLOBAL_ATTRIBUTE11,

B.GLOBAL_ATTRIBUTE12,

B.GLOBAL_ATTRIBUTE13,

B.GLOBAL_ATTRIBUTE14,

B.GLOBAL_ATTRIBUTE15,

B.GLOBAL_ATTRIBUTE16,

B.GLOBAL_ATTRIBUTE17,

B.GLOBAL_ATTRIBUTE18,

B.GLOBAL_ATTRIBUTE19,

B.GLOBAL_ATTRIBUTE20,

B.GLOBAL_ATTRIBUTE_NUMBER1,

B.GLOBAL_ATTRIBUTE_NUMBER2,

B.GLOBAL_ATTRIBUTE_NUMBER3,

B.GLOBAL_ATTRIBUTE_NUMBER4,

B.GLOBAL_ATTRIBUTE_NUMBER5,

B.GLOBAL_ATTRIBUTE_DATE1,

B.GLOBAL_ATTRIBUTE_DATE2,

B.GLOBAL_ATTRIBUTE_DATE3,

B.GLOBAL_ATTRIBUTE_DATE4,

B.GLOBAL_ATTRIBUTE_DATE5,

B.ASSET_TRACKED_FLAG,

B.ASSET_CLASS,

B.SERVICE_DURATION_TYPE_CODE,

B.SERVICE_START_TYPE_CODE,

B.START_UPON_MILESTONE_CODE,

B.SERVICE_START_DELAY,

B.ALLOW_SUSPEND_FLAG,

B.ALLOW_TERMINATE_FLAG,

B.REQUIRES_FULFILLMENT_LOC_FLAG,

B.REQUIRES_ITM_ASSOCIATION_FLAG,

B.SALES_PRODUCT_SUB_TYPE,

B.BACK_TO_BACK_ENABLED,

B.CONTRACT_MANUFACTURING,

B.SAFETY_STOCK_PLANNING_METHOD,

B.DEMAND_PERIOD,

B.DAYS_OF_COVER,

B.OUTSIDE_PROCESS_SERVICE_FLAG,

B.ALLOW_MAINTENANCE_ASSET_FLAG,

B.ENABLE_GENEALOGY_TRACKING_FLAG,

B.COMPLETENESS_SCORE,

B.CSS_ENABLED_FLAG,

B.ENGINEERED_ITEM_FLAG,

B.FORCE_PURCHASE_LEAD_TIME_FLAG,

B.REPLACEMENT_TYPE,

IO.PUBLIC_FLAG,

B.HARD_PEGGING_LEVEL,

B.COMN_SUPPLY_PRJ_DEMAND_FLAG,

B.ENABLE_IOT_FLAG,

B.EXPENDITURE_TYPE_ID,

B.PRIMARY_IMAGE_URL,

B.PACKAGING_STRING_ID,

B.CREATE_SUPPLY_AFTER_DATE,

B.CREATE_FIXED_ASSET,

B.UNDER_COMPL_TOLERANCE_TYPE,

B.UNDER_COMPL_TOLERANCE_VALUE,

B.REPAIR_TRANSACTION_CODE,

B.CREATED_FROM_ITEM_ID,

B.CREATED_FROM_REVISION_ID,

B.ITEM_OBJECT_TYPE

FROM

EGP_SYSTEM_ITEMS_B B,

EGP_ITEM_ORG_ASSOCIATIONS IO

WHERE

B.INVENTORY_ITEM_ID = IO.INVENTORY_ITEM_ID AND B.ORGANIZATION_ID = IO.ITEM_DEFINITION_ORG_ID AND IO.CHANGE_ROW_FLAG = 'N' AND B.TEMPLATE_ITEM_FLAG = 'N' AND B.APPROVAL_STATUS = 'A' AND B.ACD_TYPE = 'PROD' AND B.CHANGE_LINE_ID = -1 AND B.VERSION_ID = -1