[Home] [Help]
View: AP_WEB_PA_PROJECTS_V
Product: | AP - Payables |
Description: | The Project number list of values in Oracle Internet Expenses is based on this view |
Implementation/DBA Data: |
APPS.AP_WEB_PA_PROJECTS_V
|
View Text
SELECT PROJECT_ID
, PROJECT_NUMBER
, PROJECT_NAME
, PROJECT_DESCRIPTION
, START_DATE
, COMPLETION_DATE
, PROJECT_TYPE
, CARRYING_OUT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID
, O.NAME PROJECT_ORGANIZATION_NAME
, PROJECT_TYPE_CLASS_CODE FROM PA_PROJECTS_EXPEND_V P
, HR_ORGANIZATION_UNITS O
WHERE P.CARRYING_OUT_ORGANIZATION_ID = O.ORGANIZATION_ID
Columns
Name |
PROJECT_ID |
PROJECT_NUMBER |
PROJECT_NAME |
PROJECT_DESCRIPTION |
START_DATE |
COMPLETION_DATE |
PROJECT_TYPE |
PROJECT_ORGANIZATION_ID |
PROJECT_ORGANIZATION_NAME |
PROJECT_TYPE_CLASS_CODE |