DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.EGO_ITEM_SYNC_V

Object Details
Object Name: EGO_ITEM_SYNC_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewEGO.EGO_ITEM_SYNC_V
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This View is used for Item Sync operations with external systems. Currently this is being used for ItemSync with Siebel

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
PRIMARY_UOM_CODE VARCHAR2 (3)
Primary unit of measure code
PRIMARY_UNIT_OF_MEASURE VARCHAR2 (25)
Primary stocking unit of measure for the item
ITEM_TYPE VARCHAR2 (30)
User-defined item type
INVENTORY_ITEM_STATUS_CODE VARCHAR2 (10) Yes Material status code
ALLOWED_UNITS_LOOKUP_CODE NUMBER

Allowed unit of measure conversion type
ITEM_CATALOG_GROUP_ID NUMBER

Item catalog group identifier
CATALOG_STATUS_FLAG VARCHAR2 (1)
Flag indicating item catalog complete
INVENTORY_ITEM_FLAG VARCHAR2 (1) Yes Flag indicating inventory item
STOCK_ENABLED_FLAG VARCHAR2 (1) Yes Flag indicating item is stockable
MTL_TRANSACTIONS_ENABLED_FLAG VARCHAR2 (1) Yes Flag indicating item is transactable
CHECK_SHORTAGES_FLAG VARCHAR2 (1)
Flag indicating material shortages should be checked for this item
REVISION_QTY_CONTROL_CODE NUMBER

Revision quantity control code
RESERVABLE_TYPE NUMBER

Hard reservations allowed flag
SHELF_LIFE_CODE NUMBER

Shelf life code
SHELF_LIFE_DAYS NUMBER

Length of shelf life days
CYCLE_COUNT_ENABLED_FLAG VARCHAR2 (1) Yes Flag indicating item may be cycle counted
NEGATIVE_MEASUREMENT_ERROR NUMBER

Percent error below measured quantity
POSITIVE_MEASUREMENT_ERROR NUMBER

Percent error above measured quantity
LOT_CONTROL_CODE NUMBER

Lot control code
AUTO_LOT_ALPHA_PREFIX VARCHAR2 (30)
Item-level prefix for lot numbers
START_AUTO_LOT_NUMBER VARCHAR2 (30)
Next auto assigned lot number
SERIAL_NUMBER_CONTROL_CODE NUMBER

Serial number control code
AUTO_SERIAL_ALPHA_PREFIX VARCHAR2 (30)
Item-level alpha prefix for serial numbers
START_AUTO_SERIAL_NUMBER VARCHAR2 (30)
Next auto assigned serial number
LOCATION_CONTROL_CODE NUMBER

Stock locator control code
RESTRICT_SUBINVENTORIES_CODE NUMBER

Subinventory restrictions type
RESTRICT_LOCATORS_CODE NUMBER

Locators restrictions type
BOM_ENABLED_FLAG VARCHAR2 (1) Yes Flag indicating item may appear on a BOM
BOM_ITEM_TYPE NUMBER
Yes Type of item
BASE_ITEM_ID NUMBER

Base item identifier
EFFECTIVITY_CONTROL NUMBER

Effectivity control code. Indicates if the item is under Date Effectivity or Model/Unit
ENG_ITEM_FLAG VARCHAR2 (1) Yes Flag indicating engineering item
ENGINEERING_ECN_CODE VARCHAR2 (50)
Engineering ECN code
ENGINEERING_ITEM_ID NUMBER

Engineering implemented item identifier
ENGINEERING_DATE DATE

Engineering implementation date
PRODUCT_FAMILY_ITEM_ID NUMBER

If the item is product family member, stores the product family identifier. Used in Production Planning
AUTO_CREATED_CONFIG_FLAG VARCHAR2 (1) Yes Flag indicating configuration item automatically created
MODEL_CONFIG_CLAUSE_NAME VARCHAR2 (10)
(not currently used)
NEW_REVISION_CODE VARCHAR2 (30)
Indicates how to notify customers of new revisions of the item
COSTING_ENABLED_FLAG VARCHAR2 (1) Yes Flag indicating cost information is maintained
INVENTORY_ASSET_FLAG VARCHAR2 (1) Yes Flag indicating item is an inventory asset
DEFAULT_INCLUDE_IN_ROLLUP_FLAG VARCHAR2 (1)
Default value for include in cost rollup
COST_OF_SALES_ACCOUNT NUMBER

Cost of sales account
STD_LOT_SIZE NUMBER

Standard lot size
PURCHASING_ITEM_FLAG VARCHAR2 (1) Yes Flag indicating purchasing item
PURCHASING_ENABLED_FLAG VARCHAR2 (1) Yes Flag indicating item is purchasable
MUST_USE_APPROVED_VENDOR_FLAG VARCHAR2 (1) Yes Flag indicating purchases restricted to approved supplier
ALLOW_ITEM_DESC_UPDATE_FLAG VARCHAR2 (1)
Allow item description updates on PO lines
RFQ_REQUIRED_FLAG VARCHAR2 (1)
Flag indicating whether an RFQ (request for quotation) is required
OUTSIDE_OPERATION_FLAG VARCHAR2 (1) Yes Flag indicating item may appear on outside operation purchase order
OUTSIDE_OPERATION_UOM_TYPE VARCHAR2 (25)
Outside operation unit of measure
TAXABLE_FLAG VARCHAR2 (1)
Flag indicating whether item is taxable
PURCHASING_TAX_CODE VARCHAR2 (50)
Purchasing tax code
RECEIPT_REQUIRED_FLAG VARCHAR2 (1)
Flag indicating supplier receipt is required before payment
INSPECTION_REQUIRED_FLAG VARCHAR2 (1)
Flag indicating whether inspection is required upon receipt
BUYER_ID NUMBER (9)
Buyer identifier
UNIT_OF_ISSUE VARCHAR2 (25)
Unit of issue
RECEIVE_CLOSE_TOLERANCE NUMBER

Receipt close tolerance
INVOICE_CLOSE_TOLERANCE NUMBER

Invoice close tolerance
UN_NUMBER_ID NUMBER

Purchasing UN (United Nations) number
HAZARD_CLASS_ID NUMBER

Purchasing hazard identifier
LIST_PRICE_PER_UNIT NUMBER

Unit list price - purchasing
MARKET_PRICE NUMBER

Purchasing market price
PRICE_TOLERANCE_PERCENT NUMBER

Purchase price tolerance percentage
ROUNDING_FACTOR NUMBER

Rounding factor used to determine order quantity
ENCUMBRANCE_ACCOUNT NUMBER

Encumbrance account
EXPENSE_ACCOUNT NUMBER

Expense account
ASSET_CATEGORY_ID NUMBER

Fixed asset category identifier (foreign key FA asset category flexfield)
RECEIPT_DAYS_EXCEPTION_CODE VARCHAR2 (25)
Exception processing for early/late receipts
DAYS_EARLY_RECEIPT_ALLOWED NUMBER

Days before planned receipt that item may be received
DAYS_LATE_RECEIPT_ALLOWED NUMBER

Days after the planned receipt that item may be received
ALLOW_SUBSTITUTE_RECEIPTS_FLAG VARCHAR2 (1)
Flag indicating substitute receipts allowed
ALLOW_UNORDERED_RECEIPTS_FLAG VARCHAR2 (1)
Flag indicating unordered receipts allowed
ALLOW_EXPRESS_DELIVERY_FLAG VARCHAR2 (1)
Flag indicating express delivery allowed
QTY_RCV_EXCEPTION_CODE VARCHAR2 (25)
Over tolerance receipts processing method code
QTY_RCV_TOLERANCE NUMBER

Maximum acceptable over-receipt percentage
RECEIVING_ROUTING_ID NUMBER

Default receipt routing
ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2 (25)
Require receipt location to match ship-to location
WEIGHT_UOM_CODE VARCHAR2 (3)
Weight unit of measure code
UNIT_WEIGHT NUMBER

Conversion between weight unit of measure and base unit of measure
VOLUME_UOM_CODE VARCHAR2 (3)
Volume unit of measure code
UNIT_VOLUME NUMBER

Conversion between volume unit of measure and base unit of measure
CONTAINER_ITEM_FLAG VARCHAR2 (1)
Flag indicating if the item is a container. Used for shipping sales orders
VEHICLE_ITEM_FLAG VARCHAR2 (1)
Indicates if the item is a vehicle or not. Used for shipping sales orders
CONTAINER_TYPE_CODE VARCHAR2 (30)
Container type code for container items. Container types are user defineable
INTERNAL_VOLUME NUMBER

Internal volume for container items. Used by Shipping to calculate container capacity
MAXIMUM_LOAD_WEIGHT NUMBER

Maximum load weight of a container or a vehicle that can be used for shipping sales orders
MINIMUM_FILL_PERCENT NUMBER

Minimum fill condition under which the container or vehicle should be used
INVENTORY_PLANNING_CODE NUMBER

Inventory planning code
PLANNER_CODE VARCHAR2 (10)
Planner code
PLANNING_MAKE_BUY_CODE NUMBER

Indicates whether item is planned as manufactured or purchased
MIN_MINMAX_QUANTITY NUMBER

Minimum minmax order quantity
MAX_MINMAX_QUANTITY NUMBER

Maximum minmax order quantity
MINIMUM_ORDER_QUANTITY NUMBER

Minimum order quantity
MAXIMUM_ORDER_QUANTITY NUMBER

Maximum order quantity
ORDER_COST NUMBER

Annual carrying cost
CARRYING_COST NUMBER

Annual carrying cost
SOURCE_TYPE NUMBER

Inventory or supplier source type
SOURCE_ORGANIZATION_ID NUMBER

Organization to source items from
SOURCE_SUBINVENTORY VARCHAR2 (10)
Subinventory to source items from
MRP_SAFETY_STOCK_CODE NUMBER

Safety stock code
SAFETY_STOCK_BUCKET_DAYS NUMBER

Safety stock bucket days
MRP_SAFETY_STOCK_PERCENT NUMBER

Safety stock percentage
FIXED_ORDER_QUANTITY NUMBER

Fixed order quantity
FIXED_DAYS_SUPPLY NUMBER

Fixed days supply
FIXED_LOT_MULTIPLIER NUMBER

Fixed lot size multiplier
MRP_PLANNING_CODE NUMBER

MRP Planning option
ATO_FORECAST_CONTROL NUMBER

Type of forecast control for ATO
PLANNING_EXCEPTION_SET VARCHAR2 (10)
Exception control set
END_ASSEMBLY_PEGGING_FLAG VARCHAR2 (1)
End assembly pegging flag for MRP
SHRINKAGE_RATE NUMBER

Planned shrinkage rate
ROUNDING_CONTROL_TYPE NUMBER

Rounding control code
ACCEPTABLE_EARLY_DAYS NUMBER

Days an order may be early before rescheduling is recommended
REPETITIVE_PLANNING_FLAG VARCHAR2 (1)
Flag indicating item to be planned as repetitive schedule
OVERRUN_PERCENTAGE NUMBER

MRP repetitive acceptable overrun rate
ACCEPTABLE_RATE_INCREASE NUMBER

MRP repetitive acceptable rate increase
ACCEPTABLE_RATE_DECREASE NUMBER

MRP repetitive acceptable rate decrease
MRP_CALCULATE_ATP_FLAG VARCHAR2 (1)
Calculate ATP flag (y/n) for MRP planning routine
AUTO_REDUCE_MPS NUMBER (22)
Automatically deletes MPS entries within a time period
PLANNING_TIME_FENCE_CODE NUMBER

Planning time fence code
PLANNING_TIME_FENCE_DAYS NUMBER

Planning time fence days
DEMAND_TIME_FENCE_CODE NUMBER

Demand time fence code
DEMAND_TIME_FENCE_DAYS NUMBER

Demand time fence days
RELEASE_TIME_FENCE_CODE NUMBER

Flag to indicate if this item is auto releasable by MRP
RELEASE_TIME_FENCE_DAYS NUMBER

Number of days within which this item should be auto released
PREPROCESSING_LEAD_TIME NUMBER

Pre-processing lead time
FULL_LEAD_TIME NUMBER

Full lead time
POSTPROCESSING_LEAD_TIME NUMBER

Post-processing lead time
FIXED_LEAD_TIME NUMBER

Fixed portion of the assemblys lead time
VARIABLE_LEAD_TIME NUMBER

Variable portion of an assemblys lead time
CUM_MANUFACTURING_LEAD_TIME NUMBER

Cumulative manufacturing lead time
CUMULATIVE_TOTAL_LEAD_TIME NUMBER

Cumulative total lead time
LEAD_TIME_LOT_SIZE NUMBER

Lead time lot size
BUILD_IN_WIP_FLAG VARCHAR2 (1) Yes Flag indicating item may be built in WIP
WIP_SUPPLY_TYPE NUMBER

Source of WIP material supply
WIP_SUPPLY_SUBINVENTORY VARCHAR2 (10)
Supply subinventory for WIP transactions
WIP_SUPPLY_LOCATOR_ID NUMBER

Supply locator for WIP transactions
OVERCOMPLETION_TOLERANCE_TYPE NUMBER

Overcompletion tolerance type
OVERCOMPLETION_TOLERANCE_VALUE NUMBER

Overcompletion tolerance value
CUSTOMER_ORDER_FLAG VARCHAR2 (1) Yes Flag indicating customer orderable item
CUSTOMER_ORDER_ENABLED_FLAG VARCHAR2 (1) Yes Flag indicating item is customer orderable
SHIPPABLE_ITEM_FLAG VARCHAR2 (1) Yes Flag indicating shippable item
INTERNAL_ORDER_FLAG VARCHAR2 (1) Yes Flag indicating internally orderable item
INTERNAL_ORDER_ENABLED_FLAG VARCHAR2 (1) Yes Flag indicating item is internally orderable
SO_TRANSACTIONS_FLAG VARCHAR2 (1) Yes Sales order transactions flag
PICK_COMPONENTS_FLAG VARCHAR2 (1) Yes Flag indicating whether all shippable components should be picked
ATP_FLAG VARCHAR2 (1) Yes Flag indicating ATP must be checked when item is ordered
REPLENISH_TO_ORDER_FLAG VARCHAR2 (1) Yes Assemble to Order flag
ATP_RULE_ID NUMBER

Available to promise rule to be used for this item
ATP_COMPONENTS_FLAG VARCHAR2 (1) Yes Flag indicating whether item may have components requiring ATP check
SHIP_MODEL_COMPLETE_FLAG VARCHAR2 (1)
Flag indicating model must be complete to ship
PICKING_RULE_ID NUMBER

Picking rule code
COLLATERAL_FLAG VARCHAR2 (1)
Flag indicating item is collateral item
DEFAULT_SHIPPING_ORG NUMBER

Default shipping organization
RETURNABLE_FLAG VARCHAR2 (1)
Flag indicating whether item is returnable
RETURN_INSPECTION_REQUIREMENT NUMBER

RMA inspection requirement
OVER_SHIPMENT_TOLERANCE NUMBER

Over shipment tolerance
UNDER_SHIPMENT_TOLERANCE NUMBER

Under shipment tolerance
OVER_RETURN_TOLERANCE NUMBER

Over return tolerance
UNDER_RETURN_TOLERANCE NUMBER

Under return tolerance
INVOICEABLE_ITEM_FLAG VARCHAR2 (1) Yes Flag indicating item may appear on invoices
INVOICE_ENABLED_FLAG VARCHAR2 (1) Yes Indicates whether the item can be invoiced
ACCOUNTING_RULE_ID NUMBER

Accounting rule identifier
INVOICING_RULE_ID NUMBER

Invoicing rule identifier
TAX_CODE VARCHAR2 (50)
Tax code
SALES_ACCOUNT NUMBER

Sales account
PAYMENT_TERMS_ID NUMBER

Payment terms identifier
SERVICE_ITEM_FLAG VARCHAR2 (1) Yes Flag indicating service item
VENDOR_WARRANTY_FLAG VARCHAR2 (1) Yes Flag indicating service for the item is provided by a supplier
COVERAGE_SCHEDULE_ID NUMBER

Coverage schedule identifier
SERVICE_DURATION NUMBER

Period code for default service duration
SERVICE_DURATION_PERIOD_CODE VARCHAR2 (10)
Period code for default service duration
SERVICEABLE_PRODUCT_FLAG VARCHAR2 (1) Yes Indicates whether the item is serviceable by other service-type items and can have service requests reported against it
SERVICE_STARTING_DELAY NUMBER

Days after shipment that service begins
MATERIAL_BILLABLE_FLAG VARCHAR2 (30)
Flag indicating service material is billable
TIME_BILLABLE_FLAG VARCHAR2 (1)
Flag indicating service labor hours are billable
EXPENSE_BILLABLE_FLAG VARCHAR2 (1)
Flag indicating service expenses are billable
SERVICEABLE_COMPONENT_FLAG VARCHAR2 (1)
Indicates whether the item is serviceable by other service-type items and whether it can be referenced as the component of another item
PREVENTIVE_MAINTENANCE_FLAG VARCHAR2 (1)
Flag indicating whether item can be a preventive maintenance service item
PRORATE_SERVICE_FLAG VARCHAR2 (1)
Flag indicating cost of service may be prorated
SERVICEABLE_ITEM_CLASS_ID NUMBER

Serviceable item class identifier
BASE_WARRANTY_SERVICE_ID NUMBER

Base warranty identifier
WARRANTY_VENDOR_ID NUMBER

Service supplier identifier
MAX_WARRANTY_AMOUNT NUMBER

Monetary value of service costs covered by the item
RESPONSE_TIME_PERIOD_CODE VARCHAR2 (30)
Period code for service response time
RESPONSE_TIME_VALUE NUMBER

Default response time
PRIMARY_SPECIALIST_ID NUMBER

Primary service specialist
SECONDARY_SPECIALIST_ID NUMBER

Secondary service specialist
WH_UPDATE_DATE DATE

Warehouse update date for tracking changes relevant to data collected in Data
SEGMENT1 VARCHAR2 (40)
Key flexfield segment
SEGMENT2 VARCHAR2 (40)
Key flexfield segment
SEGMENT3 VARCHAR2 (40)
Key flexfield segment
SEGMENT4 VARCHAR2 (40)
Key flexfield segment
SEGMENT5 VARCHAR2 (40)
Key flexfield segment
SEGMENT6 VARCHAR2 (40)
Key flexfield segment
SEGMENT7 VARCHAR2 (40)
Key flexfield segment
SEGMENT8 VARCHAR2 (40)
Key flexfield segment
SEGMENT9 VARCHAR2 (40)
Key flexfield segment
SEGMENT10 VARCHAR2 (40)
Key flexfield segment
SEGMENT11 VARCHAR2 (40)
Key flexfield segment
SEGMENT12 VARCHAR2 (40)
Key flexfield segment
SEGMENT13 VARCHAR2 (40)
Key flexfield segment
SEGMENT14 VARCHAR2 (40)
Key flexfield segment
SEGMENT15 VARCHAR2 (40)
Key flexfield segment
SEGMENT16 VARCHAR2 (40)
Key flexfield segment
SEGMENT17 VARCHAR2 (40)
Key flexfield segment
SEGMENT18 VARCHAR2 (40)
Key flexfield segment
SEGMENT19 VARCHAR2 (40)
Key flexfield segment
SEGMENT20 VARCHAR2 (40)
Key flexfield segment
SUMMARY_FLAG VARCHAR2 (1) Yes Flexfield summary flag
ENABLED_FLAG VARCHAR2 (1) Yes Flexfield enabled flag
START_DATE_ACTIVE DATE

Flexfield segment start date
END_DATE_ACTIVE DATE

Flexfield segment end date
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
Global descriptive flexfield structure defining column
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Global descriptive flexfield segment
EQUIPMENT_TYPE NUMBER

Flag indicating item is equipment
RECOVERED_PART_DISP_CODE VARCHAR2 (30)
Indicates return is required for recovered pars, scrap in field, which is used for spare
DEFECT_TRACKING_ON_FLAG VARCHAR2 (1)
Specifies whether a defect or bug can be filed against the product
USAGE_ITEM_FLAG VARCHAR2 (1)
Flag indicating an item represents usage. Usage items can be sold as a use of
EVENT_FLAG VARCHAR2 (1)
Identifies item as an event
ELECTRONIC_FLAG VARCHAR2 (1)
Flag indicating an item exists only in electronic format and not physical
DOWNLOADABLE_FLAG VARCHAR2 (1)
Flag indicating an item is downloadable
VOL_DISCOUNT_EXEMPT_FLAG VARCHAR2 (1)
Indicates an item does not contribute to volume discount for any order
COUPON_EXEMPT_FLAG VARCHAR2 (1)
Indicates an item is excluded from coupons even if it is part of the group that any
COMMS_NL_TRACKABLE_FLAG VARCHAR2 (1)
Identifies an item as network logistics trackable
ASSET_CREATION_CODE VARCHAR2 (30)
Used to specify when an asset should be created
COMMS_ACTIVATION_REQD_FLAG VARCHAR2 (1)
Indicates an item requires activation on a network
ORDERABLE_ON_WEB_FLAG VARCHAR2 (1)
Indicates whether an item is orderable on the web or not. iStore will only sell items with this flag to be true
BACK_ORDERABLE_FLAG VARCHAR2 (1)
If ATP failed, can item be back ordered
WEB_STATUS VARCHAR2 (30)
Specifies item web status, which can be web enabled, web published, or neither
INDIVISIBLE_FLAG VARCHAR2 (1)
Item unit is indivisible
DIMENSION_UOM_CODE VARCHAR2 (3)
Item dimensions unit of measure code
UNIT_LENGTH NUMBER

Item length
UNIT_WIDTH NUMBER

Item width
UNIT_HEIGHT NUMBER

Unit Height
BULK_PICKED_FLAG VARCHAR2 (1)
Material pick method
LOT_STATUS_ENABLED VARCHAR2 (1)
Lot status enabled
DEFAULT_LOT_STATUS_ID NUMBER

Default lot status
SERIAL_STATUS_ENABLED VARCHAR2 (1)
Serial status enabled
DEFAULT_SERIAL_STATUS_ID NUMBER

Default serial status
LOT_SPLIT_ENABLED VARCHAR2 (1)
Lot split enabled
LOT_MERGE_ENABLED VARCHAR2 (1)
Lot merge enabled
INVENTORY_CARRY_PENALTY NUMBER

Penalty incurred for holding this item inventory
OPERATION_SLACK_PENALTY NUMBER

Penalty incurred for a time in between two ope
FINANCING_ALLOWED_FLAG VARCHAR2 (1)
Item is eligible for financing
EAM_ITEM_TYPE NUMBER

Asset item type
EAM_ACTIVITY_TYPE_CODE VARCHAR2 (30)
Asset activity type
EAM_ACTIVITY_CAUSE_CODE VARCHAR2 (30)
Asset activity cause
EAM_ACT_NOTIFICATION_FLAG VARCHAR2 (1)
Asset activity notification required
EAM_ACT_SHUTDOWN_STATUS VARCHAR2 (30)
Asset activity shutdown type
DUAL_UOM_CONTROL NUMBER

Indicates Item control of Dual Unit of Measure
SECONDARY_UOM_CODE VARCHAR2 (3)
Secondary Unit of Measure
DUAL_UOM_DEVIATION_HIGH NUMBER

Upper bound of tolerance factor by which the Dual Unit of Measure may be transacted in
DUAL_UOM_DEVIATION_LOW NUMBER

Lower bound of tolerance factor by which the Dual Unit of Measure may be transacted in
CONTRACT_ITEM_TYPE_CODE VARCHAR2 (30)
Contract Item type
SUBSCRIPTION_DEPEND_FLAG VARCHAR2 (1)
Subscription dependency enabled
SERV_REQ_ENABLED_CODE VARCHAR2 (30)
Service Request Enabled
SERV_BILLING_ENABLED_FLAG VARCHAR2 (1)
Service Billing Enabled
SERV_IMPORTANCE_LEVEL NUMBER

Service Importance Level
PLANNED_INV_POINT_FLAG VARCHAR2 (1)
Planned inventory point enabled
LOT_TRANSLATE_ENABLED VARCHAR2 (1)
Lot Translate Enabled
DEFAULT_SO_SOURCE_TYPE VARCHAR2 (30)
Default Sales Order Source Type
CREATE_SUPPLY_FLAG VARCHAR2 (1)
Create Supply Flag
SUBSTITUTION_WINDOW_CODE NUMBER

Substitution Window
SUBSTITUTION_WINDOW_DAYS NUMBER

Substitution Window Days
IB_ITEM_INSTANCE_CLASS VARCHAR2 (30)
Installed Base Item Instance Classification
CONFIG_MODEL_TYPE VARCHAR2 (30)
Configurator Model Type
LOT_SUBSTITUTION_ENABLED VARCHAR2 (1)
Lot Substitution Enabled for 11.5.9
MINIMUM_LICENSE_QUANTITY NUMBER

Minimum License Quantity for 11.5.9
EAM_ACTIVITY_SOURCE_CODE VARCHAR2 (30)
Activity Source for 11.5.9
LIFECYCLE_ID NUMBER

Lifecycle
CURRENT_PHASE_ID NUMBER

Current Lifecycle Phase
OBJECT_VERSION_NUMBER NUMBER (9)
Object version number tracks row updates
TRACKING_QUANTITY_IND VARCHAR2 (30)
Catch-Weight Support for 11.5.10
ONT_PRICING_QTY_SOURCE VARCHAR2 (30)
Catch-Weight Support for 11.5.10
SECONDARY_DEFAULT_IND VARCHAR2 (30)
Catch-Weight Support for 11.5.10
OPTION_SPECIFIC_SOURCED NUMBER

CTO changes for 11.5.10
APPROVAL_STATUS VARCHAR2 (30)
11.5.10 added for PLM it will be used in Part Number Request
VMI_MINIMUM_UNITS NUMBER

Minimum quantity in units
VMI_MINIMUM_DAYS NUMBER

Minimum quantity in days
VMI_MAXIMUM_UNITS NUMBER

Maximum quantity in units
VMI_MAXIMUM_DAYS NUMBER

Maximum quantity in days
VMI_FIXED_ORDER_QUANTITY NUMBER

Fixed order quantity in units
SO_AUTHORIZATION_FLAG NUMBER

SO release authorization flag: 1 - authorization by customer required, 2 - authorization not required (default),
CONSIGNED_FLAG NUMBER

Consigned flag: 1 - consigned, 2 - unconsigned (default)
ASN_AUTOEXPIRE_FLAG NUMBER

Auto-expiring ASN flag: 1 - ASN auto-expired (default), 2 - ASN not auto-expired
VMI_FORECAST_TYPE NUMBER

Forecast type for average daily demand calculation: 1 - order forecast (default), 2 - sales forecast, 3 - historical sales
FORECAST_HORIZON NUMBER

Forecast horizon for average daily demand calculati
EXCLUDE_FROM_BUDGET_FLAG NUMBER

1- Yes2- No (Default)
DAYS_TGT_INV_SUPPLY NUMBER

Target Inventory Level Days of Supply
DAYS_TGT_INV_WINDOW NUMBER

Target Inventory Level Calculation Window
DAYS_MAX_INV_SUPPLY NUMBER

Maximum Inventory Level Days of Supply
DAYS_MAX_INV_WINDOW NUMBER

Maximum Inventory Level Calculation Window
DRP_PLANNED_FLAG NUMBER

Distribution Planned
CRITICAL_COMPONENT_FLAG NUMBER

Critical Component flag
CONTINOUS_TRANSFER NUMBER

Continuous Inter Organization transfers1. Yes2. No3. Use Global Value (default)
CONVERGENCE NUMBER

Convergent Supply Consumption Pattern1. Series2. Parallel3. Use Global Value (default)
DIVERGENCE NUMBER

Divergent Supply Feeding Pattern1. Series2. Series with MTQ3. Use Global Value (default)
CONFIG_ORGS VARCHAR2 (30)
CTO 11.5.10 Enahncement
CONFIG_MATCH VARCHAR2 (30)
CTO 11.5.10 ENH
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
DESCRIPTION VARCHAR2 (240)
Description
LONG_DESCRIPTION VARCHAR2 (4000)
long Description
CONCATENATED_SEGMENTS VARCHAR2 (40)
Concatenated Segments
PADDED_CONCATENATED_SEGMENTS VARCHAR2 (40)
Padded Concatenated Segments
ATTRIBUTE16 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE17 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE18 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE19 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE20 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE21 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE22 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE23 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE24 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE25 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE26 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE27 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE28 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE29 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE30 VARCHAR2 (240)
Descriptive flexfield segment
CAS_NUMBER VARCHAR2 (30)
Chemical abstracts service registry number
CHILD_LOT_FLAG VARCHAR2 (1)
Whether a child lot can be created for items
CHILD_LOT_PREFIX VARCHAR2 (30)
Item-level prefix for child lot numbers
CHILD_LOT_STARTING_NUMBER NUMBER

Next auto assigned child lot number
CHILD_LOT_VALIDATION_FLAG VARCHAR2 (1)
Ensure that the child lot number conforms to the parameters defined for the item/organization
COPY_LOT_ATTRIBUTE_FLAG VARCHAR2 (1)
If it is set to yes, a new child lot will inherit all attributes from the parent lot. If set to no, the lot attributes for a new child lot will not inherit the parent lot attributes and will default to values similar to a new lot.
DEFAULT_GRADE VARCHAR2 (150)
Default Grade assigned to a newly created lot
EXPIRATION_ACTION_CODE VARCHAR2 (32)
Identifier code for action to take when a lot expires
EXPIRATION_ACTION_INTERVAL NUMBER

Interval between the time lot expires and the time expiration action should be taken
GRADE_CONTROL_FLAG VARCHAR2 (1)
Whether the item is grade controlled
HAZARDOUS_MATERIAL_FLAG VARCHAR2 (1)
Flag indicating item is hazardous
HOLD_DAYS NUMBER

Number of hold days
LOT_DIVISIBLE_FLAG VARCHAR2 (1)
Whether or not a lot may be transacted against for a quantity less than total onhand for lot
MATURITY_DAYS NUMBER

Days to maturity
PARENT_CHILD_GENERATION_FLAG VARCHAR2 (1)
Generation method for child lot numbers
PROCESS_COSTING_ENABLED_FLAG VARCHAR2 (1)
Flag indicating cost information may be maintained in OPM (Oracle Process Manufacturing)
PROCESS_EXECUTION_ENABLED_FLAG VARCHAR2 (1)
Flag indicating item may be used in OPM (Oracle Process Manufacturing) Process Excecution
PROCESS_QUALITY_ENABLED_FLAG VARCHAR2 (1)
Flag indicating item may be used in OPM (Oracle Process Manufacturing) Process Quality
PROCESS_SUPPLY_LOCATOR_ID NUMBER

Default supply locator for process execution transactions
PROCESS_SUPPLY_SUBINVENTORY VARCHAR2 (10)
Default supply subinventory for process execution transactions
PROCESS_YIELD_LOCATOR_ID NUMBER

Default yield locator for process execution transactions
PROCESS_YIELD_SUBINVENTORY VARCHAR2 (10)
Default yield subinventory for process execution transactions
RECIPE_ENABLED_FLAG VARCHAR2 (1)
Flag indicating item may appear on a Recipe in OPM (Oracle Process Manufacturing) Process
RETEST_INTERVAL NUMBER

Number of days specifying how often lot controlled items should be retested
CHARGE_PERIODICITY_CODE VARCHAR2 (3)
The time unit by which a persistent or recurring service or product is priced at ordering/quoting time
REPAIR_LEADTIME NUMBER

Time to repair the part at the supplier site
REPAIR_YIELD NUMBER

Yield when a defective part is repaired/upgraded to a new part
PREPOSITION_POINT VARCHAR2 (1)
The Pre-positioning Point represents the Push type of relationship with the trading partner.
REPAIR_PROGRAM NUMBER

Defines the relationship with the vendor for the repair item
SUBCONTRACTING_COMPONENT NUMBER

Indicates whether the sub-contracting type associated to this item when it is used as a sub-contracting component in charge based SHIKYU
OUTSOURCED_ASSEMBLY NUMBER

Identifies whether an item is Outsourced Assembly item or not
OPERATING_UNIT_NAME VARCHAR2 (240) Yes Operating Unit Name
OPERATING_UNIT_ID NUMBER (15) Yes Operating Unit Id
MASTER_ORGANIZATION_ID NUMBER
Yes Master organization id
ORGANIZATION_CODE VARCHAR2 (3)
Organization Code
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      PRIMARY_UOM_CODE
,      PRIMARY_UNIT_OF_MEASURE
,      ITEM_TYPE
,      INVENTORY_ITEM_STATUS_CODE
,      ALLOWED_UNITS_LOOKUP_CODE
,      ITEM_CATALOG_GROUP_ID
,      CATALOG_STATUS_FLAG
,      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_ENABLED_FLAG
,      BOM_ITEM_TYPE
,      BASE_ITEM_ID
,      EFFECTIVITY_CONTROL
,      ENG_ITEM_FLAG
,      ENGINEERING_ECN_CODE
,      ENGINEERING_ITEM_ID
,      ENGINEERING_DATE
,      PRODUCT_FAMILY_ITEM_ID
,      AUTO_CREATED_CONFIG_FLAG
,      MODEL_CONFIG_CLAUSE_NAME
,      NEW_REVISION_CODE
,      COSTING_ENABLED_FLAG
,      INVENTORY_ASSET_FLAG
,      DEFAULT_INCLUDE_IN_ROLLUP_FLAG
,      COST_OF_SALES_ACCOUNT
,      STD_LOT_SIZE
,      PURCHASING_ITEM_FLAG
,      PURCHASING_ENABLED_FLAG
,      MUST_USE_APPROVED_VENDOR_FLAG
,      ALLOW_ITEM_DESC_UPDATE_FLAG
,      RFQ_REQUIRED_FLAG
,      OUTSIDE_OPERATION_FLAG
,      OUTSIDE_OPERATION_UOM_TYPE
,      TAXABLE_FLAG
,      PURCHASING_TAX_CODE
,      RECEIPT_REQUIRED_FLAG
,      INSPECTION_REQUIRED_FLAG
,      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
,      ENCUMBRANCE_ACCOUNT
,      EXPENSE_ACCOUNT
,      ASSET_CATEGORY_ID
,      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
,      SALES_ACCOUNT
,      PAYMENT_TERMS_ID
,      SERVICE_ITEM_FLAG
,      VENDOR_WARRANTY_FLAG
,      COVERAGE_SCHEDULE_ID
,      SERVICE_DURATION
,      SERVICE_DURATION_PERIOD_CODE
,      SERVICEABLE_PRODUCT_FLAG
,      SERVICE_STARTING_DELAY
,      MATERIAL_BILLABLE_FLAG
,      TIME_BILLABLE_FLAG
,      EXPENSE_BILLABLE_FLAG
,      SERVICEABLE_COMPONENT_FLAG
,      PREVENTIVE_MAINTENANCE_FLAG
,      PRORATE_SERVICE_FLAG
,      SERVICEABLE_ITEM_CLASS_ID
,      BASE_WARRANTY_SERVICE_ID
,      WARRANTY_VENDOR_ID
,      MAX_WARRANTY_AMOUNT
,      RESPONSE_TIME_PERIOD_CODE
,      RESPONSE_TIME_VALUE
,      PRIMARY_SPECIALIST_ID
,      SECONDARY_SPECIALIST_ID
,      WH_UPDATE_DATE
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      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
,      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
,      USAGE_ITEM_FLAG
,      EVENT_FLAG
,      ELECTRONIC_FLAG
,      DOWNLOADABLE_FLAG
,      VOL_DISCOUNT_EXEMPT_FLAG
,      COUPON_EXEMPT_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
,      SUBSCRIPTION_DEPEND_FLAG
,      SERV_REQ_ENABLED_CODE
,      SERV_BILLING_ENABLED_FLAG
,      SERV_IMPORTANCE_LEVEL
,      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
,      LIFECYCLE_ID
,      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
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      DESCRIPTION
,      LONG_DESCRIPTION
,      CONCATENATED_SEGMENTS
,      PADDED_CONCATENATED_SEGMENTS
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      CAS_NUMBER
,      CHILD_LOT_FLAG
,      CHILD_LOT_PREFIX
,      CHILD_LOT_STARTING_NUMBER
,      CHILD_LOT_VALIDATION_FLAG
,      COPY_LOT_ATTRIBUTE_FLAG
,      DEFAULT_GRADE
,      EXPIRATION_ACTION_CODE
,      EXPIRATION_ACTION_INTERVAL
,      GRADE_CONTROL_FLAG
,      HAZARDOUS_MATERIAL_FLAG
,      HOLD_DAYS
,      LOT_DIVISIBLE_FLAG
,      MATURITY_DAYS
,      PARENT_CHILD_GENERATION_FLAG
,      PROCESS_COSTING_ENABLED_FLAG
,      PROCESS_EXECUTION_ENABLED_FLAG
,      PROCESS_QUALITY_ENABLED_FLAG
,      PROCESS_SUPPLY_LOCATOR_ID
,      PROCESS_SUPPLY_SUBINVENTORY
,      PROCESS_YIELD_LOCATOR_ID
,      PROCESS_YIELD_SUBINVENTORY
,      RECIPE_ENABLED_FLAG
,      RETEST_INTERVAL
,      CHARGE_PERIODICITY_CODE
,      REPAIR_LEADTIME
,      REPAIR_YIELD
,      PREPOSITION_POINT
,      REPAIR_PROGRAM
,      SUBCONTRACTING_COMPONENT
,      OUTSOURCED_ASSEMBLY
,      OPERATING_UNIT_NAME
,      OPERATING_UNIT_ID
,      MASTER_ORGANIZATION_ID
,      ORGANIZATION_CODE
FROM APPS.EGO_ITEM_SYNC_V;

Dependencies

[top of page]

APPS.EGO_ITEM_SYNC_V references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymHR_ORGANIZATION_INFORMATION
SynonymMTL_PARAMETERS
ViewMTL_SYSTEM_ITEMS_B_KFV
SynonymMTL_SYSTEM_ITEMS_TL

APPS.EGO_ITEM_SYNC_V is not referenced by any database object