VIEW: PA.PA_OBJECTS#

Source

View Text - Preformatted

select OBJECT_ID OBJECT_ID, OBJECT_TYPE_CODE OBJECT_TYPE_CODE, BALANCE_TYPE_CODE BALANCE_TYPE_CODE, PROJECT_ORG_ID PROJECT_ORG_ID, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, PERSON_ID PERSON_ID, ASSIGNMENT_ID ASSIGNMENT_ID, WORK_TYPE_ID WORK_TYPE_ID, ORG_UTIL_CATEGORY_ID ORG_UTIL_CATEGORY_ID, RES_UTIL_CATEGORY_ID RES_UTIL_CATEGORY_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, EXPENDITURE_TYPE_CLASS EXPENDITURE_TYPE_CLASS, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE from "PA"."PA_OBJECTS"

View Text - HTML Formatted

SELECT OBJECT_ID OBJECT_ID
, OBJECT_TYPE_CODE OBJECT_TYPE_CODE
, BALANCE_TYPE_CODE BALANCE_TYPE_CODE
, PROJECT_ORG_ID PROJECT_ORG_ID
, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, PERSON_ID PERSON_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, WORK_TYPE_ID WORK_TYPE_ID
, ORG_UTIL_CATEGORY_ID ORG_UTIL_CATEGORY_ID
, RES_UTIL_CATEGORY_ID RES_UTIL_CATEGORY_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, EXPENDITURE_TYPE_CLASS EXPENDITURE_TYPE_CLASS
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM "PA"."PA_OBJECTS"