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

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CHANNEL_NAME	VARCHAR2	(40)	Yes	Adapter communication channel ID
ADAPTER_NAME	VARCHAR2	(40)	Yes	System Generated Name. Editable only in the case of Messaging Adapters
ADAPTER_DISPLAY_NAME	VARCHAR2	(80)	Yes	User defined Name of the Adapter
FE_ID	NUMBER		Yes	Fulfillment Element identifier
FULFILLMENT_ELEMENT_NAME	VARCHAR2	(40)	Yes	Fulfillment Element Name
FE_DISPLAY_NAME	VARCHAR2	(80)	Yes	Fulfillment Element Display Name
TARGET_NODE	VARCHAR2	(30)		Target machine
PROCESS_ID	NUMBER		Yes	OS process ID for the Adapter
ADAPTER_STATUS	VARCHAR2	(40)	Yes	Current status of the Adapter
ADAPTER_STATUS_DISPLAY	VARCHAR2	(80)		Adapter Status Display
WF_ITEM_TYPE	VARCHAR2	(8)		Item type of the workflow for the adapter
WF_ITEM_KEY	VARCHAR2	(240)		Item key of the workflow for the adapter
WF_ACTIVITY_NAME	VARCHAR2	(40)		Activity name of the workflow for the adapter
CONNECT_ON_DEMAND_FLAG	VARCHAR2	(1)	Yes	Indicates whether Deferred Connection is enabled or not
MAX_IDLE_TIME_MINUTES	NUMBER			Max Idle Time in Minutes
LOG_FILE_NAME	VARCHAR2	(240)		To be used by AFLOG. Default value is ADAPTER_NAME. NULL value indicates that the log will go to the database
ADAPTER_TYPE	VARCHAR2	(40)	Yes	Adapter Type of the Instance
ADAPTER_TYPE_DISPLAY	VARCHAR2	(240)		Adapter Type Display
STATUS	VARCHAR2	(40)	Yes	Current status of the Adapter
STATUS_DISPLAY	VARCHAR2	(80)		Status Display
USAGE_CODE	VARCHAR2	(40)	Yes	Internal Code representing the usage of the adapter
USAGE_CODE_DISPLAY	VARCHAR2	(80)		Usage Code Display
STARTUP_MODE	VARCHAR2	(20)	Yes	Internal Code representing the startup mode of the adapter
STARTUP_MODE_DISPLAY	VARCHAR2	(80)		Startup Mode Display
LOG_LEVEL	VARCHAR2	(40)	Yes	AFLOG logging level for the Adapter instance
LOG_LEVEL_DISPLAY	VARCHAR2	(80)		Log Level Display
SEQ_IN_FE	NUMBER			Display / usage sequence within the FE
SERVICE_INSTANCE_ID	NUMBER		Yes	Identifies Controller Service (Node) to use for starting Adapter
CMD_LINE_OPTIONS	VARCHAR2	(240)		System properties for the Adapter instance in addition to the ones defined for the Adapter Type
CMD_LINE_ARGS	VARCHAR2	(240)		Command line arguments for the Adapter instance in addition to the ones defined for the Adapter Type
LAST_VERIFIED_TIME	DATE			Time the Adapter instance was last verified
STATUS_ACTIVE_TIME	DATE			Time stamp for when Adapter last had status BUSY
APPLICATION_ID	NUMBER	(15)	Yes	Application Identifier
OBJECT_VERSION_NUMBER	NUMBER			Column required for stateless UI support

Query Text

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


SELECT CHANNEL_NAME
,      ADAPTER_NAME
,      ADAPTER_DISPLAY_NAME
,      FE_ID
,      FULFILLMENT_ELEMENT_NAME
,      FE_DISPLAY_NAME
,      TARGET_NODE
,      PROCESS_ID
,      ADAPTER_STATUS
,      ADAPTER_STATUS_DISPLAY
,      WF_ITEM_TYPE
,      WF_ITEM_KEY
,      WF_ACTIVITY_NAME
,      CONNECT_ON_DEMAND_FLAG
,      MAX_IDLE_TIME_MINUTES
,      LOG_FILE_NAME
,      ADAPTER_TYPE
,      ADAPTER_TYPE_DISPLAY
,      STATUS
,      STATUS_DISPLAY
,      USAGE_CODE
,      USAGE_CODE_DISPLAY
,      STARTUP_MODE
,      STARTUP_MODE_DISPLAY
,      LOG_LEVEL
,      LOG_LEVEL_DISPLAY
,      SEQ_IN_FE
,      SERVICE_INSTANCE_ID
,      CMD_LINE_OPTIONS
,      CMD_LINE_ARGS
,      LAST_VERIFIED_TIME
,      STATUS_ACTIVE_TIME
,      APPLICATION_ID
,      OBJECT_VERSION_NUMBER
FROM APPS.XDP_ADAPTER_REG_V;

Dependencies

[top of page]

APPS.XDP_ADAPTER_REG_V references the following:

APPS: FND_CONCURRENT_QUEUES; FND_GLOBAL - show dependent code; FND_LOOKUPS; XDP_ADAPTER_REG; XDP_ADAPTER_TYPES_VL; XDP_FES_VL

APPS.XDP_ADAPTER_REG_V is referenced by following:

APPS: XDP_ADAPTER - show dependent code