VIEW: CRP.CRP_RESOURCE_PLAN#

Source

View Text - Preformatted

select TRANSACTION_ID TRANSACTION_ID, 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, DEPARTMENT_ID DEPARTMENT_ID, RESOURCE_ID RESOURCE_ID, ORGANIZATION_ID ORGANIZATION_ID, DESIGNATOR DESIGNATOR, SOURCE_TRANSACTION_ID SOURCE_TRANSACTION_ID, ASSEMBLY_ITEM_ID ASSEMBLY_ITEM_ID, SOURCE_ITEM_ID SOURCE_ITEM_ID, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, RESOURCE_DATE RESOURCE_DATE, RESOURCE_SEQ_NUM RESOURCE_SEQ_NUM, RESOURCE_HOURS RESOURCE_HOURS, REPETITIVE_TYPE REPETITIVE_TYPE, SUPPLY_TYPE SUPPLY_TYPE, RESOURCE_END_DATE RESOURCE_END_DATE, DAILY_RESOURCE_HOURS DAILY_RESOURCE_HOURS, LOAD_RATE LOAD_RATE, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE from "CRP"."CRP_RESOURCE_PLAN"

View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, 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
, DEPARTMENT_ID DEPARTMENT_ID
, RESOURCE_ID RESOURCE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, DESIGNATOR DESIGNATOR
, SOURCE_TRANSACTION_ID SOURCE_TRANSACTION_ID
, ASSEMBLY_ITEM_ID ASSEMBLY_ITEM_ID
, SOURCE_ITEM_ID SOURCE_ITEM_ID
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, RESOURCE_DATE RESOURCE_DATE
, RESOURCE_SEQ_NUM RESOURCE_SEQ_NUM
, RESOURCE_HOURS RESOURCE_HOURS
, REPETITIVE_TYPE REPETITIVE_TYPE
, SUPPLY_TYPE SUPPLY_TYPE
, RESOURCE_END_DATE RESOURCE_END_DATE
, DAILY_RESOURCE_HOURS DAILY_RESOURCE_HOURS
, LOAD_RATE LOAD_RATE
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM "CRP"."CRP_RESOURCE_PLAN"