DBA Data[Home] [Help]

VIEW: APPS.PA_BUDGETARY_CONTROL_TASK_V

Source

View Text - Preformatted

SELECT PABC.ROWID, PAT.TASK_NUMBER , PAT.TASK_NAME , PABC.PROJECT_ID , PABC.TASK_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.RESOURCE_LIST_MEMBER_ID, PABC.BUDGET_TYPE_CODE FROM PA_TASKS PAT , PA_BUDGETARY_CONTROLS PABC WHERE PAT.TASK_ID = PABC.TASK_ID AND PAT.PROJECT_ID = PABC.PROJECT_ID
View Text - HTML Formatted

SELECT PABC.ROWID
, PAT.TASK_NUMBER
, PAT.TASK_NAME
, PABC.PROJECT_ID
, PABC.TASK_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.RESOURCE_LIST_MEMBER_ID
, PABC.BUDGET_TYPE_CODE
FROM PA_TASKS PAT
, PA_BUDGETARY_CONTROLS PABC
WHERE PAT.TASK_ID = PABC.TASK_ID
AND PAT.PROJECT_ID = PABC.PROJECT_ID