VIEW: APPS.OZF_XLA_CLAIM_V

Source

View Text - Preformatted

SELECT DISTINCT CLA.CLAIM_NUMBER CLAIM_NUMBER, HZ.PARTY_NAME CUSTOMER_NAME, HZSU.LOCATION CUSTOMER_BILL_TO, CLTY.NAME CLAIM_TYPE, CLRS.NAME CLAIM_REASON, CLA.CLAIM_DATE CLAIM_DATE, CLA.AMOUNT CLAIM_AMOUNT, CLA.CURRENCY_CODE CLAIM_CURRENCY, CLA.CLAIM_ID CLAIM_ID, CLA.ACCTD_AMOUNT CLAIM_LEDGER_AMOUNT FROM OZF_XLA_CLAIM_HEADERS OXH, OZF_CLAIMS_ALL CLA, HZ_PARTIES HZ, HZ_CUST_ACCOUNTS HCA, HZ_CUST_SITE_USES_ALL HZSU, OZF_CLAIM_TYPES_VL CLTY, OZF_REASON_CODES_VL CLRS WHERE CLA.CLAIM_ID = OXH.CLAIM_ID AND CLA.CUST_ACCOUNT_ID = HCA.CUST_ACCOUNT_ID AND HCA.PARTY_ID = HZ.PARTY_ID AND CLA.CUST_BILLTO_ACCT_SITE_ID = HZSU.SITE_USE_ID AND CLTY.CLAIM_TYPE_ID = CLA. CLAIM_TYPE_ID AND CLRS.REASON_CODE_ID = CLA. REASON_CODE_ID

View Text - HTML Formatted

SELECT DISTINCT CLA.CLAIM_NUMBER CLAIM_NUMBER
, HZ.PARTY_NAME CUSTOMER_NAME
, HZSU.LOCATION CUSTOMER_BILL_TO
, CLTY.NAME CLAIM_TYPE
, CLRS.NAME CLAIM_REASON
, CLA.CLAIM_DATE CLAIM_DATE
, CLA.AMOUNT CLAIM_AMOUNT
, CLA.CURRENCY_CODE CLAIM_CURRENCY
, CLA.CLAIM_ID CLAIM_ID
, CLA.ACCTD_AMOUNT CLAIM_LEDGER_AMOUNT
FROM OZF_XLA_CLAIM_HEADERS OXH
, OZF_CLAIMS_ALL CLA
, HZ_PARTIES HZ
, HZ_CUST_ACCOUNTS HCA
, HZ_CUST_SITE_USES_ALL HZSU
, OZF_CLAIM_TYPES_VL CLTY
, OZF_REASON_CODES_VL CLRS
WHERE CLA.CLAIM_ID = OXH.CLAIM_ID
AND CLA.CUST_ACCOUNT_ID = HCA.CUST_ACCOUNT_ID
AND HCA.PARTY_ID = HZ.PARTY_ID
AND CLA.CUST_BILLTO_ACCT_SITE_ID = HZSU.SITE_USE_ID
AND CLTY.CLAIM_TYPE_ID = CLA. CLAIM_TYPE_ID
AND CLRS.REASON_CODE_ID = CLA. REASON_CODE_ID