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

VIEW: APPS.XDP_READY_FES_V

Object Details
Object Name: XDP_READY_FES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXDP.XDP_READY_FES_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
FENAME VARCHAR2 (40) Yes Fulfillment Element Internal Name
FE_ID NUMBER
Yes Fulfillment Element Identifier
FANAME NUMBER
Yes Fulfillment Action Instance Identifier
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
PRIORITY NUMBER

Order Priority
WORKITEM_DISPLAY VARCHAR2 (80) Yes Work Item Display Name
FANAME_DISPLAY VARCHAR2 (80) Yes Fulfillment Action Display Name
FENAME_DISPLAY VARCHAR2 (80) Yes Fulfillment Element Display Name
Query Text

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


SELECT FENAME
,      FE_ID
,      FANAME
,      WORKITEM
,      EXTERNAL_ORDER_ID
,      EXTERNAL_ORDER_VERSION
,      INTERNAL_ORDER_ID
,      QUEUED_ON
,      DUE_DATE
,      PRIORITY
,      WORKITEM_DISPLAY
,      FANAME_DISPLAY
,      FENAME_DISPLAY
FROM APPS.XDP_READY_FES_V;

Dependencies

[top of page]

APPS.XDP_READY_FES_V references the following:

SchemaAPPS
SynonymXDP_FA_RUNTIME_LIST
ViewXDP_FES_VL
ViewXDP_FULFILL_ACTIONS_VL
SynonymXDP_FULFILL_WORKLIST
SynonymXDP_ORDER_HEADERS
PL/SQL PackageXDP_SYSCN_UTIL - show dependent code
SynonymXDP_WF_CHANNEL_QTAB
ViewXDP_WORKITEMS_VL

APPS.XDP_READY_FES_V is not referenced by any database object