VIEW: MSC.MSC_ST_ITEM_CATEGORIES#

Source

View Text - Preformatted

select INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, SR_CATEGORY_SET_ID SR_CATEGORY_SET_ID, SR_CATEGORY_ID SR_CATEGORY_ID, CATEGORY_NAME CATEGORY_NAME, DESCRIPTION DESCRIPTION, DISABLE_DATE DISABLE_DATE, SUMMARY_FLAG SUMMARY_FLAG, ENABLED_FLAG ENABLED_FLAG, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, CATEGORY_SET_NAME CATEGORY_SET_NAME, 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, COMPANY_ID COMPANY_ID, COMPANY_NAME COMPANY_NAME, ITEM_NAME ITEM_NAME, ORGANIZATION_CODE ORGANIZATION_CODE, SR_INSTANCE_CODE SR_INSTANCE_CODE, MESSAGE_ID MESSAGE_ID, PROCESS_FLAG PROCESS_FLAG, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, ST_TRANSACTION_ID ST_TRANSACTION_ID, BATCH_ID BATCH_ID, ERROR_TEXT ERROR_TEXT, SOURCE_ORG_ID SOURCE_ORG_ID, SOURCE_INVENTORY_ITEM_ID SOURCE_INVENTORY_ITEM_ID, SOURCE_SR_CATEGORY_SET_ID SOURCE_SR_CATEGORY_SET_ID, SOURCE_SR_CATEGORY_ID SOURCE_SR_CATEGORY_ID from "MSC"."MSC_ST_ITEM_CATEGORIES"

View Text - HTML Formatted

SELECT INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SR_CATEGORY_SET_ID SR_CATEGORY_SET_ID
, SR_CATEGORY_ID SR_CATEGORY_ID
, CATEGORY_NAME CATEGORY_NAME
, DESCRIPTION DESCRIPTION
, DISABLE_DATE DISABLE_DATE
, SUMMARY_FLAG SUMMARY_FLAG
, ENABLED_FLAG ENABLED_FLAG
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, CATEGORY_SET_NAME CATEGORY_SET_NAME
, 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
, COMPANY_ID COMPANY_ID
, COMPANY_NAME COMPANY_NAME
, ITEM_NAME ITEM_NAME
, ORGANIZATION_CODE ORGANIZATION_CODE
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, MESSAGE_ID MESSAGE_ID
, PROCESS_FLAG PROCESS_FLAG
, DATA_SOURCE_TYPE DATA_SOURCE_TYPE
, ST_TRANSACTION_ID ST_TRANSACTION_ID
, BATCH_ID BATCH_ID
, ERROR_TEXT ERROR_TEXT
, SOURCE_ORG_ID SOURCE_ORG_ID
, SOURCE_INVENTORY_ITEM_ID SOURCE_INVENTORY_ITEM_ID
, SOURCE_SR_CATEGORY_SET_ID SOURCE_SR_CATEGORY_SET_ID
, SOURCE_SR_CATEGORY_ID SOURCE_SR_CATEGORY_ID
FROM "MSC"."MSC_ST_ITEM_CATEGORIES"