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

VIEW: APPS.XDP_READY_FAS_V

Object Details
Object Name: XDP_READY_FAS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXDP.XDP_READY_FAS_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
FANAME NUMBER

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
PROVISIONING_DATE DATE
Yes Order Fulfillment Date
PRIORITY NUMBER

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

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


SELECT FANAME
,      WORKITEM
,      EXTERNAL_ORDER_ID
,      EXTERNAL_ORDER_VERSION
,      INTERNAL_ORDER_ID
,      QUEUED_ON
,      DUE_DATE
,      PROVISIONING_DATE
,      PRIORITY
,      WORKITEM_DISPLAY
,      FANAME_DISPLAY
FROM APPS.XDP_READY_FAS_V;

Dependencies

[top of page]

APPS.XDP_READY_FAS_V references the following:

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

APPS.XDP_READY_FAS_V is not referenced by any database object