VIEW: OZF.OZF_CLAIMS_HISTORY_ALL#

Source

View Text - Preformatted

select CLAIM_HISTORY_ID CLAIM_HISTORY_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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROGRAM_ID PROGRAM_ID, CREATED_FROM CREATED_FROM, BATCH_ID BATCH_ID, CLAIM_ID CLAIM_ID, CLAIM_NUMBER CLAIM_NUMBER, CLAIM_TYPE_ID CLAIM_TYPE_ID, CLAIM_DATE CLAIM_DATE, DUE_DATE DUE_DATE, HISTORY_EVENT HISTORY_EVENT, SPLIT_FROM_CLAIM_ID SPLIT_FROM_CLAIM_ID, AMOUNT AMOUNT, ACCTD_AMOUNT ACCTD_AMOUNT, CURRENCY_CODE CURRENCY_CODE, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, EXCHANGE_RATE_DATE EXCHANGE_RATE_DATE, EXCHANGE_RATE EXCHANGE_RATE, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, ORIGINAL_CLAIM_DATE ORIGINAL_CLAIM_DATE, SOURCE_OBJECT_ID SOURCE_OBJECT_ID, SOURCE_OBJECT_CLASS SOURCE_OBJECT_CLASS, SOURCE_OBJECT_TYPE_ID SOURCE_OBJECT_TYPE_ID, SOURCE_OBJECT_NUMBER SOURCE_OBJECT_NUMBER, CUST_ACCOUNT_ID CUST_ACCOUNT_ID, CUST_BILLTO_ACCT_SITE_ID CUST_BILLTO_ACCT_SITE_ID, LOCATION_ID LOCATION_ID, REASON_TYPE REASON_TYPE, REASON_CODE_ID REASON_CODE_ID, STATUS_CODE STATUS_CODE, SALES_REP_ID SALES_REP_ID, COLLECTOR_ID COLLECTOR_ID, CONTACT_ID CONTACT_ID, BROKER_ID BROKER_ID, TERRITORY_ID TERRITORY_ID, CUSTOMER_REF_DATE CUSTOMER_REF_DATE, CUSTOMER_REF_NUMBER#2 CUSTOMER_REF_NUMBER, ASSIGNED_TO ASSIGNED_TO, RECEIPT_ID RECEIPT_ID, RECEIPT_NUMBER RECEIPT_NUMBER, DOC_SEQUENCE_ID DOC_SEQUENCE_ID, DOC_SEQUENCE_VALUE DOC_SEQUENCE_VALUE, PAYMENT_METHOD PAYMENT_METHOD, VOUCHER_ID VOUCHER_ID, VOUCHER_NUMBER VOUCHER_NUMBER, PAYMENT_REFERENCE_ID PAYMENT_REFERENCE_ID, PAYMENT_REFERENCE_NUMBER PAYMENT_REFERENCE_NUMBER, PAYMENT_REFERENCE_DATE PAYMENT_REFERENCE_DATE, PAYMENT_STATUS PAYMENT_STATUS, APPROVED_FLAG APPROVED_FLAG, APPROVED_DATE APPROVED_DATE, APPROVED_BY APPROVED_BY, SETTLED_DATE SETTLED_DATE, SETTLED_BY SETTLED_BY, LETTER_ID LETTER_ID, LETTER_DATE LETTER_DATE, 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, ORG_ID ORG_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID, AMOUNT_ADJUSTED AMOUNT_ADJUSTED, AMOUNT_REMAINING AMOUNT_REMAINING, AMOUNT_SETTLED AMOUNT_SETTLED, USER_STATUS_ID USER_STATUS_ID, CLAIM_CLASS CLAIM_CLASS, OWNER_ID OWNER_ID, HISTORY_EVENT_DATE HISTORY_EVENT_DATE, HISTORY_EVENT_DESCRIPTION HISTORY_EVENT_DESCRIPTION, DUPLICATE_CLAIM_ID DUPLICATE_CLAIM_ID, SPLIT_DATE SPLIT_DATE, ROOT_CLAIM_ID ROOT_CLAIM_ID, ACCTD_AMOUNT_REMAINING ACCTD_AMOUNT_REMAINING, TAX_AMOUNT TAX_AMOUNT, TAX_CODE TAX_CODE, TAX_CALCULATION_FLAG TAX_CALCULATION_FLAG, CUST_SHIPTO_ACCT_SITE_ID CUST_SHIPTO_ACCT_SITE_ID, PAY_RELATED_ACCOUNT_FLAG PAY_RELATED_ACCOUNT_FLAG, RELATED_CUST_ACCOUNT_ID RELATED_CUST_ACCOUNT_ID, RELATED_SITE_USE_ID RELATED_SITE_USE_ID, RELATIONSHIP_TYPE RELATIONSHIP_TYPE, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, TASK_TEMPLATE_GROUP_ID TASK_TEMPLATE_GROUP_ID, GL_DATE GL_DATE, EFFECTIVE_DATE EFFECTIVE_DATE, CUSTOM_SETUP_ID CUSTOM_SETUP_ID, TASK_ID TASK_ID, COUNTRY_ID COUNTRY_ID, COMMENTS COMMENTS, TASK_SOURCE_OBJECT_ID TASK_SOURCE_OBJECT_ID, TASK_SOURCE_OBJECT_TYPE_CODE TASK_SOURCE_OBJECT_TYPE_CODE, DEDUCTION_ATTRIBUTE_CATEGORY DEDUCTION_ATTRIBUTE_CATEGORY, DEDUCTION_ATTRIBUTE1 DEDUCTION_ATTRIBUTE1, DEDUCTION_ATTRIBUTE2 DEDUCTION_ATTRIBUTE2, DEDUCTION_ATTRIBUTE3 DEDUCTION_ATTRIBUTE3, DEDUCTION_ATTRIBUTE4 DEDUCTION_ATTRIBUTE4, DEDUCTION_ATTRIBUTE5 DEDUCTION_ATTRIBUTE5, DEDUCTION_ATTRIBUTE6 DEDUCTION_ATTRIBUTE6, DEDUCTION_ATTRIBUTE7 DEDUCTION_ATTRIBUTE7, DEDUCTION_ATTRIBUTE8 DEDUCTION_ATTRIBUTE8, DEDUCTION_ATTRIBUTE9 DEDUCTION_ATTRIBUTE9, DEDUCTION_ATTRIBUTE10 DEDUCTION_ATTRIBUTE10, DEDUCTION_ATTRIBUTE11 DEDUCTION_ATTRIBUTE11, DEDUCTION_ATTRIBUTE12 DEDUCTION_ATTRIBUTE12, DEDUCTION_ATTRIBUTE13 DEDUCTION_ATTRIBUTE13, DEDUCTION_ATTRIBUTE14 DEDUCTION_ATTRIBUTE14, DEDUCTION_ATTRIBUTE15 DEDUCTION_ATTRIBUTE15, ACCTD_AMOUNT_ADJUSTED ACCTD_AMOUNT_ADJUSTED, ACCTD_AMOUNT_SETTLED ACCTD_AMOUNT_SETTLED, CUSTOMER_REF_NORMALIZED#2 CUSTOMER_REF_NORMALIZED, ORDER_TYPE_ID ORDER_TYPE_ID, BATCH_TYPE BATCH_TYPE, GROUP_CLAIM_ID GROUP_CLAIM_ID, ACCTD_TAX_AMOUNT ACCTD_TAX_AMOUNT, SHIP_TO_CUST_ACCOUNT_ID SHIP_TO_CUST_ACCOUNT_ID, CUSTOMER_REASON CUSTOMER_REASON, WO_REC_TRX_ID WO_REC_TRX_ID, WRITE_OFF_FLAG WRITE_OFF_FLAG, WRITE_OFF_THRESHOLD_AMOUNT WRITE_OFF_THRESHOLD_AMOUNT, UNDER_WRITE_OFF_THRESHOLD UNDER_WRITE_OFF_THRESHOLD, AMOUNT_APPLIED AMOUNT_APPLIED, APPLIED_RECEIPT_ID APPLIED_RECEIPT_ID, APPLIED_RECEIPT_NUMBER APPLIED_RECEIPT_NUMBER, APPR_WF_ITEM_KEY APPR_WF_ITEM_KEY, CSTL_WF_ITEM_KEY CSTL_WF_ITEM_KEY, OFFER_ID OFFER_ID, PRE_AUTH_DEDUCTION_NUMBER PRE_AUTH_DEDUCTION_NUMBER, PRE_AUTH_DEDUCTION_NORMALIZED PRE_AUTH_DEDUCTION_NORMALIZED from "OZF"."OZF_CLAIMS_HISTORY_ALL"

View Text - HTML Formatted

SELECT CLAIM_HISTORY_ID CLAIM_HISTORY_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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROGRAM_ID PROGRAM_ID
, CREATED_FROM CREATED_FROM
, BATCH_ID BATCH_ID
, CLAIM_ID CLAIM_ID
, CLAIM_NUMBER CLAIM_NUMBER
, CLAIM_TYPE_ID CLAIM_TYPE_ID
, CLAIM_DATE CLAIM_DATE
, DUE_DATE DUE_DATE
, HISTORY_EVENT HISTORY_EVENT
, SPLIT_FROM_CLAIM_ID SPLIT_FROM_CLAIM_ID
, AMOUNT AMOUNT
, ACCTD_AMOUNT ACCTD_AMOUNT
, CURRENCY_CODE CURRENCY_CODE
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, EXCHANGE_RATE_DATE EXCHANGE_RATE_DATE
, EXCHANGE_RATE EXCHANGE_RATE
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, ORIGINAL_CLAIM_DATE ORIGINAL_CLAIM_DATE
, SOURCE_OBJECT_ID SOURCE_OBJECT_ID
, SOURCE_OBJECT_CLASS SOURCE_OBJECT_CLASS
, SOURCE_OBJECT_TYPE_ID SOURCE_OBJECT_TYPE_ID
, SOURCE_OBJECT_NUMBER SOURCE_OBJECT_NUMBER
, CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, CUST_BILLTO_ACCT_SITE_ID CUST_BILLTO_ACCT_SITE_ID
, LOCATION_ID LOCATION_ID
, REASON_TYPE REASON_TYPE
, REASON_CODE_ID REASON_CODE_ID
, STATUS_CODE STATUS_CODE
, SALES_REP_ID SALES_REP_ID
, COLLECTOR_ID COLLECTOR_ID
, CONTACT_ID CONTACT_ID
, BROKER_ID BROKER_ID
, TERRITORY_ID TERRITORY_ID
, CUSTOMER_REF_DATE CUSTOMER_REF_DATE
, CUSTOMER_REF_NUMBER#2 CUSTOMER_REF_NUMBER
, ASSIGNED_TO ASSIGNED_TO
, RECEIPT_ID RECEIPT_ID
, RECEIPT_NUMBER RECEIPT_NUMBER
, DOC_SEQUENCE_ID DOC_SEQUENCE_ID
, DOC_SEQUENCE_VALUE DOC_SEQUENCE_VALUE
, PAYMENT_METHOD PAYMENT_METHOD
, VOUCHER_ID VOUCHER_ID
, VOUCHER_NUMBER VOUCHER_NUMBER
, PAYMENT_REFERENCE_ID PAYMENT_REFERENCE_ID
, PAYMENT_REFERENCE_NUMBER PAYMENT_REFERENCE_NUMBER
, PAYMENT_REFERENCE_DATE PAYMENT_REFERENCE_DATE
, PAYMENT_STATUS PAYMENT_STATUS
, APPROVED_FLAG APPROVED_FLAG
, APPROVED_DATE APPROVED_DATE
, APPROVED_BY APPROVED_BY
, SETTLED_DATE SETTLED_DATE
, SETTLED_BY SETTLED_BY
, LETTER_ID LETTER_ID
, LETTER_DATE LETTER_DATE
, 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
, ORG_ID ORG_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, AMOUNT_ADJUSTED AMOUNT_ADJUSTED
, AMOUNT_REMAINING AMOUNT_REMAINING
, AMOUNT_SETTLED AMOUNT_SETTLED
, USER_STATUS_ID USER_STATUS_ID
, CLAIM_CLASS CLAIM_CLASS
, OWNER_ID OWNER_ID
, HISTORY_EVENT_DATE HISTORY_EVENT_DATE
, HISTORY_EVENT_DESCRIPTION HISTORY_EVENT_DESCRIPTION
, DUPLICATE_CLAIM_ID DUPLICATE_CLAIM_ID
, SPLIT_DATE SPLIT_DATE
, ROOT_CLAIM_ID ROOT_CLAIM_ID
, ACCTD_AMOUNT_REMAINING ACCTD_AMOUNT_REMAINING
, TAX_AMOUNT TAX_AMOUNT
, TAX_CODE TAX_CODE
, TAX_CALCULATION_FLAG TAX_CALCULATION_FLAG
, CUST_SHIPTO_ACCT_SITE_ID CUST_SHIPTO_ACCT_SITE_ID
, PAY_RELATED_ACCOUNT_FLAG PAY_RELATED_ACCOUNT_FLAG
, RELATED_CUST_ACCOUNT_ID RELATED_CUST_ACCOUNT_ID
, RELATED_SITE_USE_ID RELATED_SITE_USE_ID
, RELATIONSHIP_TYPE RELATIONSHIP_TYPE
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, TASK_TEMPLATE_GROUP_ID TASK_TEMPLATE_GROUP_ID
, GL_DATE GL_DATE
, EFFECTIVE_DATE EFFECTIVE_DATE
, CUSTOM_SETUP_ID CUSTOM_SETUP_ID
, TASK_ID TASK_ID
, COUNTRY_ID COUNTRY_ID
, COMMENTS COMMENTS
, TASK_SOURCE_OBJECT_ID TASK_SOURCE_OBJECT_ID
, TASK_SOURCE_OBJECT_TYPE_CODE TASK_SOURCE_OBJECT_TYPE_CODE
, DEDUCTION_ATTRIBUTE_CATEGORY DEDUCTION_ATTRIBUTE_CATEGORY
, DEDUCTION_ATTRIBUTE1 DEDUCTION_ATTRIBUTE1
, DEDUCTION_ATTRIBUTE2 DEDUCTION_ATTRIBUTE2
, DEDUCTION_ATTRIBUTE3 DEDUCTION_ATTRIBUTE3
, DEDUCTION_ATTRIBUTE4 DEDUCTION_ATTRIBUTE4
, DEDUCTION_ATTRIBUTE5 DEDUCTION_ATTRIBUTE5
, DEDUCTION_ATTRIBUTE6 DEDUCTION_ATTRIBUTE6
, DEDUCTION_ATTRIBUTE7 DEDUCTION_ATTRIBUTE7
, DEDUCTION_ATTRIBUTE8 DEDUCTION_ATTRIBUTE8
, DEDUCTION_ATTRIBUTE9 DEDUCTION_ATTRIBUTE9
, DEDUCTION_ATTRIBUTE10 DEDUCTION_ATTRIBUTE10
, DEDUCTION_ATTRIBUTE11 DEDUCTION_ATTRIBUTE11
, DEDUCTION_ATTRIBUTE12 DEDUCTION_ATTRIBUTE12
, DEDUCTION_ATTRIBUTE13 DEDUCTION_ATTRIBUTE13
, DEDUCTION_ATTRIBUTE14 DEDUCTION_ATTRIBUTE14
, DEDUCTION_ATTRIBUTE15 DEDUCTION_ATTRIBUTE15
, ACCTD_AMOUNT_ADJUSTED ACCTD_AMOUNT_ADJUSTED
, ACCTD_AMOUNT_SETTLED ACCTD_AMOUNT_SETTLED
, CUSTOMER_REF_NORMALIZED#2 CUSTOMER_REF_NORMALIZED
, ORDER_TYPE_ID ORDER_TYPE_ID
, BATCH_TYPE BATCH_TYPE
, GROUP_CLAIM_ID GROUP_CLAIM_ID
, ACCTD_TAX_AMOUNT ACCTD_TAX_AMOUNT
, SHIP_TO_CUST_ACCOUNT_ID SHIP_TO_CUST_ACCOUNT_ID
, CUSTOMER_REASON CUSTOMER_REASON
, WO_REC_TRX_ID WO_REC_TRX_ID
, WRITE_OFF_FLAG WRITE_OFF_FLAG
, WRITE_OFF_THRESHOLD_AMOUNT WRITE_OFF_THRESHOLD_AMOUNT
, UNDER_WRITE_OFF_THRESHOLD UNDER_WRITE_OFF_THRESHOLD
, AMOUNT_APPLIED AMOUNT_APPLIED
, APPLIED_RECEIPT_ID APPLIED_RECEIPT_ID
, APPLIED_RECEIPT_NUMBER APPLIED_RECEIPT_NUMBER
, APPR_WF_ITEM_KEY APPR_WF_ITEM_KEY
, CSTL_WF_ITEM_KEY CSTL_WF_ITEM_KEY
, OFFER_ID OFFER_ID
, PRE_AUTH_DEDUCTION_NUMBER PRE_AUTH_DEDUCTION_NUMBER
, PRE_AUTH_DEDUCTION_NORMALIZED PRE_AUTH_DEDUCTION_NORMALIZED
FROM "OZF"."OZF_CLAIMS_HISTORY_ALL"