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

VIEW: APPS.BOM_INV_COMPS_INTERFACE_ERV

Object Details
Object Name: BOM_INV_COMPS_INTERFACE_ERV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.BOM_INV_COMPS_INTERFACE_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)
Rowid from table BOM_INVENTORY_COMPS_INTERFACE
OPERATION_SEQ_NUM NUMBER

Operation sequence number
COMPONENT_ITEM_ID NUMBER

Component item identifier
COMPONENT_ITEM_NUMBER VARCHAR2 (40)
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
ITEM_NUM NUMBER

Item sequence within bill of material structure
COMPONENT_QUANTITY NUMBER

Quantity of component in bill of material
COMPONENT_YIELD_FACTOR NUMBER

Factor used to multiply component quantity to obtain component quantity
DISABLE_DATE DATE

Disable date
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
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

Factor used to multiply component quantity with to obtain planning quantity
QUANTITY_RELATED NUMBER

Identifier to indicate if this component has quantity related reference designators
SO_BASIS NUMBER

Quantity basis used by Oracle Order Entry to determine how many units of component to put on an order
OPTIONAL NUMBER

Flag indicating if component is optional in bill
MUTUALLY_EXCLUSIVE_OPTIONS NUMBER

Flag indicating if one or more children of component can be picked when taking an order
INCLUDE_IN_COST_ROLLUP NUMBER

Flag indicating if this component is to be used when rolling up costs
CHECK_ATP NUMBER

Flag indicating if ATP check is required
SHIPPING_ALLOWED NUMBER

Flag indicating if component is allowed to ship
REQUIRED_TO_SHIP NUMBER

Flag indicating if component is required to ship
REQUIRED_FOR_REVENUE NUMBER

Flag indicating if component is required for revenue
INCLUDE_ON_SHIP_DOCS NUMBER

Flag indicating if component is displayed on shipping documents
INCLUDE_ON_BILL_DOCS NUMBER

(not currently used)
LOW_QUANTITY NUMBER

Minimum quantity allowed on an order
HIGH_QUANTITY NUMBER

Maximum quantity allowed on an order
ACD_TYPE NUMBER

Add, change or disable code for component on an engineering change order
OLD_COMPONENT_SEQUENCE_ID NUMBER

Identifier of original component row that an ECO affects
COMPONENT_SEQUENCE_ID NUMBER

Component unique identifier
REQUEST_ID NUMBER

Concurrent Who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who column
PROGRAM_ID NUMBER

Concurrent Who column
PROGRAM_UPDATE_DATE DATE

Concurrent Who column
WIP_SUPPLY_TYPE NUMBER

WIP supply type code
SUPPLY_SUBINVENTORY VARCHAR2 (10)
Supply subinventory
SUPPLY_LOCATOR_ID NUMBER

Supply locator identifier
REVISED_ITEM_SEQUENCE_ID NUMBER

Engineering change order revised item identifier
COST_FACTOR NUMBER

(not currently used)
DDF_CONTEXT1 VARCHAR2 (30)
used by Mass Change
DDF_CONTEXT2 VARCHAR2 (30)
used by Mass Change
DESCRIPTION VARCHAR2 (240)
Item description
PRIMARY_UOM_CODE VARCHAR2 (3)
Primary unit of measure code
BOM_ITEM_TYPE NUMBER
Yes Type of item
ATP_COMPONENTS_FLAG VARCHAR2 (1) Yes Flag indicating whether item may have components requiring ATP check
REPLENISH_TO_ORDER_FLAG VARCHAR2 (1) Yes Assemble to Order flag
DEFAULT_SHIPPABLE NUMBER

Default shippable flag from table MTL_SYSTEM_ITEMS
DEFAULT_COST_ROLLUP NUMBER

Default Include in Cost Rollup flag from table MTL_SYSTEM_ITEMS
DEFAULT_WIP_SUPPLY_TYPE NUMBER

Default supply type from table MTL_SYSTEM_ITEMS
DEFAULT_SUPPLY_LOCATOR_ID NUMBER

Supply locator for WIP transactions
DEFAULT_SUPPLY_SUBINVENTORY VARCHAR2 (10)
Supply subinventory for WIP transactions
DEFAULT_CHECK_ATP NUMBER

Default Available to Promise flag from table MTL_SYSTEM_ITEMS
ITEM_LOCATOR_CONTROL NUMBER

Used to control supply locator flexfield
RESTRICT_LOCATORS_FLAG VARCHAR2 (1)
Used to control Supply Locator flexfield
RESTRICT_SUBINVENTORIES_FLAG VARCHAR2 (1)
Used to control Subinventory LOV
INVENTORY_ASSET_FLAG VARCHAR2 (1) Yes Flag indicating item is an inventory asset
SHIPPABLE_ITEM_FLAG VARCHAR2 (1) Yes Flag indicating shippable item
REVISION VARCHAR2 (3) Yes Current item revision of component
ITEM_TYPE_NAME VARCHAR2 (80)
QuickCode meaning
ACD_TYPE_NAME VARCHAR2 (80) Yes Meaning of Add, Change or Disable code
SUPPLY_TYPE VARCHAR2 (80)
Meaning of Supply Type code
TO_END_ITEM_UNIT_NUMBER VARCHAR2 (30)
To End Item Unit Number
LOCATOR CHAR (1)
Locator
Query Text

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


SELECT ROW_ID
,      OPERATION_SEQ_NUM
,      COMPONENT_ITEM_ID
,      COMPONENT_ITEM_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ITEM_NUM
,      COMPONENT_QUANTITY
,      COMPONENT_YIELD_FACTOR
,      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
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      WIP_SUPPLY_TYPE
,      SUPPLY_SUBINVENTORY
,      SUPPLY_LOCATOR_ID
,      REVISED_ITEM_SEQUENCE_ID
,      COST_FACTOR
,      DDF_CONTEXT1
,      DDF_CONTEXT2
,      DESCRIPTION
,      PRIMARY_UOM_CODE
,      BOM_ITEM_TYPE
,      ATP_COMPONENTS_FLAG
,      REPLENISH_TO_ORDER_FLAG
,      DEFAULT_SHIPPABLE
,      DEFAULT_COST_ROLLUP
,      DEFAULT_WIP_SUPPLY_TYPE
,      DEFAULT_SUPPLY_LOCATOR_ID
,      DEFAULT_SUPPLY_SUBINVENTORY
,      DEFAULT_CHECK_ATP
,      ITEM_LOCATOR_CONTROL
,      RESTRICT_LOCATORS_FLAG
,      RESTRICT_SUBINVENTORIES_FLAG
,      INVENTORY_ASSET_FLAG
,      SHIPPABLE_ITEM_FLAG
,      REVISION
,      ITEM_TYPE_NAME
,      ACD_TYPE_NAME
,      SUPPLY_TYPE
,      TO_END_ITEM_UNIT_NUMBER
,      LOCATOR
FROM APPS.BOM_INV_COMPS_INTERFACE_ERV;

Dependencies

[top of page]

APPS.BOM_INV_COMPS_INTERFACE_ERV references the following:

SchemaAPPS
SynonymBOM_INVENTORY_COMPS_INTERFACE
ViewBOM_ITEM_CURRENT_REV_VIEW
SynonymENG_REVISED_ITEMS_INTERFACE
ViewFND_COMMON_LOOKUPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewMFG_LOOKUPS
ViewMTL_ITEM_LOCATIONS_KFV
SynonymMTL_SYSTEM_ITEMS_KFV

APPS.BOM_INV_COMPS_INTERFACE_ERV is not referenced by any database object