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_ORDER_DETAILS_V

Object Details

Object Name:	XDP_ORDER_DETAILS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XDP.XDP_ORDER_DETAILS_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
ORDER_ID	NUMBER		Yes	Unique order identifier
ORDER_NUMBER	VARCHAR2	(40)	Yes	Order number
ORDER_VERSION	VARCHAR2	(40)		Order version
LINE_ITEM_ID	NUMBER		Yes	Line item identifier
LINE_NUMBER	NUMBER		Yes	Line number
LINE_ITEM_NAME	VARCHAR2	(40)	Yes	Line item name
LINE_VERSION	VARCHAR2	(20)		Line version
LINE_ITEM_ACTION_CODE	VARCHAR2	(30)		Action code for line item
WORKITEM_INSTANCE_ID	NUMBER		Yes	Work item instance id
WORKITEM_ID	NUMBER		Yes	Work item id
WORKITEM_NAME	VARCHAR2	(40)	Yes	Name of workitem
WORKITEM_VERSION	VARCHAR2	(40)	Yes	Workitem version
WI_TYPE_CODE	VARCHAR2	(40)	Yes	Code for the type of the workitem
ORDER_STATUS_CODE	VARCHAR2	(40)	Yes	Code for order status
ORDER_STATE	VARCHAR2	(0)		Not Used
LINE_STATUS_CODE	VARCHAR2	(40)	Yes	Order line status code
LINE_STATE	VARCHAR2	(0)		Not Used
WORKITEM_STATUS_CODE	VARCHAR2	(40)	Yes	Workitem status code
WORKITEM_STATE	VARCHAR2	(40)		Workitem state
LINE_SEQUENCE	NUMBER		Yes	Line item sequence
SEQ_IN_PACKAGE	NUMBER			Sequence of service within package
ORGANIZATION_ID	NUMBER			Organization Identifier for Item Definition
INVENTORY_ITEM_ID	NUMBER			Inventory Item Identifier
ORDER_PROVISIONING_DATE	DATE		Yes	Fulfillment date for order
LINE_PROVISIONING_DATE	DATE			Fulfillment date for order line
ACTUAL_PROVISIONING_DATE	DATE			Actual date for fulfillment
ORDER_COMPLETION_DATE	DATE			Order fulfillment completion date
LINE_COMPLETION_DATE	DATE			Order line fulfillment completion date
WORKITEM_COMPLETION_DATE	DATE			Workitem fulfillment completion date
ORDER_CANCEL_PROVISIONING_DATE	DATE			Order cancellation date
ORDER_CANCELED_BY	VARCHAR2	(40)		Identification of user cancelling order fulfillment
LINE_CANCEL_PROVISIONING_DATE	DATE			Date of cancellation of line item fulfilment
LINE_CANCELED_BY	VARCHAR2	(40)		Identification of person cancelling line item fulfillment
ORDER_HOLD_PROVISIONING_DATE	DATE			Date when order is put on hold
ORDER_HELD_BY	VARCHAR2	(40)		Person or process suspending order
LINE_HOLD_PROVISIONING_DATE	DATE			Date when line item processing is put on hold
LINE_HELD_BY	VARCHAR2	(40)		Person or process putting line item processing on hold
ORDER_RESUME_PROVISIONING_DATE	DATE			Order fulfillment resumption date
ORDER_RESUMED_BY	VARCHAR2	(40)		Person or process resuming order processing
LINE_RESUME_PROVISIONING_DATE	DATE			Date for resumption of line item fulfillment
LINE_RESUMED_BY	VARCHAR2	(40)		User or process responsible for resumption of line item fulfillment
ORDER_DUE_DATE	DATE			Internal due date for completion of order processing
ORDER_CUSTOMER_REQUIRED_DATE	DATE			Date by which customer expects order processing to be completed
LINE_DUE_DATE	DATE			internal date for completion of line item processing
LINE_CUSTOMER_REQUIRED_DATE	DATE			Date by which customer expects line item to be processed
ORDER_ACTION	VARCHAR2	(0)		Not Used
ORDER_SOURCE	VARCHAR2	(40)		Source or origination of order
CUSTOMER_ID	NUMBER			Customer identification
CUSTOMER_NAME	VARCHAR2	(80)		Customer name
ORG_ID	NUMBER			Organization id
SERVICE_PROVIDER_ID	VARCHAR2	(0)		Not Used
TELEPHONE_NUMBER	VARCHAR2	(40)		Customer telephone number
ORDER_PRIORITY	NUMBER			Order priority
LINE_PRIORITY	NUMBER			Order line priority
RELATED_ORDER_ID	NUMBER			Related order identifier
ORDER_TYPE	VARCHAR2	(40)		Order type
NEXT_ORDER_ID	NUMBER			Next order id used incase of related orders
PREVIOUS_ORDER_ID	NUMBER			Previous order id used incase of related orders
ORDER_REF_NAME	VARCHAR2	(80)		Order reference name
ORDER_REF_VALUE	VARCHAR2	(300)		Order reference value
SP_ORDER_NUMBER	VARCHAR2	(0)		Not Used
SP_USERID	VARCHAR2	(0)		Not Used
STARTING_NUMBER	NUMBER			Starting number
ENDING_NUMBER	NUMBER			Ending number
USER_WF_PROCESS_NAME	VARCHAR2	(40)		User defined workflow process name
WF_ITEM_TYPE	VARCHAR2	(8)		Workflow item type
WF_ITEM_KEY	VARCHAR2	(240)		Workflow item key

Query Text

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


SELECT ORDER_ID
,      ORDER_NUMBER
,      ORDER_VERSION
,      LINE_ITEM_ID
,      LINE_NUMBER
,      LINE_ITEM_NAME
,      LINE_VERSION
,      LINE_ITEM_ACTION_CODE
,      WORKITEM_INSTANCE_ID
,      WORKITEM_ID
,      WORKITEM_NAME
,      WORKITEM_VERSION
,      WI_TYPE_CODE
,      ORDER_STATUS_CODE
,      ORDER_STATE
,      LINE_STATUS_CODE
,      LINE_STATE
,      WORKITEM_STATUS_CODE
,      WORKITEM_STATE
,      LINE_SEQUENCE
,      SEQ_IN_PACKAGE
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      ORDER_PROVISIONING_DATE
,      LINE_PROVISIONING_DATE
,      ACTUAL_PROVISIONING_DATE
,      ORDER_COMPLETION_DATE
,      LINE_COMPLETION_DATE
,      WORKITEM_COMPLETION_DATE
,      ORDER_CANCEL_PROVISIONING_DATE
,      ORDER_CANCELED_BY
,      LINE_CANCEL_PROVISIONING_DATE
,      LINE_CANCELED_BY
,      ORDER_HOLD_PROVISIONING_DATE
,      ORDER_HELD_BY
,      LINE_HOLD_PROVISIONING_DATE
,      LINE_HELD_BY
,      ORDER_RESUME_PROVISIONING_DATE
,      ORDER_RESUMED_BY
,      LINE_RESUME_PROVISIONING_DATE
,      LINE_RESUMED_BY
,      ORDER_DUE_DATE
,      ORDER_CUSTOMER_REQUIRED_DATE
,      LINE_DUE_DATE
,      LINE_CUSTOMER_REQUIRED_DATE
,      ORDER_ACTION
,      ORDER_SOURCE
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      ORG_ID
,      SERVICE_PROVIDER_ID
,      TELEPHONE_NUMBER
,      ORDER_PRIORITY
,      LINE_PRIORITY
,      RELATED_ORDER_ID
,      ORDER_TYPE
,      NEXT_ORDER_ID
,      PREVIOUS_ORDER_ID
,      ORDER_REF_NAME
,      ORDER_REF_VALUE
,      SP_ORDER_NUMBER
,      SP_USERID
,      STARTING_NUMBER
,      ENDING_NUMBER
,      USER_WF_PROCESS_NAME
,      WF_ITEM_TYPE
,      WF_ITEM_KEY
FROM APPS.XDP_ORDER_DETAILS_V;

Dependencies

[top of page]

APPS.XDP_ORDER_DETAILS_V references the following:

APPS: XDP_FULFILL_WORKLIST; XDP_ORDER_HEADERS; XDP_ORDER_LINE_ITEMS; XDP_WORKITEMS

APPS.XDP_ORDER_DETAILS_V is not referenced by any database object