[Home] [Help]
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
Name |
UTILIZATION_ID |
FUND_ID |
PLAN_TYPE |
PLAN_ID |
COMPONENT_TYPE |
COMPONENT_ID |
OBJECT_TYPE |
CLAIM_NUM |
CLAIM_DATE |
CUST_NAME |
PAYMENT_METHOD |
CURRENCY |
AMOUNT |
CLAIM_ID |
CLAIM_LINE_ID |