VIEW: APPS.WSH_DOC_SEQUENCE_CATEGORIES_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)