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_ORU_ORDERS_V

Object Details

Object Name:	XDP_ORU_ORDERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XDP.XDP_ORU_ORDERS_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
RESUBMISSION_JOB_ID	NUMBER			Unique identifier for resubmitted job
WORKITEM_INSTANCE_ID	NUMBER		Yes	Workitem instance id
FA_INSTANCE_ID	NUMBER		Yes	Fulfillment action instance id
STATUS_CODE	VARCHAR2	(40)	Yes	Order status code
EXTERNAL_ORDER_NUMBER	VARCHAR2	(40)	Yes	External Order number
EXTERNAL_ORDER_VERSION	VARCHAR2	(40)		External order version
ORDER_ID	NUMBER		Yes	Unique order identifier
WORKITEM_ID	NUMBER		Yes	Unique workitem identifier
FULFILLMENT_ACTION_ID	NUMBER		Yes	Fulfillment action identifier
FE_ID	NUMBER			Fulfillment element identifier
START_PROVISIONING_DATE	DATE			Fulfillment process start date
COMPLETION_DATE	DATE			Fulfillment process completion date
LINE_NUMBER	NUMBER		Yes	Line number
LINE_ITEM_NAME	VARCHAR2	(40)	Yes	Line item name
FA_DISPLAY_NAME	VARCHAR2	(80)	Yes	Fulfillment action display name
WI_DISPLAY_NAME	VARCHAR2	(80)	Yes	Workitem display name

Query Text

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


SELECT RESUBMISSION_JOB_ID
,      WORKITEM_INSTANCE_ID
,      FA_INSTANCE_ID
,      STATUS_CODE
,      EXTERNAL_ORDER_NUMBER
,      EXTERNAL_ORDER_VERSION
,      ORDER_ID
,      WORKITEM_ID
,      FULFILLMENT_ACTION_ID
,      FE_ID
,      START_PROVISIONING_DATE
,      COMPLETION_DATE
,      LINE_NUMBER
,      LINE_ITEM_NAME
,      FA_DISPLAY_NAME
,      WI_DISPLAY_NAME
FROM APPS.XDP_ORU_ORDERS_V;

Dependencies

[top of page]

APPS.XDP_ORU_ORDERS_V references the following:

APPS: XDP_FA_RUNTIME_LIST; XDP_FULFILL_ACTIONS_VL; XDP_FULFILL_WORKLIST; XDP_ORDER_HEADERS; XDP_ORDER_LINE_ITEMS; XDP_WORKITEMS_VL

APPS.XDP_ORU_ORDERS_V is referenced by following:

APPS: XDPCORE_ERROR - show dependent code