VIEW: APPS.OZF_REQ_CLAIMS_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.batch_id, oc.status_code, aus.name, oc.payment_method, oc.source_object_id, oc.source_object_class , oc.cust_account_id , lk.meaning request_type, hp.party_id, oc.pay_related_account_flag, oc.related_cust_account_id, oc.relationship_type, oc.comments, hp.party_name, oc.customer_ref_number, oc.customer_ref_date, oc.org_id FROM ozf_claims_all oc, ozf_claim_types_all_vl oct, ams_user_statuses_vl aus, ozf_reason_codes_all_vl orc, ozf_request_headers_all_b orh, hz_parties hp, hz_cust_accounts hca, ozf_lookups lk 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.source_object_class in ('SPECIAL_PRICE', 'SOFT_FUND') and oc.cust_account_id = hca.CUST_ACCOUNT_ID and hp.party_id = hca.party_id and oc.source_object_id = orh.request_header_id and lk.lookup_type = 'OZF_REQUEST_TYPE' and lk.lookup_code = orh.request_type_code

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.BATCH_ID
, OC.STATUS_CODE
, AUS.NAME
, OC.PAYMENT_METHOD
, OC.SOURCE_OBJECT_ID
, OC.SOURCE_OBJECT_CLASS
, OC.CUST_ACCOUNT_ID
, LK.MEANING REQUEST_TYPE
, HP.PARTY_ID
, OC.PAY_RELATED_ACCOUNT_FLAG
, OC.RELATED_CUST_ACCOUNT_ID
, OC.RELATIONSHIP_TYPE
, OC.COMMENTS
, HP.PARTY_NAME
, OC.CUSTOMER_REF_NUMBER
, OC.CUSTOMER_REF_DATE
, OC.ORG_ID
FROM OZF_CLAIMS_ALL OC
, OZF_CLAIM_TYPES_ALL_VL OCT
, AMS_USER_STATUSES_VL AUS
, OZF_REASON_CODES_ALL_VL ORC
, OZF_REQUEST_HEADERS_ALL_B ORH
, HZ_PARTIES HP
, HZ_CUST_ACCOUNTS HCA
, OZF_LOOKUPS LK
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.SOURCE_OBJECT_CLASS IN ('SPECIAL_PRICE'
, 'SOFT_FUND')
AND OC.CUST_ACCOUNT_ID = HCA.CUST_ACCOUNT_ID
AND HP.PARTY_ID = HCA.PARTY_ID
AND OC.SOURCE_OBJECT_ID = ORH.REQUEST_HEADER_ID
AND LK.LOOKUP_TYPE = 'OZF_REQUEST_TYPE'
AND LK.LOOKUP_CODE = ORH.REQUEST_TYPE_CODE