VIEW: MSC.MSC_ST_PROJECT_TASKS#

Source

View Text - Preformatted

select PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, ORGANIZATION_ID ORGANIZATION_ID, TASK_NUMBER TASK_NUMBER, TASK_NAME TASK_NAME, DESCRIPTION DESCRIPTION, MANAGER MANAGER, START_DATE START_DATE, END_DATE END_DATE, 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, MANAGER_CONTACT MANAGER_CONTACT, COMPANY_ID COMPANY_ID, COMPANY_NAME COMPANY_NAME, PROJECT_NUMBER PROJECT_NUMBER, COSTING_GROUP_ID COSTING_GROUP_ID, COSTING_GROUP_CODE COSTING_GROUP_CODE, SEIBAN_NUMBER_FLAG SEIBAN_NUMBER_FLAG, PROJECT_DESCRIPTION PROJECT_DESCRIPTION, PLANNING_GROUP PLANNING_GROUP, WIP_ACCT_CLASS_CODE WIP_ACCT_CLASS_CODE, PROJECT_START_DATE PROJECT_START_DATE, PROJECT_COMPLETION_DATE PROJECT_COMPLETION_DATE, MATERIAL_ACCOUNT MATERIAL_ACCOUNT, ORGANIZATION_CODE ORGANIZATION_CODE, SR_INSTANCE_CODE SR_INSTANCE_CODE, MESSAGE_ID MESSAGE_ID, PROCESS_FLAG PROCESS_FLAG, ERROR_TEXT ERROR_TEXT, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, ST_TRANSACTION_ID ST_TRANSACTION_ID, BATCH_ID BATCH_ID, SOURCE_ORG_ID SOURCE_ORG_ID, SOURCE_PROJECT_ID SOURCE_PROJECT_ID, SOURCE_TASK_ID SOURCE_TASK_ID, SOURCE_COSTING_GROUP_ID SOURCE_COSTING_GROUP_ID from "MSC"."MSC_ST_PROJECT_TASKS"

View Text - HTML Formatted

SELECT PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, ORGANIZATION_ID ORGANIZATION_ID
, TASK_NUMBER TASK_NUMBER
, TASK_NAME TASK_NAME
, DESCRIPTION DESCRIPTION
, MANAGER MANAGER
, START_DATE START_DATE
, END_DATE END_DATE
, 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
, MANAGER_CONTACT MANAGER_CONTACT
, COMPANY_ID COMPANY_ID
, COMPANY_NAME COMPANY_NAME
, PROJECT_NUMBER PROJECT_NUMBER
, COSTING_GROUP_ID COSTING_GROUP_ID
, COSTING_GROUP_CODE COSTING_GROUP_CODE
, SEIBAN_NUMBER_FLAG SEIBAN_NUMBER_FLAG
, PROJECT_DESCRIPTION PROJECT_DESCRIPTION
, PLANNING_GROUP PLANNING_GROUP
, WIP_ACCT_CLASS_CODE WIP_ACCT_CLASS_CODE
, PROJECT_START_DATE PROJECT_START_DATE
, PROJECT_COMPLETION_DATE PROJECT_COMPLETION_DATE
, MATERIAL_ACCOUNT MATERIAL_ACCOUNT
, ORGANIZATION_CODE ORGANIZATION_CODE
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, MESSAGE_ID MESSAGE_ID
, PROCESS_FLAG PROCESS_FLAG
, ERROR_TEXT ERROR_TEXT
, DATA_SOURCE_TYPE DATA_SOURCE_TYPE
, ST_TRANSACTION_ID ST_TRANSACTION_ID
, BATCH_ID BATCH_ID
, SOURCE_ORG_ID SOURCE_ORG_ID
, SOURCE_PROJECT_ID SOURCE_PROJECT_ID
, SOURCE_TASK_ID SOURCE_TASK_ID
, SOURCE_COSTING_GROUP_ID SOURCE_COSTING_GROUP_ID
FROM "MSC"."MSC_ST_PROJECT_TASKS"