Product: | OZF - Trade Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OZF_CLAIMS_HISTORY_V |
SELECT OC.CLAIM_HISTORY_ID
, OC.CLAIM_ID
, OC.OBJECT_VERSION_NUMBER
, OC.LAST_UPDATE_DATE
, OC.LAST_UPDATED_BY
, OC.CREATION_DATE
, OC.CREATED_BY
, OC.LAST_UPDATE_LOGIN
, OC.REQUEST_ID
, OC.PROGRAM_APPLICATION_ID
, OC.PROGRAM_UPDATE_DATE
, OC.PROGRAM_ID
, OC.CREATED_FROM
, OC.BATCH_ID
, OC.CLAIM_CLASS
, LK_CC.MEANING
, OC.CLAIM_NUMBER
, OC.CLAIM_TYPE_ID
, CT.NAME
, OC.CLAIM_DATE
, OC.DUE_DATE
, OC.OWNER_ID
, ALS.MEANING
, OC.HISTORY_EVENT_DATE
, OC.HISTORY_EVENT_DESCRIPTION
, OC.ROOT_CLAIM_ID
, OC.DUPLICATE_CLAIM_ID
, OC.REASON_CODE_ID
, OC.TASK_TEMPLATE_GROUP_ID
, OC.STATUS_CODE
, OC.USER_STATUS_ID
, AUS.NAME
, OC.CUST_ACCOUNT_ID
, HP.PARTY_NAME
, HCA.ACCOUNT_NUMBER
, OC.CUST_BILLTO_ACCT_SITE_ID
, OC.CUST_SHIPTO_ACCT_SITE_ID
, OC.CUSTOMER_REF_DATE
, OC.CUSTOMER_REF_NUMBER
, OC.SALES_REP_ID
, OC.CONTACT_ID
, OC.BROKER_ID
, OC.AMOUNT
, OC.AMOUNT_REMAINING
, OC.AMOUNT_ADJUSTED
, OC.AMOUNT_SETTLED
, OC.ACCTD_AMOUNT
, OC.ACCTD_AMOUNT_REMAINING
, OC.CURRENCY_CODE
, OC.EXCHANGE_RATE_TYPE
, OC.EXCHANGE_RATE_DATE
, OC.EXCHANGE_RATE
, OC.SPLIT_FROM_CLAIM_ID
, OC.SPLIT_DATE
, OC.ORIGINAL_CLAIM_DATE
, OC.SOURCE_OBJECT_ID
, OC.SOURCE_OBJECT_CLASS
, OC.SOURCE_OBJECT_TYPE_ID
, OC.SOURCE_OBJECT_NUMBER
, OC.RECEIPT_ID
, OC.RECEIPT_NUMBER
, OC.COMMENTS
, OC.SET_OF_BOOKS_ID
, OC.ATTRIBUTE_CATEGORY
, OC.ATTRIBUTE1
, OC.ATTRIBUTE2
, OC.ATTRIBUTE3
, OC.ATTRIBUTE4
, OC.ATTRIBUTE5
, OC.ATTRIBUTE6
, OC.ATTRIBUTE7
, OC.ATTRIBUTE8
, OC.ATTRIBUTE9
, OC.ATTRIBUTE10
, OC.ATTRIBUTE11
, OC.ATTRIBUTE12
, OC.ATTRIBUTE13
, OC.ATTRIBUTE14
, OC.ATTRIBUTE15
, OC.DEDUCTION_ATTRIBUTE_CATEGORY
, OC.DEDUCTION_ATTRIBUTE1
, OC.DEDUCTION_ATTRIBUTE2
, OC.DEDUCTION_ATTRIBUTE3
, OC.DEDUCTION_ATTRIBUTE4
, OC.DEDUCTION_ATTRIBUTE5
, OC.DEDUCTION_ATTRIBUTE6
, OC.DEDUCTION_ATTRIBUTE7
, OC.DEDUCTION_ATTRIBUTE8
, OC.DEDUCTION_ATTRIBUTE9
, OC.DEDUCTION_ATTRIBUTE10
, OC.DEDUCTION_ATTRIBUTE11
, OC.DEDUCTION_ATTRIBUTE12
, OC.DEDUCTION_ATTRIBUTE13
, OC.DEDUCTION_ATTRIBUTE14
, OC.DEDUCTION_ATTRIBUTE15
, OC.CUSTOM_SETUP_ID
, OC.ORG_ID
FROM OZF_CLAIMS_HISTORY OC
, OZF_SYS_PARAMETERS OSP
, HZ_CUST_ACCOUNTS HCA
, HZ_PARTIES HP
, OZF_CLAIM_TYPES_VL CT
, AMS_LOOKUPS LK_CC
, AMS_LOOKUPS ALS
, AMS_USER_STATUSES_VL AUS
WHERE OC.SET_OF_BOOKS_ID = OSP.SET_OF_BOOKS_ID
AND OC.CUST_ACCOUNT_ID = HCA.CUST_ACCOUNT_ID
AND HCA.PARTY_ID = HP.PARTY_ID
AND OC.CLAIM_TYPE_ID = CT.CLAIM_TYPE_ID
AND OC.CLAIM_CLASS = LK_CC.LOOKUP_CODE
AND LK_CC.LOOKUP_TYPE = 'AMS_CLAIM_CLASS'
AND OC.HISTORY_EVENT = ALS.LOOKUP_CODE
AND ALS.LOOKUP_TYPE = 'AMS_CLAIM_HISTORY_EVENT'
AND OC.USER_STATUS_ID = AUS.USER_STATUS_ID