eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:

APPS: CSI_COUNTER_ASSOCIATIONS; CSI_ITEM_INSTANCES; EAM_COUNTERS_V; MTL_SYSTEM_ITEMS_KFV; MTL_UNIT_TRANSACTIONS

APPS.EAM_CFR_ISSUED_SERIALS_V is not referenced by any database object