VIEW: APPS.MST_CARRIER_FAC_CALENDAR_V

Source

View Text - Preformatted

SELECT car.carrier_id, decode(wassg.VENDOR_ID, NULL, decode(wassg.CUSTOMER_ID, NULL, wassg.ORGANIZATION_ID, wassg.CUSTOMER_ID), wassg.VENDOR_ID) TPId, decode(wassg.VENDOR_ID, NULL , decode(wassg.CUSTOMER_ID, NULL,decode(wassg.ORGANIZATION_ID,null, null,1),2 ), 4 ) TPType, wassg.LOCATION_ID LocationId, wassg.CALENDAR_CODE ReceivingCalendar, wassg.CALENDAR_CODE ShippingCalendar FROM wsh_Calendar_Assignments wassg, wsh_carriers car WHERE car.FREIGHT_CODE = wassg.FREIGHT_CODE and wassg.CALENDAR_TYPE = 'CARRIER' and enabled_flag = 'Y' and wassg.ASSOCIATION_TYPE in ('ORGANIZATION','HR_LOCATION','VENDOR','VENDOR_SITE','CUSTOMER', 'CUSTOMER_SITE') GROUP BY car.carrier_id,wassg.VENDOR_ID,wassg.CUSTOMER_ID, wassg.ORGANIZATION_ID,wassg.LOCATION_ID, wassg.CALENDAR_CODE

View Text - HTML Formatted

SELECT CAR.CARRIER_ID
, DECODE(WASSG.VENDOR_ID
, NULL
, DECODE(WASSG.CUSTOMER_ID
, NULL
, WASSG.ORGANIZATION_ID
, WASSG.CUSTOMER_ID)
, WASSG.VENDOR_ID) TPID
, DECODE(WASSG.VENDOR_ID
, NULL
, DECODE(WASSG.CUSTOMER_ID
, NULL
, DECODE(WASSG.ORGANIZATION_ID
, NULL
, NULL
, 1)
, 2 )
, 4 ) TPTYPE
, WASSG.LOCATION_ID LOCATIONID
, WASSG.CALENDAR_CODE RECEIVINGCALENDAR
, WASSG.CALENDAR_CODE SHIPPINGCALENDAR
FROM WSH_CALENDAR_ASSIGNMENTS WASSG
, WSH_CARRIERS CAR
WHERE CAR.FREIGHT_CODE = WASSG.FREIGHT_CODE
AND WASSG.CALENDAR_TYPE = 'CARRIER'
AND ENABLED_FLAG = 'Y'
AND WASSG.ASSOCIATION_TYPE IN ('ORGANIZATION'
, 'HR_LOCATION'
, 'VENDOR'
, 'VENDOR_SITE'
, 'CUSTOMER'
, 'CUSTOMER_SITE') GROUP BY CAR.CARRIER_ID
, WASSG.VENDOR_ID
, WASSG.CUSTOMER_ID
, WASSG.ORGANIZATION_ID
, WASSG.LOCATION_ID
, WASSG.CALENDAR_CODE