VIEW: PA.PA_BC_BALANCES#

Source

View Text - Preformatted

select PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, BUDGET_VERSION_ID BUDGET_VERSION_ID, BALANCE_TYPE BALANCE_TYPE, START_DATE START_DATE, END_DATE END_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, TOP_TASK_ID TOP_TASK_ID, PARENT_MEMBER_ID PARENT_MEMBER_ID, REQUEST_ID REQUEST_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PERIOD_NAME PERIOD_NAME, ACTUAL_PERIOD_TO_DATE ACTUAL_PERIOD_TO_DATE, BUDGET_PERIOD_TO_DATE BUDGET_PERIOD_TO_DATE, ENCUMB_PERIOD_TO_DATE ENCUMB_PERIOD_TO_DATE from "PA"."PA_BC_BALANCES"

View Text - HTML Formatted

SELECT PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, BUDGET_VERSION_ID BUDGET_VERSION_ID
, BALANCE_TYPE BALANCE_TYPE
, START_DATE START_DATE
, END_DATE END_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TOP_TASK_ID TOP_TASK_ID
, PARENT_MEMBER_ID PARENT_MEMBER_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PERIOD_NAME PERIOD_NAME
, ACTUAL_PERIOD_TO_DATE ACTUAL_PERIOD_TO_DATE
, BUDGET_PERIOD_TO_DATE BUDGET_PERIOD_TO_DATE
, ENCUMB_PERIOD_TO_DATE ENCUMB_PERIOD_TO_DATE
FROM "PA"."PA_BC_BALANCES"