BI Report, Business Intelligence Report,, Constraints, indexes, Table Structure

EGP_SYSTEM_ITEMS_B : Item Table in Fusion

EGP_SYSTEM_ITEMS_B: If you have implemented inventory module in Oracle Fusion Finance then one of the most important table you’ll need to query is EGP_SYSTEM_ITEMS_B. EGP_SYSTEM_ITEMS_B is the master table for items. In this post we’ll describe 2 aspects of EGP_SYSTEM_ITEMS_B:
1. Table Columns
2. Indexes

But before that a few points which might help you:
As you know EGP_SYSTEM_ITEMS_B table is item master table, so all the items defined in the system will have an entry in this table. But then, items are defined at inventory org level, so it translates into 1 entry of each item for each inventory it is defined in. Or in other words, combination of item number and Organization id will give you a unique row in EGP_SYSTEM_ITEMS_B table.

Looking to query important fields of item? Click here to see the query.

Also most probably you’ll have to query the item for assigned catalog and category. And to get the query, you can refer to Item Catalog Category Relationship.

Also one one the important aspect of the item is calculating reserved and on hand quantity, which you are bound to calculate at some point of time. Refer this post to get the query.

One of the related tables is egp_systems_items_tl which is used to query the description and long description of the item present in egp_system_items_b table.

By the way, Here ( India) or Here ( Other Geographies) are few UNCONVENTIONAL tricks which I have learnt to improve the performance of BI reports or SQL queries. Try them only when nothing else works.. kind of SOS...
https://www.amazon.in/gp/product/B093CC1CLD?ie=UTF8&tag=oraclebytes-21&camp=3638&linkCode=xm2&creativeASIN=B093CC1CLD

EGP_SYSTEM_ITEMS_B Table Columns:

COLUMN NAMEDATA TYPEDATA LENGTHNULLABLE
 INVENTORY_ITEM_IDNUMBER22
 ORGANIZATION_IDNUMBER22
 LAST_UPDATE_DATETIMESTAMP(6)11
 CREATION_DATETIMESTAMP(6)11
 LAST_UPDATE_LOGINVARCHAR2128
 SUMMARY_FLAGVARCHAR24
 ENABLED_FLAGVARCHAR24
 START_DATE_ACTIVEDATE7
 END_DATE_ACTIVEDATE7
 BUYER_IDNUMBER22
 ACCOUNTING_RULE_IDNUMBER22
 INVOICING_RULE_IDNUMBER22
 ATTRIBUTE_CATEGORYVARCHAR2120
 ATTRIBUTE1VARCHAR2960
 ATTRIBUTE2VARCHAR2960
 ATTRIBUTE3VARCHAR2960
 ATTRIBUTE4VARCHAR2960
 ATTRIBUTE5VARCHAR2960
 ATTRIBUTE6VARCHAR2960
 ATTRIBUTE7VARCHAR2960
 ATTRIBUTE8VARCHAR2960
 ATTRIBUTE9VARCHAR2960
 ATTRIBUTE10VARCHAR2960
 ATTRIBUTE11VARCHAR2960
 ATTRIBUTE12VARCHAR2960
 ATTRIBUTE13VARCHAR2960
 ATTRIBUTE14VARCHAR2960
 ATTRIBUTE15VARCHAR2960
 PURCHASING_ITEM_FLAGVARCHAR24
 SHIPPABLE_ITEM_FLAGVARCHAR24
 CUSTOMER_ORDER_FLAGVARCHAR24
 INTERNAL_ORDER_FLAGVARCHAR24
 INVENTORY_ITEM_FLAGVARCHAR24
 INVENTORY_ASSET_FLAGVARCHAR24
 PURCHASING_ENABLED_FLAGVARCHAR24
 CUSTOMER_ORDER_ENABLED_FLAGVARCHAR24
 INTERNAL_ORDER_ENABLED_FLAGVARCHAR24
 SO_TRANSACTIONS_FLAGVARCHAR24
 MTL_TRANSACTIONS_ENABLED_FLAGVARCHAR24
 STOCK_ENABLED_FLAGVARCHAR24
 BUILD_IN_WIP_FLAGVARCHAR24
 REVISION_QTY_CONTROL_CODENUMBER22
 ITEM_CATALOG_GROUP_IDNUMBER22
 RETURNABLE_FLAGVARCHAR24
 DEFAULT_SHIPPING_ORGNUMBER22
 COLLATERAL_FLAGVARCHAR24
 TAXABLE_FLAGVARCHAR24
 QTY_RCV_EXCEPTION_CODEVARCHAR2100
 ALLOW_ITEM_DESC_UPDATE_FLAGVARCHAR24
 MARKET_PRICENUMBER22
 HAZARD_CLASS_IDNUMBER22
 NEGOTIATION_REQUIRED_FLAGVARCHAR24
 QTY_RCV_TOLERANCENUMBER22
 LIST_PRICE_PER_UNITNUMBER22
 UN_NUMBER_IDNUMBER22
 PRICE_TOLERANCE_PERCENTNUMBER22
 ROUNDING_FACTORNUMBER22
 UNIT_OF_ISSUEVARCHAR2100
 ENFORCE_SHIP_TO_LOCATION_CODEVARCHAR2100
 ALLOW_SUBSTITUTE_RECEIPTS_FLAGVARCHAR24
 ALLOW_UNORDERED_RECEIPTS_FLAGVARCHAR24
 ALLOW_EXPRESS_DELIVERY_FLAGVARCHAR24
 DAYS_EARLY_RECEIPT_ALLOWEDNUMBER22
 DAYS_LATE_RECEIPT_ALLOWEDNUMBER22
 RECEIPT_DAYS_EXCEPTION_CODEVARCHAR2100
 RECEIVING_ROUTING_IDNUMBER22
 INVOICE_CLOSE_TOLERANCENUMBER22
 RECEIVE_CLOSE_TOLERANCENUMBER22
 AUTO_LOT_ALPHA_PREFIXVARCHAR2320
 START_AUTO_LOT_NUMBERVARCHAR2320
 LOT_CONTROL_CODENUMBER22
 SHELF_LIFE_CODENUMBER22
 SHELF_LIFE_DAYSNUMBER22
 SERIAL_NUMBER_CONTROL_CODENUMBER22
 START_AUTO_SERIAL_NUMBERVARCHAR2320
 AUTO_SERIAL_ALPHA_PREFIXVARCHAR2320
 SOURCE_TYPENUMBER22
 SOURCE_ORGANIZATION_IDNUMBER22
 SOURCE_SUBINVENTORYVARCHAR240
 RESTRICT_SUBINVENTORIES_CODENUMBER22
 UNIT_WEIGHTNUMBER22
 WEIGHT_UOM_CODEVARCHAR212
 VOLUME_UOM_CODEVARCHAR212
 UNIT_VOLUMENUMBER22
 RESTRICT_LOCATORS_CODENUMBER22
 LOCATION_CONTROL_CODENUMBER22
 SHRINKAGE_RATENUMBER22
 ACCEPTABLE_EARLY_DAYSNUMBER22
 PLANNING_TIME_FENCE_CODENUMBER22
 DEMAND_TIME_FENCE_CODENUMBER22
 LEAD_TIME_LOT_SIZENUMBER22
 STD_LOT_SIZENUMBER22
 CUM_MANUFACTURING_LEAD_TIMENUMBER22
 OVERRUN_PERCENTAGENUMBER22
 MRP_CALCULATE_ATP_FLAGVARCHAR24
 ACCEPTABLE_RATE_INCREASENUMBER22
 ACCEPTABLE_RATE_DECREASENUMBER22
 CUMULATIVE_TOTAL_LEAD_TIMENUMBER22
 PLANNING_TIME_FENCE_DAYSNUMBER22
 DEMAND_TIME_FENCE_DAYSNUMBER22
 END_ASSEMBLY_PEGGING_FLAGVARCHAR24
 REPETITIVE_PLANNING_FLAGVARCHAR24
 PLANNING_EXCEPTION_SETVARCHAR240
 BOM_ITEM_TYPENUMBER22
 PICK_COMPONENTS_FLAGVARCHAR24
 REPLENISH_TO_ORDER_FLAGVARCHAR24
 BASE_ITEM_IDNUMBER22
 ATP_COMPONENTS_FLAGVARCHAR24
 ATP_FLAGVARCHAR24
 FIXED_LEAD_TIMENUMBER22
 VARIABLE_LEAD_TIMENUMBER22
 WIP_SUPPLY_LOCATOR_IDNUMBER22
 WIP_SUPPLY_TYPENUMBER22
 WIP_SUPPLY_SUBINVENTORYVARCHAR240
 PRIMARY_UOM_CODEVARCHAR212
 ALLOWED_UNITS_LOOKUP_CODENUMBER22
 DEFAULT_INCLUDE_IN_ROLLUP_FLAGVARCHAR24
 INVENTORY_ITEM_STATUS_CODEVARCHAR240
 INVENTORY_PLANNING_CODENUMBER22
 PLANNER_CODEVARCHAR240
 PLANNING_MAKE_BUY_CODENUMBER22
 FIXED_LOT_MULTIPLIERNUMBER22
 ROUNDING_CONTROL_TYPENUMBER22
 CARRYING_COSTNUMBER22
 POSTPROCESSING_LEAD_TIMENUMBER22
 PREPROCESSING_LEAD_TIMENUMBER22
 FULL_LEAD_TIMENUMBER22
 ORDER_COSTNUMBER22
 MRP_SAFETY_STOCK_PERCENTNUMBER22
 MRP_SAFETY_STOCK_CODENUMBER22
 MIN_MINMAX_QUANTITYNUMBER22
 MAX_MINMAX_QUANTITYNUMBER22
 MINIMUM_ORDER_QUANTITYNUMBER22
 FIXED_ORDER_QUANTITYNUMBER22
 FIXED_DAYS_SUPPLYNUMBER22
 MAXIMUM_ORDER_QUANTITYNUMBER22
 ATP_RULE_IDNUMBER22
 PICKING_RULE_IDNUMBER22
 RESERVABLE_TYPENUMBER22
 POSITIVE_MEASUREMENT_ERRORNUMBER22
 NEGATIVE_MEASUREMENT_ERRORNUMBER22
 ENGINEERING_ITEM_IDNUMBER22
 SERVICE_STARTING_DELAYNUMBER22
 SERVICEABLE_PRODUCT_FLAGVARCHAR24
 PAYMENT_TERMS_IDNUMBER22
 MATERIAL_BILLABLE_FLAGVARCHAR2120
 COVERAGE_SCHEDULE_IDNUMBER22
 SERVICE_DURATION_PERIOD_CODEVARCHAR240
 SERVICE_DURATIONNUMBER22
 INVOICEABLE_ITEM_FLAGVARCHAR24
 TAX_CODEVARCHAR2200
 INVOICE_ENABLED_FLAGVARCHAR24
 MUST_USE_APPROVED_VENDOR_FLAGVARCHAR24
 REQUEST_IDNUMBER22
 OUTSIDE_OPERATION_FLAGVARCHAR24
 OUTSIDE_OPERATION_UOM_TYPEVARCHAR2100
 SAFETY_STOCK_BUCKET_DAYSNUMBER22
 AUTO_REDUCE_MPSNUMBER22
 COSTING_ENABLED_FLAGVARCHAR24
 AUTO_CREATED_CONFIG_FLAGVARCHAR24
 CYCLE_COUNT_ENABLED_FLAGVARCHAR24
 ITEM_TYPEVARCHAR2120
 SHIP_MODEL_COMPLETE_FLAGVARCHAR24
 MRP_PLANNING_CODENUMBER22
 RETURN_INSPECTION_REQUIREMENTNUMBER22
 ATO_FORECAST_CONTROLNUMBER22
 RELEASE_TIME_FENCE_CODENUMBER22
 RELEASE_TIME_FENCE_DAYSNUMBER22
 CONTAINER_ITEM_FLAGVARCHAR24
 VEHICLE_ITEM_FLAGVARCHAR24
 MAXIMUM_LOAD_WEIGHTNUMBER22
 MINIMUM_FILL_PERCENTNUMBER22
 CONTAINER_TYPE_CODEVARCHAR2120
 INTERNAL_VOLUMENUMBER22
 WH_UPDATE_DATEDATE7
 PRODUCT_FAMILY_ITEM_IDNUMBER22
 GLOBAL_ATTRIBUTE_CATEGORYVARCHAR2600
 GLOBAL_ATTRIBUTE1VARCHAR2600
 GLOBAL_ATTRIBUTE2VARCHAR2600
 GLOBAL_ATTRIBUTE3VARCHAR2600
 GLOBAL_ATTRIBUTE4VARCHAR2600
 GLOBAL_ATTRIBUTE5VARCHAR2600
 GLOBAL_ATTRIBUTE6VARCHAR2600
 GLOBAL_ATTRIBUTE7VARCHAR2600
 GLOBAL_ATTRIBUTE8VARCHAR2600
 GLOBAL_ATTRIBUTE9VARCHAR2600
 GLOBAL_ATTRIBUTE10VARCHAR2600
 PURCHASING_TAX_CODEVARCHAR2200
 OVERCOMPLETION_TOLERANCE_TYPENUMBER22
 OVERCOMPLETION_TOLERANCE_VALUENUMBER22
 EFFECTIVITY_CONTROLNUMBER22
 CHECK_SHORTAGES_FLAGVARCHAR24
 OVER_SHIPMENT_TOLERANCENUMBER22
 UNDER_SHIPMENT_TOLERANCENUMBER22
 OVER_RETURN_TOLERANCENUMBER22
 UNDER_RETURN_TOLERANCENUMBER22
 EQUIPMENT_TYPENUMBER22
 RECOVERED_PART_DISP_CODEVARCHAR2120
 DEFECT_TRACKING_ON_FLAGVARCHAR24
 EVENT_FLAGVARCHAR24
 ELECTRONIC_FLAGVARCHAR24
 DOWNLOADABLE_FLAGVARCHAR24
 COMMS_NL_TRACKABLE_FLAGVARCHAR24
 ASSET_CREATION_CODEVARCHAR2120
 COMMS_ACTIVATION_REQD_FLAGVARCHAR24
 ORDERABLE_ON_WEB_FLAGVARCHAR24
 BACK_ORDERABLE_FLAGVARCHAR24
 WEB_STATUSVARCHAR2120
 INDIVISIBLE_FLAGVARCHAR24
 DIMENSION_UOM_CODEVARCHAR212
 UNIT_LENGTHNUMBER22
 UNIT_WIDTHNUMBER22
 UNIT_HEIGHTNUMBER22
 BULK_PICKED_FLAGVARCHAR24
 LOT_STATUS_ENABLEDVARCHAR24
 DEFAULT_LOT_STATUS_IDNUMBER22
 SERIAL_STATUS_ENABLEDVARCHAR24
 DEFAULT_SERIAL_STATUS_IDNUMBER22
 LOT_SPLIT_ENABLEDVARCHAR24
 LOT_MERGE_ENABLEDVARCHAR24
 INVENTORY_CARRY_PENALTYNUMBER22
 OPERATION_SLACK_PENALTYNUMBER22
 FINANCING_ALLOWED_FLAGVARCHAR24
 EAM_ITEM_TYPENUMBER22
 EAM_ACTIVITY_TYPE_CODEVARCHAR2120
 EAM_ACTIVITY_CAUSE_CODEVARCHAR2120
 EAM_ACT_NOTIFICATION_FLAGVARCHAR24
 EAM_ACT_SHUTDOWN_STATUSVARCHAR2120
 DUAL_UOM_CONTROLNUMBER22
 SECONDARY_UOM_CODEVARCHAR212
 DUAL_UOM_DEVIATION_HIGHNUMBER22
 DUAL_UOM_DEVIATION_LOWNUMBER22
 CONTRACT_ITEM_TYPE_CODEVARCHAR2120
 SERV_REQ_ENABLED_CODEVARCHAR2120
 SERV_BILLING_ENABLED_FLAGVARCHAR24
 PLANNED_INV_POINT_FLAGVARCHAR24
 LOT_TRANSLATE_ENABLEDVARCHAR24
 DEFAULT_SO_SOURCE_TYPEVARCHAR2120
 CREATE_SUPPLY_FLAGVARCHAR24
 SUBSTITUTION_WINDOW_CODENUMBER22
 SUBSTITUTION_WINDOW_DAYSNUMBER22
 IB_ITEM_INSTANCE_CLASSVARCHAR2120
 CONFIG_MODEL_TYPEVARCHAR2120
 LOT_SUBSTITUTION_ENABLEDVARCHAR24
 MINIMUM_LICENSE_QUANTITYNUMBER22
 EAM_ACTIVITY_SOURCE_CODEVARCHAR2120
 CURRENT_PHASE_IDNUMBER22
 OBJECT_VERSION_NUMBERNUMBER22
 TRACKING_QUANTITY_INDVARCHAR2120
 ONT_PRICING_QTY_SOURCEVARCHAR2120
 SECONDARY_DEFAULT_INDVARCHAR2120
 OPTION_SPECIFIC_SOURCEDNUMBER22
 APPROVAL_STATUSVARCHAR2120
 VMI_MINIMUM_UNITSNUMBER22
 VMI_MINIMUM_DAYSNUMBER22
 VMI_MAXIMUM_UNITSNUMBER22
 VMI_MAXIMUM_DAYSNUMBER22
 VMI_FIXED_ORDER_QUANTITYNUMBER22
 SO_AUTHORIZATION_FLAGNUMBER22
 CONSIGNED_FLAGNUMBER22
 ASN_AUTOEXPIRE_FLAGNUMBER22
 VMI_FORECAST_TYPENUMBER22
 FORECAST_HORIZONNUMBER22
 EXCLUDE_FROM_BUDGET_FLAGNUMBER22
 DAYS_TGT_INV_SUPPLYNUMBER22
 DAYS_TGT_INV_WINDOWNUMBER22
 DAYS_MAX_INV_SUPPLYNUMBER22
 DAYS_MAX_INV_WINDOWNUMBER22
 DRP_PLANNED_FLAGNUMBER22
 CRITICAL_COMPONENT_FLAGNUMBER22
 CONTINOUS_TRANSFERNUMBER22
 CONVERGENCENUMBER22
 DIVERGENCENUMBER22
 CONFIG_ORGSVARCHAR2120
 CONFIG_MATCHVARCHAR2120
 ATTRIBUTE16VARCHAR2960
 ATTRIBUTE17VARCHAR2960
 ATTRIBUTE18VARCHAR2960
 ATTRIBUTE19VARCHAR2960
 ATTRIBUTE20VARCHAR2960
 ATTRIBUTE21VARCHAR2960
 ATTRIBUTE22VARCHAR2960
 ATTRIBUTE23VARCHAR2960
 ATTRIBUTE24VARCHAR2960
 ATTRIBUTE25VARCHAR2960
 ATTRIBUTE26VARCHAR2960
 ATTRIBUTE27VARCHAR2960
 ATTRIBUTE28VARCHAR2960
 ATTRIBUTE29VARCHAR2960
 ATTRIBUTE30VARCHAR2960
 CAS_NUMBERVARCHAR2120
 CHILD_LOT_FLAGVARCHAR24
 CHILD_LOT_PREFIXVARCHAR2120
 CHILD_LOT_STARTING_NUMBERNUMBER22
 CHILD_LOT_VALIDATION_FLAGVARCHAR24
 COPY_LOT_ATTRIBUTE_FLAGVARCHAR24
 DEFAULT_GRADEVARCHAR2600
 EXPIRATION_ACTION_CODEVARCHAR2128
 EXPIRATION_ACTION_INTERVALNUMBER22
 GRADE_CONTROL_FLAGVARCHAR24
 HAZARDOUS_MATERIAL_FLAGVARCHAR24
 HOLD_DAYSNUMBER22
 LOT_DIVISIBLE_FLAGVARCHAR24
 MATURITY_DAYSNUMBER22
 PARENT_CHILD_GENERATION_FLAGVARCHAR24
 PROCESS_COSTING_ENABLED_FLAGVARCHAR24
 PROCESS_EXECUTION_ENABLED_FLAGVARCHAR24
 PROCESS_QUALITY_ENABLED_FLAGVARCHAR24
 PROCESS_SUPPLY_LOCATOR_IDNUMBER22
 PROCESS_SUPPLY_SUBINVENTORYVARCHAR240
 PROCESS_YIELD_LOCATOR_IDNUMBER22
 PROCESS_YIELD_SUBINVENTORYVARCHAR240
 RECIPE_ENABLED_FLAGVARCHAR24
 RETEST_INTERVALNUMBER22
 CHARGE_PERIODICITY_CODEVARCHAR212
 REPAIR_LEADTIMENUMBER22
 REPAIR_YIELDNUMBER22
 PREPOSITION_POINTVARCHAR24
 REPAIR_PROGRAMNUMBER22
 SUBCONTRACTING_COMPONENTNUMBER22
 OUTSOURCED_ASSEMBLYNUMBER22
 EGO_MASTER_ITEMS_DFF_CTXVARCHAR24
 GDSN_OUTBOUND_ENABLED_FLAGVARCHAR24
 TRADE_ITEM_DESCRIPTORVARCHAR2140
 ASSET_TRACKED_FLAGVARCHAR24
 ASSET_CLASSVARCHAR2120
 SERVICE_DURATION_TYPE_CODEVARCHAR212
 SERVICE_START_TYPE_CODEVARCHAR212
 START_UPON_MILESTONE_CODEVARCHAR212
 SERVICE_START_DELAYNUMBER22
 ALLOW_SUSPEND_FLAGVARCHAR24
 ALLOW_TERMINATE_FLAGVARCHAR24
 REQUIRES_FULFILLMENT_LOC_FLAGVARCHAR24
 REQUIRES_ITM_ASSOCIATION_FLAGVARCHAR24
 STYLE_ITEM_IDNUMBER22
 STYLE_ITEM_FLAGVARCHAR24
 LAST_SUBMITTED_NIR_IDNUMBER22
 PROGRAM_NAMEVARCHAR2120
 PROGRAM_APP_NAMEVARCHAR2200
 ELIGIBILITY_COMPATIBILITY_RULEVARCHAR24
 JOB_DEFINITION_NAMEVARCHAR2400
 JOB_DEFINITION_PACKAGEVARCHAR23600
 ACD_TYPEVARCHAR2120
 CHANGE_LINE_IDNUMBER22
 VERSION_IDNUMBER22
 MASTER_ITEM_VERSION_IDNUMBER22
 VERSION_START_DATEDATE7
 VERSION_END_DATEDATE7
 IMPLEMENTATION_DATEDATE7
 TEMPLATE_ITEM_FLAGVARCHAR24
 QSC_SALES_PRODUCT_TYPEVARCHAR280
 MATCH_APPROVAL_LEVELNUMBER22
 INVOICE_MATCH_OPTIONNUMBER22
 DEFAULT_TEMPLATE_FLAGVARCHAR24
 INSPECTION_REQUIRED_FLAGVARCHAR24
 RECEIPT_REQUIRED_FLAGVARCHAR24
 ASSET_CATEGORY_IDNUMBER22
 EXPENSE_ACCOUNTNUMBER22
 SALES_ACCOUNTNUMBER22
 SALES_PRODUCT_TYPEVARCHAR2120
 SALES_PRODUCT_SUB_TYPEVARCHAR212
 ALT_ITEM_CODEVARCHAR2160
 CHANGE_BIT_MAPVARCHAR21600
 CURRENT_PHASE_CODEVARCHAR2480
 INVENTORY_ORGANIZATION_IDNUMBER22
 ITEM_NUMBERVARCHAR21200
 CREATED_BYVARCHAR2256
 LAST_UPDATED_BYVARCHAR2256
 DQ_SEMANTIC_KEYVARCHAR24000
 DQ_REQUIRED_FLAGVARCHAR24
 THREAD_IDNUMBER22
 ATTRIBUTE_NUMBER1NUMBER22
 ATTRIBUTE_NUMBER2NUMBER22
 ATTRIBUTE_NUMBER3NUMBER22
 ATTRIBUTE_NUMBER4NUMBER22
 ATTRIBUTE_NUMBER5NUMBER22
 ATTRIBUTE_NUMBER6NUMBER22
 ATTRIBUTE_NUMBER7NUMBER22
 ATTRIBUTE_NUMBER8NUMBER22
 ATTRIBUTE_NUMBER9NUMBER22
 ATTRIBUTE_NUMBER10NUMBER22
 ATTRIBUTE_DATE1DATE7
 ATTRIBUTE_DATE2DATE7
 ATTRIBUTE_DATE3DATE7
 ATTRIBUTE_DATE4DATE7
 ATTRIBUTE_DATE5DATE7
 ATTRIBUTE_TIMESTAMP1TIMESTAMP(6)11
 ATTRIBUTE_TIMESTAMP2TIMESTAMP(6)11
 ATTRIBUTE_TIMESTAMP3TIMESTAMP(6)11
 ATTRIBUTE_TIMESTAMP4TIMESTAMP(6)11
 ATTRIBUTE_TIMESTAMP5TIMESTAMP(6)11
 GLOBAL_ATTRIBUTE11VARCHAR2600
 GLOBAL_ATTRIBUTE12VARCHAR2600
 GLOBAL_ATTRIBUTE13VARCHAR2600
 GLOBAL_ATTRIBUTE14VARCHAR2600
 GLOBAL_ATTRIBUTE15VARCHAR2600
 GLOBAL_ATTRIBUTE16VARCHAR2600
 GLOBAL_ATTRIBUTE17VARCHAR2600
 GLOBAL_ATTRIBUTE18VARCHAR2600
 GLOBAL_ATTRIBUTE19VARCHAR2600
 GLOBAL_ATTRIBUTE20VARCHAR2600
 GLOBAL_ATTRIBUTE_NUMBER1NUMBER22
 GLOBAL_ATTRIBUTE_NUMBER2NUMBER22
 GLOBAL_ATTRIBUTE_NUMBER3NUMBER22
 GLOBAL_ATTRIBUTE_NUMBER4NUMBER22
 GLOBAL_ATTRIBUTE_NUMBER5NUMBER22
 GLOBAL_ATTRIBUTE_DATE1DATE7
 GLOBAL_ATTRIBUTE_DATE2DATE7
 GLOBAL_ATTRIBUTE_DATE3DATE7
 GLOBAL_ATTRIBUTE_DATE4DATE7
 GLOBAL_ATTRIBUTE_DATE5DATE7
 BACK_TO_BACK_ENABLEDVARCHAR24
 CONTRACT_MANUFACTURINGVARCHAR24
 SAFETY_STOCK_PLANNING_METHODVARCHAR2120
 DEMAND_PERIODNUMBER22
 DAYS_OF_COVERNUMBER22
 MASTER_ORG_IDNUMBER22
 OUTSIDE_PROCESS_SERVICE_FLAGVARCHAR24
 ALLOW_MAINTENANCE_ASSET_FLAGVARCHAR24
 ENABLE_GENEALOGY_TRACKING_FLAGVARCHAR24
 COMPLETENESS_SCORENUMBER22
 CSS_ENABLED_FLAGVARCHAR24
 ENGINEERED_ITEM_FLAGVARCHAR24
 FORCE_PURCHASE_LEAD_TIME_FLAGVARCHAR24
 REPLACEMENT_TYPEVARCHAR2120
 HARD_PEGGING_LEVELVARCHAR2100
 COMN_SUPPLY_PRJ_DEMAND_FLAGVARCHAR24
 ENABLE_IOT_FLAGVARCHAR24Y 
 EXPENDITURE_TYPE_IDNUMBER22
EGP_SYSTEM_ITEMS_B: Table Structure

EGP_SYSTEM_ITEMS_B Indexes

INDEX NAMEINDEX TYPEUNIQUENESSCOLUMN NAME
 EGP_SYSTEM_ITEMS_B_N1NORMALNONUNIQUEITEM_NUMBER
 EGP_SYSTEM_ITEMS_B_N10NORMALNONUNIQUEORGANIZATION_ID
 EGP_SYSTEM_ITEMS_B_N10NORMALNONUNIQUEPLANNER_CODE
 EGP_SYSTEM_ITEMS_B_N11NORMALNONUNIQUEWEB_STATUS
 EGP_SYSTEM_ITEMS_B_N11NORMALNONUNIQUEORGANIZATION_ID
 EGP_SYSTEM_ITEMS_B_N13NORMALNONUNIQUEORGANIZATION_ID
 EGP_SYSTEM_ITEMS_B_N13NORMALNONUNIQUEWIP_SUPPLY_LOCATOR_ID
 EGP_SYSTEM_ITEMS_B_N14NORMALNONUNIQUEBASE_ITEM_ID
 EGP_SYSTEM_ITEMS_B_N14NORMALNONUNIQUEORGANIZATION_ID
 EGP_SYSTEM_ITEMS_B_N15NORMALNONUNIQUESTYLE_ITEM_ID
 EGP_SYSTEM_ITEMS_B_N15NORMALNONUNIQUEORGANIZATION_ID
 EGP_SYSTEM_ITEMS_B_N16FUNCTION-BASED NORMALNONUNIQUESYS_NC00424$
 EGP_SYSTEM_ITEMS_B_N16FUNCTION-BASED NORMALNONUNIQUEORGANIZATION_ID
 EGP_SYSTEM_ITEMS_B_N18NORMALNONUNIQUEORGANIZATION_ID
 EGP_SYSTEM_ITEMS_B_N18NORMALNONUNIQUEDQ_REQUIRED_FLAG
 EGP_SYSTEM_ITEMS_B_N18NORMALNONUNIQUETHREAD_ID
 EGP_SYSTEM_ITEMS_B_N19NORMALNONUNIQUETEMPLATE_ITEM_FLAG
 EGP_SYSTEM_ITEMS_B_N19NORMALNONUNIQUEITEM_CATALOG_GROUP_ID
 EGP_SYSTEM_ITEMS_B_N20FUNCTION-BASED NORMALNONUNIQUESYS_NC00425$
 EGP_SYSTEM_ITEMS_B_N20FUNCTION-BASED NORMALNONUNIQUEORGANIZATION_ID
 EGP_SYSTEM_ITEMS_B_N21NORMALNONUNIQUESTYLE_ITEM_FLAG
 EGP_SYSTEM_ITEMS_B_N22NORMALNONUNIQUETRADE_ITEM_DESCRIPTOR
 EGP_SYSTEM_ITEMS_B_N23NORMALNONUNIQUELAST_UPDATE_DATE
 EGP_SYSTEM_ITEMS_B_N24FUNCTION-BASED NORMALNONUNIQUESYS_NC00432$
 EGP_SYSTEM_ITEMS_B_N25NORMALNONUNIQUECURRENT_PHASE_CODE
 EGP_SYSTEM_ITEMS_B_N25NORMALNONUNIQUEITEM_CATALOG_GROUP_ID
 EGP_SYSTEM_ITEMS_B_N26NORMALNONUNIQUECREATION_DATE
 EGP_SYSTEM_ITEMS_B_N27NORMALNONUNIQUEORGANIZATION_ID
 EGP_SYSTEM_ITEMS_B_N27NORMALNONUNIQUESALES_PRODUCT_TYPE
 EGP_SYSTEM_ITEMS_B_N28NORMALNONUNIQUEORGANIZATION_ID
 EGP_SYSTEM_ITEMS_B_N28NORMALNONUNIQUESERVICEABLE_PRODUCT_FLAG
 EGP_SYSTEM_ITEMS_B_N29NORMALNONUNIQUEINVENTORY_ITEM_ID
 EGP_SYSTEM_ITEMS_B_N29NORMALNONUNIQUEINVENTORY_ORGANIZATION_ID
 EGP_SYSTEM_ITEMS_B_N29NORMALNONUNIQUEVERSION_ID
 EGP_SYSTEM_ITEMS_B_N29NORMALNONUNIQUECHANGE_LINE_ID
 EGP_SYSTEM_ITEMS_B_N29NORMALNONUNIQUEACD_TYPE
 EGP_SYSTEM_ITEMS_B_N3NORMALNONUNIQUEINVENTORY_ITEM_STATUS_CODE
 EGP_SYSTEM_ITEMS_B_N30NORMALNONUNIQUEREQUEST_ID
 EGP_SYSTEM_ITEMS_B_N31NORMALNONUNIQUEINVENTORY_ITEM_ID
 EGP_SYSTEM_ITEMS_B_N31NORMALNONUNIQUESTYLE_ITEM_ID
 EGP_SYSTEM_ITEMS_B_N31NORMALNONUNIQUEORGANIZATION_ID
 EGP_SYSTEM_ITEMS_B_N4NORMALNONUNIQUEORGANIZATION_ID
 EGP_SYSTEM_ITEMS_B_N4NORMALNONUNIQUEAUTO_CREATED_CONFIG_FLAG
 EGP_SYSTEM_ITEMS_B_N5NORMALNONUNIQUEWH_UPDATE_DATE
 EGP_SYSTEM_ITEMS_B_N6NORMALNONUNIQUEITEM_CATALOG_GROUP_ID
 EGP_SYSTEM_ITEMS_B_N6NORMALNONUNIQUEORGANIZATION_ID
 EGP_SYSTEM_ITEMS_B_N6NORMALNONUNIQUEINVENTORY_ITEM_ID
 EGP_SYSTEM_ITEMS_B_N6NORMALNONUNIQUETEMPLATE_ITEM_FLAG
 EGP_SYSTEM_ITEMS_B_N6NORMALNONUNIQUEAPPROVAL_STATUS
 EGP_SYSTEM_ITEMS_B_N7NORMALNONUNIQUEPRODUCT_FAMILY_ITEM_ID
 EGP_SYSTEM_ITEMS_B_N7NORMALNONUNIQUEORGANIZATION_ID
 EGP_SYSTEM_ITEMS_B_N8NORMALNONUNIQUECOMMS_NL_TRACKABLE_FLAG
 EGP_SYSTEM_ITEMS_B_N8NORMALNONUNIQUEORGANIZATION_ID
 EGP_SYSTEM_ITEMS_B_N9NORMALNONUNIQUEORGANIZATION_ID
 EGP_SYSTEM_ITEMS_B_N9NORMALNONUNIQUEBUYER_ID
 EGP_SYSTEM_ITEMS_B_U1NORMALUNIQUEINVENTORY_ITEM_ID
 EGP_SYSTEM_ITEMS_B_U1NORMALUNIQUEORGANIZATION_ID
 EGP_SYSTEM_ITEMS_B_U3NORMALUNIQUEORGANIZATION_ID
 EGP_SYSTEM_ITEMS_B_U3NORMALUNIQUEITEM_NUMBER
EGP_SYSTEM_ITEMS_B Index Details

Related Posts

Item Detail Query
Onhand & Available Quantity Calculation
egp_system_items_tl Table

Feedback:
Hope the article helped you. If it did, please rate the post. In case it didn’t, do leave a comment to let us know what did we miss.

Reference:
support.oracle.com

How useful was this post?

Click on a star to rate it!

Average rating 5 / 5. Vote count: 2

No votes so far! Be the first to rate this post.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?