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


VIEW: APPS.ENG_REVISED_COMPONENTS_ERV

Object Details
Object Name: ENG_REVISED_COMPONENTS_ERV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewENG.ENG_REVISED_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
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
OLD_COMPONENT_SEQUENCE_ID NUMBER

Identifier of component that is being disabled or changed
ITEM_NUM NUMBER

Item sequence within bill of material structure
WIP_SUPPLY_TYPE NUMBER

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

Date on which engineering change order was implemented
IMPL_CB NUMBER

Flag indicating if component is implemented
DISABLE_DATE DATE

Disable date
ACD_TYPE NUMBER

Code indicating that component is being added, changed, or disabled
PLANNING_FACTOR NUMBER

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

Code 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
SUPPLY_LOCATOR CHAR (1)
REVISED_ITEM_SEQUENCE_ID NUMBER

Engineering change order revised item identifier
COST_FACTOR NUMBER

(not currently used)
CANCELLATION_DATE DATE

Date when the ECO, revised item, or revised component was cancelled
CANCEL_COMMENTS VARCHAR2 (240)
Cancellation comments
BOM_ITEM_TYPE NUMBER

Type of item
PRIMARY_UOM_CODE VARCHAR2 (3)
Primary unit of measure code
COMPONENT_ITEM_NO VARCHAR2 (40)
COMPONENT_ITEM_DESC VARCHAR2 (240)
ENG_ITEM_FLAG VARCHAR2 (1)
Flag indicating engineering item
INVENTORY_ITEM_STATUS_CODE VARCHAR2 (10)
Material status code
SHIPPABLE_ITEM_FLAG VARCHAR2 (1)
Flag indicating shippable item
ITEM_LOCATOR_CONTROL NUMBER

Stock locator control code
RESTRICT_LOCATORS_FLAG NUMBER

Locators restrictions type
RESTRICT_SUBINVENTORIES_FLAG VARCHAR2 (1)
Subinventory restrictions type
BASE_ITEM_ID NUMBER

Base item identifier
ITEM_TYPE VARCHAR2 (80)
QuickCode meaning
REPLENISH_TO_ORDER_FLAG VARCHAR2 (1)
Assemble to Order flag
ATP_COMPONENTS_FLAG VARCHAR2 (1)
Flag indicating whether item may have components requiring ATP check
PICK_COMPONENTS_FLAG VARCHAR2 (1)
Flag indicating all shippable components of should be picked
INVENTORY_ASSET_FLAG VARCHAR2 (1)
Flag indicating item is an inventory asset
ATP_FLAG VARCHAR2 (1)
Flag indicating ATP must be checked when item is ordered
FORECAST_CONTROL NUMBER

Type of forecast control for ATO
FROM_END_ITEM_UNIT_NUMBER VARCHAR2 (30)
From End Item Unit Number
TO_END_ITEM_UNIT_NUMBER VARCHAR2 (30)
To End Item Unit Number
ECO_FOR_PRODUCTION NUMBER

WIP Only ECO
ENFORCE_INT_REQUIREMENTS NUMBER

Enforce Integer Requirements
ENFORCE_INT_REQUIREMENTS_DESC VARCHAR2 (80)
Enforce Integer Requirements Description
ORIGINAL_SYSTEM_REFERENCE VARCHAR2 (50)
ORIGINAL_SYSTEM_REFERENCE
OLD_OPERATION_SEQ_NUM NUMBER

Old component sequence number
OLD_COMPONENT_QUANTITY NUMBER

Old component quantity
COMPONENT_ITEM_REVISION VARCHAR2 (3)
Component item revision
Query Text

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


SELECT ROW_ID
,      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
,      OLD_COMPONENT_SEQUENCE_ID
,      ITEM_NUM
,      WIP_SUPPLY_TYPE
,      SUPPLY_TYPE
,      COMPONENT_REMARKS
,      IMPLEMENTATION_DATE
,      IMPL_CB
,      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
,      SUPPLY_LOCATOR
,      REVISED_ITEM_SEQUENCE_ID
,      COST_FACTOR
,      CANCELLATION_DATE
,      CANCEL_COMMENTS
,      BOM_ITEM_TYPE
,      PRIMARY_UOM_CODE
,      COMPONENT_ITEM_NO
,      COMPONENT_ITEM_DESC
,      ENG_ITEM_FLAG
,      INVENTORY_ITEM_STATUS_CODE
,      SHIPPABLE_ITEM_FLAG
,      ITEM_LOCATOR_CONTROL
,      RESTRICT_LOCATORS_FLAG
,      RESTRICT_SUBINVENTORIES_FLAG
,      BASE_ITEM_ID
,      ITEM_TYPE
,      REPLENISH_TO_ORDER_FLAG
,      ATP_COMPONENTS_FLAG
,      PICK_COMPONENTS_FLAG
,      INVENTORY_ASSET_FLAG
,      ATP_FLAG
,      FORECAST_CONTROL
,      FROM_END_ITEM_UNIT_NUMBER
,      TO_END_ITEM_UNIT_NUMBER
,      ECO_FOR_PRODUCTION
,      ENFORCE_INT_REQUIREMENTS
,      ENFORCE_INT_REQUIREMENTS_DESC
,      ORIGINAL_SYSTEM_REFERENCE
,      OLD_OPERATION_SEQ_NUM
,      OLD_COMPONENT_QUANTITY
,      COMPONENT_ITEM_REVISION
FROM APPS.ENG_REVISED_COMPONENTS_ERV;

Dependencies

[top of page]

APPS.ENG_REVISED_COMPONENTS_ERV references the following:

SchemaAPPS
ViewBOM_BILL_OF_MATERIALS
ViewBOM_INVENTORY_COMPONENTS
SynonymENG_REVISED_COMPONENTS
SynonymENG_REVISED_ITEMS
ViewFND_COMMON_LOOKUPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewMFG_LOOKUPS
ViewMTL_ITEM_LOCATIONS_KFV
SynonymMTL_ITEM_REVISIONS
ViewMTL_SYSTEM_ITEMS_VL

APPS.ENG_REVISED_COMPONENTS_ERV is not referenced by any database object