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

Object Details

Object Name:	VEA_LAYERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	VEA.VEA_LAYERS_V
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
LAYER_ID	NUMBER		Yes
LAYER_PROVIDER_CODE	VARCHAR2	(30)	Yes
LAYER_HEADER_ID	NUMBER		Yes
ACTIVE_FLAG	VARCHAR2	(1)
NEW_PROGRAM_UNIT_ID	NUMBER		Yes
PROGRAM_UNIT_LP_CODE	VARCHAR2	(30)	Yes
SEQUENCE_NUMBER	NUMBER		Yes
DESCRIPTION	VARCHAR2	(1000)
TPS_PARAMETER1_ID	NUMBER
TPS_PARAMETER1_VALUE	VARCHAR2	(500)
TPS_PARAMETER2_ID	NUMBER
TPS_PARAMETER2_VALUE	VARCHAR2	(500)
TPS_PARAMETER3_ID	NUMBER
TPS_PARAMETER3_VALUE	VARCHAR2	(500)
TPS_PARAMETER4_ID	NUMBER
TPS_PARAMETER4_VALUE	VARCHAR2	(500)
TPS_PARAMETER5_ID	NUMBER
TPS_PARAMETER5_VALUE	VARCHAR2	(500)
TPS_PARAMETER6_ID	NUMBER
TPS_PARAMETER6_VALUE	VARCHAR2	(500)
TPS_PARAMETER7_ID	NUMBER
TPS_PARAMETER7_VALUE	VARCHAR2	(500)
TPS_PARAMETER8_ID	NUMBER
TPS_PARAMETER8_VALUE	VARCHAR2	(500)
TPS_PARAMETER9_ID	NUMBER
TPS_PARAMETER9_VALUE	VARCHAR2	(500)
TPS_PARAMETER10_ID	NUMBER
TPS_PARAMETER10_VALUE	VARCHAR2	(500)
TP_LAYER_ID	NUMBER		Yes
TP_LAYER_NAME	VARCHAR2	(50)	Yes
TP_LAYER_ACTIVE_FLAG	VARCHAR2	(1)
TP_LAYER_DESCRIPTION	VARCHAR2	(1000)
IS_LAYER_ACTIVE	VARCHAR2	(1)
TPS_PROGRAM_UNIT_LP_CODE	VARCHAR2	(30)	Yes

Query Text

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


SELECT LAYER_ID
,      LAYER_PROVIDER_CODE
,      LAYER_HEADER_ID
,      ACTIVE_FLAG
,      NEW_PROGRAM_UNIT_ID
,      PROGRAM_UNIT_LP_CODE
,      SEQUENCE_NUMBER
,      DESCRIPTION
,      TPS_PARAMETER1_ID
,      TPS_PARAMETER1_VALUE
,      TPS_PARAMETER2_ID
,      TPS_PARAMETER2_VALUE
,      TPS_PARAMETER3_ID
,      TPS_PARAMETER3_VALUE
,      TPS_PARAMETER4_ID
,      TPS_PARAMETER4_VALUE
,      TPS_PARAMETER5_ID
,      TPS_PARAMETER5_VALUE
,      TPS_PARAMETER6_ID
,      TPS_PARAMETER6_VALUE
,      TPS_PARAMETER7_ID
,      TPS_PARAMETER7_VALUE
,      TPS_PARAMETER8_ID
,      TPS_PARAMETER8_VALUE
,      TPS_PARAMETER9_ID
,      TPS_PARAMETER9_VALUE
,      TPS_PARAMETER10_ID
,      TPS_PARAMETER10_VALUE
,      TP_LAYER_ID
,      TP_LAYER_NAME
,      TP_LAYER_ACTIVE_FLAG
,      TP_LAYER_DESCRIPTION
,      IS_LAYER_ACTIVE
,      TPS_PROGRAM_UNIT_LP_CODE
FROM APPS.VEA_LAYERS_V;