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


VIEW: APPS.ENG_IMPACTED_BILLS_ERV

Object Details
Object Name: ENG_IMPACTED_BILLS_ERV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewENG.ENG_IMPACTED_BILLS_ERV
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
ASSEMBLY VARCHAR2 (40)
Assembly
DESCRIPTION VARCHAR2 (240)
Description
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
Alternate BOM designator
BILL_REVISION VARCHAR2 (3) Yes Bill revision
CATEGORY_SET_NAME VARCHAR2 (30) Yes Category set name
CATEGORY VARCHAR2 (81)
Category
ASSEMBLY_ITEM_ID NUMBER
Yes Item id
ORGANIZATION_ID NUMBER
Yes Organization id
Query Text

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


SELECT ASSEMBLY
,      DESCRIPTION
,      ALTERNATE_BOM_DESIGNATOR
,      BILL_REVISION
,      CATEGORY_SET_NAME
,      CATEGORY
,      ASSEMBLY_ITEM_ID
,      ORGANIZATION_ID
FROM APPS.ENG_IMPACTED_BILLS_ERV;

Dependencies

[top of page]

APPS.ENG_IMPACTED_BILLS_ERV references the following:

SchemaAPPS
ViewENG_REVISED_ITEMS_V
PL/SQL PackageFND_GLOBAL - show dependent code
ViewMTL_ITEM_CATEGORIES_V
SynonymMTL_ITEM_REVISIONS
ViewMTL_SYSTEM_ITEMS_VL

APPS.ENG_IMPACTED_BILLS_ERV is not referenced by any database object