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: ViewXDP.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:

SchemaAPPS
SynonymXDP_FULFILL_WORKLIST
SynonymXDP_ORDER_HEADERS
SynonymXDP_ORDER_LINE_ITEMS
SynonymXDP_WORKITEMS

APPS.XDP_ORDER_DETAILS_V is not referenced by any database object