VIEW: APPS.OZF_CLAIM_SUMMARY_V

Source

View Text - Preformatted

SELECT oc.claim_id, oc.claim_number, oc.claim_type_id, oct.name, oc.reason_code_id , orc.name, oc.claim_date, oc.due_date, oc.owner_id, oc.currency_code, oc.amount, oc.amount_remaining, oc.amount_settled, oc.amount_adjusted, oc.batch_id, oc.status_code, aus.name, oc.payment_method, lk_pm.meaning payment_method_name, oc.source_object_id, oc.source_object_class , oc.cust_account_id , hp.party_id, oc.comments, oc.cust_billto_acct_site_id, oc.custom_setup_id FROM ozf_claims oc, ozf_claim_types_vl oct, ams_user_statuses_vl aus, ozf_reason_codes_vl orc, hz_parties hp, hz_cust_accounts hca, ozf_lookups lk_pm WHERE oc.reason_code_id = orc.reason_code_id AND oc.claim_type_id = oct.claim_type_id AND oc.user_status_id = aus.user_status_id AND oc.cust_account_id = hca.cust_account_id AND hp.party_id = hca.party_id AND oc.payment_method = lk_pm.lookup_code (+) AND lk_pm.lookup_type (+) = 'OZF_PAYMENT_METHOD'

View Text - HTML Formatted

SELECT OC.CLAIM_ID
, OC.CLAIM_NUMBER
, OC.CLAIM_TYPE_ID
, OCT.NAME
, OC.REASON_CODE_ID
, ORC.NAME
, OC.CLAIM_DATE
, OC.DUE_DATE
, OC.OWNER_ID
, OC.CURRENCY_CODE
, OC.AMOUNT
, OC.AMOUNT_REMAINING
, OC.AMOUNT_SETTLED
, OC.AMOUNT_ADJUSTED
, OC.BATCH_ID
, OC.STATUS_CODE
, AUS.NAME
, OC.PAYMENT_METHOD
, LK_PM.MEANING PAYMENT_METHOD_NAME
, OC.SOURCE_OBJECT_ID
, OC.SOURCE_OBJECT_CLASS
, OC.CUST_ACCOUNT_ID
, HP.PARTY_ID
, OC.COMMENTS
, OC.CUST_BILLTO_ACCT_SITE_ID
, OC.CUSTOM_SETUP_ID
FROM OZF_CLAIMS OC
, OZF_CLAIM_TYPES_VL OCT
, AMS_USER_STATUSES_VL AUS
, OZF_REASON_CODES_VL ORC
, HZ_PARTIES HP
, HZ_CUST_ACCOUNTS HCA
, OZF_LOOKUPS LK_PM
WHERE OC.REASON_CODE_ID = ORC.REASON_CODE_ID
AND OC.CLAIM_TYPE_ID = OCT.CLAIM_TYPE_ID
AND OC.USER_STATUS_ID = AUS.USER_STATUS_ID
AND OC.CUST_ACCOUNT_ID = HCA.CUST_ACCOUNT_ID
AND HP.PARTY_ID = HCA.PARTY_ID
AND OC.PAYMENT_METHOD = LK_PM.LOOKUP_CODE (+)
AND LK_PM.LOOKUP_TYPE (+) = 'OZF_PAYMENT_METHOD'