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

VIEW: APPS.XDP_READY_WORKITEM_V

Object Details
Object Name: XDP_READY_WORKITEM_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXDP.XDP_READY_WORKITEM_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
WORKITEM NUMBER
Yes Work Item Instance Identifier.
EXTERNAL_ORDER_ID VARCHAR2 (40) Yes Order Identifier generated by the External System
EXTERNAL_ORDER_VERSION VARCHAR2 (40)
Order Version
INTERNAL_ORDER_ID NUMBER
Yes Order Identifier
QUEUED_ON TIMESTAMP(6) (11)
Date the Order was Queued on
DUE_DATE DATE

Order Due Date
PROVISIONING_DATE DATE
Yes Order Fulfillment Date
PRIORITY NUMBER

Order Priority
WORKITEM_DISPLAY VARCHAR2 (80) Yes Work Item Display Name
Query Text

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


SELECT WORKITEM
,      EXTERNAL_ORDER_ID
,      EXTERNAL_ORDER_VERSION
,      INTERNAL_ORDER_ID
,      QUEUED_ON
,      DUE_DATE
,      PROVISIONING_DATE
,      PRIORITY
,      WORKITEM_DISPLAY
FROM APPS.XDP_READY_WORKITEM_V;

Dependencies

[top of page]

APPS.XDP_READY_WORKITEM_V references the following:

SchemaAPPS
SynonymXDP_FULFILL_WORKLIST
SynonymXDP_ORDER_HEADERS
PL/SQL PackageXDP_SYSCN_UTIL - show dependent code
ViewXDP_WORKITEMS_VL
SynonymXDP_WORKITEM_QTAB

APPS.XDP_READY_WORKITEM_V is not referenced by any database object