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

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
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