[Home] [Help]
View: PA_BC_PROJECT_V
Product: | PA - Projects |
Description: | Base View for Budgetary Controls Form - Project Block |
Implementation/DBA Data: |
APPS.PA_BC_PROJECT_V
|
View Text
SELECT PABC.ROWID
, PA.SEGMENT1
, PA.NAME
, PABC.PROJECT_ID
, PABC.BUDGETARY_CONTROLS_ID
, PABC.FUNDS_CONTROL_LEVEL_CODE
, PABC.LAST_UPDATED_BY
, PABC.LAST_UPDATE_DATE
, PABC.CREATED_BY
, PABC.CREATION_DATE
, PABC.LAST_UPDATE_LOGIN
, PABC.BUDGET_TYPE_CODE
FROM PA_PROJECTS_ALL PA
, PA_BUDGETARY_CONTROLS PABC
WHERE PA.PROJECT_ID = PABC.PROJECT_ID
AND PABC.TASK_ID IS NULL
AND PABC.RESOURCE_LIST_MEMBER_ID IS NULL
Columns
Name |
ROW_ID |
PROJECT_NUMBER |
NAME |
PROJECT_ID |
BUDGETARY_CONTROLS_ID |
FUNDS_CONTROL_LEVEL_CODE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
CREATED_BY |
CREATION_DATE |
LAST_UPDATE_LOGIN |
BUDGET_TYPE_CODE |