eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: WSH_CAL_ASG_MASTER_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSH_CAL_ASG_MASTER_V

View Text

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

Columns

Name
ENTITY_NAME
ENTITY_CODE
ENTITY_ID
ENTITY_TYPE
CARRIER_ENTITY_TYPE
CALENDAR_CODE
CALENDAR_TYPE
CALENDAR_ASSIGNMENT_ID
FREIGHT_CODE
FREIGHT_ORG_ID
FREIGHT_DESC
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN