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

Object Details

Object Name:	EDW_OPI_ACTV_ACTV_LCV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OPI.EDW_OPI_ACTV_ACTV_LCV
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Sources All Activities from Discrete and Process manufacturing.

[View Source]

Columns

Name	Datatype	Length	Comments
ALL_FK	CHAR	(3)	Foreign key on the All Level.
ACTV_PK	VARCHAR2	(75)	Primary key on the activity . This is a combination of activity, instance and product-tag.
ACTV_DP	CHAR	(4)	Discoverer displayed column.
ACTV_CODE	VARCHAR2	(16)	Activity code.
NAME	VARCHAR2	(16)	Displays name for activity.
ACTV_NAME	VARCHAR2	(16)	Activity name.
DESCRIPTION	VARCHAR2	(240)	Activity description.
COST_ANALYSIS_CODE	VARCHAR2	(4)	The cost analysis code for this activity, for example, is this a value added or non-value added activity.
VALUE_ADDED	NUMBER		Flag indicating whether the activity adds value, 1= Yes, 0 = No.
USER_ATTRIBUTE1	VARCHAR2	(0)	User Defined Attribute1.
USER_ATTRIBUTE2	VARCHAR2	(0)	User Defined Attribute2.
USER_ATTRIBUTE3	VARCHAR2	(0)	User Defined Attribute3.
USER_ATTRIBUTE4	VARCHAR2	(0)	User Defined Attribute4.
USER_ATTRIBUTE5	VARCHAR2	(0)	User Defined Attribute5.
LAST_UPDATE_DATE	DATE		Standard WHO column.
CREATION_DATE	DATE		Standard WHO column.

Query Text

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


SELECT ALL_FK
,      ACTV_PK
,      ACTV_DP
,      ACTV_CODE
,      NAME
,      ACTV_NAME
,      DESCRIPTION
,      COST_ANALYSIS_CODE
,      VALUE_ADDED
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      LAST_UPDATE_DATE
,      CREATION_DATE
FROM APPS.EDW_OPI_ACTV_ACTV_LCV;

Dependencies

[top of page]

APPS.EDW_OPI_ACTV_ACTV_LCV references the following:

APPS: CST_ACTIVITIES; EDW_LOCAL_INSTANCE; FM_ACTV_MST

APPS.EDW_OPI_ACTV_ACTV_LCV is referenced by following:

APPS: EDW_OPI_ACTV_MPV