Help - Search - Members - Calendar
Full Version: performance tuning of view
Oracle DBA Forums > Oracle > Oracle Forum
manojg9
Pl help in tuning below View Definition :

CREATE OR REPLACE FORCE VIEW LOANDETAILS_VW(AGG_CODE,LOAN_ID,CUST_NAME,HEADER_ACC,HEADER_ACC_NAME,HEADER_ACC_
ID,STATUS,PARTY_CUST_NAME,PARTY_ACC_NUM,PARTY_ACC_NAME,PARTY_ACC_ID,LOAN_TYPE,OUT
STANDING_AMOUNT,REPAYMENT_TERMS,TENOT_PARTIAL_REPAYMENT,POST_INTEREST,POSTING_CYC
LE,INTEREST_POSTING_OPTION,HEADER_CRL,HEADER_LEGAL_ENTITY_NAME,PARTICIPANT_CRL,PA
RTY_LEGAL_ENTITY_NAME,LOAN_CCY,TRANSACTION_ID,TRANSACTION_STATUS,ERROR_REASON,BUS
INESS_DATE,FLG_ACTIVE,HEADERCOD_GL,BORROWERCOD_GL,HEADERCOD_COUNTRY,BORROWERCOD_C
OUNTRY,HEADERCOD_BRANCH,BORROWERCOD_BRANCH,FLG_INCO_VARIANT,ICL_ID,FLG_CALCINTERE
ST,FLG_WHT,FLG_REPORTINGFREQ,FLG_WHTPOSTALLOWED,NBR_STRCID,NBR_INSTRID,NBR_STRGRP
ID,COD_DEF_ACCR_CYCLE,DAT_FIRST_POSTING,DAT_LASTPOSTING,DAT_LOANSTART,DAT_LOANEND
,TENOR,AMT_LOAN,COD_GL,TYP_LIMIT,AMTINTERESTNOTPOSTED,COD_SERVER,LOAN_VARIANT,FLG
_YTD)
AS
SELECT LOANDTLS.COD_AGREEMENT "AGG_CODE",
LOANDTLS.COD_INCOLOANID "LOAN_ID",
CLNT1.TXT_NAMCLIENT "CUST_NAME",
ACCT1.NBR_COREACCOUNT "HEADER_ACC",
ACCT1.TXT_NAMOWNACCOUNT "HEADER_ACC_NAME",
LOANDTLS.NBR_HDRACCT "HEADER_ACC_ID",
(
CASE
WHEN LOANDTLS.FLG_HEADERROLE='L'
THEN 'LENDER ACCOUNT'
WHEN LOANDTLS.FLG_HEADERROLE='B'
THEN 'BORROWER ACCOUNT'
END) "STATUS",
CLNT2.TXT_NAMCLIENT "PARTY_CUST_NAME",
ACCT2.NBR_COREACCOUNT "PARTY_ACC_NUM",
ACCT2.TXT_NAMOWNACCOUNT "PARTY_ACC_NAME",
LOANDTLS.NBR_PARTICIPANTACCT "PARTY_ACC_ID",
LOANDTLS.FLG_LOAN_TXN "LOAN_TYPE",
INCOPOSITION.AMT_NETVALUEBALANCE "OUTSTANDING_AMOUNT",
LOANDTLS.TYP_REPAYMENT "REPAYMENT_TERMS",
LOANDTLS.FLG_INCOPARTIALREPAYMENT "TENOT_PARTIAL_REPAYMENT",
LOANDTLS.FLG_INTPOSTALLOWED "POST_INTEREST",
LOANDTLS.COD_DEF_POST_CYCLE "POSTING_CYCLE",
LOANDTLS.TYP_INTPOSTOPTION "INTEREST_POSTING_OPTION",
ACCT1.COD_CRLNUM "HEADER_CRL",
JP1.TXT_ALIAS_FULL_NAME1 "HEADER_LEGAL_ENTITY_NAME",
ACCT2.COD_CRLNUM "PARTICIPANT_CRL",
JP2.TXT_ALIAS_FULL_NAME1 "PARTY_LEGAL_ENTITY_NAME",
LOANDTLS.COD_REFCURRENCY "LOAN_CCY",
(
CASE
WHEN LOANDTLS.NBR_ACTIVETRANSACTIONID IS NOT NULL
THEN LOANDTLS.NBR_ACTIVETRANSACTIONID
|| ''
ELSE
(SELECT DISTINCT TXT_REFCODE
FROM OLM_INSTRTXNVW INSTRDTL
WHERE LOANDTLS.COD_INCOID=INSTRDTL.COD_INCOID
AND INSTRDTL.TXT_REFTYPE='SWEEPS'
AND INSTRDTL.TXT_STATUS='SUCCESSFUL'
AND ROWNUM<2
)
END) "TRANSACTION_ID",
'SUCCESS' "TRANSACTION_STATUS",
'' "ERROR_REASON",
INCOPOSITION.DAT_BUSINESS "BUSINESS_DATE",
LOANDTLS.FLG_ACTIVE "FLG_ACTIVE",
ACCT1.COD_BNK_LGL "HEADERCOD_GL",
ACCT2.COD_BNK_LGL "BORROWERCOD_GL",
ACCT1.COD_COUNTRY "HEADERCOD_COUNTRY",
ACCT2.COD_COUNTRY "BORROWERCOD_COUNTRY",
ACCT1.COD_BRANCH "HEADERCOD_BRANCH",
ACCT2.COD_BRANCH "BORROWERCOD_BRANCH",
LOANDTLS.FLG_INCO_VARIANT,
LOANDTLS.COD_INCOID "ICL_ID",
LOANDTLS.FLG_CALCINTEREST,
LOANDTLS.FLG_WHT,
LOANDEF.FLG_REPORTINGFREQ,
LOANDTLS.FLG_WHTPOSTALLOWED,
(
CASE
WHEN LOANDTLS.NBR_ACTIVETRANSACTIONID IS NULL
THEN DTLS.NBR_STRCID
ELSE(
CASE
WHEN ACTTRNS.FLG_ACTTXN='I'
THEN ACTTRNS.NBR_STRCID
ELSE NULL
END)
END) NBR_STRCID,
(
CASE
WHEN LOANDTLS.NBR_ACTIVETRANSACTIONID IS NULL
THEN DTLS.NBR_INSTRID
ELSE(
CASE
WHEN ACTTRNS.FLG_ACTTXN='I'
THEN ACTTRNS.NBR_INSTRID
ELSE NULL
END)
END) NBR_INSTRID,
(
CASE
WHEN LOANDTLS.NBR_ACTIVETRANSACTIONID IS NULL
THEN DTLS.NBR_STRGRPID
ELSE(
CASE
WHEN ACTTRNS.FLG_ACTTXN='I'
THEN DTLS.NBR_STRGRPID
ELSE NULL
END)
END) NBR_STRGRPID,
LOANDTLS.COD_DEF_ACCR_CYCLE "COD_DEF_ACCR_CYCLE",
LOANDTLS.DAT_FIRST_POSTING "DAT_FIRST_POSTING",
LOANDTLS.DAT_LASTPOSTING "DAT_LASTPOSTING",
CASE
WHEN(LOANDTLS.FLG_INCO_VARIANT='L')
THEN DTLS.DAT_START_INCO_TRACKING
ELSE LOANDTLS.DAT_LOANSTART
END "DAT_LOANSTART",
CASE
WHEN(LOANDTLS.FLG_INCO_VARIANT='L')
THEN DTLS.DAT_END_INCO_TRACKING
ELSE LOANDTLS.DAT_LOANEND
END "DAT_LOANEND",
LOANDTLS.NBR_TENOR "TENOR",
CASE
WHEN(LOANDTLS.FLG_LOAN_TXN='Y')
THEN LOANDTLS.AMT_ORIGINALLOAN
ELSE INCOPOSITION.AMT_BALANCE_2
END "AMT_LOAN",
LOANDTLS.COD_DOMICILEGL "COD_GL",
LOANDEF.TYP_LIMIT,
(SELECT SUM(DECODE(SUBSTR(cod_txn,LENGTH(cod_txn)-1,1),'C',AMT_ACCRUEDNOTPOSTED,-1*AMT_ACCRUEDNOTPOSTED))
FROM OPOOL_POSTINGSUMMARY
WHERE NBR_OWNACCOUNT=LOANDTLS.COD_INCOLOANID
AND TXT_STATUS='NO_POSTING'
) AMTINTERESTNOTPOSTED,
LOANDTLS.COD_SERVER "COD_SERVER",
LOANDTLS.FLG_ENTRUSTLOAN "LOAN_VARIANT",
LOANDEF.FLG_YTD "FLG_YTD"
FROM
(SELECT*
FROM OLM_INCO_LOAN_DETAILS A,
(SELECT DISTINCT COD_ENTITY,
COD_DEF_ACCR_CYCLE,
COD_DEF_POST_CYCLE,
TYP_INTPOSTOPTION,
DAT_FIRST_POSTING,
DAT_LASTPOSTING,
DAT_START,
DAT_END
FROM ORATE_ENTITY_INTEREST,
OLM_HOSTSYSTEMDATES OHD,
OLM_INCO_LOAN_DETAILS A
WHERE TYP_ENTITY='INCOLOAN'
AND A.COD_INCOLOANID=COD_ENTITY
AND A.FLG_CALCINTEREST='Y'
AND COD_MODULE='SWEEPS'
AND COD_GL=A.COD_DOMICILEGL
AND DAT_START<=OHD.DAT_TODAY
AND(DAT_END IS NULL
OR OHD.DAT_TODAY<=DAT_END)
) B
WHERE A.COD_INCOLOANID=B.COD_ENTITY(+)
) LOANDTLS,
ORBICASH_CLIENTMST CLNT1,
ORBICASH_ACCOUNTS ACCT1,
ORBICASH_CLIENTMST CLNT2,
ORBICASH_ACCOUNTS ACCT2,
JP_CRL JP1,
JP_CRL JP2,
OLM_INCO_POSITION INCOPOSITION,
OLM_HOSTSYSTEMDATES HOST,
OLM_INCO_DEFINITION LOANDEF,
(SELECT DISTINCT DAT_END_INCO_TRACKING,
DAT_START_INCO_TRACKING,
COD_INCOID,
B.NBR_STRGRPID,
A.NBR_STRCID,
A.NBR_INSTRID
FROM OLM_SOURCE_ACCOUNT_DTLS A,
OLM_STRUCTURE_HEADER B
WHERE A.NBR_STRCID=B.NBR_STRCID
AND COD_INCOID IS NOT NULL
) DTLS,
olm_activetransaction acttrns
WHERE LOANDTLS.NBR_HDRACCT=ACCT1.NBR_OWNACCOUNT
AND ACCT1.COD_ENTITY=CLNT1.COD_CIF
AND LOANDTLS.NBR_PARTICIPANTACCT=ACCT2.NBR_OWNACCOUNT
AND ACCT2.COD_ENTITY=CLNT2.COD_CIF
AND JP1.COD_CRL=ACCT1.COD_CRLNUM
AND JP2.COD_CRL=ACCT2.COD_CRLNUM
AND JP1.COD_PU=ACCT1.COD_GL
AND JP2.COD_PU=ACCT2.COD_GL
AND INCOPOSITION.COD_ENTITY=LOANDTLS.COD_INCOLOANID
AND INCOPOSITION.TYP_ENTITY='INCOLOAN'
AND INCOPOSITION.DAT_BUSINESS=HOST.DAT_TODAY
AND HOST.COD_GL=LOANDTLS.COD_DOMICILEGL
AND HOST.COD_MODULE='SWEEPS'
AND LOANDEF.COD_INCOID(+)=LOANDTLS.COD_INCOID
AND loandtls.nbr_activetransactionid=acttrns.nbr_activetransactionid (+)
AND LOANDTLS.COD_INCOID=DTLS.cod_incoid(+)
UNION
SELECT LOANDTLS.COD_AGREEMENT "AGG_CODE",
0
|| '' "LOAN_ID",
CLNT1.TXT_NAMCLIENT "CUST_NAME",
ACCT1.NBR_COREACCOUNT "HEADER_ACC",
ACCT1.TXT_NAMOWNACCOUNT "HEADER_ACC_NAME",
LOANDTLS.HEADER_ACC_ID "HEADER_ACC_ID",
LOANDTLS.STATUS "STATUS",
CLNT2.TXT_NAMCLIENT "PARTY_CUST_NAME",
ACCT2.NBR_COREACCOUNT "PARTY_ACC_NUM",
ACCT2.TXT_NAMOWNACCOUNT "PARTY_ACC_NAME",
LOANDTLS.PARTY_ACC_ID "PARTY_ACC_ID",
FLG_LOAN_TXN "LOAN_TYPE",
0 "OUTSTANDING_AMOUNT",
LOANDTLS.REPAYMENT_TERMS "REPAYMENT_TERMS",
LOANDTLS.TENOT_PARTIAL_REPAYMENT "TENOT_PARTIAL_REPAYMENT",
LOANDTLS.POST_INTEREST "POST_INTEREST",
LOANDTLS.COD_DEF_POST_CYCLE "POSTING_CYCLE",
LOANDTLS.TYP_INTPOSTOPTION "INTEREST_POSTING_OPTION",
ACCT1.COD_CRLNUM "HEADER_CRL",
JP1.TXT_ALIAS_FULL_NAME1 "HEADER_LEGAL_ENTITY_NAME",
ACCT2.COD_CRLNUM "PARTICIPANT_CRL",
JP2.TXT_ALIAS_FULL_NAME1 "PARTY_LEGAL_ENTITY_NAME",
ACCT1.COD_CCY "LOAN_CCY",
COD_INCOID "TRANSACTION_ID",
'REJECTED' "TRANSACTION_STATUS",
(
CASE
WHEN COD_REASON IS NOT NULL
THEN COD_REASON
WHEN COD_REASON IS NULL
AND TXT_STATUS!='SUCCESSFUL'
THEN TXT_STATUS
END) "ERROR_REASON",
DAT_BUSINESS "BUSINESS_DATE",
'R' "FLG_ACTIVE",
ACCT1.COD_BNK_LGL "HEADERCOD_GL",
ACCT2.COD_BNK_LGL "BORROWERCOD_GL",
ACCT1.COD_COUNTRY "HEADERCOD_COUNTRY",
ACCT2.COD_COUNTRY "BORROWERCOD_COUNTRY",
ACCT1.COD_BRANCH "HEADERCOD_BRANCH",
ACCT2.COD_BRANCH "BORROWERCOD_BRANCH",
LOANDTLS.FLG_INCO_VARIANT,
NULL "ICL_ID",
FLG_CALCINTEREST,
FLG_WHT,
FLG_REPORTINGFREQ,
FLG_WHTPOSTALLOWED,
NULL NBR_STRCID,
NULL NBR_INSTRID,
NULL NBR_STRGRPID,
LOANDTLS.COD_DEF_ACCR_CYCLE "COD_DEF_ACCR_CYCLE",
LOANDTLS.DAT_FIRST_POSTING "DAT_FIRST_POSTING",
LOANDTLS.DAT_LASTPOSTING "DAT_LAST_POSTING",
NULL "DAT_LOANSTART",
NULL "DAT_LOANEND",
NULL "TENOR",
NULL "AMT_LOAN",
LOANDTLS.COD_DOMICILEGL "COD_GL",
TYP_LIMIT,
0 AMTINTERESTNOTPOSTED,
LOANDTLS.COD_SERVER "COD_SERVER",
AG1.FLG_ENTRUSTLOAN "LOAN_VARIANT",
FLG_YTD
FROM ORBICASH_CLIENTMST CLNT1,
ORBICASH_ACCOUNTS ACCT1,
ORBICASH_CLIENTMST CLNT2,
ORBICASH_ACCOUNTS ACCT2,
JP_CRL JP1,
JP_CRL JP2,
(
(SELECT A.FLG_LOAN_TXN FLG_LOAN_TXN,
A.COD_AGREEMENT COD_AGREEMENT,
B.TXT_REFCODE
|| '' COD_INCOID,
COD_ENTITY1 HEADER_ACC_ID,
'LENDER ACCOUNT' STATUS,
COD_ENTITY2 PARTY_ACC_ID,
TYP_REPAYMENT REPAYMENT_TERMS,
FLG_INCOPARTIALREPAYMENT TENOT_PARTIAL_REPAYMENT,
FLG_INTPOSTALLOWED POST_INTEREST,
'INCO' TYPE1,
COD_DOMICILEGL COD_DOMICILEGL,
B.DAT_BUSINESS DAT_BUSINESS,
B.COD_REASON,
B.TXT_STATUS,
A.FLG_INCO_VARIANT,
A.FLG_CALCINTEREST,
A.FLG_WHT,
A.FLG_REPORTINGFREQ,
A.FLG_INTPOSTALLOWED,
A.FLG_WHTPOSTALLOWED,
A.TYP_LIMIT,
C.COD_DEF_ACCR_CYCLE,
C.COD_DEF_POST_CYCLE,
C.TYP_INTPOSTOPTION,
C.DAT_FIRST_POSTING,
C.DAT_LASTPOSTING,
B.COD_INCOID INCOID,
a.COD_SERVER,a.flg_ytd
FROM OLM_INCO_DEFINITION A,
OLM_INSTRTXNVW B,
(SELECT DISTINCT COD_ENTITY,
COD_DEF_ACCR_CYCLE,
COD_DEF_POST_CYCLE,
TYP_INTPOSTOPTION,
DAT_FIRST_POSTING,
DAT_LASTPOSTING,
DAT_START,
DAT_END,
OEI.TYP_ENTITY
FROM ORATE_ENTITY_INTEREST OEI,
OLM_HOSTSYSTEMDATES OHD,
OLM_INCO_DEFINITION A
WHERE OEI.TYP_ENTITY='INCO'
AND A.COD_INCOID=OEI.COD_ENTITY
AND A.FLG_CALCINTEREST='Y'
AND COD_MODULE='SWEEPS'
AND COD_GL=A.COD_DOMICILEGL
AND OEI.DAT_START<=OHD.DAT_TODAY
AND(OEI.DAT_END IS NULL
OR OHD.DAT_TODAY<=OEI.DAT_END)
) C
WHERE A.COD_INCOID=B.COD_INCOID
AND B.COD_INCOID!='-1'
AND B.TXT_STATUS!='SUCCESSFUL'
AND A.COD_INCOID=C.COD_ENTITY(+)
)
UNION
SELECT INSTRTXN.FLG_LOAN_TXN FLG_LOAN_TXN,
INSTRTXN.COD_AGREEMENT COD_AGREEMENT,
NBR_ACTIVETRANSACTIONID
|| '' COD_INCOID,
INSTRTXN.NBR_SRCACCT HEADER_ACC_ID,
DECODE('L','LENDER ACCOUNT','BORROWER ACCOUNT') STATUS,
INSTRTXN.NBR_TGTACCT PARTY_ACC_ID,
TYP_REPAYMENT REPAYMENT_TERMS,
FLG_INCOPARTIALREPAYMENT TENOT_PARTIAL_REPAYMENT,
FLG_INTPOSTALLOWED POST_INTEREST,
'ACTIVETRANSACTION' TYPE1,
COD_DOMICILEGL COD_DOMICILEGL,
INSTRTXN.DAT_BUSINESS DAT_BUSINESS,
INSTRTXN.COD_REASON,
INSTRTXN.TXT_STATUS,
FLG_INCO_VARIANT,
FLG_CALCINTEREST,
FLG_WHT,
NULL FLG_REPORTINGFREQ,
FLG_INTPOSTALLOWED,
FLG_WHTPOSTALLOWED,
NULL TYP_LIMIT,
C.COD_DEF_ACCR_CYCLE,
C.COD_DEF_POST_CYCLE,
C.TYP_INTPOSTOPTION,
C.DAT_FIRST_POSTING,
C.DAT_LASTPOSTING,
INSTRTXN.COD_INCOID INCOID,
A.COD_SERVER,'N' FLG_YTD
FROM OLM_ACTIVETRANSACTION A,
OLM_INSTRTXNVW INSTRTXN,
(SELECT DISTINCT COD_ENTITY,
COD_DEF_ACCR_CYCLE,
COD_DEF_POST_CYCLE,
TYP_INTPOSTOPTION,
DAT_FIRST_POSTING,
DAT_LASTPOSTING,
DAT_START,
DAT_END,
OEI.TYP_ENTITY
FROM ORATE_ENTITY_INTEREST OEI,
OLM_HOSTSYSTEMDATES OHD,
OLM_ACTIVETRANSACTION A
WHERE OEI.TYP_ENTITY='ACTIVETRANSACTION'
AND A.COD_INCOID=OEI.COD_ENTITY
AND A.FLG_CALCINTEREST='Y'
AND COD_MODULE='SWEEPS'
AND COD_GL=A.COD_DOMICILEGL
AND OEI.DAT_START<=OHD.DAT_TODAY
AND(OEI.DAT_END IS NULL
OR OHD.DAT_TODAY<=OEI.DAT_END)
) C
WHERE INSTRTXN.COD_INCOID='-1'
AND INSTRTXN.COD_REASON IN ('OLM700000','OLM700001','OLM700002','OLM700003', 'OLM666665','OLM666666','OLM666667','OLM666668', 'OLM666669')
AND INSTRTXN.TXT_STATUS!='SUCCESSFUL'
AND TXT_REFCODE=NBR_ACTIVETRANSACTIONID
AND INSTRTXN.TXT_REFTYPE='ACTIVETRANSACTION'
AND A.COD_INCOID=C.COD_ENTITY(+)) LOANDTLS,
OLM_INCO_AGREEMENT AG1
WHERE LOANDTLS.HEADER_ACC_ID=ACCT1.NBR_OWNACCOUNT
AND ACCT1.COD_ENTITY=CLNT1.COD_CIF
AND LOANDTLS.PARTY_ACC_ID=ACCT2.NBR_OWNACCOUNT
AND ACCT2.COD_ENTITY=CLNT2.COD_CIF
AND JP1.COD_CRL=ACCT1.COD_CRLNUM
AND JP2.COD_CRL=ACCT2.COD_CRLNUM
AND JP1.COD_PU=ACCT1.COD_GL
AND JP2.COD_PU=ACCT2.COD_GL
AND LOANDTLS.COD_AGREEMENT=AG1.COD_AGREEMENT(+);


Explain PLan :

OPERATION OPTIONS OBJECT_NODE OBJECT_OWNER OBJECT_NAME OBJECT_ALIAS OBJECT_INSTANCE OBJECT_TYPE OPTIMIZER SEARCH_COLUMNS ID PARENT_ID DEPTH POSITION COST CARDINALITY BYTES OTHER_TAG PARTITION_START PARTITION_STOP PARTITION_ID OTHER OTHER_XML DISTRIBUTION CPU_COST IO_COST TEMP_SPACE ACCESS_PREDICATES FILTER_PREDICATES PROJECTION TIME QBLOCK_NAME
SELECT STATEMENT ALL_ROWS 0 0 6184 6184 7623 8515909 191964753 338 75
UNION-ALL 1 0 1 1 (CLOB) <other_xml><info type="db_version">10.2.0.4</info><info type="parse_schema"><![CDATA["LIQU2_LMS"]]></info><info type="plan_hash">1930248558</info><outline_data><hint><![CDATA[FULL(@"SEL$15" "OLM_INSTRTXN"@"SEL$15")]]></hint><hint><![CDATA[FULL(@"SEL$16" "OLM_INSTRTXN_HISTORY"@"SEL$16")]]></hint><hint><![CDATA[SWAP_JOIN_INPUTS(@"SEL$17" "OHD"@"SEL$17")]]></hint><hint><![CDATA[USE_HASH(@"SEL$17" "OHD"@"SEL$17")]]></hint><hint><![CDATA[USE_HASH(@"SEL$17" "OEI"@"SEL$17")]]></hint><hint><![CDATA[LEADING(@"SEL$17" "A"@"SEL$17" "OEI"@"SEL$17" "OHD"@"SEL$17")]]></hint><hint><![CDATA[FULL(@"SEL$17" "OHD"@"SEL$17")]]></hint><hint><![CDATA[FULL(@"SEL$17" "OEI"@"SEL$17")]]></hint><hint><![CDATA[FULL(@"SEL$17" "A"@"SEL$17")]]></hint><hint><![CDATA[FULL(@"SEL$11" "OLM_INSTRTXN"@"SEL$11")]]></hint><hint><![CDATA[FULL(@"SEL$12" "OLM_INSTRTXN_HISTORY"@"SEL$12")]]></hint><hint><![CDATA[USE_HASH(@"SEL$13" "OEI"@"SEL$13")]]></hint><hint><![CDATA[USE_HASH(@"SEL$13" "A"@"SEL$13")]]></hint><hint><![CDATA[LEADING(@"SEL$13" "OHD"@"SEL$13" "A"@"SEL$13" "OEI"@"SEL$13")]]></hint><hint><![CDATA[FULL(@"SEL$13" "OEI"@"SEL$13")]]></hint><hint><![CDATA[FULL(@"SEL$13" "A"@"SEL$13")]]></hint><hint><![CDATA[FULL(@"SEL$13" "OHD"@"SEL$13")]]></hint><hint><![CDATA[SWAP_JOIN_INPUTS(@"SEL$10" "AG1"@"SEL$10")]]></hint><hint><![CDATA[USE_HASH(@"SEL$10" "AG1"@"SEL$10")]]></hint><hint><![CDATA[USE_HASH(@"SEL$10" "B"@"SEL$10")]]></hint><hint><![CDATA[USE_HASH(@"SEL$10" "C"@"SEL$10")]]></hint><hint><![CDATA[LEADING(@"SEL$10" "A"@"SEL$10" "C"@"SEL$10" "B"@"SEL$10" "AG1"@"SEL$10")]]></hint><hint><![CDATA[FULL(@"SEL$10" "AG1"@"SEL$10")]]></hint><hint><![CDATA[NO_ACCESS(@"SEL$10" "B"@"SEL$10")]]></hint><hint><![CDATA[NO_ACCESS(@"SEL$10" "C"@"SEL$10")]]></hint><hint><![CDATA[FULL(@"SEL$10" "A"@"SEL$10")]]></hint><hint><![CDATA[USE_HASH(@"SEL$14" "C"@"SEL$14")]]></hint><hint><![CDATA[USE_NL(@"SEL$14" "A"@"SEL$14")]]></hint><hint><![CDATA[USE_NL(@"SEL$14" "AG1"@"SEL$14")]]></hint><hint><![CDATA[LEADING(@"SEL$14" "INSTRTXN"@"SEL$14" "AG1"@"SEL$14" "A"@"SEL$14" "C"@"SEL$14")]]></hint><hint><![CDATA[NO_ACCESS(@"SEL$14" "C"@"SEL$14")]]></hint><hint><![CDATA[INDEX_RS_ASC(@"SEL$14" "A"@"SEL$14" ("OLM_ACTIVETRANSACTION"."NBR_ACTIVETRANSACTIONID"))]]></hint><hint><![CDATA[INDEX_RS_ASC(@"SEL$14" "AG1"@"SEL$14" ("OLM_INCO_AGREEMENT"."COD_AGREEMENT"))]]></hint><hint><![CDATA[NO_ACCESS(@"SEL$14" "INSTRTXN"@"SEL$14")]]></hint><hint><![CDATA[INDEX_RS_ASC(@"SEL$3" "OLM_INSTRTXN"@"SEL$3" ("OLM_INSTRTXN"."TXT_STATUS" "OLM_INSTRTXN"."COD_GLSRCACCT"))]]></hint><hint><![CDATA[FULL(@"SEL$4" "OLM_INSTRTXN_HISTORY"@"SEL$4")]]></hint><hint><![CDATA[NO_ACCESS(@"SEL$2" "INSTRDTL"@"SEL$2")]]></hint><hint><![CDATA[FULL(@"SEL$5" "OPOOL_POSTINGSUMMARY"@"SEL$5")]]></hint><hint><![CDATA[USE_HASH(@"SEL$8" "B"@"SEL$8")]]></hint><hint><![CDATA[LEADING(@"SEL$8" "A"@"SEL$8" "B"@"SEL$8")]]></hint><hint><![CDATA[FULL(@"SEL$8" "B"@"SEL$8")]]></hint><hint><![CDATA[FULL(@"SEL$8" "A"@"SEL$8")]]></hint><hint><![CDATA[USE_HASH(@"SEL$7" "ORATE_ENTITY_INTEREST"@"SEL$7")]]></hint><hint><![CDATA[USE_HASH(@"SEL$7" "A"@"SEL$7")]]></hint><hint><![CDATA[LEADING(@"SEL$7" "OHD"@"SEL$7" "A"@"SEL$7" "ORATE_ENTITY_INTEREST"@"SEL$7")]]></hint><hint><![CDATA[FULL(@"SEL$7" "ORATE_ENTITY_INTEREST"@"SEL$7")]]></hint><hint><![CDATA[FULL(@"SEL$7" "A"@"SEL$7")]]></hint><hint><![CDATA[FULL(@"SEL$7" "OHD"@"SEL$7")]]></hint><hint><![CDATA[SWAP_JOIN_INPUTS(@"SEL$560A7E3C" "B"@"SEL$6")]]></hint><hint><![CDATA[SWAP_JOIN_INPUTS(@"SEL$560A7E3C" "DTLS"@"SEL$1")]]></hint><hint><![CDATA[SWAP_JOIN_INPUTS(@"SEL$560A7E3C" "LOANDEF"@"SEL$1")]]></hint><hint><![CDATA[SWAP_JOIN_INPUTS(@"SEL$560A7E3C" "ACTTRNS"@"SEL$1")]]></hint><hint><![CDATA[USE_HASH(@"SEL$560A7E3C" "INCOPOSITION"@"SEL$1")]]></hint><hint><![CDATA[USE_HASH(@"SEL$560A7E3C" "B"@"SEL$6")]]></hint><hint><![CDATA[USE_HASH(@"SEL$560A7E3C" "DTLS"@"SEL$1")]]></hint><hint><![CDATA[USE_HASH(@"SEL$560A7E3C" "CLNT2"@"SEL$1")]]></hint><hint><![CDATA[USE_HASH(@"SEL$560A7E3C" "JP2"@"SEL$1")]]></hint><hint><![C... STRDEF[160], STRDEF[160], STRDEF[400], STRDEF[160], STRDEF[400], STRDEF[160], STRDEF[16], STRDEF[400], STRDEF[160], STRDEF[400], STRDEF[160], STRDEF[4], STRDEF[22], STRDEF[80], STRDEF[4], STRDEF[4], STRDEF[80], STRDEF[40], STRDEF[44], STRDEF[400], STRDEF[44], STRDEF[400], STRDEF[12], STRDEF[400], STRDEF[8], STRDEF[140], STRDEF[7], STRDEF[4], STRDEF[80], STRDEF[80], STRDEF[80], STRDEF[80], STRDEF[80], STRDEF[80], STRDEF[160], STRDEF[160], STRDEF[4], STRDEF[4], STRDEF[4], STRDEF[4], STRDEF[22], STRDEF[22], STRDEF[22], STRDEF[80], STRDEF[7], STRDEF[7], STRDEF[7], STRDEF[7], STRDEF[22], STRDEF[22], STRDEF[80], STRDEF[40], STRDEF[22], STRDEF[20], STRDEF[4], STRDEF[4] SET$1
HASH JOIN 2 1 2 1 350 292 224548 191964753 338 "INCOPOSITION"."COD_ENTITY"="A"."COD_INCOLOANID" AND "INCOPOSITION"."DAT_BUSINESS"="HOST"."DAT_TODAY" (#keys=2) "A"."COD_INCOLOANID"[VARCHAR2,160], "INCOPOSITION"."DAT_BUSINESS"[DATE,7], "ACCT2"."COD_BRANCH"[VARCHAR2,80], "B"."DAT_LASTPOSTING"[DATE,7], "B"."COD_DEF_ACCR_CYCLE"[VARCHAR2,80], "B"."COD_DEF_POST_CYCLE"[VARCHAR2,80], "B"."TYP_INTPOSTOPTION"[VARCHAR2,40], "B"."DAT_FIRST_POSTING"[DATE,7], "A"."COD_INCOID"[VARCHAR2,160], "DTLS"."DAT_END_INCO_TRACKING"[DATE,7], "DTLS"."DAT_START_INCO_TRACKING"[DATE,7], "DTLS"."NBR_INSTRID"[NUMBER,22], "DTLS"."NBR_STRGRPID"[NUMBER,22], "DTLS"."NBR_STRCID"[NUMBER,22], "ACCT2"."COD_CRLNUM"[VARCHAR2,44], "A"."NBR_PARTICIPANTACCT"[VARCHAR2,160], "ACCT1"."COD_CRLNUM"[VARCHAR2,44], "A"."NBR_HDRACCT"[VARCHAR2,80], "CLNT2"."TXT_NAMCLIENT"[VARCHAR2,400], "LOANDEF"."FLG_YTD"[VARCHAR2,4], "LOANDEF"."FLG_REPORTINGFREQ"[VARCHAR2,4], "LOANDEF"."TYP_LIMIT"[VARCHAR2,40], "A"."NBR_ACTIVETRANSACTIONID"[NUMBER,22], "ACTTRNS"."FLG_ACTTXN"[VARCHAR2,4], "ACTTRNS"."NBR_INSTRID"[NUMBER,22], "ACTTRNS"."NBR_STRCID"[NUMBER,22], "A"."COD_DOMICILEGL"[VARCHAR2,80], "JP2"."TXT_ALIAS_FULL_NAME1"[VARCHAR2,400], "ACCT2"."COD_COUNTRY"[VARCHAR2,80], "A"."FLG_INCO_VARIANT"[VARCHAR2,160], "A"."DAT_LOANSTART"[DATE,7], "A"."DAT_LOANEND"[DATE,7], "A"."FLG_ACTIVE"[VARCHAR2,4], "A"."COD_AGREEMENT"[VARCHAR2,160], "A"."NBR_TENOR"[NUMBER,22], "A"."COD_REFCURRENCY"[VARCHAR2,12], "A"."FLG_INCOPARTIALREPAYMENT"[VARCHAR2,4], "CLNT1"."TXT_NAMCLIENT"[VARCHAR2,400], "A"."FLG_HEADERROLE"[VARCHAR2,4], "A"."FLG_ENTRUSTLOAN"[VARCHAR2,4], "A"."FLG_CALCINTEREST"[VARCHAR2,4], "A"."FLG_INTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_WHT"[VARCHAR2,4], "A"."FLG_WHTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_LOAN_TXN"[VARCHAR2,4], "A"."TYP_REPAYMENT"[VARCHAR2,80], "A"."AMT_ORIGINALLOAN"[NUMBER,22], "A"."COD_SERVER"[VARCHAR2,20], "ACCT1"."COD_BNK_LGL"[VARCHAR2,80], "ACCT1"."TXT_NAMOWNACCOUNT"[VARCHAR2,400], "ACCT1"."NBR_COREACCOUNT"[VARCHAR2,160], "JP1"."TXT_ALIAS_FULL_NAME1"[VARCHAR2,400], "ACCT1"."COD_BRANCH"[VARCHAR2,80], "ACCT1"."COD_COUNTRY"[VARCHAR2,80], "ACCT2"."COD_BNK_LGL"[VARCHAR2,80], "ACCT2"."TXT_NAMOWNACCOUNT"[VARCHAR2,400], "ACCT2"."NBR_COREACCOUNT"[VARCHAR2,160], "INCOPOSITION"."AMT_BALANCE_2"[NUMBER,22], "INCOPOSITION"."AMT_NETVALUEBALANCE"[NUMBER,22] 5 SEL$560A7E3C
HASH JOIN RIGHT OUTER 3 2 3 1 247 177 130095 159654478 237 "A"."COD_INCOLOANID"="B"."COD_ENTITY"(+) (#keys=1) "A"."COD_INCOLOANID"[VARCHAR2,160], "B"."DAT_LASTPOSTING"[DATE,7], "B"."COD_DEF_ACCR_CYCLE"[VARCHAR2,80], "B"."COD_DEF_POST_CYCLE"[VARCHAR2,80], "B"."TYP_INTPOSTOPTION"[VARCHAR2,40], "B"."DAT_FIRST_POSTING"[DATE,7], "A"."COD_INCOID"[VARCHAR2,160], "DTLS"."DAT_END_INCO_TRACKING"[DATE,7], "DTLS"."DAT_START_INCO_TRACKING"[DATE,7], "DTLS"."NBR_INSTRID"[NUMBER,22], "DTLS"."NBR_STRGRPID"[NUMBER,22], "DTLS"."NBR_STRCID"[NUMBER,22], "ACCT2"."COD_CRLNUM"[VARCHAR2,44], "A"."NBR_PARTICIPANTACCT"[VARCHAR2,160], "ACCT1"."COD_CRLNUM"[VARCHAR2,44], "A"."NBR_HDRACCT"[VARCHAR2,80], "CLNT2"."TXT_NAMCLIENT"[VARCHAR2,400], "LOANDEF"."FLG_YTD"[VARCHAR2,4], "LOANDEF"."FLG_REPORTINGFREQ"[VARCHAR2,4], "LOANDEF"."TYP_LIMIT"[VARCHAR2,40], "A"."NBR_ACTIVETRANSACTIONID"[NUMBER,22], "ACTTRNS"."FLG_ACTTXN"[VARCHAR2,4], "ACTTRNS"."NBR_INSTRID"[NUMBER,22], "ACTTRNS"."NBR_STRCID"[NUMBER,22], "A"."COD_DOMICILEGL"[VARCHAR2,80], "HOST"."DAT_TODAY"[DATE,7], "ACCT2"."COD_COUNTRY"[VARCHAR2,80], "A"."FLG_INCO_VARIANT"[VARCHAR2,160], "A"."DAT_LOANSTART"[DATE,7], "A"."DAT_LOANEND"[DATE,7], "A"."FLG_ACTIVE"[VARCHAR2,4], "A"."COD_AGREEMENT"[VARCHAR2,160], "A"."NBR_TENOR"[NUMBER,22], "A"."COD_REFCURRENCY"[VARCHAR2,12], "A"."FLG_INCOPARTIALREPAYMENT"[VARCHAR2,4], "CLNT1"."TXT_NAMCLIENT"[VARCHAR2,400], "A"."FLG_HEADERROLE"[VARCHAR2,4], "A"."FLG_ENTRUSTLOAN"[VARCHAR2,4], "A"."FLG_CALCINTEREST"[VARCHAR2,4], "A"."FLG_INTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_WHT"[VARCHAR2,4], "A"."FLG_WHTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_LOAN_TXN"[VARCHAR2,4], "A"."TYP_REPAYMENT"[VARCHAR2,80], "A"."AMT_ORIGINALLOAN"[NUMBER,22], "A"."COD_SERVER"[VARCHAR2,20], "ACCT1"."COD_BNK_LGL"[VARCHAR2,80], "ACCT1"."TXT_NAMOWNACCOUNT"[VARCHAR2,400], "ACCT1"."NBR_COREACCOUNT"[VARCHAR2,160], "JP1"."TXT_ALIAS_FULL_NAME1"[VARCHAR2,400], "ACCT1"."COD_BRANCH"[VARCHAR2,80], "ACCT1"."COD_COUNTRY"[VARCHAR2,80], "ACCT2"."COD_BNK_LGL"[VARCHAR2,80], "ACCT2"."TXT_NAMOWNACCOUNT"[VARCHAR2,400], "ACCT2"."NBR_COREACCOUNT"[VARCHAR2,160], "JP2"."TXT_ALIAS_FULL_NAME1"[VARCHAR2,400], "ACCT2"."COD_BRANCH"[VARCHAR2,80] 3
VIEW LIQU2_LMS B@SEL$6 5 4 3 4 1 12 133 25270 33274769 10 "B"."COD_ENTITY"[VARCHAR2,128], "B"."COD_DEF_ACCR_CYCLE"[VARCHAR2,80], "B"."COD_DEF_POST_CYCLE"[VARCHAR2,80], "B"."TYP_INTPOSTOPTION"[VARCHAR2,40], "B"."DAT_FIRST_POSTING"[DATE,7], "B"."DAT_LASTPOSTING"[DATE,7] 1 SEL$7
HASH UNIQUE 5 4 5 1 12 133 12768 33274769 10 (#keys=8) "COD_ENTITY"[VARCHAR2,128], "COD_DEF_ACCR_CYCLE"[VARCHAR2,80], "COD_DEF_POST_CYCLE"[VARCHAR2,80], "TYP_INTPOSTOPTION"[VARCHAR2,40], "DAT_FIRST_POSTING"[DATE,7], "DAT_LASTPOSTING"[DATE,7], "DAT_START"[DATE,7], "DAT_END"[DATE,7] 1 SEL$7
HASH JOIN 6 5 6 1 11 133 12768 17074902 10 "A"."COD_INCOLOANID"="COD_ENTITY" "DAT_START"<="OHD"."DAT_TODAY" AND ("DAT_END" IS NULL OR "OHD"."DAT_TODAY"<="DAT_END") (#keys=1) "COD_ENTITY"[VARCHAR2,128], "TYP_INTPOSTOPTION"[VARCHAR2,40], "COD_DEF_ACCR_CYCLE"[VARCHAR2,80], "COD_DEF_POST_CYCLE"[VARCHAR2,80], "DAT_FIRST_POSTING"[DATE,7], "DAT_LASTPOSTING"[DATE,7], "DAT_START"[DATE,7], "DAT_END"[DATE,7] 1
HASH JOIN 7 6 7 1 7 175 5425 8460274 6 "COD_GL"="A"."COD_DOMICILEGL" (#keys=1) "OHD"."DAT_TODAY"[DATE,7], "A"."COD_INCOLOANID"[VARCHAR2,160] 1
TABLE ACCESS FULL LIQU2_LMS OLM_HOSTSYSTEMDATES OHD@SEL$7 7 TABLE ANALYZED 8 7 8 1 2 37 740 46246 2 "COD_MODULE"='SWEEPS' "COD_GL"[VARCHAR2,80], "OHD"."DAT_TODAY"[DATE,7] 1 SEL$7
TABLE ACCESS FULL LIQU2_LMS OLM_INCO_LOAN_DETAILS A@SEL$7 8 TABLE ANALYZED 9 7 8 2 4 167 1837 312183 4 "A"."FLG_CALCINTEREST"='Y' "A"."COD_INCOLOANID"[VARCHAR2,160], "A"."COD_DOMICILEGL"[VARCHAR2,80] 1 SEL$7
PARTITION RANGE SINGLE 10 6 7 2 4 294 19110 1 1 10 480183 4 "COD_ENTITY"[VARCHAR2,128], "COD_DEF_ACCR_CYCLE"[VARCHAR2,80], "COD_DEF_POST_CYCLE"[VARCHAR2,80], "DAT_FIRST_POSTING"[DATE,7], "DAT_LASTPOSTING"[DATE,7], "DAT_START"[DATE,7], "DAT_END"[DATE,7], "TYP_INTPOSTOPTION"[VARCHAR2,40] 1
TABLE ACCESS FULL LIQU2_LMS ORATE_ENTITY_INTEREST ORATE_ENTITY_INTEREST@SEL$7 6 TABLE ANALYZED 11 10 8 1 4 294 19110 1 1 11 480183 4 "TYP_ENTITY"='INCOLOAN' "COD_ENTITY"[VARCHAR2,128], "COD_DEF_ACCR_CYCLE"[VARCHAR2,80], "COD_DEF_POST_CYCLE"[VARCHAR2,80], "DAT_FIRST_POSTING"[DATE,7], "DAT_LASTPOSTING"[DATE,7], "DAT_START"[DATE,7], "DAT_END"[DATE,7], "TYP_INTPOSTOPTION"[VARCHAR2,40] 1 SEL$7
HASH JOIN RIGHT OUTER 12 3 4 2 234 177 96465 118263265 227 "A"."COD_INCOID"="DTLS"."COD_INCOID"(+) (#keys=1) "A"."COD_INCOID"[VARCHAR2,160], "DTLS"."DAT_END_INCO_TRACKING"[DATE,7], "DTLS"."DAT_START_INCO_TRACKING"[DATE,7], "DTLS"."NBR_INSTRID"[NUMBER,22], "DTLS"."NBR_STRGRPID"[NUMBER,22], "DTLS"."NBR_STRCID"[NUMBER,22], "ACCT2"."COD_CRLNUM"[VARCHAR2,44], "A"."NBR_PARTICIPANTACCT"[VARCHAR2,160], "ACCT1"."COD_CRLNUM"[VARCHAR2,44], "A"."NBR_HDRACCT"[VARCHAR2,80], "CLNT2"."TXT_NAMCLIENT"[VARCHAR2,400], "LOANDEF"."FLG_YTD"[VARCHAR2,4], "LOANDEF"."FLG_REPORTINGFREQ"[VARCHAR2,4], "LOANDEF"."TYP_LIMIT"[VARCHAR2,40], "A"."NBR_ACTIVETRANSACTIONID"[NUMBER,22], "ACTTRNS"."FLG_ACTTXN"[VARCHAR2,4], "ACTTRNS"."NBR_INSTRID"[NUMBER,22], "ACTTRNS"."NBR_STRCID"[NUMBER,22], "A"."COD_DOMICILEGL"[VARCHAR2,80], "HOST"."DAT_TODAY"[DATE,7], "A"."COD_INCOLOANID"[VARCHAR2,160], "A"."FLG_INCO_VARIANT"[VARCHAR2,160], "A"."DAT_LOANSTART"[DATE,7], "A"."DAT_LOANEND"[DATE,7], "A"."FLG_ACTIVE"[VARCHAR2,4], "A"."COD_AGREEMENT"[VARCHAR2,160], "A"."NBR_TENOR"[NUMBER,22], "A"."COD_REFCURRENCY"[VARCHAR2,12], "A"."FLG_INCOPARTIALREPAYMENT"[VARCHAR2,4], "CLNT1"."TXT_NAMCLIENT"[VARCHAR2,400], "A"."FLG_HEADERROLE"[VARCHAR2,4], "A"."FLG_ENTRUSTLOAN"[VARCHAR2,4], "A"."FLG_CALCINTEREST"[VARCHAR2,4], "A"."FLG_INTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_WHT"[VARCHAR2,4], "A"."FLG_WHTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_LOAN_TXN"[VARCHAR2,4], "A"."TYP_REPAYMENT"[VARCHAR2,80], "A"."AMT_ORIGINALLOAN"[NUMBER,22], "A"."COD_SERVER"[VARCHAR2,20], "ACCT1"."COD_BNK_LGL"[VARCHAR2,80], "ACCT1"."TXT_NAMOWNACCOUNT"[VARCHAR2,400], "ACCT1"."NBR_COREACCOUNT"[VARCHAR2,160], "JP1"."TXT_ALIAS_FULL_NAME1"[VARCHAR2,400], "ACCT1"."COD_BRANCH"[VARCHAR2,80], "ACCT1"."COD_COUNTRY"[VARCHAR2,80], "ACCT2"."COD_BNK_LGL"[VARCHAR2,80], "ACCT2"."TXT_NAMOWNACCOUNT"[VARCHAR2,400], "ACCT2"."NBR_COREACCOUNT"[VARCHAR2,160], "JP2"."TXT_ALIAS_FULL_NAME1"[VARCHAR2,400], "ACCT2"."COD_BRANCH"[VARCHAR2,80], "ACCT2"."COD_COUNTRY"[VARCHAR2,80] 3
VIEW LIQU2_LMS DTLS@SEL$1 18 13 12 5 1 18 88 12232 10808970 17 "DTLS"."DAT_END_INCO_TRACKING"[DATE,7], "DTLS"."DAT_START_INCO_TRACKING"[DATE,7], "DTLS"."COD_INCOID"[VARCHAR2,160], "DTLS"."NBR_STRGRPID"[NUMBER,22], "DTLS"."NBR_STRCID"[NUMBER,22], "DTLS"."NBR_INSTRID"[NUMBER,22] 1 SEL$8
HASH JOIN 14 13 6 1 18 88 1848 10808970 17 "A"."NBR_STRCID"="B"."NBR_STRCID" (#keys=1) "A"."NBR_STRCID"[NUMBER,22], "DAT_END_INCO_TRACKING"[DATE,7], "A"."NBR_INSTRID"[NUMBER,22], "COD_INCOID"[VARCHAR2,160], "DAT_START_INCO_TRACKING"[DATE,7], "B"."NBR_STRGRPID"[NUMBER,22] 1 SEL$8
PARTITION LIST SINGLE 15 14 7 1 11 88 1144 1 1 15 2256761 11 "A"."NBR_STRCID"[NUMBER,22], "A"."NBR_INSTRID"[NUMBER,22], "COD_INCOID"[VARCHAR2,160], "DAT_START_INCO_TRACKING"[DATE,7], "DAT_END_INCO_TRACKING"[DATE,7] 1
TABLE ACCESS FULL LIQU2_LMS OLM_SOURCE_ACCOUNT_DTLS A@SEL$8 19 TABLE ANALYZED 16 15 8 1 11 88 1144 1 1 16 2256761 11 "COD_INCOID" IS NOT NULL "A"."NBR_STRCID"[NUMBER,22], "A"."NBR_INSTRID"[NUMBER,22], "COD_INCOID"[VARCHAR2,160], "DAT_START_INCO_TRACKING"[DATE,7], "DAT_END_INCO_TRACKING"[DATE,7] 1 SEL$8
PARTITION RANGE SINGLE 17 14 7 2 6 526 4208 1 1 17 407615 6 "B"."NBR_STRCID"[NUMBER,22], "B"."NBR_STRGRPID"[NUMBER,22] 1
TABLE ACCESS FULL LIQU2_LMS OLM_STRUCTURE_HEADER B@SEL$8 20 TABLE ANALYZED 18 17 8 1 6 526 4208 1 1 18 407615 6 "B"."NBR_STRCID"[NUMBER,22], "B"."NBR_STRGRPID"[NUMBER,22] 1 SEL$8
HASH JOIN 19 12 5 2 216 177 71862 99344600 210 "ACCT2"."COD_ENTITY"="CLNT2"."COD_CIF" (#keys=1) "ACCT2"."COD_CRLNUM"[VARCHAR2,44], "A"."NBR_PARTICIPANTACCT"[VARCHAR2,160], "ACCT1"."COD_CRLNUM"[VARCHAR2,44], "A"."NBR_HDRACCT"[VARCHAR2,80], "A"."COD_INCOID"[VARCHAR2,160], "LOANDEF"."FLG_YTD"[VARCHAR2,4], "LOANDEF"."FLG_REPORTINGFREQ"[VARCHAR2,4], "LOANDEF"."TYP_LIMIT"[VARCHAR2,40], "A"."NBR_ACTIVETRANSACTIONID"[NUMBER,22], "ACTTRNS"."FLG_ACTTXN"[VARCHAR2,4], "ACTTRNS"."NBR_INSTRID"[NUMBER,22], "ACTTRNS"."NBR_STRCID"[NUMBER,22], "A"."COD_DOMICILEGL"[VARCHAR2,80], "HOST"."DAT_TODAY"[DATE,7], "A"."COD_INCOLOANID"[VARCHAR2,160], "A"."FLG_INCO_VARIANT"[VARCHAR2,160], "A"."DAT_LOANSTART"[DATE,7], "A"."DAT_LOANEND"[DATE,7], "A"."FLG_ACTIVE"[VARCHAR2,4], "A"."COD_AGREEMENT"[VARCHAR2,160], "A"."NBR_TENOR"[NUMBER,22], "A"."COD_REFCURRENCY"[VARCHAR2,12], "A"."FLG_INCOPARTIALREPAYMENT"[VARCHAR2,4], "CLNT1"."TXT_NAMCLIENT"[VARCHAR2,400], "A"."FLG_HEADERROLE"[VARCHAR2,4], "A"."FLG_ENTRUSTLOAN"[VARCHAR2,4], "A"."FLG_CALCINTEREST"[VARCHAR2,4], "A"."FLG_INTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_WHT"[VARCHAR2,4], "A"."FLG_WHTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_LOAN_TXN"[VARCHAR2,4], "A"."TYP_REPAYMENT"[VARCHAR2,80], "A"."AMT_ORIGINALLOAN"[NUMBER,22], "A"."COD_SERVER"[VARCHAR2,20], "ACCT1"."COD_BNK_LGL"[VARCHAR2,80], "ACCT1"."TXT_NAMOWNACCOUNT"[VARCHAR2,400], "ACCT1"."NBR_COREACCOUNT"[VARCHAR2,160], "JP1"."TXT_ALIAS_FULL_NAME1"[VARCHAR2,400], "ACCT1"."COD_BRANCH"[VARCHAR2,80], "ACCT1"."COD_COUNTRY"[VARCHAR2,80], "ACCT2"."COD_BNK_LGL"[VARCHAR2,80], "ACCT2"."TXT_NAMOWNACCOUNT"[VARCHAR2,400], "ACCT2"."NBR_COREACCOUNT"[VARCHAR2,160], "JP2"."TXT_ALIAS_FULL_NAME1"[VARCHAR2,400], "ACCT2"."COD_BRANCH"[VARCHAR2,80], "ACCT2"."COD_COUNTRY"[VARCHAR2,80], "CLNT2"."TXT_NAMCLIENT"[VARCHAR2,400] 3
HASH JOIN 20 19 6 1 197 177 68145 89573409 191 "JP2"."COD_CRL"="ACCT2"."COD_CRLNUM" AND "JP2"."COD_PU"="ACCT2"."COD_GL" (#keys=2) "ACCT2"."COD_CRLNUM"[VARCHAR2,44], "A"."NBR_PARTICIPANTACCT"[VARCHAR2,160], "ACCT1"."COD_CRLNUM"[VARCHAR2,44], "A"."NBR_HDRACCT"[VARCHAR2,80], "A"."COD_INCOID"[VARCHAR2,160], "LOANDEF"."FLG_YTD"[VARCHAR2,4], "LOANDEF"."FLG_REPORTINGFREQ"[VARCHAR2,4], "LOANDEF"."TYP_LIMIT"[VARCHAR2,40], "A"."NBR_ACTIVETRANSACTIONID"[NUMBER,22], "ACTTRNS"."FLG_ACTTXN"[VARCHAR2,4], "ACTTRNS"."NBR_INSTRID"[NUMBER,22], "ACTTRNS"."NBR_STRCID"[NUMBER,22], "A"."COD_DOMICILEGL"[VARCHAR2,80], "HOST"."DAT_TODAY"[DATE,7], "A"."COD_INCOLOANID"[VARCHAR2,160], "A"."FLG_INCO_VARIANT"[VARCHAR2,160], "A"."DAT_LOANSTART"[DATE,7], "A"."DAT_LOANEND"[DATE,7], "A"."FLG_ACTIVE"[VARCHAR2,4], "A"."COD_AGREEMENT"[VARCHAR2,160], "A"."NBR_TENOR"[NUMBER,22], "A"."COD_REFCURRENCY"[VARCHAR2,12], "A"."FLG_INCOPARTIALREPAYMENT"[VARCHAR2,4], "CLNT1"."TXT_NAMCLIENT"[VARCHAR2,400], "A"."FLG_HEADERROLE"[VARCHAR2,4], "A"."FLG_ENTRUSTLOAN"[VARCHAR2,4], "A"."FLG_CALCINTEREST"[VARCHAR2,4], "A"."FLG_INTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_WHT"[VARCHAR2,4], "A"."FLG_WHTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_LOAN_TXN"[VARCHAR2,4], "A"."TYP_REPAYMENT"[VARCHAR2,80], "A"."AMT_ORIGINALLOAN"[NUMBER,22], "A"."COD_SERVER"[VARCHAR2,20], "ACCT1"."COD_BNK_LGL"[VARCHAR2,80], "ACCT1"."TXT_NAMOWNACCOUNT"[VARCHAR2,400], "ACCT1"."NBR_COREACCOUNT"[VARCHAR2,160], "JP1"."TXT_ALIAS_FULL_NAME1"[VARCHAR2,400], "ACCT1"."COD_BRANCH"[VARCHAR2,80], "ACCT1"."COD_COUNTRY"[VARCHAR2,80], "ACCT2"."COD_BNK_LGL"[VARCHAR2,80], "ACCT2"."TXT_NAMOWNACCOUNT"[VARCHAR2,400], "ACCT2"."NBR_COREACCOUNT"[VARCHAR2,160], "ACCT2"."COD_ENTITY"[VARCHAR2,80], "ACCT2"."COD_BRANCH"[VARCHAR2,80], "ACCT2"."COD_COUNTRY"[VARCHAR2,80], "JP2"."TXT_ALIAS_FULL_NAME1"[VARCHAR2,400] 3
HASH JOIN 21 20 7 1 161 177 62304 77891788 156 "A"."NBR_PARTICIPANTACCT"="ACCT2"."NBR_OWNACCOUNT" (#keys=1) "A"."NBR_PARTICIPANTACCT"[VARCHAR2,160], "ACCT1"."COD_CRLNUM"[VARCHAR2,44], "A"."NBR_HDRACCT"[VARCHAR2,80], "A"."COD_INCOID"[VARCHAR2,160], "LOANDEF"."FLG_YTD"[VARCHAR2,4], "LOANDEF"."FLG_REPORTINGFREQ"[VARCHAR2,4], "LOANDEF"."TYP_LIMIT"[VARCHAR2,40], "A"."NBR_ACTIVETRANSACTIONID"[NUMBER,22], "ACTTRNS"."FLG_ACTTXN"[VARCHAR2,4], "ACTTRNS"."NBR_INSTRID"[NUMBER,22], "ACTTRNS"."NBR_STRCID"[NUMBER,22], "A"."COD_DOMICILEGL"[VARCHAR2,80], "HOST"."DAT_TODAY"[DATE,7], "A"."COD_INCOLOANID"[VARCHAR2,160], "A"."FLG_INCO_VARIANT"[VARCHAR2,160], "A"."DAT_LOANSTART"[DATE,7], "A"."DAT_LOANEND"[DATE,7], "A"."FLG_ACTIVE"[VARCHAR2,4], "A"."COD_AGREEMENT"[VARCHAR2,160], "A"."NBR_TENOR"[NUMBER,22], "A"."COD_REFCURRENCY"[VARCHAR2,12], "A"."FLG_INCOPARTIALREPAYMENT"[VARCHAR2,4], "CLNT1"."TXT_NAMCLIENT"[VARCHAR2,400], "A"."FLG_HEADERROLE"[VARCHAR2,4], "A"."FLG_ENTRUSTLOAN"[VARCHAR2,4], "A"."FLG_CALCINTEREST"[VARCHAR2,4], "A"."FLG_INTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_WHT"[VARCHAR2,4], "A"."FLG_WHTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_LOAN_TXN"[VARCHAR2,4], "A"."TYP_REPAYMENT"[VARCHAR2,80], "A"."AMT_ORIGINALLOAN"[NUMBER,22], "A"."COD_SERVER"[VARCHAR2,20], "ACCT1"."COD_BNK_LGL"[VARCHAR2,80], "ACCT1"."TXT_NAMOWNACCOUNT"[VARCHAR2,400], "ACCT1"."NBR_COREACCOUNT"[VARCHAR2,160], "JP1"."TXT_ALIAS_FULL_NAME1"[VARCHAR2,400], "ACCT1"."COD_BRANCH"[VARCHAR2,80], "ACCT1"."COD_COUNTRY"[VARCHAR2,80], "ACCT2"."COD_CRLNUM"[VARCHAR2,44], "ACCT2"."TXT_NAMOWNACCOUNT"[VARCHAR2,400], "ACCT2"."NBR_COREACCOUNT"[VARCHAR2,160], "ACCT2"."COD_ENTITY"[VARCHAR2,80], "ACCT2"."COD_BRANCH"[VARCHAR2,80], "ACCT2"."COD_GL"[VARCHAR2,80], "ACCT2"."COD_COUNTRY"[VARCHAR2,80], "ACCT2"."COD_BNK_LGL"[VARCHAR2,80] 2
HASH JOIN 22 21 8 1 115 177 49206 62260533 111 "ACCT1"."COD_ENTITY"="CLNT1"."COD_CIF" (#keys=1) "ACCT1"."COD_CRLNUM"[VARCHAR2,44], "A"."NBR_HDRACCT"[VARCHAR2,80], "A"."COD_INCOID"[VARCHAR2,160], "LOANDEF"."FLG_YTD"[VARCHAR2,4], "LOANDEF"."FLG_REPORTINGFREQ"[VARCHAR2,4], "LOANDEF"."TYP_LIMIT"[VARCHAR2,40], "A"."NBR_ACTIVETRANSACTIONID"[NUMBER,22], "ACTTRNS"."FLG_ACTTXN"[VARCHAR2,4], "ACTTRNS"."NBR_INSTRID"[NUMBER,22], "ACTTRNS"."NBR_STRCID"[NUMBER,22], "A"."COD_DOMICILEGL"[VARCHAR2,80], "HOST"."DAT_TODAY"[DATE,7], "A"."COD_INCOLOANID"[VARCHAR2,160], "A"."FLG_INCO_VARIANT"[VARCHAR2,160], "A"."DAT_LOANSTART"[DATE,7], "A"."DAT_LOANEND"[DATE,7], "A"."FLG_ACTIVE"[VARCHAR2,4], "A"."COD_AGREEMENT"[VARCHAR2,160], "A"."NBR_TENOR"[NUMBER,22], "A"."COD_REFCURRENCY"[VARCHAR2,12], "A"."FLG_INCOPARTIALREPAYMENT"[VARCHAR2,4], "A"."NBR_PARTICIPANTACCT"[VARCHAR2,160], "A"."FLG_HEADERROLE"[VARCHAR2,4], "A"."FLG_ENTRUSTLOAN"[VARCHAR2,4], "A"."FLG_CALCINTEREST"[VARCHAR2,4], "A"."FLG_INTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_WHT"[VARCHAR2,4], "A"."FLG_WHTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_LOAN_TXN"[VARCHAR2,4], "A"."TYP_REPAYMENT"[VARCHAR2,80], "A"."AMT_ORIGINALLOAN"[NUMBER,22], "A"."COD_SERVER"[VARCHAR2,20], "ACCT1"."COD_BNK_LGL"[VARCHAR2,80], "ACCT1"."TXT_NAMOWNACCOUNT"[VARCHAR2,400], "ACCT1"."NBR_COREACCOUNT"[VARCHAR2,160], "JP1"."TXT_ALIAS_FULL_NAME1"[VARCHAR2,400], "ACCT1"."COD_BRANCH"[VARCHAR2,80], "ACCT1"."COD_COUNTRY"[VARCHAR2,80], "CLNT1"."TXT_NAMCLIENT"[VARCHAR2,400] 2
HASH JOIN 23 22 9 1 95 177 45489 52489343 92 "JP1"."COD_CRL"="ACCT1"."COD_CRLNUM" AND "JP1"."COD_PU"="ACCT1"."COD_GL" (#keys=2) "ACCT1"."COD_CRLNUM"[VARCHAR2,44], "A"."NBR_HDRACCT"[VARCHAR2,80], "A"."COD_INCOID"[VARCHAR2,160], "LOANDEF"."FLG_YTD"[VARCHAR2,4], "LOANDEF"."FLG_REPORTINGFREQ"[VARCHAR2,4], "LOANDEF"."TYP_LIMIT"[VARCHAR2,40], "A"."NBR_ACTIVETRANSACTIONID"[NUMBER,22], "ACTTRNS"."FLG_ACTTXN"[VARCHAR2,4], "ACTTRNS"."NBR_INSTRID"[NUMBER,22], "ACTTRNS"."NBR_STRCID"[NUMBER,22], "A"."COD_DOMICILEGL"[VARCHAR2,80], "HOST"."DAT_TODAY"[DATE,7], "A"."COD_INCOLOANID"[VARCHAR2,160], "A"."FLG_INCO_VARIANT"[VARCHAR2,160], "A"."DAT_LOANSTART"[DATE,7], "A"."DAT_LOANEND"[DATE,7], "A"."FLG_ACTIVE"[VARCHAR2,4], "A"."COD_AGREEMENT"[VARCHAR2,160], "A"."NBR_TENOR"[NUMBER,22], "A"."COD_REFCURRENCY"[VARCHAR2,12], "A"."FLG_INCOPARTIALREPAYMENT"[VARCHAR2,4], "A"."NBR_PARTICIPANTACCT"[VARCHAR2,160], "A"."FLG_HEADERROLE"[VARCHAR2,4], "A"."FLG_ENTRUSTLOAN"[VARCHAR2,4], "A"."FLG_CALCINTEREST"[VARCHAR2,4], "A"."FLG_INTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_WHT"[VARCHAR2,4], "A"."FLG_WHTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_LOAN_TXN"[VARCHAR2,4], "A"."TYP_REPAYMENT"[VARCHAR2,80], "A"."AMT_ORIGINALLOAN"[NUMBER,22], "A"."COD_SERVER"[VARCHAR2,20], "ACCT1"."COD_BNK_LGL"[VARCHAR2,80], "ACCT1"."TXT_NAMOWNACCOUNT"[VARCHAR2,400], "ACCT1"."NBR_COREACCOUNT"[VARCHAR2,160], "ACCT1"."COD_ENTITY"[VARCHAR2,80], "ACCT1"."COD_BRANCH"[VARCHAR2,80], "ACCT1"."COD_COUNTRY"[VARCHAR2,80], "JP1"."TXT_ALIAS_FULL_NAME1"[VARCHAR2,400] 2
HASH JOIN 24 23 10 1 60 177 39648 40807721 57 "A"."NBR_HDRACCT"="ACCT1"."NBR_OWNACCOUNT" (#keys=1) "A"."NBR_HDRACCT"[VARCHAR2,80], "A"."COD_INCOID"[VARCHAR2,160], "LOANDEF"."FLG_YTD"[VARCHAR2,4], "LOANDEF"."FLG_REPORTINGFREQ"[VARCHAR2,4], "LOANDEF"."TYP_LIMIT"[VARCHAR2,40], "A"."NBR_ACTIVETRANSACTIONID"[NUMBER,22], "ACTTRNS"."FLG_ACTTXN"[VARCHAR2,4], "ACTTRNS"."NBR_INSTRID"[NUMBER,22], "ACTTRNS"."NBR_STRCID"[NUMBER,22], "A"."COD_DOMICILEGL"[VARCHAR2,80], "HOST"."DAT_TODAY"[DATE,7], "A"."COD_INCOLOANID"[VARCHAR2,160], "A"."FLG_INCO_VARIANT"[VARCHAR2,160], "A"."DAT_LOANSTART"[DATE,7], "A"."DAT_LOANEND"[DATE,7], "A"."FLG_ACTIVE"[VARCHAR2,4], "A"."COD_AGREEMENT"[VARCHAR2,160], "A"."NBR_TENOR"[NUMBER,22], "A"."COD_REFCURRENCY"[VARCHAR2,12], "A"."FLG_INCOPARTIALREPAYMENT"[VARCHAR2,4], "A"."NBR_PARTICIPANTACCT"[VARCHAR2,160], "A"."FLG_HEADERROLE"[VARCHAR2,4], "A"."FLG_ENTRUSTLOAN"[VARCHAR2,4], "A"."FLG_CALCINTEREST"[VARCHAR2,4], "A"."FLG_INTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_WHT"[VARCHAR2,4], "A"."FLG_WHTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_LOAN_TXN"[VARCHAR2,4], "A"."TYP_REPAYMENT"[VARCHAR2,80], "A"."AMT_ORIGINALLOAN"[NUMBER,22], "A"."COD_SERVER"[VARCHAR2,20], "ACCT1"."COD_CRLNUM"[VARCHAR2,44], "ACCT1"."TXT_NAMOWNACCOUNT"[VARCHAR2,400], "ACCT1"."NBR_COREACCOUNT"[VARCHAR2,160], "ACCT1"."COD_ENTITY"[VARCHAR2,80], "ACCT1"."COD_BRANCH"[VARCHAR2,80], "ACCT1"."COD_GL"[VARCHAR2,80], "ACCT1"."COD_COUNTRY"[VARCHAR2,80], "ACCT1"."COD_BNK_LGL"[VARCHAR2,80] 1
HASH JOIN RIGHT OUTER 25 24 11 1 14 177 26550 25176467 12 "LOANDEF"."COD_INCOID"(+)="A"."COD_INCOID" (#keys=1) "A"."COD_INCOID"[VARCHAR2,160], "LOANDEF"."FLG_YTD"[VARCHAR2,4], "LOANDEF"."FLG_REPORTINGFREQ"[VARCHAR2,4], "LOANDEF"."TYP_LIMIT"[VARCHAR2,40], "A"."NBR_ACTIVETRANSACTIONID"[NUMBER,22], "ACTTRNS"."FLG_ACTTXN"[VARCHAR2,4], "ACTTRNS"."NBR_INSTRID"[NUMBER,22], "ACTTRNS"."NBR_STRCID"[NUMBER,22], "A"."COD_DOMICILEGL"[VARCHAR2,80], "HOST"."DAT_TODAY"[DATE,7], "A"."COD_INCOLOANID"[VARCHAR2,160], "A"."FLG_INCO_VARIANT"[VARCHAR2,160], "A"."DAT_LOANSTART"[DATE,7], "A"."DAT_LOANEND"[DATE,7], "A"."FLG_ACTIVE"[VARCHAR2,4], "A"."COD_AGREEMENT"[VARCHAR2,160], "A"."NBR_TENOR"[NUMBER,22], "A"."COD_REFCURRENCY"[VARCHAR2,12], "A"."NBR_HDRACCT"[VARCHAR2,80], "A"."NBR_PARTICIPANTACCT"[VARCHAR2,160], "A"."FLG_HEADERROLE"[VARCHAR2,4], "A"."FLG_ENTRUSTLOAN"[VARCHAR2,4], "A"."FLG_CALCINTEREST"[VARCHAR2,4], "A"."FLG_INTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_WHT"[VARCHAR2,4], "A"."FLG_WHTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_LOAN_TXN"[VARCHAR2,4], "A"."TYP_REPAYMENT"[VARCHAR2,80], "A"."AMT_ORIGINALLOAN"[NUMBER,22], "A"."COD_SERVER"[VARCHAR2,20], "A"."FLG_INCOPARTIALREPAYMENT"[VARCHAR2,4] 1
TABLE ACCESS FULL LIQU2_LMS OLM_INCO_DEFINITION LOANDEF@SEL$1 17 TABLE ANALYZED 26 25 12 1 3 175 2100 244222 3 "LOANDEF"."COD_INCOID"[VARCHAR2,160], "LOANDEF"."FLG_REPORTINGFREQ"[VARCHAR2,4], "LOANDEF"."TYP_LIMIT"[VARCHAR2,40], "LOANDEF"."FLG_YTD"[VARCHAR2,4] 1 SEL$560A7E3C
HASH JOIN RIGHT OUTER 27 25 12 2 10 177 24426 16809500 9 "A"."NBR_ACTIVETRANSACTIONID"="ACTTRNS"."NBR_ACTIVETRANSACTIONID"(+) (#keys=1) "A"."NBR_ACTIVETRANSACTIONID"[NUMBER,22], "ACTTRNS"."FLG_ACTTXN"[VARCHAR2,4], "ACTTRNS"."NBR_INSTRID"[NUMBER,22], "ACTTRNS"."NBR_STRCID"[NUMBER,22], "A"."COD_DOMICILEGL"[VARCHAR2,80], "HOST"."DAT_TODAY"[DATE,7], "A"."COD_INCOLOANID"[VARCHAR2,160], "A"."COD_INCOID"[VARCHAR2,160], "A"."DAT_LOANSTART"[DATE,7], "A"."DAT_LOANEND"[DATE,7], "A"."FLG_ACTIVE"[VARCHAR2,4], "A"."COD_AGREEMENT"[VARCHAR2,160], "A"."NBR_TENOR"[NUMBER,22], "A"."COD_REFCURRENCY"[VARCHAR2,12], "A"."NBR_HDRACCT"[VARCHAR2,80], "A"."NBR_PARTICIPANTACCT"[VARCHAR2,160], "A"."FLG_HEADERROLE"[VARCHAR2,4], "A"."FLG_ENTRUSTLOAN"[VARCHAR2,4], "A"."FLG_CALCINTEREST"[VARCHAR2,4], "A"."FLG_INTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_WHT"[VARCHAR2,4], "A"."FLG_WHTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_LOAN_TXN"[VARCHAR2,4], "A"."TYP_REPAYMENT"[VARCHAR2,80], "A"."AMT_ORIGINALLOAN"[NUMBER,22], "A"."COD_SERVER"[VARCHAR2,20], "A"."FLG_INCOPARTIALREPAYMENT"[VARCHAR2,4], "A"."FLG_INCO_VARIANT"[VARCHAR2,160] 1
TABLE ACCESS FULL LIQU2_LMS OLM_ACTIVETRANSACTION ACTTRNS@SEL$1 21 TABLE ANALYZED 28 27 13 1 3 97 3007 203442 3 "ACTTRNS"."NBR_ACTIVETRANSACTIONID"[NUMBER,22], "ACTTRNS"."NBR_INSTRID"[NUMBER,22], "ACTTRNS"."NBR_STRCID"[NUMBER,22], "ACTTRNS"."FLG_ACTTXN"[VARCHAR2,4] 1 SEL$560A7E3C
HASH JOIN 29 27 13 2 7 177 18939 8495014 6 "HOST"."COD_GL"="A"."COD_DOMICILEGL" (#keys=1) "A"."COD_DOMICILEGL"[VARCHAR2,80], "HOST"."DAT_TODAY"[DATE,7], "A"."COD_INCOLOANID"[VARCHAR2,160], "A"."COD_INCOID"[VARCHAR2,160], "A"."DAT_LOANSTART"[DATE,7], "A"."DAT_LOANEND"[DATE,7], "A"."FLG_ACTIVE"[VARCHAR2,4], "A"."COD_AGREEMENT"[VARCHAR2,160], "A"."NBR_TENOR"[NUMBER,22], "A"."COD_REFCURRENCY"[VARCHAR2,12], "A"."NBR_HDRACCT"[VARCHAR2,80], "A"."NBR_PARTICIPANTACCT"[VARCHAR2,160], "A"."FLG_HEADERROLE"[VARCHAR2,4], "A"."FLG_ENTRUSTLOAN"[VARCHAR2,4], "A"."FLG_CALCINTEREST"[VARCHAR2,4], "A"."FLG_INTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_WHT"[VARCHAR2,4], "A"."FLG_WHTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_LOAN_TXN"[VARCHAR2,4], "A"."TYP_REPAYMENT"[VARCHAR2,80], "A"."AMT_ORIGINALLOAN"[NUMBER,22], "A"."COD_SERVER"[VARCHAR2,20], "A"."FLG_INCOPARTIALREPAYMENT"[VARCHAR2,4], "A"."NBR_ACTIVETRANSACTIONID"[NUMBER,22], "A"."FLG_INCO_VARIANT"[VARCHAR2,160] 1
TABLE ACCESS FULL LIQU2_LMS OLM_HOSTSYSTEMDATES HOST@SEL$1 16 TABLE ANALYZED 30 29 14 1 2 37 740 45506 2 "HOST"."COD_MODULE"='SWEEPS' "HOST"."COD_GL"[VARCHAR2,80], "HOST"."DAT_TODAY"[DATE,7] 1 SEL$560A7E3C
TABLE ACCESS FULL LIQU2_LMS OLM_INCO_LOAN_DETAILS A@SEL$6 4 TABLE ANALYZED 31 29 14 2 4 168 14616 347463 4 "A"."COD_INCOLOANID"[VARCHAR2,160], "A"."COD_INCOID"[VARCHAR2,160], "A"."DAT_LOANSTART"[DATE,7], "A"."DAT_LOANEND"[DATE,7], "A"."FLG_ACTIVE"[VARCHAR2,4], "A"."COD_AGREEMENT"[VARCHAR2,160], "A"."NBR_TENOR"[NUMBER,22], "A"."COD_REFCURRENCY"[VARCHAR2,12], "A"."NBR_HDRACCT"[VARCHAR2,80], "A"."NBR_PARTICIPANTACCT"[VARCHAR2,160], "A"."FLG_HEADERROLE"[VARCHAR2,4], "A"."FLG_ENTRUSTLOAN"[VARCHAR2,4], "A"."FLG_CALCINTEREST"[VARCHAR2,4], "A"."FLG_INTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_WHT"[VARCHAR2,4], "A"."FLG_WHTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_LOAN_TXN"[VARCHAR2,4], "A"."TYP_REPAYMENT"[VARCHAR2,80], "A"."AMT_ORIGINALLOAN"[NUMBER,22], "A"."COD_DOMICILEGL"[VARCHAR2,80], "A"."FLG_INCOPARTIALREPAYMENT"[VARCHAR2,4], "A"."NBR_ACTIVETRANSACTIONID"[NUMBER,22], "A"."FLG_INCO_VARIANT"[VARCHAR2,160], "A"."COD_SERVER"[VARCHAR2,20] 1 SEL$560A7E3C
PARTITION RANGE SINGLE 32 24 11 2 45 3805 281570 1 1 32 7145410 45 "ACCT1"."NBR_OWNACCOUNT"[VARCHAR2,160], "ACCT1"."TXT_NAMOWNACCOUNT"[VARCHAR2,400], "ACCT1"."NBR_COREACCOUNT"[VARCHAR2,160], "ACCT1"."COD_ENTITY"[VARCHAR2,80], "ACCT1"."COD_BRANCH"[VARCHAR2,80], "ACCT1"."COD_GL"[VARCHAR2,80], "ACCT1"."COD_COUNTRY"[VARCHAR2,80], "ACCT1"."COD_BNK_LGL"[VARCHAR2,80], "ACCT1"."COD_CRLNUM"[VARCHAR2,44] 1
TABLE ACCESS FULL LIQU2_LMS ORBICASH_ACCOUNTS ACCT1@SEL$1 10 TABLE ANALYZED 33 32 12 1 45 3805 281570 1 1 33 7145410 45 "ACCT1"."NBR_OWNACCOUNT"[VARCHAR2,160], "ACCT1"."TXT_NAMOWNACCOUNT"[VARCHAR2,400], "ACCT1"."NBR_COREACCOUNT"[VARCHAR2,160], "ACCT1"."COD_ENTITY"[VARCHAR2,80], "ACCT1"."COD_BRANCH"[VARCHAR2,80], "ACCT1"."COD_GL"[VARCHAR2,80], "ACCT1"."COD_COUNTRY"[VARCHAR2,80], "ACCT1"."COD_BNK_LGL"[VARCHAR2,80], "ACCT1"."COD_CRLNUM"[VARCHAR2,44] 1 SEL$560A7E3C
TABLE ACCESS FULL LIQU2_LMS JP_CRL JP1@SEL$1 13 TABLE ANALYZED 34 23 10 2 35 3744 123552 3201876 35 "JP1"."COD_CRL"[VARCHAR2,40], "JP1"."COD_PU"[VARCHAR2,80], "JP1"."TXT_ALIAS_FULL_NAME1"[VARCHAR2,400] 1 SEL$560A7E3C
PARTITION RANGE SINGLE 35 22 9 2 19 2014 42294 1 1 35 1464445 19 "CLNT1"."TXT_NAMCLIENT"[VARCHAR2,400], "CLNT1"."COD_CIF"[VARCHAR2,80] 1
TABLE ACCESS FULL LIQU2_LMS ORBICASH_CLIENTMST CLNT1@SEL$1 9 TABLE ANALYZED 36 35 10 1 19 2014 42294 1 1 36 1464445 19 "CLNT1"."TXT_NAMCLIENT"[VARCHAR2,400], "CLNT1"."COD_CIF"[VARCHAR2,80] 1 SEL$560A7E3C
PARTITION RANGE SINGLE 37 21 8 2 45 3805 281570 1 1 37 7145410 45 "ACCT2"."NBR_OWNACCOUNT"[VARCHAR2,160], "ACCT2"."TXT_NAMOWNACCOUNT"[VARCHAR2,400], "ACCT2"."NBR_COREACCOUNT"[VARCHAR2,160], "ACCT2"."COD_ENTITY"[VARCHAR2,80], "ACCT2"."COD_BRANCH"[VARCHAR2,80], "ACCT2"."COD_GL"[VARCHAR2,80], "ACCT2"."COD_COUNTRY"[VARCHAR2,80], "ACCT2"."COD_BNK_LGL"[VARCHAR2,80], "ACCT2"."COD_CRLNUM"[VARCHAR2,44] 1
TABLE ACCESS FULL LIQU2_LMS ORBICASH_ACCOUNTS ACCT2@SEL$1 12 TABLE ANALYZED 38 37 9 1 45 3805 281570 1 1 38 7145410 45 "ACCT2"."NBR_OWNACCOUNT"[VARCHAR2,160], "ACCT2"."TXT_NAMOWNACCOUNT"[VARCHAR2,400], "ACCT2"."NBR_COREACCOUNT"[VARCHAR2,160], "ACCT2"."COD_ENTITY"[VARCHAR2,80], "ACCT2"."COD_BRANCH"[VARCHAR2,80], "ACCT2"."COD_GL"[VARCHAR2,80], "ACCT2"."COD_COUNTRY"[VARCHAR2,80], "ACCT2"."COD_BNK_LGL"[VARCHAR2,80], "ACCT2"."COD_CRLNUM"[VARCHAR2,44] 1 SEL$560A7E3C
TABLE ACCESS FULL LIQU2_LMS JP_CRL JP2@SEL$1 14 TABLE ANALYZED 39 20 7 2 35 3744 123552 3201876 35 "JP2"."COD_CRL"[VARCHAR2,40], "JP2"."COD_PU"[VARCHAR2,80], "JP2"."TXT_ALIAS_FULL_NAME1"[VARCHAR2,400] 1 SEL$560A7E3C
PARTITION RANGE SINGLE 40 19 6 2 19 2014 42294 1 1 40 1464445 19 "CLNT2"."TXT_NAMCLIENT"[VARCHAR2,400], "CLNT2"."COD_CIF"[VARCHAR2,80] 1
TABLE ACCESS FULL LIQU2_LMS ORBICASH_CLIENTMST CLNT2@SEL$1 11 TABLE ANALYZED 41 40 7 1 19 2014 42294 1 1 41 1464445 19 "CLNT2"."TXT_NAMCLIENT"[VARCHAR2,400], "CLNT2"."COD_CIF"[VARCHAR2,80] 1 SEL$560A7E3C
TABLE ACCESS FULL LIQU2_LMS OLM_INCO_POSITION INCOPOSITION@SEL$1 15 TABLE ANALYZED 42 2 3 2 102 32423 1102382 20962629 101 "INCOPOSITION"."TYP_ENTITY"='INCOLOAN' "INCOPOSITION"."COD_ENTITY"[VARCHAR2,160], "INCOPOSITION"."DAT_BUSINESS"[DATE,7], "INCOPOSITION"."AMT_NETVALUEBALANCE"[NUMBER,22], "INCOPOSITION"."AMT_BALANCE_2"[NUMBER,22] 2 SEL$560A7E3C
HASH JOIN 43 1 2 2 5834 7331 8291361 1354299059 5750 "JP2"."COD_CRL"="ACCT2"."COD_CRLNUM" AND "JP2"."COD_PU"="ACCT2"."COD_GL" (#keys=2) "ACCT2"."COD_CRLNUM"[VARCHAR2,44], "JP2"."TXT_ALIAS_FULL_NAME1"[VARCHAR2,400], "CLNT2"."TXT_NAMCLIENT"[VARCHAR2,400], "LOANDTLS"."PARTY_ACC_ID"[VARCHAR2,160], "LOANDTLS"."DAT_LASTPOSTING"[DATE,7], "ACCT2"."TXT_NAMOWNACCOUNT"[VARCHAR2,400], "ACCT2"."NBR_COREACCOUNT"[VARCHAR2,160], "LOANDTLS"."COD_SERVER"[VARCHAR2,20], "ACCT2"."COD_BRANCH"[VARCHAR2,80], "LOANDTLS"."DAT_FIRST_POSTING"[DATE,7], "ACCT2"."COD_COUNTRY"[VARCHAR2,80], "ACCT2"."COD_BNK_LGL"[VARCHAR2,80], "LOANDTLS"."HEADER_ACC_ID"[VARCHAR2,160], "ACCT1"."COD_CRLNUM"[VARCHAR2,44], "JP1"."TXT_ALIAS_FULL_NAME1"[VARCHAR2,400], "CLNT1"."TXT_NAMCLIENT"[VARCHAR2,400], "ACCT1"."COD_COUNTRY"[VARCHAR2,80], "ACCT1"."TXT_NAMOWNACCOUNT"[VARCHAR2,400], "ACCT1"."NBR_COREACCOUNT"[VARCHAR2,160], "ACCT1"."COD_BNK_LGL"[VARCHAR2,80], "ACCT1"."COD_BRANCH"[VARCHAR2,80], "ACCT1"."COD_CCY"[VARCHAR2,12], "FLG_LOAN_TXN"[VARCHAR2,4], "LOANDTLS"."COD_AGREEMENT"[VARCHAR2,160], "COD_INCOID"[VARCHAR2,400], "LOANDTLS"."FLG_ENTRUSTLOAN"[VARCHAR2,4], "LOANDTLS"."STATUS"[CHARACTER,14], "FLG_YTD"[VARCHAR2,4], "LOANDTLS"."REPAYMENT_TERMS"[VARCHAR2,80], "LOANDTLS"."TENOT_PARTIAL_REPAYMENT"[VARCHAR2,4], "LOANDTLS"."POST_INTEREST"[VARCHAR2,4], "LOANDTLS"."COD_DOMICILEGL"[VARCHAR2,80], "DAT_BUSINESS"[DATE,7], "COD_REASON"[VARCHAR2,80], "TXT_STATUS"[VARCHAR2,140], "LOANDTLS"."FLG_INCO_VARIANT"[VARCHAR2,8], "FLG_CALCINTEREST"[VARCHAR2,4], "FLG_WHT"[VARCHAR2,4], "FLG_REPORTINGFREQ"[VARCHAR2,4], "FLG_WHTPOSTALLOWED"[VARCHAR2,4], "TYP_LIMIT"[VARCHAR2,40], "LOANDTLS"."COD_DEF_ACCR_CYCLE"[VARCHAR2,80], "LOANDTLS"."COD_DEF_POST_CYCLE"[VARCHAR2,80], "LOANDTLS"."TYP_INTPOSTOPTION"[VARCHAR2,40] 71 SEL$9
TABLE ACCESS FULL LIQU2_LMS JP_CRL JP2@SEL$9 27 TABLE ANALYZED 44 43 3 1 35 3744 123552 3201876 35 "JP2"."COD_CRL"[VARCHAR2,40], "JP2"."COD_PU"[VARCHAR2,80], "JP2"."TXT_ALIAS_FULL_NAME1"[VARCHAR2,400] 1 SEL$9
HASH JOIN 45 43 3 2 5798 7331 8049438 1341723688 5715 "ACCT2"."COD_ENTITY"="CLNT2"."COD_CIF" (#keys=1) "CLNT2"."TXT_NAMCLIENT"[VARCHAR2,400], "LOANDTLS"."PARTY_ACC_ID"[VARCHAR2,160], "ACCT2"."COD_CRLNUM"[VARCHAR2,44], "ACCT2"."TXT_NAMOWNACCOUNT"[VARCHAR2,400], "ACCT2"."NBR_COREACCOUNT"[VARCHAR2,160], "LOANDTLS"."COD_SERVER"[VARCHAR2,20], "ACCT2"."COD_BRANCH"[VARCHAR2,80], "ACCT2"."COD_GL"[VARCHAR2,80], "ACCT2"."COD_COUNTRY"[VARCHAR2,80], "ACCT2"."COD_BNK_LGL"[VARCHAR2,80], "LOANDTLS"."HEADER_ACC_ID"[VARCHAR2,160], "ACCT1"."COD_CRLNUM"[VARCHAR2,44], "JP1"."TXT_ALIAS_FULL_NAME1"[VARCHAR2,400], "CLNT1"."TXT_NAMCLIENT"[VARCHAR2,400], "ACCT1"."COD_COUNTRY"[VARCHAR2,80], "ACCT1"."TXT_NAMOWNACCOUNT"[VARCHAR2,400], "ACCT1"."NBR_COREACCOUNT"[VARCHAR2,160], "ACCT1"."COD_BNK_LGL"[VARCHAR2,80], "ACCT1"."COD_BRANCH"[VARCHAR2,80], "ACCT1"."COD_CCY"[VARCHAR2,12], "FLG_LOAN_TXN"[VARCHAR2,4], "LOANDTLS"."COD_AGREEMENT"[VARCHAR2,160], "COD_INCOID"[VARCHAR2,400], "LOANDTLS"."FLG_ENTRUSTLOAN"[VARCHAR2,4], "LOANDTLS"."STATUS"[CHARACTER,14], "FLG_YTD"[VARCHAR2,4], "LOANDTLS"."REPAYMENT_TERMS"[VARCHAR2,80], "LOANDTLS"."TENOT_PARTIAL_REPAYMENT"[VARCHAR2,4], "LOANDTLS"."POST_INTEREST"[VARCHAR2,4], "LOANDTLS"."COD_DOMICILEGL"[VARCHAR2,80], "DAT_BUSINESS"[DATE,7], "COD_REASON"[VARCHAR2,80], "TXT_STATUS"[VARCHAR2,140], "LOANDTLS"."FLG_INCO_VARIANT"[VARCHAR2,8], "FLG_CALCINTEREST"[VARCHAR2,4], "FLG_WHT"[VARCHAR2,4], "FLG_REPORTINGFREQ"[VARCHAR2,4], "FLG_WHTPOSTALLOWED"[VARCHAR2,4], "TYP_LIMIT"[VARCHAR2,40], "LOANDTLS"."COD_DEF_ACCR_CYCLE"[VARCHAR2,80], "LOANDTLS"."COD_DEF_POST_CYCLE"[VARCHAR2,80], "LOANDTLS"."TYP_INTPOSTOPTION"[VARCHAR2,40], "LOANDTLS"."DAT_FIRST_POSTING"[DATE,7], "LOANDTLS"."DAT_LASTPOSTING"[DATE,7] 70
PARTITION RANGE SINGLE 46 45 4 1 19 2014 42294 1 1 46 1464445 19 "CLNT2"."TXT_NAMCLIENT"[VARCHAR2,400], "CLNT2"."COD_CIF"[VARCHAR2,80] 1
TABLE ACCESS FULL LIQU2_LMS ORBICASH_CLIENTMST CLNT2@SEL$9 24 TABLE ANALYZED 47 46 5 1 19 2014 42294 1 1 47 1464445 19 "CLNT2"."TXT_NAMCLIENT"[VARCHAR2,400], "CLNT2"."COD_CIF"[VARCHAR2,80] 1 SEL$9
HASH JOIN 48 45 4 2 5778 7331 7895487 1331145247 5696 "LOANDTLS"."PARTY_ACC_ID"="ACCT2"."NBR_OWNACCOUNT" (#keys=1) "LOANDTLS"."PARTY_ACC_ID"[VARCHAR2,160], "ACCT2"."COD_CRLNUM"[VARCHAR2,44], "ACCT2"."TXT_NAMOWNACCOUNT"[VARCHAR2,400], "ACCT2"."NBR_COREACCOUNT"[VARCHAR2,160], "ACCT2"."COD_ENTITY"[VARCHAR2,80], "ACCT2"."COD_BRANCH"[VARCHAR2,80], "ACCT2"."COD_GL"[VARCHAR2,80], "ACCT2"."COD_COUNTRY"[VARCHAR2,80], "ACCT2"."COD_BNK_LGL"[VARCHAR2,80], "LOANDTLS"."HEADER_ACC_ID"[VARCHAR2,160], "ACCT1"."COD_CRLNUM"[VARCHAR2,44], "JP1"."TXT_ALIAS_FULL_NAME1"[VARCHAR2,400], "CLNT1"."TXT_NAMCLIENT"[VARCHAR2,400], "ACCT1"."COD_COUNTRY"[VARCHAR2,80], "ACCT1"."TXT_NAMOWNACCOUNT"[VARCHAR2,400], "ACCT1"."NBR_COREACCOUNT"[VARCHAR2,160], "ACCT1"."COD_BNK_LGL"[VARCHAR2,80], "ACCT1"."COD_BRANCH"[VARCHAR2,80], "ACCT1"."COD_CCY"[VARCHAR2,12], "FLG_LOAN_TXN"[VARCHAR2,4], "LOANDTLS"."COD_AGREEMENT"[VARCHAR2,160], "COD_INCOID"[VARCHAR2,400], "LOANDTLS"."FLG_ENTRUSTLOAN"[VARCHAR2,4], "LOANDTLS"."STATUS"[CHARACTER,14], "FLG_YTD"[VARCHAR2,4], "LOANDTLS"."REPAYMENT_TERMS"[VARCHAR2,80], "LOANDTLS"."TENOT_PARTIAL_REPAYMENT"[VARCHAR2,4], "LOANDTLS"."POST_INTEREST"[VARCHAR2,4], "LOANDTLS"."COD_DOMICILEGL"[VARCHAR2,80], "DAT_BUSINESS"[DATE,7], "COD_REASON"[VARCHAR2,80], "TXT_STATUS"[VARCHAR2,140], "LOANDTLS"."FLG_INCO_VARIANT"[VARCHAR2,8], "FLG_CALCINTEREST"[VARCHAR2,4], "FLG_WHT"[VARCHAR2,4], "FLG_REPORTINGFREQ"[VARCHAR2,4], "FLG_WHTPOSTALLOWED"[VARCHAR2,4], "TYP_LIMIT"[VARCHAR2,40], "LOANDTLS"."COD_DEF_ACCR_CYCLE"[VARCHAR2,80], "LOANDTLS"."COD_DEF_POST_CYCLE"[VARCHAR2,80], "LOANDTLS"."TYP_INTPOSTOPTION"[VARCHAR2,40], "LOANDTLS"."DAT_FIRST_POSTING"[DATE,7], "LOANDTLS"."DAT_LASTPOSTING"[DATE,7], "LOANDTLS"."COD_SERVER"[VARCHAR2,20] 70
PARTITION RANGE SINGLE 49 48 5 1 45 3805 281570 1 1 49 7145410 45 "ACCT2"."NBR_OWNACCOUNT"[VARCHAR2,160], "ACCT2"."TXT_NAMOWNACCOUNT"[VARCHAR2,400], "ACCT2"."NBR_COREACCOUNT"[VARCHAR2,160], "ACCT2"."COD_ENTITY"[VARCHAR2,80], "ACCT2"."COD_BRANCH"[VARCHAR2,80], "ACCT2"."COD_GL"[VARCHAR2,80], "ACCT2"."COD_COUNTRY"[VARCHAR2,80], "ACCT2"."COD_BNK_LGL"[VARCHAR2,80], "ACCT2"."COD_CRLNUM"[VARCHAR2,44] 1
TABLE ACCESS FULL LIQU2_LMS ORBICASH_ACCOUNTS ACCT2@SEL$9 25 TABLE ANALYZED 50 49 6 1 45 3805 281570 1 1 50 7145410 45 "ACCT2"."NBR_OWNACCOUNT"[VARCHAR2,160], "ACCT2"."TXT_NAMOWNACCOUNT"[VARCHAR2,400], "ACCT2"."NBR_COREACCOUNT"[VARCHAR2,160], "ACCT2"."COD_ENTITY"[VARCHAR2,80], "ACCT2"."COD_BRANCH"[VARCHAR2,80], "ACCT2"."COD_GL"[VARCHAR2,80], "ACCT2"."COD_COUNTRY"[VARCHAR2,80], "ACCT2"."COD_BNK_LGL"[VARCHAR2,80], "ACCT2"."COD_CRLNUM"[VARCHAR2,44] 1 SEL$9
HASH JOIN 51 48 5 2 5732 7331 7352993 1314617192 5651 "LOANDTLS"."HEADER_ACC_ID"="ACCT1"."NBR_OWNACCOUNT" (#keys=1) "LOANDTLS"."HEADER_ACC_ID"[VARCHAR2,160], "ACCT1"."COD_CRLNUM"[VARCHAR2,44], "JP1"."TXT_ALIAS_FULL_NAME1"[VARCHAR2,400], "CLNT1"."TXT_NAMCLIENT"[VARCHAR2,400], "ACCT1"."COD_COUNTRY"[VARCHAR2,80], "ACCT1"."TXT_NAMOWNACCOUNT"[VARCHAR2,400], "ACCT1"."NBR_COREACCOUNT"[VARCHAR2,160], "ACCT1"."COD_BNK_LGL"[VARCHAR2,80], "ACCT1"."COD_BRANCH"[VARCHAR2,80], "ACCT1"."COD_CCY"[VARCHAR2,12], "FLG_LOAN_TXN"[VARCHAR2,4], "LOANDTLS"."COD_AGREEMENT"[VARCHAR2,160], "COD_INCOID"[VARCHAR2,400], "LOANDTLS"."FLG_ENTRUSTLOAN"[VARCHAR2,4], "LOANDTLS"."STATUS"[CHARACTER,14], "LOANDTLS"."PARTY_ACC_ID"[VARCHAR2,160], "LOANDTLS"."REPAYMENT_TERMS"[VARCHAR2,80], "LOANDTLS"."TENOT_PARTIAL_REPAYMENT"[VARCHAR2,4], "LOANDTLS"."POST_INTEREST"[VARCHAR2,4], "LOANDTLS"."COD_DOMICILEGL"[VARCHAR2,80], "DAT_BUSINESS"[DATE,7], "COD_REASON"[VARCHAR2,80], "TXT_STATUS"[VARCHAR2,140], "LOANDTLS"."FLG_INCO_VARIANT"[VARCHAR2,8], "FLG_CALCINTEREST"[VARCHAR2,4], "FLG_WHT"[VARCHAR2,4], "FLG_REPORTINGFREQ"[VARCHAR2,4], "FLG_WHTPOSTALLOWED"[VARCHAR2,4], "TYP_LIMIT"[VARCHAR2,40], "LOANDTLS"."COD_DEF_ACCR_CYCLE"[VARCHAR2,80], "LOANDTLS"."COD_DEF_POST_CYCLE"[VARCHAR2,80], "LOANDTLS"."TYP_INTPOSTOPTION"[VARCHAR2,40], "LOANDTLS"."DAT_FIRST_POSTING"[DATE,7], "LOANDTLS"."DAT_LASTPOSTING"[DATE,7], "LOANDTLS"."COD_SERVER"[VARCHAR2,20], "FLG_YTD"[VARCHAR2,4] 69
HASH JOIN 52 51 6 1 101 3805 502260 29594022 99 "JP1"."COD_CRL"="ACCT1"."COD_CRLNUM" AND "JP1"."COD_PU"="ACCT1"."COD_GL" (#keys=2) "ACCT1"."COD_CRLNUM"[VARCHAR2,44], "JP1"."TXT_ALIAS_FULL_NAME1"[VARCHAR2,400], "CLNT1"."TXT_NAMCLIENT"[VARCHAR2,400], "ACCT1"."NBR_OWNACCOUNT"[VARCHAR2,160], "ACCT1"."TXT_NAMOWNACCOUNT"[VARCHAR2,400], "ACCT1"."NBR_COREACCOUNT"[VARCHAR2,160], "ACCT1"."COD_BNK_LGL"[VARCHAR2,80], "ACCT1"."COD_BRANCH"[VARCHAR2,80], "ACCT1"."COD_CCY"[VARCHAR2,12], "ACCT1"."COD_COUNTRY"[VARCHAR2,80] 2
TABLE ACCESS FULL LIQU2_LMS JP_CRL JP1@SEL$9 26 TABLE ANALYZED 53 52 7 1 35 3744 123552 3201876 35 "JP1"."COD_CRL"[VARCHAR2,40], "JP1"."COD_PU"[VARCHAR2,80], "JP1"."TXT_ALIAS_FULL_NAME1"[VARCHAR2,400] 1 SEL$9
HASH JOIN 54 52 7 2 65 3805 376695 17371250 64 "ACCT1"."COD_ENTITY"="CLNT1"."COD_CIF" (#keys=1) "CLNT1"."TXT_NAMCLIENT"[VARCHAR2,400], "ACCT1"."NBR_OWNACCOUNT"[VARCHAR2,160], "ACCT1"."TXT_NAMOWNACCOUNT"[VARCHAR2,400], "ACCT1"."NBR_COREACCOUNT"[VARCHAR2,160], "ACCT1"."COD_CRLNUM"[VARCHAR2,44], "ACCT1"."COD_BRANCH"[VARCHAR2,80], "ACCT1"."COD_CCY"[VARCHAR2,12], "ACCT1"."COD_GL"[VARCHAR2,80], "ACCT1"."COD_COUNTRY"[VARCHAR2,80], "ACCT1"."COD_BNK_LGL"[VARCHAR2,80] 1
PARTITION RANGE SINGLE 55 54 8 1 19 2014 42294 1 1 55 1464445 19 "CLNT1"."TXT_NAMCLIENT"[VARCHAR2,400], "CLNT1"."COD_CIF"[VARCHAR2,80] 1
TABLE ACCESS FULL LIQU2_LMS ORBICASH_CLIENTMST CLNT1@SEL$9 22 TABLE ANALYZED 56 55 9 1 19 2014 42294 1 1 56 1464445 19 "CLNT1"."TXT_NAMCLIENT"[VARCHAR2,400], "CLNT1"."COD_CIF"[VARCHAR2,80] 1 SEL$9
PARTITION RANGE SINGLE 57 54 8 2 45 3805 296790 1 1 57 7145410 45 "ACCT1"."NBR_OWNACCOUNT"[VARCHAR2,160], "ACCT1"."TXT_NAMOWNACCOUNT"[VARCHAR2,400], "ACCT1"."NBR_COREACCOUNT"[VARCHAR2,160], "ACCT1"."COD_ENTITY"[VARCHAR2,80], "ACCT1"."COD_BRANCH"[VARCHAR2,80], "ACCT1"."COD_CCY"[VARCHAR2,12], "ACCT1"."COD_GL"[VARCHAR2,80], "ACCT1"."COD_COUNTRY"[VARCHAR2,80], "ACCT1"."COD_BNK_LGL"[VARCHAR2,80], "ACCT1"."COD_CRLNUM"[VARCHAR2,44] 1
TABLE ACCESS FULL LIQU2_LMS ORBICASH_ACCOUNTS ACCT1@SEL$9 23 TABLE ANALYZED 58 57 9 1 45 3805 296790 1 1 58 7145410 45 "ACCT1"."NBR_OWNACCOUNT"[VARCHAR2,160], "ACCT1"."TXT_NAMOWNACCOUNT"[VARCHAR2,400], "ACCT1"."NBR_COREACCOUNT"[VARCHAR2,160], "ACCT1"."COD_ENTITY"[VARCHAR2,80], "ACCT1"."COD_BRANCH"[VARCHAR2,80], "ACCT1"."COD_CCY"[VARCHAR2,12], "ACCT1"."COD_GL"[VARCHAR2,80], "ACCT1"."COD_COUNTRY"[VARCHAR2,80], "ACCT1"."COD_BNK_LGL"[VARCHAR2,80], "ACCT1"."COD_CRLNUM"[VARCHAR2,44] 1 SEL$9
VIEW LIQU2_LMS LOANDTLS@SEL$9 28 59 51 6 2 5631 7331 6385301 1275640526 5552 "FLG_LOAN_TXN"[VARCHAR2,4], "LOANDTLS"."COD_AGREEMENT"[VARCHAR2,160], "COD_INCOID"[VARCHAR2,400], "LOANDTLS"."HEADER_ACC_ID"[VARCHAR2,160], "LOANDTLS"."STATUS"[CHARACTER,14], "LOANDTLS"."PARTY_ACC_ID"[VARCHAR2,160], "LOANDTLS"."REPAYMENT_TERMS"[VARCHAR2,80], "LOANDTLS"."TENOT_PARTIAL_REPAYMENT"[VARCHAR2,4], "LOANDTLS"."POST_INTEREST"[VARCHAR2,4], "LOANDTLS"."COD_DOMICILEGL"[VARCHAR2,80], "DAT_BUSINESS"[DATE,7], "COD_REASON"[VARCHAR2,80], "TXT_STATUS"[VARCHAR2,140], "LOANDTLS"."FLG_INCO_VARIANT"[VARCHAR2,8], "FLG_CALCINTEREST"[VARCHAR2,4], "FLG_WHT"[VARCHAR2,4], "FLG_REPORTINGFREQ"[VARCHAR2,4], "FLG_WHTPOSTALLOWED"[VARCHAR2,4], "TYP_LIMIT"[VARCHAR2,40], "LOANDTLS"."COD_DEF_ACCR_CYCLE"[VARCHAR2,80], "LOANDTLS"."COD_DEF_POST_CYCLE"[VARCHAR2,80], "LOANDTLS"."TYP_INTPOSTOPTION"[VARCHAR2,40], "LOANDTLS"."DAT_FIRST_POSTING"[DATE,7], "LOANDTLS"."DAT_LASTPOSTING"[DATE,7], "LOANDTLS"."COD_SERVER"[VARCHAR2,20], "FLG_YTD"[VARCHAR2,4], "LOANDTLS"."FLG_ENTRUSTLOAN"[VARCHAR2,4] 68 SET$3
SORT UNIQUE 60 59 7 1 5631 7331 5410650 642395491 3641 12018000 (#keys=30) STRDEF[4], STRDEF[160], STRDEF[400], STRDEF[160], STRDEF[14], STRDEF[160], STRDEF[80], STRDEF[4], STRDEF[4], STRDEF[17], STRDEF[80], STRDEF[7], STRDEF[80], STRDEF[140], STRDEF[8], STRDEF[4], STRDEF[4], STRDEF[4], STRDEF[4], STRDEF[4], STRDEF[40], STRDEF[80], STRDEF[80], STRDEF[40], STRDEF[7], STRDEF[7], STRDEF[160], STRDEF[20], STRDEF[4], STRDEF[4] 68 SET$3
UNION-ALL 61 60 8 1 STRDEF[4], STRDEF[160], STRDEF[400], STRDEF[160], STRDEF[14], STRDEF[160], STRDEF[80], STRDEF[4], STRDEF[4], STRDEF[17], STRDEF[80], STRDEF[7], STRDEF[80], STRDEF[140], STRDEF[8], STRDEF[4], STRDEF[4], STRDEF[4], STRDEF[4], STRDEF[4], STRDEF[40], STRDEF[80], STRDEF[80], STRDEF[40], STRDEF[7], STRDEF[7], STRDEF[160], STRDEF[20], STRDEF[4], STRDEF[4]
HASH JOIN RIGHT OUTER 62 61 9 1 2538 7329 5408802 603824280 2501 "AG1"."COD_AGREEMENT"(+)="B"."COD_AGREEMENT" (#keys=1) "AG1"."FLG_ENTRUSTLOAN"[VARCHAR2,4], "B"."COD_INCOID"[VARCHAR2,160], "C"."DAT_FIRST_POSTING"[DATE,7], "A"."FLG_YTD"[VARCHAR2,4], "COD_ENTITY1"[VARCHAR2,160], "COD_ENTITY2"[VARCHAR2,160], "A"."COD_AGREEMENT"[VARCHAR2,160], "COD_DOMICILEGL"[VARCHAR2,80], "A"."FLG_CALCINTEREST"[VARCHAR2,4], "A"."FLG_INTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_WHT"[VARCHAR2,4], "A"."FLG_WHTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_LOAN_TXN"[VARCHAR2,4], "TYP_REPAYMENT"[VARCHAR2,80], "FLG_INCOPARTIALREPAYMENT"[VARCHAR2,4], "A"."FLG_INCO_VARIANT"[VARCHAR2,4], "A"."FLG_REPORTINGFREQ"[VARCHAR2,4], "A"."TYP_LIMIT"[VARCHAR2,40], "A"."COD_SERVER"[VARCHAR2,20], "C"."DAT_LASTPOSTING"[DATE,7], "C"."COD_DEF_ACCR_CYCLE"[VARCHAR2,80], "C"."COD_DEF_POST_CYCLE"[VARCHAR2,80], "C"."TYP_INTPOSTOPTION"[VARCHAR2,40], "B"."TXT_STATUS"[VARCHAR2,140], "B"."COD_REASON"[VARCHAR2,80], "B"."DAT_BUSINESS"[DATE,7], "B"."TXT_REFCODE"[VARCHAR2,400] 31 SEL$10
TABLE ACCESS FULL LIQU2_LMS OLM_INCO_AGREEMENT AG1@SEL$10 35 TABLE ANALYZED 63 62 10 1 3 58 290 74952 3 "AG1"."COD_AGREEMENT"[VARCHAR2,160], "AG1"."FLG_ENTRUSTLOAN"[VARCHAR2,4] 1 SEL$10
HASH JOIN 64 62 10 2 2535 7329 5372157 594928933 2498 "A"."COD_INCOID"="B"."COD_INCOID" (#keys=1) "B"."COD_INCOID"[VARCHAR2,160], "C"."DAT_FIRST_POSTING"[DATE,7], "A"."FLG_YTD"[VARCHAR2,4], "COD_ENTITY1"[VARCHAR2,160], "COD_ENTITY2"[VARCHAR2,160], "A"."COD_AGREEMENT"[VARCHAR2,160], "COD_DOMICILEGL"[VARCHAR2,80], "A"."FLG_CALCINTEREST"[VARCHAR2,4], "A"."FLG_INTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_WHT"[VARCHAR2,4], "A"."FLG_WHTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_LOAN_TXN"[VARCHAR2,4], "TYP_REPAYMENT"[VARCHAR2,80], "FLG_INCOPARTIALREPAYMENT"[VARCHAR2,4], "A"."FLG_INCO_VARIANT"[VARCHAR2,4], "A"."FLG_REPORTINGFREQ"[VARCHAR2,4], "A"."TYP_LIMIT"[VARCHAR2,40], "A"."COD_SERVER"[VARCHAR2,20], "C"."DAT_LASTPOSTING"[DATE,7], "C"."COD_DEF_ACCR_CYCLE"[VARCHAR2,80], "C"."COD_DEF_POST_CYCLE"[VARCHAR2,80], "C"."TYP_INTPOSTOPTION"[VARCHAR2,40], "B"."TXT_STATUS"[VARCHAR2,140], "B"."COD_REASON"[VARCHAR2,80], "B"."DAT_BUSINESS"[DATE,7], "B"."TXT_REFCODE"[VARCHAR2,400], "B"."COD_AGREEMENT"[VARCHAR2,160] 31
HASH JOIN OUTER 65 64 11 1 15 175 42700 41392989 12 "A"."COD_INCOID"="C"."COD_ENTITY"(+) (#keys=1) "A"."COD_INCOID"[VARCHAR2,160], "A"."FLG_YTD"[VARCHAR2,4], "COD_ENTITY1"[VARCHAR2,160], "COD_ENTITY2"[VARCHAR2,160], "A"."COD_AGREEMENT"[VARCHAR2,160], "COD_DOMICILEGL"[VARCHAR2,80], "A"."FLG_CALCINTEREST"[VARCHAR2,4], "A"."FLG_INTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_WHT"[VARCHAR2,4], "A"."FLG_WHTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_LOAN_TXN"[VARCHAR2,4], "TYP_REPAYMENT"[VARCHAR2,80], "FLG_INCOPARTIALREPAYMENT"[VARCHAR2,4], "A"."FLG_INCO_VARIANT"[VARCHAR2,4], "A"."FLG_REPORTINGFREQ"[VARCHAR2,4], "A"."TYP_LIMIT"[VARCHAR2,40], "A"."COD_SERVER"[VARCHAR2,20], "C"."DAT_LASTPOSTING"[DATE,7], "C"."COD_DEF_ACCR_CYCLE"[VARCHAR2,80], "C"."COD_DEF_POST_CYCLE"[VARCHAR2,80], "C"."TYP_INTPOSTOPTION"[VARCHAR2,40], "C"."DAT_FIRST_POSTING"[DATE,7] 1
TABLE ACCESS FULL LIQU2_LMS OLM_INCO_DEFINITION A@SEL$10 29 TABLE ANALYZED 66 65 12 1 3 175 9450 244222 3 "A"."COD_INCOID"<>'-1' "A"."COD_INCOID"[VARCHAR2,160], "COD_ENTITY1"[VARCHAR2,160], "COD_ENTITY2"[VARCHAR2,160], "A"."COD_AGREEMENT"[VARCHAR2,160], "COD_DOMICILEGL"[VARCHAR2,80], "A"."FLG_CALCINTEREST"[VARCHAR2,4], "A"."FLG_INTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_WHT"[VARCHAR2,4], "A"."FLG_WHTPOSTALLOWED"[VARCHAR2,4], "A"."FLG_LOAN_TXN"[VARCHAR2,4], "TYP_REPAYMENT"[VARCHAR2,80], "FLG_INCOPARTIALREPAYMENT"[VARCHAR2,4], "A"."FLG_INCO_VARIANT"[VARCHAR2,4], "A"."FLG_REPORTINGFREQ"[VARCHAR2,4], "A"."TYP_LIMIT"[VARCHAR2,40], "A"."COD_SERVER"[VARCHAR2,20], "A"."FLG_YTD"[VARCHAR2,4] 1 SEL$10
VIEW LIQU2_LMS C@SEL$10 31 67 65 12 2 11 47 8930 33026222 9 "C"."COD_ENTITY"[VARCHAR2,128], "C"."COD_DEF_ACCR_CYCLE"[VARCHAR2,80], "C"."COD_DEF_POST_CYCLE"[VARCHAR2,80], "C"."TYP_INTPOSTOPTION"[VARCHAR2,40], "C"."DAT_FIRST_POSTING"[DATE,7], "C"."DAT_LASTPOSTING"[DATE,7] 1 SEL$13
HASH UNIQUE 68 67 13 1 11 47 4465 33026222 9 (#keys=9) "COD_ENTITY"[VARCHAR2,128], "COD_DEF_ACCR_CYCLE"[VARCHAR2,80], "COD_DEF_POST_CYCLE"[VARCHAR2,80], "TYP_INTPOSTOPTION"[VARCHAR2,40], "DAT_FIRST_POSTING"[DATE,7], "DAT_LASTPOSTING"[DATE,7], "DAT_START"[DATE,7], "DAT_END"[DATE,7], "OEI"."TYP_ENTITY"[VARCHAR2,128] 1 SEL$13
HASH JOIN 69 68 14 1 10 47 4465 16856870 9 "A"."COD_INCOID"="OEI"."COD_ENTITY" "OEI"."DAT_START"<="OHD"."DAT_TODAY" AND ("OEI"."DAT_END" IS NULL OR "OHD"."DAT_TODAY"<="OEI"."DAT_END") (#keys=1) "OEI"."COD_ENTITY"[VARCHAR2,128], "OEI"."TYP_ENTITY"[VARCHAR2,128], "TYP_INTPOSTOPTION"[VARCHAR2,40], "COD_DEF_ACCR_CYCLE"[VARCHAR2,80], "COD_DEF_POST_CYCLE"[VARCHAR2,80], "DAT_FIRST_POSTING"[DATE,7], "DAT_LASTPOSTING"[DATE,7], "OEI"."DAT_START"[DATE,7], "OEI"."DAT_END"[DATE,7] 1
HASH JOIN 70 69 15 1 6 91 2730 8263162 5 "COD_GL"="A"."COD_DOMICILEGL" (#keys=1) "OHD"."DAT_TODAY"[DATE,7], "A"."COD_INCOID"[VARCHAR2,160] 1
TABLE ACCESS FULL LIQU2_LMS OLM_HOSTSYSTEMDATES OHD@SEL$13 33 TABLE ANALYZED 71 70 16 1 2 37 740 46246 2 "COD_MODULE"='SWEEPS' "COD_GL"[VARCHAR2,80], "OHD"."DAT_TODAY"[DATE,7] 1 SEL$13
TABLE ACCESS FULL LIQU2_LMS OLM_INCO_DEFINITION A@SEL$13 34 TABLE ANALYZED 72 70 16 2 3 88 880 123472 3 "A"."FLG_CALCINTEREST"='Y' AND "A"."COD_INCOID"<>'-1' "A"."COD_INCOID"[VARCHAR2,160], "A"."COD_DOMICILEGL"[VARCHAR2,80] 1 SEL$13
PARTITION RANGE SINGLE 73 69 15 2 4 262 17030 1 1 73 475063 4 "OEI"."TYP_ENTITY"[VARCHAR2,128], "OEI"."COD_ENTITY"[VARCHAR2,128], "COD_DEF_ACCR_CYCLE"[VARCHAR2,80], "COD_DEF_POST_CYCLE"[VARCHAR2,80], "DAT_FIRST_POSTING"[DATE,7], "DAT_LASTPOSTING"[DATE,7], "OEI"."DAT_START"[DATE,7], "OEI"."DAT_END"[DATE,7], "TYP_INTPOSTOPTION"[VARCHAR2,40] 1
TABLE ACCESS FULL LIQU2_LMS ORATE_ENTITY_INTEREST OEI@SEL$13 32 TABLE ANALYZED 74 73 16 1 4 262 17030 1 1 74 475063 4 "OEI"."TYP_ENTITY"='INCO' AND "COD_ENTITY"<>'-1' "OEI"."TYP_ENTITY"[VARCHAR2,128], "OEI"."COD_ENTITY"[VARCHAR2,128], "COD_DEF_ACCR_CYCLE"[VARCHAR2,80], "COD_DEF_POST_CYCLE"[VARCHAR2,80], "DAT_FIRST_POSTING"[DATE,7], "DAT_LASTPOSTING"[DATE,7], "OEI"."DAT_START"[DATE,7], "OEI"."DAT_END"[DATE,7], "TYP_INTPOSTOPTION"[VARCHAR2,40] 1 SEL$13
VIEW LIQU2_LMS OLM_INSTRTXNVW B@SEL$10 30 VIEW 75 64 11 2 2520 7329 3583881 544698000 2486 "B"."TXT_STATUS"[VARCHAR2,140], "B"."COD_REASON"[VARCHAR2,80], "B"."DAT_BUSINESS"[DATE,7], "B"."COD_INCOID"[VARCHAR2,160], "B"."COD_AGREEMENT"[VARCHAR2,160], "B"."TXT_REFCODE"[VARCHAR2,400] 31 SET$4
SORT UNIQUE 76 75 12 1 2520 7329 2748409 22447196 35 10937000
burleson
Hi Manoj,

You are trying solve a complex proglem solely in DQL, not a good idea. SQL is fo data retrienal, nothing more, and you use PL/SQL with twiddle the data.

Please READ:

http://www.remote-dba.net/oracle_10g_tunin..._sql_clause.htm

I would simplify this by making smaller, multiple queries and fit them into a PL/SQL stored procedure.

I will be easier to maintain, tune, and rasier to read also!

It's right in front of you, in the execution plan:

http://www.dba-oracle.com/t_OracleAutotrace.htm

See here below on how to tune a complex monsters like this one!

http://rampant-books.com/book_1002_oracle_...ence_2nd_ed.htm

[code]Explain PLan :

OPERATION OPTIONS OBJECT_NODE OBJECT_OWNER OBJECT_NAME OBJECT_ALIAS OBJECT_INSTANCE OBJECT_TYPE OPTIMIZER SEARCH_COLUMNS ID PARENT_ID DEPTH POSITION COST CARDINALITY BYTES OTHER_TAG PARTITION_START PARTITION_STOP PARTITION_ID OTHER OTHER_XML DISTRIBUTION CPU_COST IO_COST TEMP_SPACE ACCESS_PREDICATES FILTER_PREDICATES PROJECTION TIME QBLOCK_NAME
burleson
This is from a Medicaid system, right?

You should have loads of qalified DBA's to tutor you!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.