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]

TABLE: XDP.XDP_FA_RUNTIME_LIST

Object Details

Object Name:	XDP_FA_RUNTIME_LIST
Object Type:	TABLE
Owner:	XDP
FND Design Data:	XDP.XDP_FA_RUNTIME_LIST
Subobject Name:
Status:	VALID

XDP_FA_RUNTIME_LIST is used to contain the list of the FAs which need to be executed for a work item instance.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XDP_FA_RUNTIME_LIST_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FA_INSTANCE_ID
XDP_FA_RUNTIME_LIST_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESUBMISSION_JOB_ID
XDP_FA_RUNTIME_LIST_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FULFILLMENT_ACTION_ID
XDP_FA_RUNTIME_LIST_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WORKITEM_INSTANCE_ID
XDP_FA_RUNTIME_LIST_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
FA_INSTANCE_ID	NUMBER		Yes	Fulfillment Action instance identifier
WORKITEM_INSTANCE_ID	NUMBER		Yes	Associated work item instance identifier
FULFILLMENT_ACTION_ID	NUMBER		Yes	Fulfillment Action identifier
STATUS_CODE	VARCHAR2	(40)	Yes	Current fulfillment status of the Fulfillment Action instance
STATE	VARCHAR2	(40)		Not used
FE_ID	NUMBER			Identifier of the Fulfillment Element where fulfillment will be performed
FA_RUNTIME_MESSAGE_ID	RAW	(16)		A handle to an AQ runtime message
PROVISIONING_SEQUENCE	NUMBER			The fulfillment sequence number of this Fulfillment Action instance within its associated work item execution
PRIORITY	NUMBER			Fulfillment priority
START_PROVISIONING_DATE	DATE			Time stamp when the fulfillment process starts
COMPLETION_DATE	DATE			The time stamp when the fulfillment completed
CANCEL_PROVISIONING_DATE	DATE			The time stamp when the fulfillment is cancelled
CANCELED_BY	VARCHAR2	(40)		The user ID of who cancelled the fulfillment process
HOLD_PROVISIONING_DATE	DATE			Reserved for future use
HELD_BY	VARCHAR2	(40)		Reserved for future use
RESUME_PROVISIONING_DATE	DATE			Reserved for future use
RESUMED_BY	VARCHAR2	(40)		Reserved for future use
WF_ITEM_TYPE	VARCHAR2	(8)		Fulfillment action workflow item type
WF_ITEM_KEY	VARCHAR2	(240)		Fulfillment action workflow item key
ERROR_REF_ID	NUMBER			A handle to the error table
RESUBMISSION_JOB_ID	NUMBER			Identifier of an order resubmission job if this fulfillment action instance is part of a resubmission job
MSGID	RAW	(16)		A handle to its corresponding process queue
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
RESOURCE_REGISTERED_DATE	DATE			Time when the Fulfillment Action registers for a channel to an Fulfillment Element
RESOURCE_DELIVERED_DATE	DATE			Time when the Fulfillment Action is granted a channel to fulfill the Fulfillment Element
ATTRIBUTE_CATEGORY	VARCHAR2	(240)		Attribute Category
ATTRIBUTE1	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE2	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE3	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE4	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE5	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE6	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE7	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE8	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE9	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE10	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE11	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE12	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE13	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE14	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE15	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE16	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE17	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE18	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE19	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE20	VARCHAR2	(240)		Descriptive Flexvfeld
PROC_NAME	VARCHAR2	(80)		Procedure internal name

Query Text

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


SELECT FA_INSTANCE_ID
,      WORKITEM_INSTANCE_ID
,      FULFILLMENT_ACTION_ID
,      STATUS_CODE
,      STATE
,      FE_ID
,      FA_RUNTIME_MESSAGE_ID
,      PROVISIONING_SEQUENCE
,      PRIORITY
,      START_PROVISIONING_DATE
,      COMPLETION_DATE
,      CANCEL_PROVISIONING_DATE
,      CANCELED_BY
,      HOLD_PROVISIONING_DATE
,      HELD_BY
,      RESUME_PROVISIONING_DATE
,      RESUMED_BY
,      WF_ITEM_TYPE
,      WF_ITEM_KEY
,      ERROR_REF_ID
,      RESUBMISSION_JOB_ID
,      MSGID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      RESOURCE_REGISTERED_DATE
,      RESOURCE_DELIVERED_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      PROC_NAME
FROM XDP.XDP_FA_RUNTIME_LIST;

Dependencies

[top of page]

XDP.XDP_FA_RUNTIME_LIST does not reference any database object

XDP.XDP_FA_RUNTIME_LIST is referenced by following:

APPS: XDP_FA_RUNTIME_LIST