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


VIEW: APPS.ICX_EDM_PURCHASE_REQ_V

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

View Type

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


The ICX_EDM_PURCHASE_REQ_V view returns purchase requisitions 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
REQUISITION_NUMBER VARCHAR2 (20) Yes Purchase requisition number
TYPE VARCHAR2 (25)
Purchase requisition type
DESCRIPTION VARCHAR2 (240)
Purchase requisition description
CREATION_DATE DATE

Purchase requisition creation date
PREPARER VARCHAR2 (240)
Requisition prepaper name
TOTAL VARCHAR2 (4000)
Requisition amount
CURRENCY VARCHAR2 (15) Yes Currency
APPROVER VARCHAR2 (240)
Requisition approver name
APPROVAL_STATUS VARCHAR2 (80) Yes Approval status
CANCELLED VARCHAR2 (80) Yes Cancelled flag - currently not used
CLOSED VARCHAR2 (3)
Closure status
REQUISITION_HEADER_ID NUMBER
Yes Requisition header unique identifier
PREPARER_ID NUMBER (9) Yes Preparer employee unique identifier
APPROVER_ID NUMBER (9)
Approver employee unique identifier
Query Text

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


SELECT PROJECT_ID
,      TASK_ID
,      PROJECT_NUMBER
,      TASK_NUMBER
,      REQUISITION_NUMBER
,      TYPE
,      DESCRIPTION
,      CREATION_DATE
,      PREPARER
,      TOTAL
,      CURRENCY
,      APPROVER
,      APPROVAL_STATUS
,      CANCELLED
,      CLOSED
,      REQUISITION_HEADER_ID
,      PREPARER_ID
,      APPROVER_ID
FROM APPS.ICX_EDM_PURCHASE_REQ_V;

Dependencies

[top of page]

APPS.ICX_EDM_PURCHASE_REQ_V references the following:

SchemaAPPS
SynonymFINANCIALS_SYSTEM_PARAMETERS
PL/SQL PackageFND_CURRENCY - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
PL/SQL PackageFND_PROFILE - show dependent code
ViewGL_SETS_OF_BOOKS
ViewHR_EMPLOYEES
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
PL/SQL PackageMRP_GET_PROJECT - show dependent code
SynonymPO_ACTION_HISTORY
SynonymPO_DOCUMENT_TYPES_ALL
ViewPO_LOOKUP_CODES
SynonymPO_REQUISITION_HEADERS_ALL
PL/SQL PackagePO_REQUISITION_HEADERS_PKG - show dependent code
SynonymPO_REQUISITION_LINES_ALL
SynonymPO_REQ_DISTRIBUTIONS_ALL

APPS.ICX_EDM_PURCHASE_REQ_V is not referenced by any database object