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

VIEW: APPS.ENG_COMPONENT_VIEW

Object Details
Object Name: ENG_COMPONENT_VIEW
Object Type: VIEW
Owner: APPS
FND Design Data: ViewENG.ENG_COMPONENT_VIEW
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
COMPONENT_SEQUENCE_ID NUMBER

Component unique identifier
COMPONENT_ITEM_ID NUMBER

Component item identifier
BILL_SEQUENCE_ID NUMBER

Bill of material unique identifier
CHANGE_NOTICE VARCHAR2 (10)
Engineering change order number
EFFECTIVITY_DATE DATE

Effective date
COMPONENT_QUANTITY NUMBER

Quantity of component in bill of material
COMPONENT_YIELD_FACTOR NUMBER

Factor used to multiply component quantity with to obtain component quantity
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
CANCELLATION_DATE DATE

Date that revised component was cancelled
CANCEL_COMMENTS VARCHAR2 (240)
Cancellation comments
OLD_COMPONENT_SEQUENCE_ID NUMBER

Identifier of original component row an ECO affects
ITEM_NUM NUMBER

Item sequence within bill of material structure
WIP_SUPPLY_TYPE NUMBER

WIP supply type code
COMPONENT_REMARKS VARCHAR2 (240)
Component comments
IMPLEMENTATION_DATE DATE

Date on which engineering change order was implemented
DISABLE_DATE DATE

Disable date
ACD_TYPE NUMBER

Add, change or disable code for component on an engineering change order
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

Flag indicating if component is included on billing documents
LOW_QUANTITY NUMBER

Minimum quantity allowed on an order
HIGH_QUANTITY NUMBER

Maximum quantity allowed on an order
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
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
PICK_COMPONENTS NUMBER

(not currently used)
OPERATION_SEQ_NUM NUMBER

Operation sequence number
SUPPLY_SUBINVENTORY VARCHAR2 (10)
Supply subinventory
SUPPLY_LOCATOR_ID NUMBER

Supply locator identifier x
REVISED_ITEM_SEQUENCE_ID NUMBER

Engineering change order revised item identifier
COST_FACTOR NUMBER

(not currently used)
Query Text

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


SELECT COMPONENT_SEQUENCE_ID
,      COMPONENT_ITEM_ID
,      BILL_SEQUENCE_ID
,      CHANGE_NOTICE
,      EFFECTIVITY_DATE
,      COMPONENT_QUANTITY
,      COMPONENT_YIELD_FACTOR
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CANCELLATION_DATE
,      CANCEL_COMMENTS
,      OLD_COMPONENT_SEQUENCE_ID
,      ITEM_NUM
,      WIP_SUPPLY_TYPE
,      COMPONENT_REMARKS
,      IMPLEMENTATION_DATE
,      DISABLE_DATE
,      ACD_TYPE
,      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
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PICK_COMPONENTS
,      OPERATION_SEQ_NUM
,      SUPPLY_SUBINVENTORY
,      SUPPLY_LOCATOR_ID
,      REVISED_ITEM_SEQUENCE_ID
,      COST_FACTOR
FROM APPS.ENG_COMPONENT_VIEW;

Dependencies

[top of page]

APPS.ENG_COMPONENT_VIEW references the following:

SchemaAPPS
ViewBOM_INVENTORY_COMPONENTS
SynonymENG_REVISED_COMPONENTS

APPS.ENG_COMPONENT_VIEW is not referenced by any database object