VIEW: AHL.AHL_WARRANTY_CLAIMS_B#

Source

View Text - Preformatted

select WARRANTY_CLAIM_ID WARRANTY_CLAIM_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, WARRANTY_CLAIM_NUMBER WARRANTY_CLAIM_NUMBER, CLAIM_NAME CLAIM_NAME, CLAIM_STATUS_CODE CLAIM_STATUS_CODE, WARRANTY_VENDOR_ID WARRANTY_VENDOR_ID, CLAIM_DATE CLAIM_DATE, OSP_FLAG OSP_FLAG, AMOUNT AMOUNT, AMOUNT_CURRENCY_CODE AMOUNT_CURRENCY_CODE, TOTAL_ORDER_AMOUNT TOTAL_ORDER_AMOUNT, REIMBURSEMENT_AMOUNT REIMBURSEMENT_AMOUNT, REIMBURSEMENT_CURR_CODE REIMBURSEMENT_CURR_CODE, REIMBURSEMENT_TYPE REIMBURSEMENT_TYPE, REIMBURSEMENT_REF_DOC REIMBURSEMENT_REF_DOC, REIMBURSEMENT_DATE REIMBURSEMENT_DATE, SECURITY_GROUP_ID SECURITY_GROUP_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, R_ATTRIBUTE_CATEGORY R_ATTRIBUTE_CATEGORY, R_ATTRIBUTE1 R_ATTRIBUTE1, R_ATTRIBUTE2 R_ATTRIBUTE2, R_ATTRIBUTE3 R_ATTRIBUTE3, R_ATTRIBUTE4 R_ATTRIBUTE4, R_ATTRIBUTE5 R_ATTRIBUTE5, R_ATTRIBUTE6 R_ATTRIBUTE6, R_ATTRIBUTE7 R_ATTRIBUTE7, R_ATTRIBUTE8 R_ATTRIBUTE8, R_ATTRIBUTE9 R_ATTRIBUTE9, R_ATTRIBUTE10 R_ATTRIBUTE10, R_ATTRIBUTE11 R_ATTRIBUTE11, R_ATTRIBUTE12 R_ATTRIBUTE12, R_ATTRIBUTE13 R_ATTRIBUTE13, R_ATTRIBUTE14 R_ATTRIBUTE14, R_ATTRIBUTE15 R_ATTRIBUTE15 from "AHL"."AHL_WARRANTY_CLAIMS_B"

View Text - HTML Formatted

SELECT WARRANTY_CLAIM_ID WARRANTY_CLAIM_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, WARRANTY_CLAIM_NUMBER WARRANTY_CLAIM_NUMBER
, CLAIM_NAME CLAIM_NAME
, CLAIM_STATUS_CODE CLAIM_STATUS_CODE
, WARRANTY_VENDOR_ID WARRANTY_VENDOR_ID
, CLAIM_DATE CLAIM_DATE
, OSP_FLAG OSP_FLAG
, AMOUNT AMOUNT
, AMOUNT_CURRENCY_CODE AMOUNT_CURRENCY_CODE
, TOTAL_ORDER_AMOUNT TOTAL_ORDER_AMOUNT
, REIMBURSEMENT_AMOUNT REIMBURSEMENT_AMOUNT
, REIMBURSEMENT_CURR_CODE REIMBURSEMENT_CURR_CODE
, REIMBURSEMENT_TYPE REIMBURSEMENT_TYPE
, REIMBURSEMENT_REF_DOC REIMBURSEMENT_REF_DOC
, REIMBURSEMENT_DATE REIMBURSEMENT_DATE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, R_ATTRIBUTE_CATEGORY R_ATTRIBUTE_CATEGORY
, R_ATTRIBUTE1 R_ATTRIBUTE1
, R_ATTRIBUTE2 R_ATTRIBUTE2
, R_ATTRIBUTE3 R_ATTRIBUTE3
, R_ATTRIBUTE4 R_ATTRIBUTE4
, R_ATTRIBUTE5 R_ATTRIBUTE5
, R_ATTRIBUTE6 R_ATTRIBUTE6
, R_ATTRIBUTE7 R_ATTRIBUTE7
, R_ATTRIBUTE8 R_ATTRIBUTE8
, R_ATTRIBUTE9 R_ATTRIBUTE9
, R_ATTRIBUTE10 R_ATTRIBUTE10
, R_ATTRIBUTE11 R_ATTRIBUTE11
, R_ATTRIBUTE12 R_ATTRIBUTE12
, R_ATTRIBUTE13 R_ATTRIBUTE13
, R_ATTRIBUTE14 R_ATTRIBUTE14
, R_ATTRIBUTE15 R_ATTRIBUTE15
FROM "AHL"."AHL_WARRANTY_CLAIMS_B"