VIEW: MSC.MSC_ST_PROJECTS#

Source

View Text - Preformatted

select PROJECT_ID PROJECT_ID, ORGANIZATION_ID ORGANIZATION_ID, PLANNING_GROUP PLANNING_GROUP, COSTING_GROUP_ID COSTING_GROUP_ID, WIP_ACCT_CLASS_CODE WIP_ACCT_CLASS_CODE, SEIBAN_NUMBER_FLAG SEIBAN_NUMBER_FLAG, PROJECT_NAME PROJECT_NAME, PROJECT_NUMBER PROJECT_NUMBER, PROJECT_NUMBER_SORT_ORDER PROJECT_NUMBER_SORT_ORDER, PROJECT_DESCRIPTION PROJECT_DESCRIPTION, START_DATE START_DATE, COMPLETION_DATE COMPLETION_DATE, OPERATING_UNIT OPERATING_UNIT, DELETED_FLAG DELETED_FLAG, 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, SR_INSTANCE_ID SR_INSTANCE_ID, REFRESH_ID REFRESH_ID, MATERIAL_ACCOUNT MATERIAL_ACCOUNT, MANAGER_CONTACT MANAGER_CONTACT from "MSC"."MSC_ST_PROJECTS"

View Text - HTML Formatted

SELECT PROJECT_ID PROJECT_ID
, ORGANIZATION_ID ORGANIZATION_ID
, PLANNING_GROUP PLANNING_GROUP
, COSTING_GROUP_ID COSTING_GROUP_ID
, WIP_ACCT_CLASS_CODE WIP_ACCT_CLASS_CODE
, SEIBAN_NUMBER_FLAG SEIBAN_NUMBER_FLAG
, PROJECT_NAME PROJECT_NAME
, PROJECT_NUMBER PROJECT_NUMBER
, PROJECT_NUMBER_SORT_ORDER PROJECT_NUMBER_SORT_ORDER
, PROJECT_DESCRIPTION PROJECT_DESCRIPTION
, START_DATE START_DATE
, COMPLETION_DATE COMPLETION_DATE
, OPERATING_UNIT OPERATING_UNIT
, DELETED_FLAG DELETED_FLAG
, 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
, SR_INSTANCE_ID SR_INSTANCE_ID
, REFRESH_ID REFRESH_ID
, MATERIAL_ACCOUNT MATERIAL_ACCOUNT
, MANAGER_CONTACT MANAGER_CONTACT
FROM "MSC"."MSC_ST_PROJECTS"