VIEW: APPS.GR_DISPATCH_HISTORY_V

Source

View Text - Preformatted

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_vl doc, FND_LOOKUP_VALUES LK1, FND_LOOKUP_VALUES 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 LK2.LANGUAGE = userenv('LANG') AND LK1.LOOKUP_CODE = DH.DISPATCH_METHOD_CODE AND LK1.LOOKUP_TYPE = 'GR_DISPATCH_METHOD_CODE' AND LK1.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

View Text - HTML Formatted

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_VL DOC
, FND_LOOKUP_VALUES LK1
, FND_LOOKUP_VALUES 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 LK2.LANGUAGE = USERENV('LANG')
AND LK1.LOOKUP_CODE = DH.DISPATCH_METHOD_CODE
AND LK1.LOOKUP_TYPE = 'GR_DISPATCH_METHOD_CODE'
AND LK1.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