VIEW: MSC.MSC_ST_RESOURCES_CUM_F#

Source

View Text - Preformatted

select ST_TRANSACTION_ID ST_TRANSACTION_ID, ERROR_CODE ERROR_CODE, SR_INSTANCE_ID SR_INSTANCE_ID, ORGANIZATION_ID ORGANIZATION_ID, DEPARTMENT_ID DEPARTMENT_ID, RESOURCE_ID RESOURCE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_CODE ORGANIZATION_CODE, DEPARTMENT_CODE DEPARTMENT_CODE, DEPARTMENT_CLASS DEPARTMENT_CLASS, RESOURCE_CODE RESOURCE_CODE, RESOURCE_GROUP_NAME RESOURCE_GROUP_NAME, ITEM_NAME ITEM_NAME, ANALYSIS_DATE ANALYSIS_DATE, CUM_NET_RESOURCE_AVAIL CUM_NET_RESOURCE_AVAIL, 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, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, REQUEST_ID REQUEST_ID from "MSC"."MSC_ST_RESOURCES_CUM_F"

View Text - HTML Formatted

SELECT ST_TRANSACTION_ID ST_TRANSACTION_ID
, ERROR_CODE ERROR_CODE
, SR_INSTANCE_ID SR_INSTANCE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, DEPARTMENT_ID DEPARTMENT_ID
, RESOURCE_ID RESOURCE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_CODE ORGANIZATION_CODE
, DEPARTMENT_CODE DEPARTMENT_CODE
, DEPARTMENT_CLASS DEPARTMENT_CLASS
, RESOURCE_CODE RESOURCE_CODE
, RESOURCE_GROUP_NAME RESOURCE_GROUP_NAME
, ITEM_NAME ITEM_NAME
, ANALYSIS_DATE ANALYSIS_DATE
, CUM_NET_RESOURCE_AVAIL CUM_NET_RESOURCE_AVAIL
, 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
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, REQUEST_ID REQUEST_ID
FROM "MSC"."MSC_ST_RESOURCES_CUM_F"