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: GR_DISPATCH_HISTORY_V

Product:	GR - Process Manufacturing Regulatory Management
Description:
Implementation/DBA Data:	APPS.GR_DISPATCH_HISTORY_V

View Text

SELECT DH.ROWID ROW_ID
, DH.DISPATCH_HISTORY_ID
, DH.DOCUMENT_ID
, DH.DOCUMENT_CODE
, DH.ITEM
, DH.ORGANIZATION_ID
, DH.INVENTORY_ITEM_ID
, DH.RECIPIENT_ID
, DH.RECIPIENT_SITE_ID
, DH.DATE_SENT
, DH.DISPATCH_METHOD_CODE
, DH.CREATION_SOURCE
, DH.ATTRIBUTE_CATEGORY
, DH.ATTRIBUTE1
, DH.ATTRIBUTE2
, DH.ATTRIBUTE3
, DH.ATTRIBUTE4
, DH.ATTRIBUTE5
, DH.ATTRIBUTE6
, DH.ATTRIBUTE7
, DH.ATTRIBUTE8
, DH.ATTRIBUTE9
, DH.ATTRIBUTE10
, DH.ATTRIBUTE11
, DH.ATTRIBUTE12
, DH.ATTRIBUTE13
, DH.ATTRIBUTE14
, DH.ATTRIBUTE15
, DH.ATTRIBUTE16
, DH.ATTRIBUTE17
, DH.ATTRIBUTE18
, DH.ATTRIBUTE19
, DH.ATTRIBUTE20
, DH.ATTRIBUTE21
, DH.ATTRIBUTE22
, DH.ATTRIBUTE23
, DH.ATTRIBUTE24
, DH.ATTRIBUTE25
, DH.ATTRIBUTE26
, DH.ATTRIBUTE27
, DH.ATTRIBUTE28
, DH.ATTRIBUTE29
, DH.ATTRIBUTE30
, DH.CREATED_BY
, DH.CREATION_DATE
, DH.LAST_UPDATED_BY
, DH.LAST_UPDATE_DATE
, DH.LAST_UPDATE_LOGIN
, MTL.CAS_NUMBER
, HZP.PARTY_NAME AS RECIPIENT
, HZP.PARTY_NUMBER AS RECIPIENT_NUMBER
, HZP.PARTY_TYPE AS RECIPIENT_TYPE
, HZS.PARTY_SITE_NAME AS RECIPIENT_SITE_NAME
, HZS.PARTY_SITE_NUMBER AS RECIPIENT_SITE_NUMBER
, HZS.ADDRESSEE
, DOC.FILE_NAME AS DOCUMENT
, DOC.DESCRIPTION AS DOCUMENT_DESCRIPTION
, DOC.DOC_ATTRIBUTE_CATEGORY AS DOCUMENT_CATEGORY
, DOC.DOC_ATTRIBUTE2 AS DOCUMENT_TYPE
, DOC.DOC_ATTRIBUTE3 AS DOCUMENT_LANGUAGE
, DOC.DOC_ATTRIBUTE4 AS DISCLOSURE_CODE
, LK1.MEANING AS DISPATCH_METHOD_DISPLAY
, LK2.MEANING AS CREATION_SOURCE_DISPLAY
, EDR.VERSION_LABEL AS DOCUMENT_VERSION
FROM GR_DISPATCH_HISTORY DH
, HZ_PARTIES HZP
, HZ_PARTY_SITES HZS
, FND_DOCUMENTS_TL DOC
, FND_LOOKUPS LK1
, FND_LOOKUPS LK2
, EDR_FILES_B EDR
, MTL_SYSTEM_ITEMS_B MTL
WHERE MTL.INVENTORY_ITEM_ID = DH.INVENTORY_ITEM_ID
AND MTL.ORGANIZATION_ID = DH.ORGANIZATION_ID
AND DH.DOCUMENT_ID = EDR.FND_DOCUMENT_ID(+)
AND LK2.LOOKUP_CODE = DH.CREATION_SOURCE
AND LK2.LOOKUP_TYPE = 'GR_CREATION_SOURCE'
AND LK1.LOOKUP_CODE = DH.DISPATCH_METHOD_CODE
AND LK1.LOOKUP_TYPE = 'GR_DISPATCH_METHOD_CODE'
AND DOC.LANGUAGE = USERENV('LANG')
AND DH.DOCUMENT_ID = DOC.DOCUMENT_ID
AND DH.RECIPIENT_SITE_ID = HZS.PARTY_SITE_ID
AND DH.RECIPIENT_ID = HZP.PARTY_ID

Columns

Name
ROW_ID
DISPATCH_HISTORY_ID
DOCUMENT_ID
DOCUMENT_CODE
ITEM
ORGANIZATION_ID
INVENTORY_ITEM_ID
RECIPIENT_ID
RECIPIENT_SITE_ID
DATE_SENT
DISPATCH_METHOD_CODE
CREATION_SOURCE
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
ATTRIBUTE21
ATTRIBUTE22
ATTRIBUTE23
ATTRIBUTE24
ATTRIBUTE25
ATTRIBUTE26
ATTRIBUTE27
ATTRIBUTE28
ATTRIBUTE29
ATTRIBUTE30
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
CAS_NUMBER
RECIPIENT
RECIPIENT_NUMBER
RECIPIENT_TYPE
RECIPIENT_SITE_NAME
RECIPIENT_SITE_NUMBER
ADDRESSEE
DOCUMENT
DOCUMENT_DESCRIPTION
DOCUMENT_CATEGORY
DOCUMENT_TYPE
DOCUMENT_LANGUAGE
DISCLOSURE_CODE
DISPATCH_METHOD_DISPLAY
CREATION_SOURCE_DISPLAY
DOCUMENT_VERSION