VIEW: APPS.WSH_CAL_ASG_MASTER_V

Source

View Text - Preformatted

SELECT POV.VENDOR_NAME ,POV.SEGMENT1, POV.VENDOR_ID , WCA.ASSOCIATION_TYPE , NULL , WCA.CALENDAR_CODE , WCA.CALENDAR_TYPE , WCA.CALENDAR_ASSIGNMENT_ID , WCA.FREIGHT_CODE , WCA.FREIGHT_ORG_ID , NULL, WCA.ATTRIBUTE_CATEGORY , WCA.ATTRIBUTE1 , WCA.ATTRIBUTE2 , WCA.ATTRIBUTE3 , WCA.ATTRIBUTE4 , WCA.ATTRIBUTE5 , WCA.ATTRIBUTE6 , WCA.ATTRIBUTE7 , WCA.ATTRIBUTE8 , WCA.ATTRIBUTE9 , WCA.ATTRIBUTE10 , WCA.ATTRIBUTE11 , WCA.ATTRIBUTE12 , WCA.ATTRIBUTE13 , WCA.ATTRIBUTE14 ,WCA.ATTRIBUTE15 , WCA.CREATION_DATE , WCA.CREATED_BY , WCA.LAST_UPDATE_DATE ,WCA.LAST_UPDATED_BY , WCA.LAST_UPDATE_LOGIN FROM WSH_CALENDAR_ASSIGNMENTS WCA , PO_VENDORS POV WHERE WCA.ASSOCIATION_TYPE = 'VENDOR' AND WCA.VENDOR_ID = POV.VENDOR_ID UNION SELECT substrb ( party.party_name, 1, 50 ) /* customer_name */, cust_acct.account_number, cust_acct.cust_account_id, wca.association_type , null , wca.calendar_code , wca.calendar_type , wca.calendar_assignment_id , wca.freight_code , wca.freight_org_id , null, wca.attribute_category , wca.attribute1 , wca.attribute2 , wca.attribute3 , wca.attribute4 , wca.attribute5 , wca.attribute6 , wca.attribute7 , wca.attribute8 , wca.attribute9 , wca.attribute10 , wca.attribute11 , wca.attribute12 , wca.attribute13 , wca.attribute14 , wca.attribute15, WCA.CREATION_DATE, WCA.CREATED_BY, WCA.LAST_UPDATE_DATE, WCA.LAST_UPDATED_BY, WCA.LAST_UPDATE_LOGIN FROM wsh_calendar_assignments wca , hz_parties party, hz_cust_accounts cust_acct WHERE wca.association_type = 'CUSTOMER' and cust_acct.party_id = party.party_id and wca.customer_id = cust_acct.cust_account_id UNION SELECT PARTY.PARTY_NAME , PARTY.PARTY_NUMBER, WCA.CARRIER_ID , WCA.ASSOCIATION_TYPE , NULL, WCA.CALENDAR_CODE , WCA.CALENDAR_TYPE , WCA.CALENDAR_ASSIGNMENT_ID , NULL, -1, NULL, WCA.ATTRIBUTE_CATEGORY , WCA.ATTRIBUTE1 , WCA.ATTRIBUTE2 , WCA.ATTRIBUTE3 , WCA.ATTRIBUTE4 , WCA.ATTRIBUTE5 , WCA.ATTRIBUTE6 , WCA.ATTRIBUTE7 , WCA.ATTRIBUTE8 , WCA.ATTRIBUTE9 , WCA.ATTRIBUTE10 , WCA.ATTRIBUTE11 , WCA.ATTRIBUTE12 , WCA.ATTRIBUTE13 , WCA.ATTRIBUTE14 , WCA.ATTRIBUTE15, WCA.CREATION_DATE, WCA.CREATED_BY, WCA.LAST_UPDATE_DATE, WCA.LAST_UPDATED_BY, WCA.LAST_UPDATE_LOGIN FROM WSH_CALENDAR_ASSIGNMENTS WCA , WSH_CARRIERS WCR, HZ_PARTIES PARTY WHERE WCA.ASSOCIATION_TYPE = 'CARRIER' AND WCA.CARRIER_ID = WCR.CARRIER_ID AND WCA.CARRIER_ID = PARTY.PARTY_ID UNION SELECT HROU.NAME , MP.ORGANIZATION_CODE, HROU.ORGANIZATION_ID , WCA.ASSOCIATION_TYPE , NULL , WCA.CALENDAR_CODE , WCA.CALENDAR_TYPE , WCA.CALENDAR_ASSIGNMENT_ID , WCA.FREIGHT_CODE , WCA.FREIGHT_ORG_ID , NULL, WCA.ATTRIBUTE_CATEGORY , WCA.ATTRIBUTE1 , WCA.ATTRIBUTE2 , WCA.ATTRIBUTE3 , WCA.ATTRIBUTE4 , WCA.ATTRIBUTE5 , WCA.ATTRIBUTE6 , WCA.ATTRIBUTE7 , WCA.ATTRIBUTE8 , WCA.ATTRIBUTE9 , WCA.ATTRIBUTE10 , WCA.ATTRIBUTE11 , WCA.ATTRIBUTE12 , WCA.ATTRIBUTE13 , WCA.ATTRIBUTE14 , WCA.ATTRIBUTE15, WCA.CREATION_DATE, WCA.CREATED_BY, WCA.LAST_UPDATE_DATE, WCA.LAST_UPDATED_BY, WCA.LAST_UPDATE_LOGIN FROM WSH_CALENDAR_ASSIGNMENTS WCA , HR_ORGANIZATION_UNITS HROU, MTL_PARAMETERS MP WHERE WCA.ASSOCIATION_TYPE = 'ORGANIZATION' AND WCA.ORGANIZATION_ID = HROU.ORGANIZATION_ID AND HROU.ORGANIZATION_ID = MP.ORGANIZATION_ID

View Text - HTML Formatted

SELECT POV.VENDOR_NAME
, POV.SEGMENT1
, POV.VENDOR_ID
, WCA.ASSOCIATION_TYPE
, NULL
, WCA.CALENDAR_CODE
, WCA.CALENDAR_TYPE
, WCA.CALENDAR_ASSIGNMENT_ID
, WCA.FREIGHT_CODE
, WCA.FREIGHT_ORG_ID
, NULL
, WCA.ATTRIBUTE_CATEGORY
, WCA.ATTRIBUTE1
, WCA.ATTRIBUTE2
, WCA.ATTRIBUTE3
, WCA.ATTRIBUTE4
, WCA.ATTRIBUTE5
, WCA.ATTRIBUTE6
, WCA.ATTRIBUTE7
, WCA.ATTRIBUTE8
, WCA.ATTRIBUTE9
, WCA.ATTRIBUTE10
, WCA.ATTRIBUTE11
, WCA.ATTRIBUTE12
, WCA.ATTRIBUTE13
, WCA.ATTRIBUTE14
, WCA.ATTRIBUTE15
, WCA.CREATION_DATE
, WCA.CREATED_BY
, WCA.LAST_UPDATE_DATE
, WCA.LAST_UPDATED_BY
, WCA.LAST_UPDATE_LOGIN
FROM WSH_CALENDAR_ASSIGNMENTS WCA
, PO_VENDORS POV
WHERE WCA.ASSOCIATION_TYPE = 'VENDOR'
AND WCA.VENDOR_ID = POV.VENDOR_ID UNION SELECT SUBSTRB ( PARTY.PARTY_NAME
, 1
, 50 ) /* CUSTOMER_NAME */
, CUST_ACCT.ACCOUNT_NUMBER
, CUST_ACCT.CUST_ACCOUNT_ID
, WCA.ASSOCIATION_TYPE
, NULL
, WCA.CALENDAR_CODE
, WCA.CALENDAR_TYPE
, WCA.CALENDAR_ASSIGNMENT_ID
, WCA.FREIGHT_CODE
, WCA.FREIGHT_ORG_ID
, NULL
, WCA.ATTRIBUTE_CATEGORY
, WCA.ATTRIBUTE1
, WCA.ATTRIBUTE2
, WCA.ATTRIBUTE3
, WCA.ATTRIBUTE4
, WCA.ATTRIBUTE5
, WCA.ATTRIBUTE6
, WCA.ATTRIBUTE7
, WCA.ATTRIBUTE8
, WCA.ATTRIBUTE9
, WCA.ATTRIBUTE10
, WCA.ATTRIBUTE11
, WCA.ATTRIBUTE12
, WCA.ATTRIBUTE13
, WCA.ATTRIBUTE14
, WCA.ATTRIBUTE15
, WCA.CREATION_DATE
, WCA.CREATED_BY
, WCA.LAST_UPDATE_DATE
, WCA.LAST_UPDATED_BY
, WCA.LAST_UPDATE_LOGIN
FROM WSH_CALENDAR_ASSIGNMENTS WCA
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
WHERE WCA.ASSOCIATION_TYPE = 'CUSTOMER'
AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND WCA.CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID UNION SELECT PARTY.PARTY_NAME
, PARTY.PARTY_NUMBER
, WCA.CARRIER_ID
, WCA.ASSOCIATION_TYPE
, NULL
, WCA.CALENDAR_CODE
, WCA.CALENDAR_TYPE
, WCA.CALENDAR_ASSIGNMENT_ID
, NULL
, -1
, NULL
, WCA.ATTRIBUTE_CATEGORY
, WCA.ATTRIBUTE1
, WCA.ATTRIBUTE2
, WCA.ATTRIBUTE3
, WCA.ATTRIBUTE4
, WCA.ATTRIBUTE5
, WCA.ATTRIBUTE6
, WCA.ATTRIBUTE7
, WCA.ATTRIBUTE8
, WCA.ATTRIBUTE9
, WCA.ATTRIBUTE10
, WCA.ATTRIBUTE11
, WCA.ATTRIBUTE12
, WCA.ATTRIBUTE13
, WCA.ATTRIBUTE14
, WCA.ATTRIBUTE15
, WCA.CREATION_DATE
, WCA.CREATED_BY
, WCA.LAST_UPDATE_DATE
, WCA.LAST_UPDATED_BY
, WCA.LAST_UPDATE_LOGIN
FROM WSH_CALENDAR_ASSIGNMENTS WCA
, WSH_CARRIERS WCR
, HZ_PARTIES PARTY
WHERE WCA.ASSOCIATION_TYPE = 'CARRIER'
AND WCA.CARRIER_ID = WCR.CARRIER_ID
AND WCA.CARRIER_ID = PARTY.PARTY_ID UNION SELECT HROU.NAME
, MP.ORGANIZATION_CODE
, HROU.ORGANIZATION_ID
, WCA.ASSOCIATION_TYPE
, NULL
, WCA.CALENDAR_CODE
, WCA.CALENDAR_TYPE
, WCA.CALENDAR_ASSIGNMENT_ID
, WCA.FREIGHT_CODE
, WCA.FREIGHT_ORG_ID
, NULL
, WCA.ATTRIBUTE_CATEGORY
, WCA.ATTRIBUTE1
, WCA.ATTRIBUTE2
, WCA.ATTRIBUTE3
, WCA.ATTRIBUTE4
, WCA.ATTRIBUTE5
, WCA.ATTRIBUTE6
, WCA.ATTRIBUTE7
, WCA.ATTRIBUTE8
, WCA.ATTRIBUTE9
, WCA.ATTRIBUTE10
, WCA.ATTRIBUTE11
, WCA.ATTRIBUTE12
, WCA.ATTRIBUTE13
, WCA.ATTRIBUTE14
, WCA.ATTRIBUTE15
, WCA.CREATION_DATE
, WCA.CREATED_BY
, WCA.LAST_UPDATE_DATE
, WCA.LAST_UPDATED_BY
, WCA.LAST_UPDATE_LOGIN
FROM WSH_CALENDAR_ASSIGNMENTS WCA
, HR_ORGANIZATION_UNITS HROU
, MTL_PARAMETERS MP
WHERE WCA.ASSOCIATION_TYPE = 'ORGANIZATION'
AND WCA.ORGANIZATION_ID = HROU.ORGANIZATION_ID
AND HROU.ORGANIZATION_ID = MP.ORGANIZATION_ID