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


VIEW: APPS.CE_PO_FC_ORDERS_TEMP_V

Object Details
Object Name: CE_PO_FC_ORDERS_TEMP_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCE.CE_PO_FC_ORDERS_TEMP_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
PO_NUM VARCHAR2 (20) Yes Purchase order number
BASE_AMOUNT NUMBER

Purchase order amount in the base currency
AMOUNT NUMBER

Purchase order amount
START_DATE DATE

Start date
END_DATE DATE

End date
CURRENCY_CODE VARCHAR2 (15)
Currency code of the purchase order
STATUS VARCHAR2 (25)
Authorization status of the purchase order
PAYMENT_PRIORITY NUMBER

Payment priority assigned to the purchase order
VENDOR_TYPE VARCHAR2 (30)
Vendor type on the purchase order
PAYGROUP VARCHAR2 (25)
Pay group assigned to the purchase order
ORG_ID NUMBER

Organization identifier
PROJECT_ID NUMBER

Identifier for project used to build default Accounting Flexfield
LINE_NUMBER NUMBER
Yes Purchase Order Line Number
REFERENCE_ID NUMBER
Yes Reference identifier
ORDER_TYPE_LOOKUP_CODE VARCHAR2 (25)
Order Type Lookup Code
PURCHASE_BASIS VARCHAR2 (30)
Type of Purchase lookup code
MATCHING_BASIS VARCHAR2 (30)
Type of Matching Basis lookup code
Query Text

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


SELECT PO_NUM
,      BASE_AMOUNT
,      AMOUNT
,      START_DATE
,      END_DATE
,      CURRENCY_CODE
,      STATUS
,      PAYMENT_PRIORITY
,      VENDOR_TYPE
,      PAYGROUP
,      ORG_ID
,      PROJECT_ID
,      LINE_NUMBER
,      REFERENCE_ID
,      ORDER_TYPE_LOOKUP_CODE
,      PURCHASE_BASIS
,      MATCHING_BASIS
FROM APPS.CE_PO_FC_ORDERS_TEMP_V;

Dependencies

[top of page]

APPS.CE_PO_FC_ORDERS_TEMP_V references the following:

SchemaAPPS
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
PL/SQL PackageFND_GLOBAL - show dependent code
ViewGL_SETS_OF_BOOKS
SynonymPO_DISTRIBUTIONS_ALL
SynonymPO_DOCUMENT_TYPES_ALL
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL
APPS.CE_PO_FC_ORDERS_TEMP_V is referenced by following:

SchemaAPPS
Package BodyCE_CSH_FCST_POP - show dependent code
ViewCE_FC_POP_DISC_V