MSC_CALENDAR_ASSIGNMENTSRC

Details

Schema: FUSION
Object owner: MSC
Object type: VIEW

Columns

Name
ASSOCIATION_TYPE CALENDAR_CODE CALENDAR_TYPE PARTNER_ID PARTNER_SITE_ID ORGANIZATION_ID CARRIER_PARTNER_ID PARTNER_TYPE ASSOCIATION_LEVEL SHIP_METHOD_CODE SERVICE_LEVEL MODE_OF_TRANSPORT REFRESH_NUMBER LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN

Name

ASSOCIATION_TYPE

CALENDAR_CODE

CALENDAR_TYPE

PARTNER_ID

PARTNER_SITE_ID

ORGANIZATION_ID

CARRIER_PARTNER_ID

PARTNER_TYPE

ASSOCIATION_LEVEL

SHIP_METHOD_CODE

SERVICE_LEVEL

MODE_OF_TRANSPORT

REFRESH_NUMBER

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

Query

SQL_Statement
select "ASSOCIATION_TYPE","CALENDAR_CODE","CALENDAR_TYPE","PARTNER_ID","PARTNER_SITE_ID","ORGANIZATION_ID","CARRIER_PARTNER_ID","PARTNER_TYPE","ASSOCIATION_LEVEL","SHIP_METHOD_CODE","SERVICE_LEVEL","MODE_OF_TRANSPORT","REFRESH_NUMBER","LAST_UPDATE_DATE","LAST_UPDATED_BY","CREATION_DATE","CREATED_BY","LAST_UPDATE_LOGIN" from msc_calendar_assignments as of scn msc_coll_utils.get_last_read_cons_SCN(SYS_CONTEXT ('MSC', 'readscn'))

SQL_Statement

select "ASSOCIATION_TYPE","CALENDAR_CODE","CALENDAR_TYPE","PARTNER_ID","PARTNER_SITE_ID","ORGANIZATION_ID","CARRIER_PARTNER_ID","PARTNER_TYPE","ASSOCIATION_LEVEL","SHIP_METHOD_CODE","SERVICE_LEVEL","MODE_OF_TRANSPORT","REFRESH_NUMBER","LAST_UPDATE_DATE","LAST_UPDATED_BY","CREATION_DATE","CREATED_BY","LAST_UPDATE_LOGIN" from msc_calendar_assignments as of scn msc_coll_utils.get_last_read_cons_SCN(SYS_CONTEXT ('MSC', 'readscn'))