VIEW: APPS.CSD_RECALL_HEADERS_VL

Source

View Text - Preformatted

SELECT crh."ROWID" ROW_ID, crh."RECALL_ID", crh."RECALL_NUMBER", crh."REPORTED_DATE", crh."INIT_DATE", crh."COMP_DATE", crh."MANDAT_COMP_DATE", crh."ACT_COMP_DATE", crh."SERVICE_CODES", crh."REG_AGENCY_ID", crh."REG_AGENCY_REF_NO", crh."OBJECT_VERSION_NUMBER", crh."CREATED_BY", crh."CREATION_DATE", crh."LAST_UPDATED_BY", crh."LAST_UPDATE_DATE", crh."LAST_UPDATE_LOGIN", crh."ATTRIBUTE_CATEGORY", crh."ATTRIBUTE1", crh."ATTRIBUTE2", crh."ATTRIBUTE3", crh."ATTRIBUTE4", crh."ATTRIBUTE5", crh."ATTRIBUTE6", crh."ATTRIBUTE7", crh."ATTRIBUTE8", crh."ATTRIBUTE9", crh."ATTRIBUTE10", crh."ATTRIBUTE11", crh."ATTRIBUTE12", crh."ATTRIBUTE13", crh."ATTRIBUTE14", crh."ATTRIBUTE15", crh."SEVERITY_ID", crh."STATUS_ID", crh."RECALL_FLOW_STATUS_ID", crh."WIP_ACCOUNTING_CLASS", crh."HOTLINE_NUMBER", crh."RECALL_WEBSITE", crh."RECALL_REVISION", crh."DISCOVERY_DATE", crh."ESTIMATED_NO_OF_UNITS", crh."CONSUMER_CONTACT", crtl."DESCRIPTION", crtl."DISCOVERY_METHOD", crtl."INCIDENTS_AND_ISSUES", crtl."CONSEQUENCE", crtl."STRATEGY_DESCR", crtl."REMEDY_ACTIONS", crtl."REG_AGENCY_COMMENTS", crtl."LANGUAGE", crtl."RECALL_NAME", crtl."SOURCE_LANG", crtl."RECALL_REASON", crtl."RECALL_RISK", crh."CLASSIFICATION_CODE" FROM "CSD_RECALL_HEADERS_B" crh, "CSD_RECALL_HEADERS_TL" crtl WHERE crh."RECALL_ID" = crtl.recall_id AND crtl.language = userenv('LANG')

View Text - HTML Formatted

SELECT CRH."ROWID" ROW_ID
, CRH."RECALL_ID"
, CRH."RECALL_NUMBER"
, CRH."REPORTED_DATE"
, CRH."INIT_DATE"
, CRH."COMP_DATE"
, CRH."MANDAT_COMP_DATE"
, CRH."ACT_COMP_DATE"
, CRH."SERVICE_CODES"
, CRH."REG_AGENCY_ID"
, CRH."REG_AGENCY_REF_NO"
, CRH."OBJECT_VERSION_NUMBER"
, CRH."CREATED_BY"
, CRH."CREATION_DATE"
, CRH."LAST_UPDATED_BY"
, CRH."LAST_UPDATE_DATE"
, CRH."LAST_UPDATE_LOGIN"
, CRH."ATTRIBUTE_CATEGORY"
, CRH."ATTRIBUTE1"
, CRH."ATTRIBUTE2"
, CRH."ATTRIBUTE3"
, CRH."ATTRIBUTE4"
, CRH."ATTRIBUTE5"
, CRH."ATTRIBUTE6"
, CRH."ATTRIBUTE7"
, CRH."ATTRIBUTE8"
, CRH."ATTRIBUTE9"
, CRH."ATTRIBUTE10"
, CRH."ATTRIBUTE11"
, CRH."ATTRIBUTE12"
, CRH."ATTRIBUTE13"
, CRH."ATTRIBUTE14"
, CRH."ATTRIBUTE15"
, CRH."SEVERITY_ID"
, CRH."STATUS_ID"
, CRH."RECALL_FLOW_STATUS_ID"
, CRH."WIP_ACCOUNTING_CLASS"
, CRH."HOTLINE_NUMBER"
, CRH."RECALL_WEBSITE"
, CRH."RECALL_REVISION"
, CRH."DISCOVERY_DATE"
, CRH."ESTIMATED_NO_OF_UNITS"
, CRH."CONSUMER_CONTACT"
, CRTL."DESCRIPTION"
, CRTL."DISCOVERY_METHOD"
, CRTL."INCIDENTS_AND_ISSUES"
, CRTL."CONSEQUENCE"
, CRTL."STRATEGY_DESCR"
, CRTL."REMEDY_ACTIONS"
, CRTL."REG_AGENCY_COMMENTS"
, CRTL."LANGUAGE"
, CRTL."RECALL_NAME"
, CRTL."SOURCE_LANG"
, CRTL."RECALL_REASON"
, CRTL."RECALL_RISK"
, CRH."CLASSIFICATION_CODE"
FROM "CSD_RECALL_HEADERS_B" CRH
, "CSD_RECALL_HEADERS_TL" CRTL
WHERE CRH."RECALL_ID" = CRTL.RECALL_ID
AND CRTL.LANGUAGE = USERENV('LANG')