View: WSH_DOC_SEQUENCE_CATEGORIES_V

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

View Text

SELECT WSH.ROWID
, WSH.DOC_SEQUENCE_CATEGORY_ID
, WSH.LOCATION_ID
, WL.UI_LOCATION_CODE LOCATION_CODE
, WSH.DOCUMENT_TYPE
, WLU1.MEANING
, WSH.DOCUMENT_CODE
, WLU2.MEANING
, WSH.APPLICATION_ID
, WSH.CATEGORY_CODE
, WSH.PREFIX
, WSH.SUFFIX
, WSH.DELIMITER
, WSH.ENABLED_FLAG
, FND.NAME
, FND.TABLE_NAME
, FND.DESCRIPTION
, WSH.CREATED_BY
, WSH.CREATION_DATE
, WSH.LAST_UPDATED_BY
, WSH.LAST_UPDATE_DATE
, WSH.LAST_UPDATE_LOGIN
, WSH.PROGRAM_APPLICATION_ID
, WSH.PROGRAM_ID
, WSH.PROGRAM_UPDATE_DATE
, WSH.REQUEST_ID
, WSH.ATTRIBUTE_CATEGORY
, WSH.ATTRIBUTE1
, WSH.ATTRIBUTE2
, WSH.ATTRIBUTE3
, WSH.ATTRIBUTE4
, WSH.ATTRIBUTE5
, WSH.ATTRIBUTE6
, WSH.ATTRIBUTE7
, WSH.ATTRIBUTE8
, WSH.ATTRIBUTE9
, WSH.ATTRIBUTE10
, WSH.ATTRIBUTE11
, WSH.ATTRIBUTE12
, WSH.ATTRIBUTE13
, WSH.ATTRIBUTE14
, WSH.ATTRIBUTE15
FROM WSH_DOC_SEQUENCE_CATEGORIES WSH
, FND_DOC_SEQUENCE_CATEGORIES FND
, WSH_LOOKUPS WLU1
, WSH_LOOKUPS WLU2
, WSH_LOCATIONS WL
WHERE WSH.APPLICATION_ID = FND.APPLICATION_ID
AND WSH.CATEGORY_CODE = FND.CODE
AND WLU1.LOOKUP_TYPE = 'DOCUMENT_TYPE'
AND WLU1.LOOKUP_CODE = WSH.DOCUMENT_TYPE
AND WSH.DOCUMENT_TYPE NOT IN ('BOL')
AND WSH.DOCUMENT_TYPE = WLU2.LOOKUP_TYPE (+)
AND WSH.DOCUMENT_CODE = WLU2.LOOKUP_CODE (+)
AND WSH.LOCATION_ID = WL.WSH_LOCATION_ID (+) UNION SELECT WSH.ROWID
, WSH.DOC_SEQUENCE_CATEGORY_ID
, WSH.LOCATION_ID
, WL.UI_LOCATION_CODE LOCATION_CODE
, WSH.DOCUMENT_TYPE
, WLU.MEANING
, WSH.DOCUMENT_CODE
, NULL DESCRIPTION
, WSH.APPLICATION_ID
, WSH.CATEGORY_CODE
, WSH.PREFIX
, WSH.SUFFIX
, WSH.DELIMITER
, WSH.ENABLED_FLAG
, FND.NAME
, FND.TABLE_NAME
, FND.DESCRIPTION
, WSH.CREATED_BY
, WSH.CREATION_DATE
, WSH.LAST_UPDATED_BY
, WSH.LAST_UPDATE_DATE
, WSH.LAST_UPDATE_LOGIN
, WSH.PROGRAM_APPLICATION_ID
, WSH.PROGRAM_ID
, WSH.PROGRAM_UPDATE_DATE
, WSH.REQUEST_ID
, WSH.ATTRIBUTE_CATEGORY
, WSH.ATTRIBUTE1
, WSH.ATTRIBUTE2
, WSH.ATTRIBUTE3
, WSH.ATTRIBUTE4
, WSH.ATTRIBUTE5
, WSH.ATTRIBUTE6
, WSH.ATTRIBUTE7
, WSH.ATTRIBUTE8
, WSH.ATTRIBUTE9
, WSH.ATTRIBUTE10
, WSH.ATTRIBUTE11
, WSH.ATTRIBUTE12
, WSH.ATTRIBUTE13
, WSH.ATTRIBUTE14
, WSH.ATTRIBUTE15
FROM WSH_DOC_SEQUENCE_CATEGORIES WSH
, FND_DOC_SEQUENCE_CATEGORIES FND
, WSH_LOOKUPS WLU
, WSH_LOCATIONS WL
WHERE WSH.APPLICATION_ID = FND.APPLICATION_ID
AND WSH.CATEGORY_CODE = FND.CODE
AND WLU.LOOKUP_TYPE = 'DOCUMENT_TYPE'
AND WLU.LOOKUP_CODE = WSH.DOCUMENT_TYPE
AND WSH.DOCUMENT_TYPE = 'BOL'
AND WSH.LOCATION_ID = WL.WSH_LOCATION_ID (+)

Columns