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


VIEW: APPS.EAM_CFR_ISSUED_SERIALS_V

Object Details
Object Name: EAM_CFR_ISSUED_SERIALS_V
Object Type: VIEW
Owner: APPS
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
INSTANCE_ID NUMBER
Yes Instance identifier generated by system. This represents instance id of the issued serial
INSTANCE_NUMBER VARCHAR2 (30) Yes Instance number of the issued serial
SERIAL_NUMBER VARCHAR2 (30)
Instance Serial number of the issued serial
INSTANCE_DESCRIPTION VARCHAR2 (240)
Instance description of the issued serial
INVENTORY_ITEM_ID NUMBER
Yes Asset group id of the issued serial
CONCATENATED_SEGMENTS VARCHAR2 (40)
Asset group concatenated segments
DESCRIPTION VARCHAR2 (240)
Asset group description of the issued serial
WIP_ENTITY_ID NUMBER

Work Order identifier - this is of the work order against which serials were issued
ORGANIZATION_ID NUMBER
Yes Work Order organization id
METER_ID NUMBER

Meter Id of the meter associated with issued serial
METER_NAME VARCHAR2 (80)
Meter Name of the meter associated with issued serial
SOURCE_METER_ID NUMBER

Source Meter Id
SOURCE_METER_NAME VARCHAR2 (80)
Source Meter Name
Query Text

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


SELECT INSTANCE_ID
,      INSTANCE_NUMBER
,      SERIAL_NUMBER
,      INSTANCE_DESCRIPTION
,      INVENTORY_ITEM_ID
,      CONCATENATED_SEGMENTS
,      DESCRIPTION
,      WIP_ENTITY_ID
,      ORGANIZATION_ID
,      METER_ID
,      METER_NAME
,      SOURCE_METER_ID
,      SOURCE_METER_NAME
FROM APPS.EAM_CFR_ISSUED_SERIALS_V;

Dependencies

[top of page]

APPS.EAM_CFR_ISSUED_SERIALS_V references the following:

SchemaAPPS
SynonymCSI_COUNTER_ASSOCIATIONS
SynonymCSI_ITEM_INSTANCES
ViewEAM_COUNTERS_V
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymMTL_UNIT_TRANSACTIONS

APPS.EAM_CFR_ISSUED_SERIALS_V is not referenced by any database object