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


VIEW: APPS.ENG_WEB_REVISED_COMPS_V

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

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


Revised Component on an ECO. Designed for use in Oracle Self
Service Web Applications.


[View Source]

Columns
Name Datatype Length Mandatory Comments
REVISED_ITEM_SEQUENCE_ID NUMBER

Foreign key to revised item
OPERATION_SEQ_NUM NUMBER

Operation from routing
ITEM_NUM NUMBER

User define sequencing of components within bill
PADDED_CONCATENATED_SEGMENTS VARCHAR2 (40)
Padded concatenated item segments. Used for ordering by item number.
REVISED_ITEM VARCHAR2 (40)
Concatenated Segments of parent revised item
ACTION VARCHAR2 (80)
Add, change or disable
COMPONENT_ITEM_ID NUMBER

Inventory Item Id
ORGANIZATION_ID NUMBER

Organization
ORGANIZATION_CODE VARCHAR2 (3)
Organization Code
COMPONENT_ITEM VARCHAR2 (40)
Item concatenated segments
DESCRIPTION VARCHAR2 (240)
Item Description
ENG_ITEM_FLAG VARCHAR2 (1)
Engineering Item? Asterisk means yes, blank means no.
PRIMARY_UOM_CODE VARCHAR2 (3)
Item's unit of measure
OLD_OPERATION_SEQ_NUM NUMBER

Old component's operation
EFFECTIVITY_DATE DATE

Date component becomes effective
EFFECTIVITY_TIME VARCHAR2 (8)
The time portion of Effective Date translated to string
COMPONENT_QUANTITY NUMBER

Quantity used in bill
CHANGE_NOTICE VARCHAR2 (10)
ECO
COMPONENT_SEQUENCE_ID NUMBER

Primary key for revised component
Query Text

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


SELECT REVISED_ITEM_SEQUENCE_ID
,      OPERATION_SEQ_NUM
,      ITEM_NUM
,      PADDED_CONCATENATED_SEGMENTS
,      REVISED_ITEM
,      ACTION
,      COMPONENT_ITEM_ID
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      COMPONENT_ITEM
,      DESCRIPTION
,      ENG_ITEM_FLAG
,      PRIMARY_UOM_CODE
,      OLD_OPERATION_SEQ_NUM
,      EFFECTIVITY_DATE
,      EFFECTIVITY_TIME
,      COMPONENT_QUANTITY
,      CHANGE_NOTICE
,      COMPONENT_SEQUENCE_ID
FROM APPS.ENG_WEB_REVISED_COMPS_V;

Dependencies

[top of page]

APPS.ENG_WEB_REVISED_COMPS_V references the following:

SchemaAPPS
ViewBOM_INVENTORY_COMPONENTS
SynonymENG_REVISED_COMPONENTS
SynonymENG_REVISED_ITEMS
ViewMFG_LOOKUPS
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS_KFV

APPS.ENG_WEB_REVISED_COMPS_V is not referenced by any database object