VIEW: APPS.OZF_CLAIMS_V

Source

View Text - Preformatted

SELECT 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_TYPE ,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 ,OC.HISTORY_EVENT ,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.SALES_REP_ID ,OC.CONTACT_ID ,OC.BROKER_ID ,OC.CUSTOMER_REF_DATE ,OC.CUSTOMER_REF_NUMBER ,OC.CUSTOMER_REF_NORMALIZED ,OC.CUSTOMER_REASON ,OC.AMOUNT ,OC.AMOUNT_REMAINING ,OC.AMOUNT_ADJUSTED ,OC.AMOUNT_SETTLED ,OC.TAX_AMOUNT ,OC.ACCTD_AMOUNT ,OC.ACCTD_AMOUNT_ADJUSTED ,OC.ACCTD_AMOUNT_REMAINING ,OC.ACCTD_AMOUNT_SETTLED ,OC.ACCTD_TAX_AMOUNT ,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.ORDER_TYPE_ID ,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 ,OC.LEGAL_ENTITY_ID ,OC.WRITE_OFF_FLAG ,OC.WRITE_OFF_THRESHOLD_AMOUNT ,OC.UNDER_WRITE_OFF_THRESHOLD ,OC.SHIP_TO_CUST_ACCOUNT_ID ,OC.AMOUNT_APPLIED ,OC.APPLIED_RECEIPT_ID ,OC.APPLIED_RECEIPT_NUMBER ,OC.WO_REC_TRX_ID ,OC.GROUP_CLAIM_ID ,OC.OFFER_ID ,OC.PRE_AUTH_DEDUCTION_NORMALIZED ,OC.PRE_AUTH_DEDUCTION_NUMBER FROM OZF_CLAIMS OC , OZF_SYS_PARAMETERS OSP , HZ_CUST_ACCOUNTS HCA , HZ_PARTIES HP , OZF_CLAIM_TYPES_VL CT , OZF_LOOKUPS LK_CC , 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 = 'OZF_CLAIM_CLASS' AND OC.USER_STATUS_ID = AUS.USER_STATUS_ID AND OC.CLAIM_CLASS <> 'GROUP'

View Text - HTML Formatted

SELECT 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_TYPE
, 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
, OC.HISTORY_EVENT
, 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.SALES_REP_ID
, OC.CONTACT_ID
, OC.BROKER_ID
, OC.CUSTOMER_REF_DATE
, OC.CUSTOMER_REF_NUMBER
, OC.CUSTOMER_REF_NORMALIZED
, OC.CUSTOMER_REASON
, OC.AMOUNT
, OC.AMOUNT_REMAINING
, OC.AMOUNT_ADJUSTED
, OC.AMOUNT_SETTLED
, OC.TAX_AMOUNT
, OC.ACCTD_AMOUNT
, OC.ACCTD_AMOUNT_ADJUSTED
, OC.ACCTD_AMOUNT_REMAINING
, OC.ACCTD_AMOUNT_SETTLED
, OC.ACCTD_TAX_AMOUNT
, 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.ORDER_TYPE_ID
, 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
, OC.LEGAL_ENTITY_ID
, OC.WRITE_OFF_FLAG
, OC.WRITE_OFF_THRESHOLD_AMOUNT
, OC.UNDER_WRITE_OFF_THRESHOLD
, OC.SHIP_TO_CUST_ACCOUNT_ID
, OC.AMOUNT_APPLIED
, OC.APPLIED_RECEIPT_ID
, OC.APPLIED_RECEIPT_NUMBER
, OC.WO_REC_TRX_ID
, OC.GROUP_CLAIM_ID
, OC.OFFER_ID
, OC.PRE_AUTH_DEDUCTION_NORMALIZED
, OC.PRE_AUTH_DEDUCTION_NUMBER
FROM OZF_CLAIMS OC
, OZF_SYS_PARAMETERS OSP
, HZ_CUST_ACCOUNTS HCA
, HZ_PARTIES HP
, OZF_CLAIM_TYPES_VL CT
, OZF_LOOKUPS LK_CC
, 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 = 'OZF_CLAIM_CLASS'
AND OC.USER_STATUS_ID = AUS.USER_STATUS_ID
AND OC.CLAIM_CLASS <> 'GROUP'