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

VIEW: APPS.ENG_WEB_SUB_COMPS_V

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

View Type

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


Revised Substitute Components. Only those substitute components
defined within an ECO are shown in this view. Designed for use in
Oracle Self Service Web Applications.


[View Source]

Columns
Name Datatype Length Mandatory Comments
COMPONENT_SEQUENCE_ID NUMBER
Yes Foreign key to revised component
ACTION VARCHAR2 (80) Yes Add or Delete
SUBSTITUTE_COMPONENT VARCHAR2 (40)
Item concatenated segments
PADDED_CONCATENATED_SEGMENTS VARCHAR2 (40)
Item padded concatenated segments
SUBSTITUTE_ITEM_QUANTITY NUMBER
Yes Quantity of substitute item to use in bill
PRIMARY_UOM_CODE VARCHAR2 (3)
Item's unit of measure
DESCRIPTION VARCHAR2 (240)
Item description
Query Text

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


SELECT COMPONENT_SEQUENCE_ID
,      ACTION
,      SUBSTITUTE_COMPONENT
,      PADDED_CONCATENATED_SEGMENTS
,      SUBSTITUTE_ITEM_QUANTITY
,      PRIMARY_UOM_CODE
,      DESCRIPTION
FROM APPS.ENG_WEB_SUB_COMPS_V;

Dependencies

[top of page]

APPS.ENG_WEB_SUB_COMPS_V references the following:

SchemaAPPS
ViewBOM_INVENTORY_COMPONENTS
SynonymBOM_SUBSTITUTE_COMPONENTS
SynonymENG_REVISED_ITEMS
ViewMFG_LOOKUPS
SynonymMTL_SYSTEM_ITEMS_KFV

APPS.ENG_WEB_SUB_COMPS_V is not referenced by any database object