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

Object Details

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

View Type

MultiLingual view (a language resolved view of the data.)

FND_CP_SERVICES_VL

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		ROW_ID
SERVICE_ID	NUMBER	(15)	Yes	Unique id for the service, created by using sequence
SERVICE_HANDLE	VARCHAR2	(8)	Yes	Developer key for the service
ALLOW_VERIFY	VARCHAR2	(1)	Yes	Indicates if the service will accept a command to verify its internal state
ALLOW_SUSPEND	VARCHAR2	(1)	Yes	Allow suspend or not
ALLOW_MULTIPLE_PROC_NODE	VARCHAR2	(1)	Yes	Indicator whether or not the service allows more thanone service process to be active for on a given node
MIGRATE_ON_FAILURE	VARCHAR2	(1)	Yes	Indicator whether or not service process can be movedto a secondary node when primary mode service fails
SERVER_TYPE	VARCHAR2	(1)	Yes	Indicates the type of applications server upon which the service runs
ALLOW_MULTIPLE_PROC_INSTANCE	VARCHAR2	(1)	Yes	Indicator whether or not the service allows more than one service process tobe active for an Apps instance
ALLOW_PARAMETER	VARCHAR2	(1)	Yes	Indicator whether the service allows a parameter string to be associated with each work shift
ALLOW_START	VARCHAR2	(1)	Yes	Indicates if the service can be started from the system administration user interface
ALLOW_RESTART	VARCHAR2	(1)	Yes	Indicates if a service process should be restarted by the ICM if that service process exits abnormally
PARAMETER_CHANGE_ACTION	VARCHAR2	(1)	Yes	In dicates the action that should be taken when the parameters for a service instance change when the active work shift changes
ENV_FILE_NAME	VARCHAR2	(30)		Optional environment file for the service
CARTRIDGE_HANDLE	VARCHAR2	(8)	Yes	Developer key for cartridge
DEVELOPER_PARAMETERS	VARCHAR2	(2000)		Service specific cartridge parameter
ALLOW_CREATE	VARCHAR2	(1)		Indicates whether or not users should be allowed to create new service instances for this service
SERVICE_CLASS	VARCHAR2	(1024)		If not null, this points to the display class that should be used for the right pane of the OAM instead of the default class, when the Navigator focus is on the service
SERVICE_INSTANCE_CLASS	VARCHAR2	(1024)		If not null, this points to the display class that should be used for the right pane of the OAM instead of the default class, when the Navigator focus is on an instance of this service
OAM_DISPLAY_ORDER	NUMBER	(15)		Determines the order in which the services are listed in the Services branch of the OAM Navigator tree
ALLOW_RCG	VARCHAR2	(1)	Yes	Indicate whether or not the service definition user interface should allow a resource consumer group to be chosen for this service
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
SERVICE_NAME	VARCHAR2	(240)	Yes	Developer key for the service
DESCRIPTION	VARCHAR2	(240)		Description
ALLOW_EDIT	VARCHAR2	(1)	Yes	ALLOW_EDIT
DEBUG_CHANGE_ACTION	VARCHAR2	(1)	Yes	Type of Action taken when debug level is changed
ENABLED	VARCHAR2	(1)	Yes	Enabled Flag - Enabled Services can have Service Instances created
CARTRIDGE_APPLICATION_ID	NUMBER	(15)		Application Id of cartridge
DEBUG_TYPE	VARCHAR2	(30)		Lookup type name for diagnostic level
SERVICE_PLURAL_NAME	VARCHAR2	(240)		Service name
ALLOW_MULTIPLE_PROC_SI	VARCHAR2	(1)		Allow multiple processes per Service Instance
DEFAULT_DEBUG_LEVEL	VARCHAR2	(1)		Default value for diagnostic level

Query Text

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


SELECT ROW_ID
,      SERVICE_ID
,      SERVICE_HANDLE
,      ALLOW_VERIFY
,      ALLOW_SUSPEND
,      ALLOW_MULTIPLE_PROC_NODE
,      MIGRATE_ON_FAILURE
,      SERVER_TYPE
,      ALLOW_MULTIPLE_PROC_INSTANCE
,      ALLOW_PARAMETER
,      ALLOW_START
,      ALLOW_RESTART
,      PARAMETER_CHANGE_ACTION
,      ENV_FILE_NAME
,      CARTRIDGE_HANDLE
,      DEVELOPER_PARAMETERS
,      ALLOW_CREATE
,      SERVICE_CLASS
,      SERVICE_INSTANCE_CLASS
,      OAM_DISPLAY_ORDER
,      ALLOW_RCG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      SERVICE_NAME
,      DESCRIPTION
,      ALLOW_EDIT
,      DEBUG_CHANGE_ACTION
,      ENABLED
,      CARTRIDGE_APPLICATION_ID
,      DEBUG_TYPE
,      SERVICE_PLURAL_NAME
,      ALLOW_MULTIPLE_PROC_SI
,      DEFAULT_DEBUG_LEVEL
FROM APPS.FND_CP_SERVICES_VL;

Dependencies

[top of page]

APPS.FND_CP_SERVICES_VL references the following:

APPS: FND_CP_SERVICES; FND_CP_SERVICES_TL

APPS.FND_CP_SERVICES_VL is referenced by following:

APPS: FND_CONCURRENT - show dependent code; XDP_APPLICATION - show dependent code