VIEW: APPS.AHL_MEL_CDL_ATA_SEQUENCES_V

Source

View Text - Preformatted

SELECT ATA.MEL_CDL_ATA_SEQUENCE_ID, ATA.OBJECT_VERSION_NUMBER, ATA.MEL_CDL_HEADER_ID, HDR.PC_NODE_ID, HDR.PC_NODE_NAME, HDR.PC_NODE_DESC, HDR.PC_HEADER_ID, HDR.PC_HEADER_NAME, HDR.REVISION, HDR.VERSION_NUMBER, HDR.MEL_CDL_TYPE_CODE, HDR.MEL_CDL_TYPE_MEANING, HDR.STATUS_CODE, HDR.STATUS_MEANING, ATA.REPAIR_CATEGORY_ID, REPCAT.SR_URGENCY_ID, CSIU.NAME SR_URGENCY_NAME, CSIU.DESCRIPTION SR_URGENCY_DESC, REPCAT.REPAIR_TIME, ATA.ATA_CODE, FLATA.MEANING ATA_MEANING, FLATA.DESCRIPTION ATA_DESC, ATA.INSTALLED_NUMBER, ATA.DISPATCH_NUMBER, ATA.ATTRIBUTE_CATEGORY, ATA.ATTRIBUTE1, ATA.ATTRIBUTE2, ATA.ATTRIBUTE3, ATA.ATTRIBUTE4, ATA.ATTRIBUTE5, ATA.ATTRIBUTE6, ATA.ATTRIBUTE7, ATA.ATTRIBUTE8, ATA.ATTRIBUTE9, ATA.ATTRIBUTE10, ATA.ATTRIBUTE11, ATA.ATTRIBUTE12, ATA.ATTRIBUTE13, ATA.ATTRIBUTE14, ATA.ATTRIBUTE15 FROM AHL_MEL_CDL_ATA_SEQUENCES ATA, AHL_MEL_CDL_HEADERS_V HDR, FND_LOOKUP_VALUES_VL FLATA, AHL_REPAIR_CATEGORIES REPCAT, CS_INCIDENT_URGENCIES_VL CSIU WHERE FLATA.LOOKUP_TYPE = 'AHL_ATA_CODE' AND FLATA.LOOKUP_CODE = ATA.ATA_CODE AND HDR.MEL_CDL_HEADER_ID = ATA.MEL_CDL_HEADER_ID AND REPCAT.REPAIR_CATEGORY_ID = ATA.REPAIR_CATEGORY_ID AND REPCAT.SR_URGENCY_ID = CSIU.INCIDENT_URGENCY_ID

View Text - HTML Formatted

SELECT ATA.MEL_CDL_ATA_SEQUENCE_ID
, ATA.OBJECT_VERSION_NUMBER
, ATA.MEL_CDL_HEADER_ID
, HDR.PC_NODE_ID
, HDR.PC_NODE_NAME
, HDR.PC_NODE_DESC
, HDR.PC_HEADER_ID
, HDR.PC_HEADER_NAME
, HDR.REVISION
, HDR.VERSION_NUMBER
, HDR.MEL_CDL_TYPE_CODE
, HDR.MEL_CDL_TYPE_MEANING
, HDR.STATUS_CODE
, HDR.STATUS_MEANING
, ATA.REPAIR_CATEGORY_ID
, REPCAT.SR_URGENCY_ID
, CSIU.NAME SR_URGENCY_NAME
, CSIU.DESCRIPTION SR_URGENCY_DESC
, REPCAT.REPAIR_TIME
, ATA.ATA_CODE
, FLATA.MEANING ATA_MEANING
, FLATA.DESCRIPTION ATA_DESC
, ATA.INSTALLED_NUMBER
, ATA.DISPATCH_NUMBER
, ATA.ATTRIBUTE_CATEGORY
, ATA.ATTRIBUTE1
, ATA.ATTRIBUTE2
, ATA.ATTRIBUTE3
, ATA.ATTRIBUTE4
, ATA.ATTRIBUTE5
, ATA.ATTRIBUTE6
, ATA.ATTRIBUTE7
, ATA.ATTRIBUTE8
, ATA.ATTRIBUTE9
, ATA.ATTRIBUTE10
, ATA.ATTRIBUTE11
, ATA.ATTRIBUTE12
, ATA.ATTRIBUTE13
, ATA.ATTRIBUTE14
, ATA.ATTRIBUTE15
FROM AHL_MEL_CDL_ATA_SEQUENCES ATA
, AHL_MEL_CDL_HEADERS_V HDR
, FND_LOOKUP_VALUES_VL FLATA
, AHL_REPAIR_CATEGORIES REPCAT
, CS_INCIDENT_URGENCIES_VL CSIU
WHERE FLATA.LOOKUP_TYPE = 'AHL_ATA_CODE'
AND FLATA.LOOKUP_CODE = ATA.ATA_CODE
AND HDR.MEL_CDL_HEADER_ID = ATA.MEL_CDL_HEADER_ID
AND REPCAT.REPAIR_CATEGORY_ID = ATA.REPAIR_CATEGORY_ID
AND REPCAT.SR_URGENCY_ID = CSIU.INCIDENT_URGENCY_ID