DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.XDP_OE_ORDER_DETAILS_V

Object Details
Object Name: XDP_OE_ORDER_DETAILS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXDP.XDP_OE_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_NUMBER VARCHAR2 (40) Yes Order number
ORDER_VERSION VARCHAR2 (40)
Order version
LINE_NUMBER NUMBER
Yes Line number
LINE_ITEM_NAME VARCHAR2 (40) Yes Line item name
LINE_ITEM_VERSION VARCHAR2 (40)
Line item version
LINE_ITEM_TYPE VARCHAR2 (20)
Line item type
IS_WORK_ITEM_FLAG VARCHAR2 (1)
Workitem indicator
PROVISIONING_REQUIRED_FLAG VARCHAR2 (1) Yes Provisioining process end date
ORDER_PROVISIONING_DATE DATE
Yes Date by which order fulfillment should be completed
LINE_PROVISIONING_DATE DATE

Date by which fulfillment for order line should be completed
PROVISIONING_SEQUENCE NUMBER

Sequence of fulfillment
ORDER_TYPE VARCHAR2 (40)
Order Type
ORDER_ACTION VARCHAR2 (30)
Order Action
LINE_ITEM_ACTION VARCHAR2 (30)
Line item action
ORDER_SOURCE VARCHAR2 (40)
Source or origination of order
ORDER_PRIORITY NUMBER

Order priority
LINE_PRIORITY NUMBER

Line priority
ORDER_STATUS VARCHAR2 (40)
Order status
LINE_STATUS VARCHAR2 (40)
Line status
SDP_ORDER_ID NUMBER

Internal order id
ORDER_DUE_DATE DATE

Internal date for completion of order processing
LINE_DUE_DATE DATE

Internal date for completion of order line processing
ORDER_CUSTOMER_REQUIRED_DATE DATE

Date by which customer expects order fulfillment to be completed
LINE_CUSTOMER_REQUIRED_DATE DATE

Date by which customer expects line fulfillment to be completed
CUSTOMER_NAME VARCHAR2 (40)
Customer name
CUSTOMER_ID NUMBER

Customer id
ORG_ID NUMBER

Organization id
SERVICE_PROVIDER_ID NUMBER

Service provider id
TELEPHONE_NUMBER VARCHAR2 (40)
Telephone number
RELATED_ORDER_ID NUMBER

Related order identifier
SP_ORDER_NUMBER VARCHAR2 (80)
Service provider order number
SP_USERID NUMBER (15)
Service provider userid
ORDER_REF_NAME VARCHAR2 (80)
Order reference name
ORDER_REF_VALUE VARCHAR2 (300)
Order reference value
STARTING_NUMBER NUMBER

Starting number
ENDING_NUMBER NUMBER

Ending number
Query Text

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


SELECT ORDER_NUMBER
,      ORDER_VERSION
,      LINE_NUMBER
,      LINE_ITEM_NAME
,      LINE_ITEM_VERSION
,      LINE_ITEM_TYPE
,      IS_WORK_ITEM_FLAG
,      PROVISIONING_REQUIRED_FLAG
,      ORDER_PROVISIONING_DATE
,      LINE_PROVISIONING_DATE
,      PROVISIONING_SEQUENCE
,      ORDER_TYPE
,      ORDER_ACTION
,      LINE_ITEM_ACTION
,      ORDER_SOURCE
,      ORDER_PRIORITY
,      LINE_PRIORITY
,      ORDER_STATUS
,      LINE_STATUS
,      SDP_ORDER_ID
,      ORDER_DUE_DATE
,      LINE_DUE_DATE
,      ORDER_CUSTOMER_REQUIRED_DATE
,      LINE_CUSTOMER_REQUIRED_DATE
,      CUSTOMER_NAME
,      CUSTOMER_ID
,      ORG_ID
,      SERVICE_PROVIDER_ID
,      TELEPHONE_NUMBER
,      RELATED_ORDER_ID
,      SP_ORDER_NUMBER
,      SP_USERID
,      ORDER_REF_NAME
,      ORDER_REF_VALUE
,      STARTING_NUMBER
,      ENDING_NUMBER
FROM APPS.XDP_OE_ORDER_DETAILS_V;

Dependencies

[top of page]

APPS.XDP_OE_ORDER_DETAILS_V references the following:

SchemaAPPS
SynonymXDP_OE_ORDER_HEADERS
SynonymXDP_OE_ORDER_LINES

APPS.XDP_OE_ORDER_DETAILS_V is not referenced by any database object