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

Object Details

Object Name:	ZPB_ATTRIBUTES_VL
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

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

ZPB Attributes with their name labels in the language of the current session. Language determined by the userenv('LANG') variable

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ATTRIBUTE_ID	NUMBER		Yes	Primary key of zpb_attributes
DIMENSION_ID	NUMBER		Yes	Dimension id of attribute's domain dimension. Foreign key into zpb_dimensions table.
NAME	VARCHAR2	(240)		Attribute name
TYPE	VARCHAR2	(30)		Types include : 'DIMENSION_ATTRIBUTE', 'VALUE_NAME_ATTRIBUTE', and 'END_DATE_ATTRIBUTE'
EPB_ID	VARCHAR2	(30)		EPB Id
LABEL	VARCHAR2	(240)		Attribute Label
RANGE_DIM_ID	NUMBER			Dimension id of attribute's range dimension. Foreign key into zpb_dimensions table
SHAR_CWM_NAME	VARCHAR2	(60)		CWM Name of attribute in the shared workspace
PERS_CWM_NAME	VARCHAR2	(60)		CWM Name of attribute in the personal workspace
FEM_ATTRIBUTE_ID	NUMBER			Attribute ID in EPF
CREATED_BY	NUMBER	(15)	Yes	Bookkeeping Column
CREATION_DATE	DATE		Yes	Bookkeeping Column
LAST_UPDATE_DATE	DATE		Yes	Bookkeeping Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Bookkeeping Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Bookkeeping Column
PLURAL_NAME	VARCHAR2	(240)		Plural Name
PLURAL_LONG_NAME	VARCHAR2	(240)		Plural Long Name
LONG_NAME	VARCHAR2	(240)		Long Name

Query Text

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


SELECT ATTRIBUTE_ID
,      DIMENSION_ID
,      NAME
,      TYPE
,      EPB_ID
,      LABEL
,      RANGE_DIM_ID
,      SHAR_CWM_NAME
,      PERS_CWM_NAME
,      FEM_ATTRIBUTE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      PLURAL_NAME
,      PLURAL_LONG_NAME
,      LONG_NAME
FROM APPS.ZPB_ATTRIBUTES_VL;

Dependencies

[top of page]

APPS.ZPB_ATTRIBUTES_VL references the following:

APPS: ZPB_ATTRIBUTES; ZPB_ATTRIBUTES_TL

APPS.ZPB_ATTRIBUTES_VL is referenced by following:

APPS: ZPB_DEBUG - show dependent code; ZPB_LAB_ATTRIBS_SCOPE_V; ZPB_LAB_ATTRIBS_V; ZPB_MD_LABELS_V; ZPB_OS_ATTRIBUTES_V