View: OZF_FUNDS_PAID_V

Product:	OZF - Trade Management
Description:	View on Funds Paid and Claims to present Funds paid details
Implementation/DBA Data:	APPS.OZF_FUNDS_PAID_V

View Text

SELECT UTIL.UTILIZATION_ID
, UTIL.FUND_ID
, UTIL.PLAN_TYPE
, UTIL.PLAN_ID
, UTIL.COMPONENT_TYPE
, UTIL.COMPONENT_ID
, UTIL.OBJECT_TYPE
, CLA.CLAIM_NUMBER
, CLA.CLAIM_DATE
, HZA.ACCOUNT_NAME
, CLN.PAYMENT_METHOD
, CLN.CURRENCY_CODE
, CLN.AMOUNT
, CLA.CLAIM_ID
, CLN.CLAIM_LINE_ID
FROM OZF_FUNDS_UTILIZED_ALL_B UTIL
, OZF_CLAIM_LINES CLN
, OZF_CLAIMS CLA
, HZ_CUST_ACCOUNTS HZA
WHERE UTIL.UTILIZATION_ID = CLN.UTILIZATION_ID(+)
AND CLN.CLAIM_ID = CLA.CLAIM_ID
AND CLA.CUST_ACCOUNT_ID = HZA.CUST_ACCOUNT_ID

Columns