VIEW: APPS.OZF_XLA_CLAIM_LINES_V

Source

View Text - Preformatted

SELECT /*+ leading(XEG) use_nl(XEG OXH)*/ XEG.EVENT_ID EVENT_ID, OXL.LINE_NUMBER LINE_NUMBER, CLU.CLAIM_LINE_UTIL_ID DISTRIBUTION_IDENTIFIER, CLU.CLAIM_LINE_ID CLAIM_LINE_ID, UTIL.UTILIZATION_ID UTILIZATION_ID, CLN.AMOUNT CLAIM_LINE_AMOUNT, CLN.ACCTD_AMOUNT CLAIM_LINE_LEDGER_AMOUNT, CLU.AMOUNT CLAIM_UTIL_AMOUNT, CLU.ACCTD_AMOUNT CLAIM_CLEARING_LEDGER_AMOUNT, CLU.UTILIZED_ACCTD_AMOUNT CLAIM_ACCRUAL_LEDGER_AMOUNT, CLU.FXGL_ACCTD_AMOUNT GAIN_LOSS_LEDGER_AMOUNT, 0 GAIN_LOSS_AMOUNT, UTIL.EXCHANGE_RATE_DATE UTIL_EXCHANGE_RATE_DATE, UTIL.EXCHANGE_RATE_TYPE UTIL_EXCHANGE_RATE_TYPE, UTIL.EXCHANGE_RATE UTIL_EXCHANGE_RATE, CLN.ACTIVITY_TYPE ACTIVITY_TYPE, CLN.ACTIVITY_ID ACTIVITY_ID, CLN.OFFER_ID OFFER_ID, CLN.ITEM_ID ITEM_ID, CLN.ITEM_TYPE ITEM_TYPE, CLN.ATTRIBUTE_CATEGORY LINE_ATTR_CATEGORY, CLN.ATTRIBUTE1 LINE_ATTRIBUTE1 , CLN.ATTRIBUTE2 LINE_ATTRIBUTE2 , CLN.ATTRIBUTE3 LINE_ATTRIBUTE3 , CLN.ATTRIBUTE4 LINE_ATTRIBUTE4 , CLN.ATTRIBUTE5 LINE_ATTRIBUTE5 , CLN.ATTRIBUTE6 LINE_ATTRIBUTE6 , CLN.ATTRIBUTE7 LINE_ATTRIBUTE7 , CLN.ATTRIBUTE8 LINE_ATTRIBUTE8 , CLN.ATTRIBUTE9 LINE_ATTRIBUTE9 , CLN.ATTRIBUTE10 LINE_ATTRIBUTE10 , CLN.ATTRIBUTE11 LINE_ATTRIBUTE11 , CLN.ATTRIBUTE12 LINE_ATTRIBUTE12 , CLN.ATTRIBUTE13 LINE_ATTRIBUTE13 , CLN.ATTRIBUTE14 LINE_ATTRIBUTE14 , CLN.ATTRIBUTE15 LINE_ATTRIBUTE15, FUND.ACCRUED_LIABLE_ACCOUNT FUND_LIAB_ACCT_CCID, FUND.DED_ADJUSTMENT_ACCOUNT FUND_EXP_ACCT_CCID, FCAT.ACCRUED_LIABILITY_ACCOUNT FUND_CATG_LIAB_ACCT_CCID, FCAT.DED_ADJUSTMENT_ACCOUNT FUND_CATG_EXP_ACCT_CCID, OXL.ACTG_CLAIM_ACC_ACCT_CCID ACTG_CLAIM_ACC_ACCT_CCID, OXL.ACTG_CLAIM_EXP_ACCT_CCID ACTG_CLAIM_EXP_ACCT_CCID FROM OZF_CLAIMS_ALL CLA, OZF_CLAIM_LINES_ALL CLN, OZF_CLAIM_LINES_UTIL_ALL CLU, OZF_FUNDS_UTILIZED_ALL_B UTIL, OZF_XLA_CLAIM_LINES OXL, OZF_XLA_CLAIM_HEADERS OXH, XLA_EVENTS_GT XEG, OZF_FUNDS_ALL_B FUND, AMS_CATEGORIES_B FCAT WHERE XEG.ENTITY_CODE = 'CLAIM_SETTLEMENT' AND XEG.SOURCE_ID_INT_1 = OXH.CLAIM_ID AND OXH.EVENT_TYPE_CODE = XEG.EVENT_TYPE_CODE AND XEG.EVENT_ID = OXH.EVENT_ID AND XEG.APPLICATION_ID = 682 AND OXH.CLAIM_ID = CLA.CLAIM_ID AND CLA.CLAIM_ID = CLN.CLAIM_ID AND CLN.CLAIM_LINE_ID = CLU.CLAIM_LINE_ID AND CLU.UTILIZATION_ID = UTIL.UTILIZATION_ID AND OXH.XLA_CLAIM_HEADER_ID = OXL.XLA_CLAIM_HEADER_ID AND OXL.CLAIM_LINE_UTIL_ID = CLU.CLAIM_LINE_UTIL_ID AND UTIL.FUND_ID = FUND.FUND_ID AND FUND.CATEGORY_ID = FCAT.CATEGORY_ID

View Text - HTML Formatted

SELECT /*+ LEADING(XEG) USE_NL(XEG OXH)*/ XEG.EVENT_ID EVENT_ID
, OXL.LINE_NUMBER LINE_NUMBER
, CLU.CLAIM_LINE_UTIL_ID DISTRIBUTION_IDENTIFIER
, CLU.CLAIM_LINE_ID CLAIM_LINE_ID
, UTIL.UTILIZATION_ID UTILIZATION_ID
, CLN.AMOUNT CLAIM_LINE_AMOUNT
, CLN.ACCTD_AMOUNT CLAIM_LINE_LEDGER_AMOUNT
, CLU.AMOUNT CLAIM_UTIL_AMOUNT
, CLU.ACCTD_AMOUNT CLAIM_CLEARING_LEDGER_AMOUNT
, CLU.UTILIZED_ACCTD_AMOUNT CLAIM_ACCRUAL_LEDGER_AMOUNT
, CLU.FXGL_ACCTD_AMOUNT GAIN_LOSS_LEDGER_AMOUNT
, 0 GAIN_LOSS_AMOUNT
, UTIL.EXCHANGE_RATE_DATE UTIL_EXCHANGE_RATE_DATE
, UTIL.EXCHANGE_RATE_TYPE UTIL_EXCHANGE_RATE_TYPE
, UTIL.EXCHANGE_RATE UTIL_EXCHANGE_RATE
, CLN.ACTIVITY_TYPE ACTIVITY_TYPE
, CLN.ACTIVITY_ID ACTIVITY_ID
, CLN.OFFER_ID OFFER_ID
, CLN.ITEM_ID ITEM_ID
, CLN.ITEM_TYPE ITEM_TYPE
, CLN.ATTRIBUTE_CATEGORY LINE_ATTR_CATEGORY
, CLN.ATTRIBUTE1 LINE_ATTRIBUTE1
, CLN.ATTRIBUTE2 LINE_ATTRIBUTE2
, CLN.ATTRIBUTE3 LINE_ATTRIBUTE3
, CLN.ATTRIBUTE4 LINE_ATTRIBUTE4
, CLN.ATTRIBUTE5 LINE_ATTRIBUTE5
, CLN.ATTRIBUTE6 LINE_ATTRIBUTE6
, CLN.ATTRIBUTE7 LINE_ATTRIBUTE7
, CLN.ATTRIBUTE8 LINE_ATTRIBUTE8
, CLN.ATTRIBUTE9 LINE_ATTRIBUTE9
, CLN.ATTRIBUTE10 LINE_ATTRIBUTE10
, CLN.ATTRIBUTE11 LINE_ATTRIBUTE11
, CLN.ATTRIBUTE12 LINE_ATTRIBUTE12
, CLN.ATTRIBUTE13 LINE_ATTRIBUTE13
, CLN.ATTRIBUTE14 LINE_ATTRIBUTE14
, CLN.ATTRIBUTE15 LINE_ATTRIBUTE15
, FUND.ACCRUED_LIABLE_ACCOUNT FUND_LIAB_ACCT_CCID
, FUND.DED_ADJUSTMENT_ACCOUNT FUND_EXP_ACCT_CCID
, FCAT.ACCRUED_LIABILITY_ACCOUNT FUND_CATG_LIAB_ACCT_CCID
, FCAT.DED_ADJUSTMENT_ACCOUNT FUND_CATG_EXP_ACCT_CCID
, OXL.ACTG_CLAIM_ACC_ACCT_CCID ACTG_CLAIM_ACC_ACCT_CCID
, OXL.ACTG_CLAIM_EXP_ACCT_CCID ACTG_CLAIM_EXP_ACCT_CCID
FROM OZF_CLAIMS_ALL CLA
, OZF_CLAIM_LINES_ALL CLN
, OZF_CLAIM_LINES_UTIL_ALL CLU
, OZF_FUNDS_UTILIZED_ALL_B UTIL
, OZF_XLA_CLAIM_LINES OXL
, OZF_XLA_CLAIM_HEADERS OXH
, XLA_EVENTS_GT XEG
, OZF_FUNDS_ALL_B FUND
, AMS_CATEGORIES_B FCAT
WHERE XEG.ENTITY_CODE = 'CLAIM_SETTLEMENT'
AND XEG.SOURCE_ID_INT_1 = OXH.CLAIM_ID
AND OXH.EVENT_TYPE_CODE = XEG.EVENT_TYPE_CODE
AND XEG.EVENT_ID = OXH.EVENT_ID
AND XEG.APPLICATION_ID = 682
AND OXH.CLAIM_ID = CLA.CLAIM_ID
AND CLA.CLAIM_ID = CLN.CLAIM_ID
AND CLN.CLAIM_LINE_ID = CLU.CLAIM_LINE_ID
AND CLU.UTILIZATION_ID = UTIL.UTILIZATION_ID
AND OXH.XLA_CLAIM_HEADER_ID = OXL.XLA_CLAIM_HEADER_ID
AND OXL.CLAIM_LINE_UTIL_ID = CLU.CLAIM_LINE_UTIL_ID
AND UTIL.FUND_ID = FUND.FUND_ID
AND FUND.CATEGORY_ID = FCAT.CATEGORY_ID