DBA Data[Home] [Help]

VIEW: MSC.MSC_CALENDAR_ASSIGNMENTS#

Source

View Text - Preformatted

select ASSOCIATION_TYPE ASSOCIATION_TYPE, CALENDAR_CODE CALENDAR_CODE, CALENDAR_TYPE CALENDAR_TYPE, PARTNER_ID PARTNER_ID, PARTNER_SITE_ID PARTNER_SITE_ID, ORGANIZATION_ID ORGANIZATION_ID, SR_INSTANCE_ID SR_INSTANCE_ID, CARRIER_PARTNER_ID CARRIER_PARTNER_ID, PARTNER_TYPE PARTNER_TYPE, ASSOCIATION_LEVEL ASSOCIATION_LEVEL, SHIP_METHOD_CODE SHIP_METHOD_CODE, REFRESH_NUMBER REFRESH_NUMBER, 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 from "MSC"."MSC_CALENDAR_ASSIGNMENTS"
View Text - HTML Formatted

SELECT ASSOCIATION_TYPE ASSOCIATION_TYPE
, CALENDAR_CODE CALENDAR_CODE
, CALENDAR_TYPE CALENDAR_TYPE
, PARTNER_ID PARTNER_ID
, PARTNER_SITE_ID PARTNER_SITE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, CARRIER_PARTNER_ID CARRIER_PARTNER_ID
, PARTNER_TYPE PARTNER_TYPE
, ASSOCIATION_LEVEL ASSOCIATION_LEVEL
, SHIP_METHOD_CODE SHIP_METHOD_CODE
, REFRESH_NUMBER REFRESH_NUMBER
, 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
FROM "MSC"."MSC_CALENDAR_ASSIGNMENTS"