VIEW: MSC.MSC_INSTANCE_ORGS#

Source

View Text - Preformatted

select SR_INSTANCE_ID SR_INSTANCE_ID, ORGANIZATION_ID ORGANIZATION_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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ENABLED_FLAG ENABLED_FLAG, ORG_GROUP ORG_GROUP, SUPPLIER_CAPACITY_LRN SUPPLIER_CAPACITY_LRN, BOM_LRN BOM_LRN, BOR_LRN BOR_LRN, FORECAST_LRN FORECAST_LRN, ITEM_LRN ITEM_LRN, MDS_LRN MDS_LRN, MPS_LRN MPS_LRN, OH_LRN OH_LRN, RESERVATIONS_LRN RESERVATIONS_LRN, PO_LRN PO_LRN, SO_LRN SO_LRN, USER_SUPPLY_DEMAND_LRN USER_SUPPLY_DEMAND_LRN, WIP_LRN WIP_LRN, NRA_LRN NRA_LRN, SAF_STOCK_LRN SAF_STOCK_LRN, UNIT_NO_LRN UNIT_NO_LRN, UOM_LRN UOM_LRN, CALENDAR_LRN CALENDAR_LRN, TRIP_LRN TRIP_LRN, ORG_LRN ORG_LRN, DP_ENABLED_FLAG DP_ENABLED_FLAG, LAST_SUCC_ASL_REF_TIME LAST_SUCC_ASL_REF_TIME, LAST_SUCC_ITEM_REF_TIME LAST_SUCC_ITEM_REF_TIME, ERO_LRN ERO_LRN, IRO_LRN IRO_LRN, LAST_SUCC_IRO_REF_TIME LAST_SUCC_IRO_REF_TIME, LAST_SUCC_RES_REF_TIME LAST_SUCC_RES_REF_TIME, ORGANIZATION_TYPE ORGANIZATION_TYPE from "MSC"."MSC_INSTANCE_ORGS"

View Text - HTML Formatted

SELECT SR_INSTANCE_ID SR_INSTANCE_ID
, ORGANIZATION_ID ORGANIZATION_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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ENABLED_FLAG ENABLED_FLAG
, ORG_GROUP ORG_GROUP
, SUPPLIER_CAPACITY_LRN SUPPLIER_CAPACITY_LRN
, BOM_LRN BOM_LRN
, BOR_LRN BOR_LRN
, FORECAST_LRN FORECAST_LRN
, ITEM_LRN ITEM_LRN
, MDS_LRN MDS_LRN
, MPS_LRN MPS_LRN
, OH_LRN OH_LRN
, RESERVATIONS_LRN RESERVATIONS_LRN
, PO_LRN PO_LRN
, SO_LRN SO_LRN
, USER_SUPPLY_DEMAND_LRN USER_SUPPLY_DEMAND_LRN
, WIP_LRN WIP_LRN
, NRA_LRN NRA_LRN
, SAF_STOCK_LRN SAF_STOCK_LRN
, UNIT_NO_LRN UNIT_NO_LRN
, UOM_LRN UOM_LRN
, CALENDAR_LRN CALENDAR_LRN
, TRIP_LRN TRIP_LRN
, ORG_LRN ORG_LRN
, DP_ENABLED_FLAG DP_ENABLED_FLAG
, LAST_SUCC_ASL_REF_TIME LAST_SUCC_ASL_REF_TIME
, LAST_SUCC_ITEM_REF_TIME LAST_SUCC_ITEM_REF_TIME
, ERO_LRN ERO_LRN
, IRO_LRN IRO_LRN
, LAST_SUCC_IRO_REF_TIME LAST_SUCC_IRO_REF_TIME
, LAST_SUCC_RES_REF_TIME LAST_SUCC_RES_REF_TIME
, ORGANIZATION_TYPE ORGANIZATION_TYPE
FROM "MSC"."MSC_INSTANCE_ORGS"