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


VIEW: APPS.ICX_EDM_PURCHASE_ORDER_V

Object Details
Object Name: ICX_EDM_PURCHASE_ORDER_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewICX.ICX_EDM_PURCHASE_ORDER_V
Subobject Name:
Status: VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


The ICX_EDM_PURCHASE_ORDER_V view returns purchase order information
that are linked to a project / task.
.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER

Project / Seiban unique identifier
TASK_ID NUMBER

Task unique identifier
PROJECT_NUMBER VARCHAR2 (4000)
Project / Seiban number
TASK_NUMBER VARCHAR2 (4000)
Task number
PO_NUMBER VARCHAR2 (61)
Purchase order number
DOCUMENT_TYPE VARCHAR2 (80)
Document type
AUTHORIZATION_STATUS VARCHAR2 (80)
Authorization status
ORDER_DATE DATE

Purchase order date
PRINTED_DATE DATE

Date document was last printed
REVISION_NUMBER NUMBER

Revision number
REVISED_DATE DATE

Date document was last revised
AMOUNT VARCHAR2 (4000)
Purchase amount
CURRENCY VARCHAR2 (4000)
Currency
BUYER VARCHAR2 (4000)
Buyer employee name
SUPPLIER VARCHAR2 (240)
Supplier name
SUPPLIER_CONTACT VARCHAR2 (32)
Supplier contant name
SUPPLIER_SITE VARCHAR2 (15)
Supplier site
SUPPLIER_URL VARCHAR2 (150)
Supplier Web URL
FOB VARCHAR2 (80)
Free-on-board terms
TERMS VARCHAR2 (50)
Payment terms
FREIGHT_TERMS VARCHAR2 (80)
Freight terms
CLOSURE_STATUS VARCHAR2 (80)
Closure status
PO_RELEASE_NUMBER NUMBER

Purchase release number
SHIP_TO_LOCATION VARCHAR2 (60)
Ship-to location
SHIP_VIA VARCHAR2 (25)
Freight carrier
BILL_TO_LOCATION VARCHAR2 (60)
Bill-to location
PO_HEADER_ID NUMBER

Purchase order header unique identifier
BUYER_ID NUMBER (9)
Buyer employee unique identifier
SUPPLIER_ID NUMBER

Supplier unique identifier
SUPPLIER_CONTACT_ID NUMBER

Supplier contact unique identifier
SUPPLIER_SITE_ID NUMBER

Supplier site unique identifier
TERMS_ID NUMBER

Payment terms unique identifier
BILL_TO_LOCATION_ID NUMBER

Bill-to location unique identifier
SHIP_TO_LOCATION_ID NUMBER

Ship-to location unique identifier
PO_RELEASE_ID NUMBER

Purchase release unique identifier
Query Text

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


SELECT PROJECT_ID
,      TASK_ID
,      PROJECT_NUMBER
,      TASK_NUMBER
,      PO_NUMBER
,      DOCUMENT_TYPE
,      AUTHORIZATION_STATUS
,      ORDER_DATE
,      PRINTED_DATE
,      REVISION_NUMBER
,      REVISED_DATE
,      AMOUNT
,      CURRENCY
,      BUYER
,      SUPPLIER
,      SUPPLIER_CONTACT
,      SUPPLIER_SITE
,      SUPPLIER_URL
,      FOB
,      TERMS
,      FREIGHT_TERMS
,      CLOSURE_STATUS
,      PO_RELEASE_NUMBER
,      SHIP_TO_LOCATION
,      SHIP_VIA
,      BILL_TO_LOCATION
,      PO_HEADER_ID
,      BUYER_ID
,      SUPPLIER_ID
,      SUPPLIER_CONTACT_ID
,      SUPPLIER_SITE_ID
,      TERMS_ID
,      BILL_TO_LOCATION_ID
,      SHIP_TO_LOCATION_ID
,      PO_RELEASE_ID
FROM APPS.ICX_EDM_PURCHASE_ORDER_V;

Dependencies

[top of page]

APPS.ICX_EDM_PURCHASE_ORDER_V references the following:

SchemaAPPS
SynonymAP_TERMS
PL/SQL PackageFND_CURRENCY - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
PL/SQL PackageMRP_GET_PROJECT - show dependent code
SynonymPO_DISTRIBUTIONS_ALL
SynonymPO_DOCUMENT_TYPES_ALL
SynonymPO_HEADERS_ALL
PL/SQL PackagePO_INQ_SV - show dependent code
ViewPO_LOOKUP_CODES
SynonymPO_RELEASES_ALL
PL/SQL PackagePO_TOTALS_PO_SV - show dependent code
ViewPO_VENDORS
ViewPO_VENDOR_CONTACTS
ViewPO_VENDOR_SITES_ALL

APPS.ICX_EDM_PURCHASE_ORDER_V is not referenced by any database object