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


VIEW: APPS.BOM_INVENTORY_COMPONENTS_ERV

Object Details
Object Name: BOM_INVENTORY_COMPONENTS_ERV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.BOM_INVENTORY_COMPONENTS_ERV
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identifier
OPERATION_SEQ_NUM NUMBER
Yes Sequence number of the operation
COMPONENT_ITEM_ID NUMBER

COmponent item id
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER
Yes Standard WHO column
CREATION_DATE DATE
Yes Standard WHO column
CREATED_BY NUMBER
Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column
ITEM_NUM NUMBER

Item number
COMPONENT_QUANTITY NUMBER
Yes Component quantity
COMPONENT_YIELD_FACTOR NUMBER
Yes Component yield factor
COMPONENT_REMARKS VARCHAR2 (240)
Component remarks
EFFECTIVITY_DATE DATE
Yes Effective date
FROM_END_ITEM_UNIT_NUMBER VARCHAR2 (30)
From end item unit number
TO_END_ITEM_UNIT_NUMBER VARCHAR2 (30)
To end item unit number
CHANGE_NOTICE VARCHAR2 (10)
Engineering change notice
IMPLEMENTATION_DATE DATE

Implementation date
IMPL_CB NUMBER

DISABLE_DATE DATE

Disable date
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Flex structure defining columns
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
PLANNING_FACTOR NUMBER
Yes Planning factor
QUANTITY_RELATED NUMBER
Yes Related quantity
SO_BASIS NUMBER

QUantity basis used by Oracle Order Mgmt to determine how many units of components to put on an order
OPTIONAL NUMBER

indicating if quantity is optional in bill
MUTUALLY_EXCLUSIVE_OPTIONS NUMBER

Flag indicating if one or more children of component can be picked up when taking an order
INCLUDE_IN_COST_ROLLUP NUMBER
Yes Flag indicating if component is to be used when rolling up cost
CHECK_ATP NUMBER
Yes Flag indicating if ATP check is required
SHIPPING_ALLOWED NUMBER

Flag indicating if component is allowed to be shipped
REQUIRED_TO_SHIP NUMBER

Flag indicating if component is required to be shipped
REQUIRED_FOR_REVENUE NUMBER

Flag indicatinf if component s required for revenue
INCLUDE_ON_SHIP_DOCS NUMBER

Flag indicating if component is required for shipping documents
INCLUDE_ON_BILL_DOCS NUMBER

not used
LOW_QUANTITY NUMBER

Minimum quantity allowed on an order
HIGH_QUANTITY NUMBER

Maximum quantity allowed on an order
ACD_TYPE NUMBER

ACD type
OLD_COMPONENT_SEQUENCE_ID NUMBER

Sequnce id of original component record in ECO
COMPONENT_SEQUENCE_ID NUMBER
Yes Sequence id of the component
BILL_SEQUENCE_ID NUMBER
Yes Sequence id of the BILL
REQUEST_ID NUMBER

Concurrent WHO columns
PROGRAM_APPLICATION_ID NUMBER

Concurrent WHO columns
PROGRAM_ID NUMBER

Concurrent WHO columns
PROGRAM_UPDATE_DATE DATE

Concurrent WHO columns
WIP_SUPPLY_TYPE NUMBER

Work in process supply type
SUPPLY_TYPE VARCHAR2 (80)
Supply type
PICK_COMPONENTS NUMBER

not used
SUPPLY_SUBINVENTORY VARCHAR2 (10)
Supplu subinventory
SUPPLY_LOCATOR_ID NUMBER

Supply locator type
SUPPLY_LOCATOR CHAR (1)
Supply locator
OPERATION_LEAD_TIME_PERCENT NUMBER

Operation lead time percentage
REVISED_ITEM_SEQUENCE_ID NUMBER

Revised item sequence id
COST_FACTOR NUMBER

not used
BOM_ITEM_TYPE NUMBER

BOM item type
PRIMARY_UOM_CODE VARCHAR2 (3)
Primary unit of measure
DESCRIPTION VARCHAR2 (240)
Description
ENG_ITEM_FLAG VARCHAR2 (1) Yes Flag indicating if the item is an engineering item
INVENTORY_ITEM_STATUS_CODE VARCHAR2 (10) Yes Status code of the item
SHIPPABLE_ITEM_FLAG VARCHAR2 (1) Yes Flag indicating if the item is shippable
ITEM_LOCATOR_CONTROL NUMBER

Item locator control
RESTRICT_LOCATORS_FLAG NUMBER

Restrict locators flag
RESTRICT_SUBINVENTORIES_FLAG VARCHAR2 (1)
Restrict subinventories flag
ITEM_TYPE VARCHAR2 (80)
Item type
REPLENISH_TO_ORDER_FLAG VARCHAR2 (1) Yes Replenish to order flag
ATP_COMPONENTS_FLAG VARCHAR2 (1) Yes ATP components flag
PICK_COMPONENTS_FLAG VARCHAR2 (1) Yes Pick components flag
INVENTORY_ASSET_FLAG VARCHAR2 (1) Yes Inventory assets flag
ATP_FLAG VARCHAR2 (1) Yes ATP flag
FORECAST_CONTROL NUMBER

Forecast control
DISABLE_CB NUMBER

ECO_FOR_PRODUCTION NUMBER

Engineering change ordre for production
ENFORCE_INT_REQUIREMENTS NUMBER

Enforce initial requirements
ENFORCE_INT_REQUIREMENTS_DESC VARCHAR2 (80)
Enforce initial requirements description
AUTO_REQUEST_MATERIAL VARCHAR2 (1)
Auto request material
EFFECTIVITY_CONTROL NUMBER

Effectivity control
CURRENT_REVISION VARCHAR2 (3)
Current revision
COMPONENT_ITEM_NAME VARCHAR2 (40)
Component item name
Query Text

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


SELECT ROW_ID
,      OPERATION_SEQ_NUM
,      COMPONENT_ITEM_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ITEM_NUM
,      COMPONENT_QUANTITY
,      COMPONENT_YIELD_FACTOR
,      COMPONENT_REMARKS
,      EFFECTIVITY_DATE
,      FROM_END_ITEM_UNIT_NUMBER
,      TO_END_ITEM_UNIT_NUMBER
,      CHANGE_NOTICE
,      IMPLEMENTATION_DATE
,      IMPL_CB
,      DISABLE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PLANNING_FACTOR
,      QUANTITY_RELATED
,      SO_BASIS
,      OPTIONAL
,      MUTUALLY_EXCLUSIVE_OPTIONS
,      INCLUDE_IN_COST_ROLLUP
,      CHECK_ATP
,      SHIPPING_ALLOWED
,      REQUIRED_TO_SHIP
,      REQUIRED_FOR_REVENUE
,      INCLUDE_ON_SHIP_DOCS
,      INCLUDE_ON_BILL_DOCS
,      LOW_QUANTITY
,      HIGH_QUANTITY
,      ACD_TYPE
,      OLD_COMPONENT_SEQUENCE_ID
,      COMPONENT_SEQUENCE_ID
,      BILL_SEQUENCE_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      WIP_SUPPLY_TYPE
,      SUPPLY_TYPE
,      PICK_COMPONENTS
,      SUPPLY_SUBINVENTORY
,      SUPPLY_LOCATOR_ID
,      SUPPLY_LOCATOR
,      OPERATION_LEAD_TIME_PERCENT
,      REVISED_ITEM_SEQUENCE_ID
,      COST_FACTOR
,      BOM_ITEM_TYPE
,      PRIMARY_UOM_CODE
,      DESCRIPTION
,      ENG_ITEM_FLAG
,      INVENTORY_ITEM_STATUS_CODE
,      SHIPPABLE_ITEM_FLAG
,      ITEM_LOCATOR_CONTROL
,      RESTRICT_LOCATORS_FLAG
,      RESTRICT_SUBINVENTORIES_FLAG
,      ITEM_TYPE
,      REPLENISH_TO_ORDER_FLAG
,      ATP_COMPONENTS_FLAG
,      PICK_COMPONENTS_FLAG
,      INVENTORY_ASSET_FLAG
,      ATP_FLAG
,      FORECAST_CONTROL
,      DISABLE_CB
,      ECO_FOR_PRODUCTION
,      ENFORCE_INT_REQUIREMENTS
,      ENFORCE_INT_REQUIREMENTS_DESC
,      AUTO_REQUEST_MATERIAL
,      EFFECTIVITY_CONTROL
,      CURRENT_REVISION
,      COMPONENT_ITEM_NAME
FROM APPS.BOM_INVENTORY_COMPONENTS_ERV;

Dependencies

[top of page]

APPS.BOM_INVENTORY_COMPONENTS_ERV references the following:

SchemaAPPS
ViewBOM_BILL_OF_MATERIALS
ViewBOM_INVENTORY_COMPONENTS
ViewFND_COMMON_LOOKUPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewMFG_LOOKUPS
ViewMTL_ITEM_LOCATIONS_KFV
SynonymMTL_ITEM_REVISIONS
SynonymMTL_ITEM_REVISIONS_B
ViewMTL_SYSTEM_ITEMS_B_KFV
SynonymMTL_SYSTEM_ITEMS_TL

APPS.BOM_INVENTORY_COMPONENTS_ERV is not referenced by any database object