UNION
=====


STATEMENT_ID,TIMESTAMP,REMARKS,OPERATION,OPTIONS,OBJECT_NODE,OBJECT_OWNER,OBJECT_NAME,OBJECT_INSTANCE,OBJECT_TYPE,OPTIMIZER,SEARCH_COLUMNS,ID,PARENT_ID,POSITION,COST,CARDINALITY,BYTES,OTHER_TAG,PARTITION_START,PARTITION_STOP,PARTITION_ID,OTHER,DISTRIBUTION,CPU_COST,IO_COST,TEMP_SPACE,ACCESS_PREDICATES,FILTER_PREDICATES
[NULL],13/06/2008 12:06,[NULL],INDEX,UNIQUE SCAN,[NULL],CALYPSO_DEV10,PK_PRODUCT_SEC_CODE,[NULL],UNIQUE,ANALYZED,2,69,68,1,1,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"DC.""CALYPSOSECURITYID""=""SYS_ALIAS_0000"".""PRODUCT_ID""(+) AND ""SYS_ALIAS_0000"".""SEC_CODE""(+)='INDUSTRY_SECTOR'",[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,PRODUCT_SEC_CODE,35,[NULL],ANALYZED,[NULL],70,39,2,2,1,26,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],INDEX,UNIQUE SCAN,[NULL],CALYPSO_DEV10,PK_PRODUCT_SEC_CODE,[NULL],UNIQUE,ANALYZED,2,71,70,1,1,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"DC.""CALYPSOSECURITYID""=""SYS_ALIAS_0001"".""PRODUCT_ID""(+) AND ""SYS_ALIAS_0001"".""SEC_CODE""(+)='Collateral_Type'",[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,PRODUCT_SEC_CODE,33,[NULL],ANALYZED,[NULL],72,38,2,2,1,26,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],INDEX,UNIQUE SCAN,[NULL],CALYPSO_DEV10,PK_PRODUCT_SEC_CODE,[NULL],UNIQUE,ANALYZED,2,73,72,1,1,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"DC.""CALYPSOSECURITYID""=""SYS_ALIAS_0002"".""PRODUCT_ID""(+) AND ""SYS_ALIAS_0002"".""SEC_CODE""(+)='RTG_DBRS'",[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,PRODUCT_SEC_CODE,31,[NULL],ANALYZED,[NULL],74,37,2,2,1,26,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],INDEX,UNIQUE SCAN,[NULL],CALYPSO_DEV10,PK_PRODUCT_SEC_CODE,[NULL],UNIQUE,ANALYZED,2,75,74,1,1,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"DC.""CALYPSOSECURITYID""=""C"".""PRODUCT_ID""(+) AND ""C"".""SEC_CODE""(+)='INDUSTRY_GROUP'",[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,FULL,[NULL],CALYPSO_DEV10,CMPP_TMP_BADBOOKIDS,38,[NULL],ANALYZED,[NULL],76,36,2,2,2,10,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],"LNNVL(""CMPP_TMP_BADBOOKIDS"".""BOOK_ID""<>:B1)"
[NULL],13/06/2008 12:06,[NULL],FILTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],77,2,3,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]," NOT EXISTS (SELECT /*+ */ 0 FROM ""CMPP_TMP_BADBOOKIDS"" ""CMPP_TMP_BADBOOKIDS"" WHERE LNNVL(""CMPP_TMP_BADBOOKIDS"".""BOOK_ID""<>:B1))"
[NULL],13/06/2008 12:06,[NULL],HASH JOIN,OUTER,:Q571309013,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],78,77,1,4165,1276,1006764,PARALLEL_TO_SERIAL,[NULL],[NULL],[NULL],"SELECT /*+ ORDERED NO_EXPAND USE_HASH(A2) */ A1.C1,A1.C2,A1.C3,A1.C4,A1.C5,A1.C6,A1.C7,A1.C8,A1.C9,A1.C10,A1.C11,A1.C12,A1.C13,A1.C14,A1.C15,A1.C16,A1.C17,A1.C18,A1.C19,A1.C20,A1.C21,A1.C22,A1.C23,A1.C24,A1.C25,A1.C26,A1.C27,A1.C28,A1.C29,A1.C30,A1.C31,A1.C32,A1.C33,A1.C34,A1.C35,A1.C36,A1.C37,A1.C38,A1.C39,A1.C40,A1.C41,A1.C42,A1.C43,A1.C44,A1.C45,A1.C46,A1.C47,A1.C48,A1.C49,A1.C50,A1.C51,A1.C52,A1.C53,A1.C54,A1.C55,A1.C56,A1.C57,A1.C58,A1.C59,A1.C60,A1.C61,A1.C62,A1.C63,A1.C64,A1.C65,A1.C66 FROM :Q571309011 A1,:Q571309012 A2 WHERE A1.C0=A2.C0(+)",QC (RANDOM),[NULL],4165,[NULL],"SYS_ALIAS_1.""COUNTERPARTYCISID""=""GC"".""CIS_CODE""(+)",[NULL]
[NULL],13/06/2008 12:06,[NULL],HASH JOIN,OUTER,:Q571309011,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],79,78,1,3937,1276,995280,PARALLEL_TO_PARALLEL,[NULL],[NULL],[NULL],"SELECT /*+ ORDERED NO_EXPAND USE_HASH(A2) */ A1.C19 C0,A1.C0 C1,A2.C0 C2,A1.C1 C3,A1.C2 C4,A1.C3 C5,A1.C4 C6,A1.C5 C7,A1.C6 C8,A1.C7 C9,A1.C8 C10,A1.C9 C11,A1.C10 C12,A1.C11 C13,A1.C12 C14,A1.C13 C15,A1.C14 C16,A1.C15 C17,A1.C16 C18,A1.C17 C19,A1.C18 C20,A2.C2 C21,A1.C20 C22,A1.C21 C23,A1.C22 C24,A1.C23 C25,A1.C24 C26,A1.C25 C27,A1.C26 C28,A1.C27 C29,A1.C28 C30,A1.C29 C31,A1.C30 C32,A1.C31 C33,A1.C32 C34,A1.C33 C35,A1.C34 C36,A1.C35 C37,A1.C36 C38,A1.C37 C39,A1.C38 C40,A1.C39 C41,A1.C40 C42,A1.C41 C43,A1.C42 C44,A1.C43 C45,A1.C44 C46,A1.C45 C47,A1.C46 C48,A1.C47 C49,A1.C48 C50,A1.C49 C51,A1.C50 C52,A1.C51 C53,A1.C52 C54,A1.C53 C55,A1.C54 C56,A1.C55 C57,A1.C56 C58,A1.C57 C59,A1.C58 C60,A1.C59 C61,A1.C60 C62,A1.C61 C63,A1.C62 C64,A1.C63 C65,A2.C1 C66 FROM (SELECT /*+ ORDERED NO_EXPAND USE_HASH(A4) */ A3.C0 C0,A4.C2 C1,A4.C0 C2,A3.C1 C3,A3.C2 C4,A3.C3 C5,A3.C4 C6,A3.C5 C7,A3.C6 C8,A3.C7 C9,A3.C8 C10,A3.C9 C11,A3.C10 C12,A3.C11 C13,A3.C12 C14,A3.C13 C15,A3.C14 C16,A3.C15 C17,A3.C16 C18,A3.C17 C19,A3.C18 C20,A3.C19 C21,A3.C20 C22,A3.C21 C23,A3.C22 C24,A3.C23 C25,A3.C24 C26,A3.C25 C27,A3.C26 C28,A3.C27 C29,A3.C28 C30,A3.C29 C31,A3.C30 C32,A3.C31 C33,A3.C32 C34,A3.C33 C35,A3.C34 C36,A3.C35 C37,A3.C36 C38,A3.C37 C39,A3.C38 C40,A3.C39 C41,A3.C40 C42,A3.C41 C43,A3.C42 C44,A3.C43 C45,A3.C44 C46,A3.C45 C47,A3.C46 C48,A3.C47 C49,A3.C48 C50,A3.C49 C51,A3.C50 C52,A3.C51 C53,A3.C52 C54,A3.C53 C55,A3.C54 C56,A3.C55 C57,A3.C56 C58,A3.C57 C59,A3.C58 C60,A3.C59 C61,A3.C60 C62,A4.C1 C63 FROM (SELECT /*+ ORDERED NO_EXPAND USE_HASH(A6) */ A5.C0 C0,A6.C2 C1,A6.C0 C2,A5.C1 C3,A5.C2 C4,A5.C3 C5,A5.C4 C6,A5.C5 C7,A5.C6 C8,A5.C7 C9,A5.C8 C10,A5.C9 C11,A5.C10 C12,A5.C11 C13,A5.C12 C14,A5.C13 C15,A5.C14 C16,A5.C15 C17,A5.C16 C18,A5.C17 C19,A5.C18 C20,A5.C19 C21,A5.C20 C22,A5.C21 C23,A5.C22 C24,A5.C23 C25,A5.C24 C26,A5.C25 C27,A5.C26 C28,A5.C27 C29,A5.C28 C30,A5.C29 C31,A5.C30 C32,A5.C31 C33,A5.C32 C34,A5.C33 C35,A5.C34 C36,A5.C35 C37,A5.C36 C38,A5.C37 C39,A5.C38 C40,A5.C39 C41,A5.C40 C42,A5.C41 C43,A5.C42 C44,A5.C43 C45,A5.C44 C46,A5.C45 C47,A5.C46 C48,A5.C47 C49,A5.C48 C50,A5.C49 C51,A5.C50 C52,A5.C51 C53,A5.C52 C54,A5.C53 C55,A5.C54 C56,A5.C55 C57,A5.C56 C58,A5.C57 C59,A6.C1 C60 FROM (SELECT /*+ ORDERED NO_EXPAND USE_HASH(A8) */ A7.C0 C0,A8.C2 C1,A8.C0 C2,A7.C1 C3,A7.C2 C4,A7.C3 C5,A7.C4 C6,A7.C5 C7,A7.C6 C8,A7.C7 C9,A7.C8 C10,A7.C9 C11,A7.C10 C12,A7.C11 C13,A7.C12 C14,A7.C13 C15,A7.C14 C16,A7.C15 C17,A7.C16 C18,A7.C17 C19,A7.C18 C20,A7.C19 C21,A7.C20 C22,A7.C21 C23,A7.C22 C24,A7.C23 C25,A7.C24 C26,A7.C25 C27,A7.C26 C28,A7.C27 C29,A7.C28 C30,A7.C29 C31,A7.C30 C32,A7.C31 C33,A7.C32 C34,A7.C33 C35,A7.C34 C36,A7.C35 C37,A7.C36 C38,A7.C37 C39,A7.C38 C40,A7.C39 C41,A7.C40 C42,A7.C41 C43,A7.C42 C44,A7.C43 C45,A7.C44 C46,A7.C45 C47,A7.C46 C48,A7.C47 C49,A7.C48 C50,A7.C49 C51,A7.C50 C52,A7.C51 C53,A7.C52 C54,A7.C53 C55,A7.C54 C56,A8.C1 C57 FROM :Q571309010 A7,:Q571309003 A8 WHERE A7.C0=A8.C0(+)) A5,:Q571309004 A6 WHERE A5.C0=A6.C0(+)) A3,:Q571309005 A4 WHERE A3.C0=A4.C0(+)) A1,:Q571309006 A2 WHERE A1.C0=A2.C0(+)",HASH,[NULL],3937,[NULL],"DC.""CALYPSOSECURITYID""=""SYS_ALIAS_0000"".""PRODUCT_ID""(+)",[NULL]
[NULL],13/06/2008 12:06,[NULL],HASH JOIN,OUTER,:Q571309011,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],80,79,1,3105,1069,806026,PARALLEL_COMBINED_WITH_PARENT,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],3105,[NULL],"DC.""CALYPSOSECURITYID""=""SYS_ALIAS_0001"".""PRODUCT_ID""(+)",[NULL]
[NULL],13/06/2008 12:06,[NULL],HASH JOIN,OUTER,:Q571309011,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],81,80,1,2273,896,652288,PARALLEL_COMBINED_WITH_PARENT,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2273,[NULL],"DC.""CALYPSOSECURITYID""=""SYS_ALIAS_0002"".""PRODUCT_ID""(+)",[NULL]
[NULL],13/06/2008 12:06,[NULL],HASH JOIN,OUTER,:Q571309011,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],82,81,1,1441,751,527202,PARALLEL_COMBINED_WITH_PARENT,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1441,[NULL],"DC.""CALYPSOSECURITYID""=""C"".""PRODUCT_ID""(+)",[NULL]
[NULL],13/06/2008 12:06,[NULL],FILTER,[NULL],:Q571309011,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],83,82,1,[NULL],[NULL],[NULL],PARALLEL_COMBINED_WITH_CHILD,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"DC.""REGION""=""P"".""REGION"" OR ""P"".""REGION"" IS NULL"
[NULL],13/06/2008 12:06,[NULL],NESTED LOOPS,OUTER,:Q571309010,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],84,83,1,[NULL],[NULL],[NULL],PARALLEL_TO_PARALLEL,[NULL],[NULL],[NULL],"SELECT /*+ ORDERED NO_EXPAND USE_NL(A2) INDEX(A2 ""IDX_CMPP_TMP_PRCE1"") */ A1.C45 C0,A1.C0 C1,A1.C1 C2,A1.C2 C3,A1.C3 C4,A1.C4 C5,A1.C5 C6,A1.C6 C7,A1.C7 C8,A1.C8 C9,A1.C9 C10,A1.C10 C11,A1.C11 C12,A1.C12 C13,A1.C13 C14,A1.C14 C15,A1.C15 C16,A1.C16 C17,A1.C17 C18,A1.C18 C19,A1.C19 C20,A1.C20 C21,A1.C21 C22,A1.C22 C23,A1.C23 C24,A1.C24 C25,A1.C25 C26,A1.C26 C27,A1.C27 C28,A1.C28 C29,A1.C29 C30,A1.C30 C31,A1.C31 C32,A1.C32 C33,A1.C33 C34,A1.C34 C35,A1.C35 C36,A1.C36 C37,A1.C37 C38,A1.C38 C39,A1.C39 C40,A1.C40 C41,A1.C41 C42,A1.C42 C43,A1.C43 C44,A1.C44 C45,A2.""REGION"" C46,A1.C46 C47,A1.C47 C48,A1.C48 C49,A1.C49 C50,A1.C50 C51,A2.ROWID C52,A2.""ID"" C53,A2.""BID"" C54 FROM (SELECT /*+ ORDERED NO_EXPAND USE_NL(A4) INDEX(A4 ""IDX_CMPP_TMP_RATE1"") */ A3.C0 C0,A3.C1 C1,A3.C2 C2,A3.C3 C3,A3.C4 C4,A3.C5 C5,A3.C6 C6,A3.C7 C7,A3.C8 C8,A3.C9 C9,A3.C10 C10,A3.C11 C11,A3.C12 C12,A3.C13 C13,A3.C14 C14,A3.C15 C15,A3.C16 C16,A3.C17 C17,A3.C18 C18,A3.C19 C19,A3.C20 C20,A3.C21 C21,A3.C22 C22,A3.C23 C23,A3.C24 C24,A3.C25 C25,A3.C26 C26,A3.C27 C27,A3.C28 C28,A3.C29 C29,A3.C30 C30,A3.C31 C31,A3.C32 C32,A3.C33 C33,A3.C34 C34,A3.C35 C35,A3.C36 C36,A3.C37 C37,A3.C38 C38,A3.C39 C39,A3.C40 C40,A3.C41 C41,A3.C42 C42,A3.C43 C43,A3.C44 C44,A3.C45 C45,A3.C46 C46,A4.ROWID C47,A4.""CALYPSOSECURITYID"" C48,A4.""RATINGTYPE"" C49,A4.""RATINGVALUE"" C50 FROM (SELECT /*+ ORDERED NO_EXPAND USE_HASH(A6) */ A5.C0 C0,A5.C1 C1,A5.C2 C2,A5.C3 C3,A5.C4 C4,A5.C5 C5,A5.C6 C6,A5.C7 C7,A5.C8 C8,A5.C9 C9,A5.C10 C10,A5.C11 C11,A5.C12 C12,A5.C13 C13,A5.C14 C14,A5.C15 C15,A5.C16 C16,A5.C17 C17,A5.C18 C18,A5.C19 C19,A5.C20 C20,A5.C21 C21,A5.C22 C22,A5.C23 C23,A5.C24 C24,A5.C25 C25,A5.C26 C26,A5.C27 C27,A5.C28 C28,A5.C29 C29,A5.C30 C30,A5.C31 C31,A5.C32 C32,A5.C33 C33,A5.C34 C34,A5.C35 C35,A5.C36 C36,A5.C37 C37,A5.C38 C38,A5.C39 C39,A5.C40 C40,A5.C41 C41,A6.C1 C42,A6.C2 C43,A6.C3 C44,A6.C4 C45,A6.C5 C46 FROM :Q571309009 A5,:Q571309002 A6 WHERE A6.C4 IS NULL AND A5.C0=A6.C0(+)) A3,""CMPP_TMP_RATE"" A4 WHERE (A4.""RATINGTYPE""='S & P' OR A4.""RATINGTYPE"" IS NULL) AND A3.C45=A4.""CALYPSOSECURITYID""(+)) A1,""CMPP_TMP_PRCE"" A2 WHERE (A1.C43=A2.""REGION"" OR A2.""REGION"" IS NULL) AND A1.C45=A2.""ID""(+)",HASH,[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],FILTER,[NULL],:Q571309010,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],85,84,1,[NULL],[NULL],[NULL],PARALLEL_COMBINED_WITH_CHILD,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"R.""RATINGTYPE""='S & P' OR ""R"".""RATINGTYPE"" IS NULL"
[NULL],13/06/2008 12:06,[NULL],NESTED LOOPS,OUTER,:Q571309010,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],86,85,1,[NULL],[NULL],[NULL],PARALLEL_COMBINED_WITH_PARENT,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],FILTER,[NULL],:Q571309010,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],87,86,1,[NULL],[NULL],[NULL],PARALLEL_COMBINED_WITH_CHILD,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"DC.""CALYPSOSECURITYID"" IS NULL"
[NULL],13/06/2008 12:06,[NULL],HASH JOIN,OUTER,:Q571309010,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],88,87,1,[NULL],[NULL],[NULL],PARALLEL_COMBINED_WITH_PARENT,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"SYS_ALIAS_1.""CALYPSOTRADEID""=""DC"".""CALYPSOTRADEID""(+)",[NULL]
[NULL],13/06/2008 12:06,[NULL],HASH JOIN,[NULL],:Q571309009,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],89,88,1,331,622,340234,PARALLEL_TO_PARALLEL,[NULL],[NULL],[NULL],"SELECT /*+ ORDERED NO_EXPAND USE_HASH(A2) */ A1.C5 C0,A1.C1 C1,A1.C2 C2,A1.C3 C3,A1.C4 C4,A1.C42 C5,A1.C6 C6,A1.C7 C7,A1.C8 C8,A1.C9 C9,A1.C10 C10,A1.C11 C11,A1.C12 C12,A1.C13 C13,A1.C14 C14,A1.C15 C15,A1.C16 C16,A1.C17 C17,A1.C18 C18,A1.C19 C19,A1.C20 C20,A1.C21 C21,A1.C22 C22,A1.C23 C23,A1.C24 C24,A1.C25 C25,A1.C26 C26,A1.C27 C27,A1.C28 C28,A1.C29 C29,A1.C30 C30,A1.C31 C31,A1.C32 C32,A1.C33 C33,A1.C34 C34,A1.C35 C35,A1.C36 C36,A1.C37 C37,A1.C38 C38,A1.C39 C39,A1.C40 C40,A1.C41 C41 FROM :Q571309008 A1,:Q571309001 A2 WHERE A1.C0=A2.C0",HASH,[NULL],331,[NULL],"GB.""SYS_BOOK""=""GS"".""SRC_SYS_BOOK""",[NULL]
[NULL],13/06/2008 12:06,[NULL],HASH JOIN,OUTER,:Q571309008,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],90,89,1,316,622,326550,PARALLEL_TO_PARALLEL,[NULL],[NULL],[NULL],"SELECT /*+ ORDERED NO_EXPAND USE_HASH(A2) */ A1.C2 C0,A1.C1 C1,A1.C43 C2,A1.C3 C3,A1.C4 C4,A1.C5 C5,A1.C6 C6,A1.C7 C7,A1.C8 C8,A1.C9 C9,A1.C10 C10,A1.C11 C11,A1.C12 C12,A1.C13 C13,A1.C14 C14,A1.C15 C15,A1.C16 C16,A1.C17 C17,A1.C18 C18,A1.C19 C19,A1.C20 C20,A1.C21 C21,A1.C22 C22,A1.C23 C23,A1.C24 C24,A1.C25 C25,A1.C26 C26,A1.C27 C27,A1.C28 C28,A1.C29 C29,A1.C30 C30,A1.C31 C31,A1.C32 C32,A1.C33 C33,A1.C34 C34,A1.C35 C35,A1.C36 C36,A1.C37 C37,A1.C38 C38,A1.C39 C39,A1.C40 C40,A1.C41 C41,A1.C42 C42 FROM :Q571309000 A1,:Q571309007 A2 WHERE A1.C0=A2.C0(+)",HASH,[NULL],316,[NULL],"GB.""PARENT_ORGANISATION_ID""=""GO"".""ORGANISATION_ID""(+)",[NULL]
[NULL],13/06/2008 12:06,[NULL],HASH JOIN,[NULL],:Q571309000,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],91,90,1,313,622,323440,PARALLEL_FROM_SERIAL,[NULL],[NULL],[NULL],[NULL],HASH,[NULL],313,[NULL],"SYS_ALIAS_1.""CALYPSOBOOKNAME""=""GB"".""SYS_BOOK_POSTFIX""",[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,FULL,[NULL],CALYPSO_DEV10,CMPP_TMP_GRD_BOOK,43,[NULL],ANALYZED,[NULL],92,91,1,5,1372,42532,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],5,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],93,91,2,306,621,303669,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],306,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,FULL,[NULL],CALYPSO_DEV10,CMPP_TMP_DEAL,39,[NULL],ANALYZED,[NULL],94,93,1,306,621,89424,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],306,[NULL],[NULL],"SYS_ALIAS_1.""FLATFILERECORDTYPE""='Repo Loan' OR ""SYS_ALIAS_1"".""FLATFILERECORDTYPE""='Security Loan'"
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_INST,41,[NULL],ANALYZED,[NULL],95,93,2,[NULL],1,345,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_INST1,[NULL],NON-UNIQUE,ANALYZED,1,96,95,1,[NULL],1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""I"".""CALYPSOSECURITYID""(+)",[NULL]
[NULL],13/06/2008 12:06,[NULL],INDEX,FAST FULL SCAN,:Q571309007,CALYPSO_DEV10,IDX_CMPP_TMP_GO1,[NULL],NON-UNIQUE,ANALYZED,[NULL],97,90,2,3,3230,16150,PARALLEL_TO_PARALLEL,[NULL],[NULL],[NULL],"SELECT /*+ INDEX_RRS(A1 ""IDX_CMPP_TMP_GO1"") */ A1.""ORGANISATION_ID"" C0 FROM ""CMPP_TMP_GRD_ORGN""  PX_GRANULE(0, BLOCK_RANGE, DYNAMIC) A1",HASH,[NULL],3,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,FULL,:Q571309001,CALYPSO_DEV10,CMPP_TMP_GRDW_SDM,42,[NULL],ANALYZED,[NULL],98,89,2,15,15513,341286,PARALLEL_FROM_SERIAL,[NULL],[NULL],[NULL],[NULL],HASH,[NULL],15,[NULL],[NULL],"GS.""COST_CENTRE"" IS NOT NULL"
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,FULL,:Q571309002,CALYPSO_DEV10,CMPP_TMP_DEAL_COLL,40,[NULL],ANALYZED,[NULL],99,88,2,278,27180,1657980,PARALLEL_FROM_SERIAL,[NULL],[NULL],[NULL],[NULL],HASH,[NULL],278,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,BY INDEX ROWID,:Q571309010,CALYPSO_DEV10,CMPP_TMP_RATE,46,[NULL],ANALYZED,[NULL],100,86,2,[NULL],1,39,PARALLEL_COMBINED_WITH_PARENT,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],INDEX,RANGE SCAN,:Q571309010,CALYPSO_DEV10,IDX_CMPP_TMP_RATE1,[NULL],NON-UNIQUE,ANALYZED,1,101,100,1,[NULL],1,[NULL],PARALLEL_COMBINED_WITH_PARENT,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"DC.""CALYPSOSECURITYID""=""R"".""CALYPSOSECURITYID""(+)",[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,BY INDEX ROWID,:Q571309010,CALYPSO_DEV10,CMPP_TMP_PRCE,47,[NULL],ANALYZED,[NULL],102,84,2,[NULL],1,29,PARALLEL_COMBINED_WITH_PARENT,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],INDEX,RANGE SCAN,:Q571309010,CALYPSO_DEV10,IDX_CMPP_TMP_PRCE1,[NULL],NON-UNIQUE,ANALYZED,1,103,102,1,[NULL],1,[NULL],PARALLEL_COMBINED_WITH_PARENT,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"DC.""CALYPSOSECURITYID""=""P"".""ID""(+)",[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,FULL,:Q571309003,CALYPSO_DEV10,PRODUCT_SEC_CODE,49,[NULL],ANALYZED,[NULL],104,82,2,832,24386,634036,PARALLEL_FROM_SERIAL,[NULL],[NULL],[NULL],[NULL],HASH,[NULL],832,[NULL],[NULL],"C.""SEC_CODE""(+)='INDUSTRY_GROUP'"
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,FULL,:Q571309004,CALYPSO_DEV10,PRODUCT_SEC_CODE,51,[NULL],ANALYZED,[NULL],105,81,2,832,24386,634036,PARALLEL_FROM_SERIAL,[NULL],[NULL],[NULL],[NULL],HASH,[NULL],832,[NULL],[NULL],"SYS_ALIAS_0002.""SEC_CODE""(+)='RTG_DBRS'"
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,FULL,:Q571309005,CALYPSO_DEV10,PRODUCT_SEC_CODE,53,[NULL],ANALYZED,[NULL],106,80,2,832,24386,634036,PARALLEL_FROM_SERIAL,[NULL],[NULL],[NULL],[NULL],HASH,[NULL],832,[NULL],[NULL],"SYS_ALIAS_0001.""SEC_CODE""(+)='Collateral_Type'"
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,FULL,:Q571309006,CALYPSO_DEV10,PRODUCT_SEC_CODE,55,[NULL],ANALYZED,[NULL],107,79,2,832,24386,634036,PARALLEL_FROM_SERIAL,[NULL],[NULL],[NULL],[NULL],HASH,[NULL],832,[NULL],[NULL],"SYS_ALIAS_0000.""SEC_CODE""(+)='INDUSTRY_SECTOR'"
[NULL],13/06/2008 12:06,[NULL],INDEX,FAST FULL SCAN,:Q571309012,CALYPSO_DEV10,IDX_CMPP_TMP_GC1,[NULL],NON-UNIQUE,ANALYZED,[NULL],108,78,2,228,548749,4938741,PARALLEL_TO_PARALLEL,[NULL],[NULL],[NULL],"SELECT /*+ INDEX_RRS(A1 ""IDX_CMPP_TMP_GC1"") */ A1.""CIS_CODE"" C0 FROM ""CMPP_TMP_GRD_CPTY""  PX_GRANULE(0, BLOCK_RANGE, DYNAMIC) A1",HASH,[NULL],228,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,FULL,[NULL],CALYPSO_DEV10,CMPP_TMP_BADBOOKIDS,56,[NULL],ANALYZED,[NULL],109,77,2,2,2,10,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],"LNNVL(""CMPP_TMP_BADBOOKIDS"".""BOOK_ID""<>:B1)"
[NULL],13/06/2008 12:06,[NULL],FILTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],110,2,4,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]," NOT EXISTS (SELECT /*+ */ 0 FROM ""CMPP_TMP_BADBOOKIDS"" ""CMPP_TMP_BADBOOKIDS"" WHERE LNNVL(""CMPP_TMP_BADBOOKIDS"".""BOOK_ID""<>:B1))"
[NULL],13/06/2008 12:06,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],111,110,1,16,1,1024,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],16,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],112,111,1,14,1,998,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],14,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],113,112,1,12,1,972,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],12,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],114,113,1,10,1,946,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],10,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],115,114,1,8,1,920,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],8,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],NESTED LOOPS,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],116,115,1,6,1,911,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],6,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],117,116,1,4,1,889,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],4,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],NESTED LOOPS,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],118,117,1,3,1,884,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],3,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],119,118,1,1,1,853,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],FILTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],120,119,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"SYS_ALIAS_1.""REGION""=""P"".""REGION"" OR ""P"".""REGION"" IS NULL"
[NULL],13/06/2008 12:06,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],121,120,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],FILTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],122,121,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"R.""RATINGTYPE""='S & P' OR ""R"".""RATINGTYPE"" IS NULL"
[NULL],13/06/2008 12:06,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],123,122,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],124,123,1,1,1,440,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_POSN,58,[NULL],ANALYZED,[NULL],125,124,1,1,1,231,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_POSN3,[NULL],NON-UNIQUE,ANALYZED,1,126,125,1,1,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"SYS_ALIAS_1.""POSITIONTYPE""='T'",[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_POSN,60,[NULL],ANALYZED,[NULL],127,124,2,[NULL],1,209,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"SYS_ALIAS_1.""CALYPSOBOOKID""=""CMPP_TMP_POSN"".""CALYPSOBOOKID""(+) AND ""SYS_ALIAS_1"".""CALYPSOSECURITYNAME""=""CMPP_TMP_POSN"".""CALYPSOSECURITYNAME""(+) AND ""CMPP_TMP_POSN"".""POSITIONTYPE""(+)='S'"
[NULL],13/06/2008 12:06,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_POSN2,[NULL],NON-UNIQUE,ANALYZED,1,128,127,1,[NULL],1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""CMPP_TMP_POSN"".""CALYPSOSECURITYID""(+)",[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_RATE,67,[NULL],ANALYZED,[NULL],129,123,2,[NULL],1,39,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_RATE1,[NULL],NON-UNIQUE,ANALYZED,1,130,129,1,[NULL],1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""R"".""CALYPSOSECURITYID""(+)",[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_PRCE,66,[NULL],ANALYZED,[NULL],131,121,2,[NULL],1,29,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_PRCE1,[NULL],NON-UNIQUE,ANALYZED,1,132,131,1,[NULL],1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""P"".""ID""(+)",[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_INST,61,[NULL],ANALYZED,[NULL],133,119,2,[NULL],1,345,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_INST1,[NULL],NON-UNIQUE,ANALYZED,1,134,133,1,[NULL],1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""I"".""CALYPSOSECURITYID""(+)",[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_GRD_BOOK,63,[NULL],ANALYZED,[NULL],135,118,2,2,1,31,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_GBA1,[NULL],NON-UNIQUE,ANALYZED,1,136,135,1,1,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"SYS_ALIAS_1.""CALYPSOBOOKNAME""=""GB"".""SYS_BOOK_POSTFIX""",[NULL]
[NULL],13/06/2008 12:06,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_GO1,[NULL],NON-UNIQUE,ANALYZED,1,137,117,2,1,1,5,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"GB.""PARENT_ORGANISATION_ID""=""GO"".""ORGANISATION_ID""(+)",[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_GRDW_SDM,62,[NULL],ANALYZED,[NULL],138,116,2,2,1,22,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],"GS.""COST_CENTRE"" IS NOT NULL"
[NULL],13/06/2008 12:06,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_GS1,[NULL],NON-UNIQUE,ANALYZED,1,139,138,1,1,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"GB.""SYS_BOOK""=""GS"".""SRC_SYS_BOOK""",[NULL]
[NULL],13/06/2008 12:06,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_GC1,[NULL],NON-UNIQUE,ANALYZED,1,140,115,2,2,1,9,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],"I.""ISSUERCISCODE""=""GC"".""CIS_CODE""(+)",[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,PRODUCT_SEC_CODE,75,[NULL],ANALYZED,[NULL],141,114,2,2,1,26,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],INDEX,UNIQUE SCAN,[NULL],CALYPSO_DEV10,PK_PRODUCT_SEC_CODE,[NULL],UNIQUE,ANALYZED,2,142,141,1,1,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""SYS_ALIAS_0000"".""PRODUCT_ID""(+) AND ""SYS_ALIAS_0000"".""SEC_CODE""(+)='INDUSTRY_SECTOR'",[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,PRODUCT_SEC_CODE,73,[NULL],ANALYZED,[NULL],143,113,2,2,1,26,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],INDEX,UNIQUE SCAN,[NULL],CALYPSO_DEV10,PK_PRODUCT_SEC_CODE,[NULL],UNIQUE,ANALYZED,2,144,143,1,1,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""SYS_ALIAS_0001"".""PRODUCT_ID""(+) AND ""SYS_ALIAS_0001"".""SEC_CODE""(+)='Collateral_Type'",[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,PRODUCT_SEC_CODE,71,[NULL],ANALYZED,[NULL],145,112,2,2,1,26,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],INDEX,UNIQUE SCAN,[NULL],CALYPSO_DEV10,PK_PRODUCT_SEC_CODE,[NULL],UNIQUE,ANALYZED,2,146,145,1,1,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""SYS_ALIAS_0002"".""PRODUCT_ID""(+) AND ""SYS_ALIAS_0002"".""SEC_CODE""(+)='RTG_DBRS'",[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,PRODUCT_SEC_CODE,69,[NULL],ANALYZED,[NULL],147,111,2,2,1,26,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],INDEX,UNIQUE SCAN,[NULL],CALYPSO_DEV10,PK_PRODUCT_SEC_CODE,[NULL],UNIQUE,ANALYZED,2,148,147,1,1,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""C"".""PRODUCT_ID""(+) AND ""C"".""SEC_CODE""(+)='INDUSTRY_GROUP'",[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,FULL,[NULL],CALYPSO_DEV10,CMPP_TMP_BADBOOKIDS,76,[NULL],ANALYZED,[NULL],149,110,2,2,2,10,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],"LNNVL(""CMPP_TMP_BADBOOKIDS"".""BOOK_ID""<>:B1)"
[NULL],13/06/2008 12:06,[NULL],SELECT STATEMENT,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],CHOOSE,[NULL],0,[NULL],12797,12797,2210,1739272,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],5867,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],SORT,UNIQUE,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,0,1,12797,2210,1739272,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],5867,3655000,[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],UNION-ALL,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,1,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],FILTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],3,2,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]," NOT EXISTS (SELECT /*+ */ 0 FROM ""CMPP_TMP_BADBOOKIDS"" ""CMPP_TMP_BADBOOKIDS"" WHERE LNNVL(""CMPP_TMP_BADBOOKIDS"".""BOOK_ID""<>:B1))"
[NULL],13/06/2008 12:06,[NULL],HASH JOIN,OUTER,:Q571310011,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],4,3,1,3888,932,730688,PARALLEL_TO_SERIAL,[NULL],[NULL],[NULL],"SELECT /*+ ORDERED NO_EXPAND USE_HASH(A2) */ A1.C0,A2.C0,A1.C1,A1.C2,A1.C3,A1.C4,A1.C5,A1.C6,A1.C7,A1.C8,A1.C9,A1.C10,A1.C11,A1.C12,A1.C13,A1.C14,A1.C15,A1.C16,A1.C17,A1.C18,A1.C19,A1.C20,A1.C21,A1.C22,A1.C23,A1.C24,A1.C25,A1.C26,A1.C27,A1.C28,A1.C29,A1.C30,A1.C31,A1.C32,A1.C33,A1.C34,A1.C35,A1.C36,A1.C37,A1.C38,A1.C39,A1.C40,A1.C41,A1.C42,A1.C43,A1.C44,A1.C45,A1.C46,A1.C47,A1.C48,A1.C49,A1.C50,A1.C51,A1.C52,A1.C53,A1.C54,A1.C55,A1.C56,A1.C57,A1.C58,A1.C59,A1.C60,A1.C61,A1.C62,A1.C63,A1.C64,A1.C65,A2.C1,A2.C2 FROM (SELECT /*+ ORDERED NO_EXPAND USE_HASH(A4) */ A3.C0 C0,A4.C2 C1,A4.C0 C2,A3.C1 C3,A3.C2 C4,A3.C3 C5,A3.C4 C6,A3.C5 C7,A3.C6 C8,A3.C7 C9,A3.C8 C10,A3.C9 C11,A3.C10 C12,A3.C11 C13,A3.C12 C14,A3.C13 C15,A3.C14 C16,A3.C15 C17,A3.C16 C18,A3.C17 C19,A3.C18 C20,A3.C19 C21,A3.C20 C22,A3.C21 C23,A3.C22 C24,A3.C23 C25,A3.C24 C26,A3.C25 C27,A3.C26 C28,A3.C27 C29,A3.C28 C30,A3.C29 C31,A3.C30 C32,A3.C31 C33,A3.C32 C34,A3.C33 C35,A3.C34 C36,A3.C35 C37,A3.C36 C38,A3.C37 C39,A3.C38 C40,A3.C39 C41,A3.C40 C42,A3.C41 C43,A3.C42 C44,A3.C43 C45,A3.C44 C46,A3.C45 C47,A3.C46 C48,A3.C47 C49,A3.C48 C50,A3.C49 C51,A3.C50 C52,A3.C51 C53,A3.C52 C54,A3.C53 C55,A3.C54 C56,A3.C55 C57,A3.C56 C58,A3.C57 C59,A3.C58 C60,A3.C59 C61,A3.C60 C62,A3.C61 C63,A3.C62 C64,A4.C1 C65 FROM (SELECT /*+ ORDERED NO_EXPAND USE_HASH(A6) */ A5.C0 C0,A6.C2 C1,A6.C0 C2,A5.C1 C3,A5.C2 C4,A5.C3 C5,A5.C4 C6,A5.C5 C7,A5.C6 C8,A5.C7 C9,A5.C8 C10,A5.C9 C11,A5.C10 C12,A5.C11 C13,A5.C12 C14,A5.C13 C15,A5.C14 C16,A5.C15 C17,A5.C16 C18,A5.C17 C19,A5.C18 C20,A5.C19 C21,A5.C20 C22,A5.C21 C23,A5.C22 C24,A5.C23 C25,A5.C24 C26,A5.C25 C27,A5.C26 C28,A5.C27 C29,A5.C28 C30,A5.C29 C31,A5.C30 C32,A5.C31 C33,A5.C32 C34,A5.C33 C35,A5.C34 C36,A5.C35 C37,A5.C36 C38,A5.C37 C39,A5.C38 C40,A5.C39 C41,A5.C40 C42,A5.C41 C43,A5.C42 C44,A5.C43 C45,A5.C44 C46,A5.C45 C47,A5.C46 C48,A5.C47 C49,A5.C48 C50,A5.C49 C51,A5.C50 C52,A5.C51 C53,A5.C52 C54,A5.C53 C55,A5.C54 C56,A5.C55 C57,A5.C56 C58,A5.C57 C59,A5.C58 C60,A5.C59 C61,A6.C1 C62 FROM (SELECT /*+ ORDERED NO_EXPAND USE_HASH(A8) */ A7.C0 C0,A8.C2 C1,A8.C0 C2,A7.C1 C3,A7.C2 C4,A7.C3 C5,A7.C4 C6,A7.C5 C7,A7.C6 C8,A7.C7 C9,A7.C8 C10,A7.C9 C11,A7.C10 C12,A7.C11 C13,A7.C12 C14,A7.C13 C15,A7.C14 C16,A7.C15 C17,A7.C16 C18,A7.C17 C19,A7.C18 C20,A7.C19 C21,A7.C20 C22,A7.C21 C23,A7.C22 C24,A7.C23 C25,A7.C24 C26,A7.C25 C27,A7.C26 C28,A7.C27 C29,A7.C28 C30,A7.C29 C31,A7.C30 C32,A7.C31 C33,A7.C32 C34,A7.C33 C35,A7.C34 C36,A7.C35 C37,A7.C36 C38,A7.C37 C39,A7.C38 C40,A7.C39 C41,A7.C40 C42,A7.C41 C43,A7.C42 C44,A7.C43 C45,A7.C44 C46,A7.C45 C47,A7.C46 C48,A7.C47 C49,A7.C48 C50,A7.C49 C51,A7.C50 C52,A7.C51 C53,A7.C52 C54,A7.C53 C55,A7.C54 C56,A7.C55 C57,A7.C56 C58,A8.C1 C59 FROM :Q571310010 A7,:Q571310002 A8 WHERE A7.C0=A8.C0(+)) A5,:Q571310003 A6 WHERE A5.C0=A6.C0(+)) A3,:Q571310004 A4 WHERE A3.C0=A4.C0(+)) A1,:Q571310005 A2 WHERE A1.C0=A2.C0(+)",QC (RANDOM),[NULL],3888,[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""SYS_ALIAS_0000"".""PRODUCT_ID""(+)",[NULL]
[NULL],13/06/2008 12:06,[NULL],HASH JOIN,OUTER,:Q571310011,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],5,4,1,3056,932,706456,PARALLEL_COMBINED_WITH_PARENT,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],3056,[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""SYS_ALIAS_0001"".""PRODUCT_ID""(+)",[NULL]
[NULL],13/06/2008 12:06,[NULL],HASH JOIN,OUTER,:Q571310011,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],6,5,1,2224,932,682224,PARALLEL_COMBINED_WITH_PARENT,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2224,[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""SYS_ALIAS_0002"".""PRODUCT_ID""(+)",[NULL]
[NULL],13/06/2008 12:06,[NULL],HASH JOIN,OUTER,:Q571310011,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],7,6,1,1392,932,657992,PARALLEL_COMBINED_WITH_PARENT,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1392,[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""C"".""PRODUCT_ID""(+)",[NULL]
[NULL],13/06/2008 12:06,[NULL],HASH JOIN,OUTER,:Q571310010,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],8,7,1,560,932,633760,PARALLEL_TO_PARALLEL,[NULL],[NULL],[NULL],"SELECT /*+ ORDERED NO_EXPAND USE_HASH(A2) */ A1.C18 C0,A1.C1 C1,A1.C2 C2,A1.C3 C3,A1.C4 C4,A1.C5 C5,A1.C6 C6,A1.C7 C7,A1.C8 C8,A1.C9 C9,A1.C10 C10,A1.C11 C11,A1.C12 C12,A1.C13 C13,A1.C14 C14,A1.C15 C15,A1.C16 C16,A1.C17 C17,A1.C57 C18,A1.C19 C19,A1.C20 C20,A1.C21 C21,A1.C22 C22,A1.C23 C23,A1.C24 C24,A1.C25 C25,A1.C26 C26,A1.C27 C27,A1.C28 C28,A1.C29 C29,A1.C30 C30,A1.C31 C31,A1.C32 C32,A1.C33 C33,A1.C34 C34,A1.C35 C35,A1.C36 C36,A1.C37 C37,A1.C38 C38,A1.C39 C39,A1.C40 C40,A1.C41 C41,A1.C42 C42,A1.C43 C43,A1.C44 C44,A1.C45 C45,A1.C46 C46,A1.C47 C47,A1.C48 C48,A1.C49 C49,A1.C50 C50,A1.C51 C51,A1.C52 C52,A1.C53 C53,A1.C54 C54,A1.C55 C55,A1.C56 C56 FROM :Q571310008 A1,:Q571310009 A2 WHERE A1.C0=A2.C0(+)",HASH,[NULL],560,[NULL],"SYS_ALIAS_1.""COUNTERPARTYCISID""=""GC"".""CIS_CODE""(+)",[NULL]
[NULL],13/06/2008 12:06,[NULL],HASH JOIN,[NULL],:Q571310008,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],9,8,1,332,932,625372,PARALLEL_TO_PARALLEL,[NULL],[NULL],[NULL],"SELECT /*+ ORDERED NO_EXPAND USE_HASH(A2) SWAP_JOIN_INPUTS(A2) */ A1.C12 C0,A1.C1 C1,A1.C2 C2,A1.C3 C3,A1.C4 C4,A1.C5 C5,A1.C6 C6,A1.C7 C7,A1.C8 C8,A1.C9 C9,A1.C10 C10,A1.C11 C11,A1.C58 C12,A1.C13 C13,A1.C14 C14,A1.C15 C15,A1.C16 C16,A1.C17 C17,A1.C18 C18,A1.C19 C19,A1.C20 C20,A1.C21 C21,A1.C22 C22,A1.C23 C23,A1.C24 C24,A1.C25 C25,A1.C26 C26,A1.C27 C27,A1.C28 C28,A1.C29 C29,A1.C30 C30,A1.C31 C31,A1.C32 C32,A1.C33 C33,A1.C34 C34,A1.C35 C35,A1.C36 C36,A1.C37 C37,A1.C38 C38,A1.C39 C39,A1.C40 C40,A1.C41 C41,A1.C42 C42,A1.C43 C43,A1.C44 C44,A1.C45 C45,A1.C46 C46,A1.C47 C47,A1.C48 C48,A1.C49 C49,A1.C50 C50,A1.C51 C51,A1.C52 C52,A1.C53 C53,A1.C54 C54,A1.C55 C55,A1.C56 C56,A1.C57 C57 FROM :Q571310007 A1,:Q571310001 A2 WHERE A1.C0=A2.C0",HASH,[NULL],332,[NULL],"GB.""SYS_BOOK""=""GS"".""SRC_SYS_BOOK""",[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,FULL,:Q571310001,CALYPSO_DEV10,CMPP_TMP_GRDW_SDM,3,[NULL],ANALYZED,[NULL],10,9,1,15,15513,341286,PARALLEL_FROM_SERIAL,[NULL],[NULL],[NULL],[NULL],HASH,[NULL],15,[NULL],[NULL],"GS.""COST_CENTRE"" IS NOT NULL"
[NULL],13/06/2008 12:06,[NULL],HASH JOIN,OUTER,:Q571310007,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],11,9,2,317,932,604868,PARALLEL_TO_PARALLEL,[NULL],[NULL],[NULL],"SELECT /*+ ORDERED NO_EXPAND USE_HASH(A2) */ A1.C2 C0,A1.C1 C1,A1.C59 C2,A1.C3 C3,A1.C4 C4,A1.C5 C5,A1.C6 C6,A1.C7 C7,A1.C8 C8,A1.C9 C9,A1.C10 C10,A1.C11 C11,A1.C12 C12,A1.C13 C13,A1.C14 C14,A1.C15 C15,A1.C16 C16,A1.C17 C17,A1.C18 C18,A1.C19 C19,A1.C20 C20,A1.C21 C21,A1.C22 C22,A1.C23 C23,A1.C24 C24,A1.C25 C25,A1.C26 C26,A1.C27 C27,A1.C28 C28,A1.C29 C29,A1.C30 C30,A1.C31 C31,A1.C32 C32,A1.C33 C33,A1.C34 C34,A1.C35 C35,A1.C36 C36,A1.C37 C37,A1.C38 C38,A1.C39 C39,A1.C40 C40,A1.C41 C41,A1.C42 C42,A1.C43 C43,A1.C44 C44,A1.C45 C45,A1.C46 C46,A1.C47 C47,A1.C48 C48,A1.C49 C49,A1.C50 C50,A1.C51 C51,A1.C52 C52,A1.C53 C53,A1.C54 C54,A1.C55 C55,A1.C56 C56,A1.C57 C57,A1.C58 C58 FROM :Q571310000 A1,:Q571310006 A2 WHERE A1.C0=A2.C0(+)",HASH,[NULL],317,[NULL],"GB.""PARENT_ORGANISATION_ID""=""GO"".""ORGANISATION_ID""(+)",[NULL]
[NULL],13/06/2008 12:06,[NULL],HASH JOIN,[NULL],:Q571310000,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],12,11,1,314,932,600208,PARALLEL_FROM_SERIAL,[NULL],[NULL],[NULL],[NULL],HASH,[NULL],314,[NULL],"SYS_ALIAS_1.""CALYPSOBOOKNAME""=""GB"".""SYS_BOOK_POSTFIX""",[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,FULL,[NULL],CALYPSO_DEV10,CMPP_TMP_GRD_BOOK,4,[NULL],ANALYZED,[NULL],13,12,1,5,1372,42532,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],5,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],14,12,2,306,931,570703,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],306,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],FILTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],15,14,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"SYS_ALIAS_1.""REGION""=""P"".""REGION"" OR ""P"".""REGION"" IS NULL"
[NULL],13/06/2008 12:06,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],16,15,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],FILTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],17,16,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"R.""RATINGTYPE""='S & P' OR ""R"".""RATINGTYPE"" IS NULL"
[NULL],13/06/2008 12:06,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],18,17,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],19,18,1,306,931,457121,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],306,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,FULL,[NULL],CALYPSO_DEV10,CMPP_TMP_DEAL,1,[NULL],ANALYZED,[NULL],20,19,1,306,931,135926,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],306,[NULL],[NULL],"SYS_ALIAS_1.""FLATFILERECORDTYPE""='Collateral Movement' OR ""SYS_ALIAS_1"".""FLATFILERECORDTYPE""='Loan/Depo' OR ""SYS_ALIAS_1"".""FLATFILERECORDTYPE""='Security'"
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_INST,2,[NULL],ANALYZED,[NULL],21,19,2,[NULL],1,345,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_INST1,[NULL],NON-UNIQUE,ANALYZED,1,22,21,1,[NULL],1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""I"".""CALYPSOSECURITYID""(+)",[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_RATE,7,[NULL],ANALYZED,[NULL],23,18,2,[NULL],1,39,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_RATE1,[NULL],NON-UNIQUE,ANALYZED,1,24,23,1,[NULL],1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""R"".""CALYPSOSECURITYID""(+)",[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_PRCE,8,[NULL],ANALYZED,[NULL],25,16,2,[NULL],1,29,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_PRCE1,[NULL],NON-UNIQUE,ANALYZED,1,26,25,1,[NULL],1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""P"".""ID""(+)",[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_POSN,10,[NULL],ANALYZED,[NULL],27,14,2,[NULL],1,54,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"SYS_ALIAS_1.""CALYPSOBOOKID""=""CMPP_TMP_POSN"".""CALYPSOBOOKID""(+) AND ""CMPP_TMP_POSN"".""POSITIONTYPE""(+)='T' AND ""CMPP_TMP_POSN"".""POSITION""(+)<>0"
[NULL],13/06/2008 12:06,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_POSN2,[NULL],NON-UNIQUE,ANALYZED,1,28,27,1,[NULL],1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""CMPP_TMP_POSN"".""CALYPSOSECURITYID""(+)",[NULL]
[NULL],13/06/2008 12:06,[NULL],INDEX,FAST FULL SCAN,:Q571310006,CALYPSO_DEV10,IDX_CMPP_TMP_GO1,[NULL],NON-UNIQUE,ANALYZED,[NULL],29,11,2,3,3230,16150,PARALLEL_TO_PARALLEL,[NULL],[NULL],[NULL],"SELECT /*+ INDEX_RRS(A1 ""IDX_CMPP_TMP_GO1"") */ A1.""ORGANISATION_ID"" C0 FROM ""CMPP_TMP_GRD_ORGN""  PX_GRANULE(0, BLOCK_RANGE, DYNAMIC) A1",HASH,[NULL],3,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],INDEX,FAST FULL SCAN,:Q571310009,CALYPSO_DEV10,IDX_CMPP_TMP_GC1,[NULL],NON-UNIQUE,ANALYZED,[NULL],30,8,2,228,548749,4938741,PARALLEL_TO_PARALLEL,[NULL],[NULL],[NULL],"SELECT /*+ INDEX_RRS(A1 ""IDX_CMPP_TMP_GC1"") */ A1.""CIS_CODE"" C0 FROM ""CMPP_TMP_GRD_CPTY""  PX_GRANULE(0, BLOCK_RANGE, DYNAMIC) A1",HASH,[NULL],228,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,FULL,:Q571310002,CALYPSO_DEV10,PRODUCT_SEC_CODE,12,[NULL],ANALYZED,[NULL],31,7,2,832,24386,634036,PARALLEL_FROM_SERIAL,[NULL],[NULL],[NULL],[NULL],HASH,[NULL],832,[NULL],[NULL],"C.""SEC_CODE""(+)='INDUSTRY_GROUP'"
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,FULL,:Q571310003,CALYPSO_DEV10,PRODUCT_SEC_CODE,14,[NULL],ANALYZED,[NULL],32,6,2,832,24386,634036,PARALLEL_FROM_SERIAL,[NULL],[NULL],[NULL],[NULL],HASH,[NULL],832,[NULL],[NULL],"SYS_ALIAS_0002.""SEC_CODE""(+)='RTG_DBRS'"
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,FULL,:Q571310004,CALYPSO_DEV10,PRODUCT_SEC_CODE,16,[NULL],ANALYZED,[NULL],33,5,2,832,24386,634036,PARALLEL_FROM_SERIAL,[NULL],[NULL],[NULL],[NULL],HASH,[NULL],832,[NULL],[NULL],"SYS_ALIAS_0001.""SEC_CODE""(+)='Collateral_Type'"
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,FULL,:Q571310005,CALYPSO_DEV10,PRODUCT_SEC_CODE,18,[NULL],ANALYZED,[NULL],34,4,2,832,24386,634036,PARALLEL_FROM_SERIAL,[NULL],[NULL],[NULL],[NULL],HASH,[NULL],832,[NULL],[NULL],"SYS_ALIAS_0000.""SEC_CODE""(+)='INDUSTRY_SECTOR'"
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,FULL,[NULL],CALYPSO_DEV10,CMPP_TMP_BADBOOKIDS,19,[NULL],ANALYZED,[NULL],35,3,2,2,2,10,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],"LNNVL(""CMPP_TMP_BADBOOKIDS"".""BOOK_ID""<>:B1)"
[NULL],13/06/2008 12:06,[NULL],FILTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],36,2,2,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]," NOT EXISTS (SELECT /*+ */ 0 FROM ""CMPP_TMP_BADBOOKIDS"" ""CMPP_TMP_BADBOOKIDS"" WHERE LNNVL(""CMPP_TMP_BADBOOKIDS"".""BOOK_ID""<>:B1))"
[NULL],13/06/2008 12:06,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],37,36,1,31,1,796,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],31,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],38,37,1,29,1,770,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],29,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],39,38,1,27,1,744,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],27,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],40,39,1,25,1,718,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],25,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],41,40,1,23,1,692,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],23,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],42,41,1,21,1,683,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],21,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],NESTED LOOPS,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],43,42,1,19,1,674,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],19,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],44,43,1,17,1,652,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],17,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],NESTED LOOPS,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],45,44,1,16,1,647,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],16,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],NESTED LOOPS,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],46,45,1,14,1,616,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],14,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],FILTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],47,46,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"R.""RATINGTYPE""='S & P' OR ""R"".""RATINGTYPE"" IS NULL"
[NULL],13/06/2008 12:06,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],48,47,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],FILTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],49,48,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"DC.""REGION""=""P"".""REGION"" OR ""P"".""REGION"" IS NULL"
[NULL],13/06/2008 12:06,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],50,49,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],NESTED LOOPS,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],51,50,1,12,1,406,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],12,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,FULL,[NULL],CALYPSO_DEV10,CMPP_TMP_INST,22,[NULL],ANALYZED,[NULL],52,51,1,2,1,345,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_DEAL_COLL,21,[NULL],ANALYZED,[NULL],53,51,2,10,9,549,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],10,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_DEAL_COLL2,[NULL],NON-UNIQUE,ANALYZED,1,54,53,1,1,9,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"DC.""CALYPSOSECURITYID""=""I"".""CALYPSOSECURITYID""",[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_PRCE,29,[NULL],ANALYZED,[NULL],55,50,2,[NULL],1,29,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_PRCE1,[NULL],NON-UNIQUE,ANALYZED,1,56,55,1,[NULL],1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"DC.""CALYPSOSECURITYID""=""P"".""ID""(+)",[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_RATE,28,[NULL],ANALYZED,[NULL],57,48,2,[NULL],1,39,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_RATE1,[NULL],NON-UNIQUE,ANALYZED,1,58,57,1,[NULL],1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"DC.""CALYPSOSECURITYID""=""R"".""CALYPSOSECURITYID""(+)",[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_DEAL,20,[NULL],ANALYZED,[NULL],59,46,2,2,1,142,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],"SYS_ALIAS_1.""FLATFILERECORDTYPE""='Repo Loan' OR ""SYS_ALIAS_1"".""FLATFILERECORDTYPE""='Security Loan'"
[NULL],13/06/2008 12:06,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_DEAL0B,[NULL],NON-UNIQUE,ANALYZED,1,60,59,1,1,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"SYS_ALIAS_1.""CALYPSOTRADEID""=""DC"".""CALYPSOTRADEID""",[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_GRD_BOOK,24,[NULL],ANALYZED,[NULL],61,45,2,2,1,31,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:06,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_GBA1,[NULL],NON-UNIQUE,ANALYZED,1,62,61,1,1,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"SYS_ALIAS_1.""CALYPSOBOOKNAME""=""GB"".""SYS_BOOK_POSTFIX""",[NULL]
[NULL],13/06/2008 12:06,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_GO1,[NULL],NON-UNIQUE,ANALYZED,1,63,44,2,1,1,5,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"GB.""PARENT_ORGANISATION_ID""=""GO"".""ORGANISATION_ID""(+)",[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_GRDW_SDM,23,[NULL],ANALYZED,[NULL],64,43,2,2,1,22,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],"GS.""COST_CENTRE"" IS NOT NULL"
[NULL],13/06/2008 12:06,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_GS1,[NULL],NON-UNIQUE,ANALYZED,1,65,64,1,1,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"GB.""SYS_BOOK""=""GS"".""SRC_SYS_BOOK""",[NULL]
[NULL],13/06/2008 12:06,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_GC1,[NULL],NON-UNIQUE,ANALYZED,1,66,42,2,2,1,9,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],"I.""ISSUERCISCODE""=""I_GC"".""CIS_CODE""(+)",[NULL]
[NULL],13/06/2008 12:06,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_GC1,[NULL],NON-UNIQUE,ANALYZED,1,67,41,2,2,1,9,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],"SYS_ALIAS_1.""COUNTERPARTYCISID""=""D_GC"".""CIS_CODE""(+)",[NULL]
[NULL],13/06/2008 12:06,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,PRODUCT_SEC_CODE,37,[NULL],ANALYZED,[NULL],68,40,2,2,1,26,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],[NULL]


UNION ALL
=========

STATEMENT_ID,TIMESTAMP,REMARKS,OPERATION,OPTIONS,OBJECT_NODE,OBJECT_OWNER,OBJECT_NAME,OBJECT_INSTANCE,OBJECT_TYPE,OPTIMIZER,SEARCH_COLUMNS,ID,PARENT_ID,POSITION,COST,CARDINALITY,BYTES,OTHER_TAG,PARTITION_START,PARTITION_STOP,PARTITION_ID,OTHER,DISTRIBUTION,CPU_COST,IO_COST,TEMP_SPACE,ACCESS_PREDICATES,FILTER_PREDICATES
[NULL],13/06/2008 12:10,[NULL],INDEX,FAST FULL SCAN,:Q571311012,CALYPSO_DEV10,IDX_CMPP_TMP_GC1,[NULL],NON-UNIQUE,ANALYZED,[NULL],107,77,2,228,548749,4938741,PARALLEL_TO_PARALLEL,[NULL],[NULL],[NULL],"SELECT /*+ INDEX_RRS(A1 ""IDX_CMPP_TMP_GC1"") */ A1.""CIS_CODE"" C0 FROM ""CMPP_TMP_GRD_CPTY""  PX_GRANULE(0, BLOCK_RANGE, DYNAMIC) A1",HASH,[NULL],228,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,FULL,[NULL],CALYPSO_DEV10,CMPP_TMP_BADBOOKIDS,56,[NULL],ANALYZED,[NULL],108,76,2,2,2,10,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],"LNNVL(""CMPP_TMP_BADBOOKIDS"".""BOOK_ID""<>:B1)"
[NULL],13/06/2008 12:10,[NULL],FILTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],109,1,4,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]," NOT EXISTS (SELECT /*+ */ 0 FROM ""CMPP_TMP_BADBOOKIDS"" ""CMPP_TMP_BADBOOKIDS"" WHERE LNNVL(""CMPP_TMP_BADBOOKIDS"".""BOOK_ID""<>:B1))"
[NULL],13/06/2008 12:10,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],110,109,1,16,1,1024,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],16,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],111,110,1,14,1,998,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],14,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],112,111,1,12,1,972,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],12,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],113,112,1,10,1,946,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],10,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],114,113,1,8,1,920,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],8,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],NESTED LOOPS,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],115,114,1,6,1,911,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],6,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],116,115,1,4,1,889,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],4,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],NESTED LOOPS,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],117,116,1,3,1,884,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],3,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],118,117,1,1,1,853,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],FILTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],119,118,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"SYS_ALIAS_1.""REGION""=""P"".""REGION"" OR ""P"".""REGION"" IS NULL"
[NULL],13/06/2008 12:10,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],120,119,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],FILTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],121,120,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"R.""RATINGTYPE""='S & P' OR ""R"".""RATINGTYPE"" IS NULL"
[NULL],13/06/2008 12:10,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],122,121,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],123,122,1,1,1,440,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_POSN,58,[NULL],ANALYZED,[NULL],124,123,1,1,1,231,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_POSN3,[NULL],NON-UNIQUE,ANALYZED,1,125,124,1,1,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"SYS_ALIAS_1.""POSITIONTYPE""='T'",[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_POSN,60,[NULL],ANALYZED,[NULL],126,123,2,[NULL],1,209,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"SYS_ALIAS_1.""CALYPSOBOOKID""=""CMPP_TMP_POSN"".""CALYPSOBOOKID""(+) AND ""SYS_ALIAS_1"".""CALYPSOSECURITYNAME""=""CMPP_TMP_POSN"".""CALYPSOSECURITYNAME""(+) AND ""CMPP_TMP_POSN"".""POSITIONTYPE""(+)='S'"
[NULL],13/06/2008 12:10,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_POSN2,[NULL],NON-UNIQUE,ANALYZED,1,127,126,1,[NULL],1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""CMPP_TMP_POSN"".""CALYPSOSECURITYID""(+)",[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_RATE,67,[NULL],ANALYZED,[NULL],128,122,2,[NULL],1,39,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_RATE1,[NULL],NON-UNIQUE,ANALYZED,1,129,128,1,[NULL],1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""R"".""CALYPSOSECURITYID""(+)",[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_PRCE,66,[NULL],ANALYZED,[NULL],130,120,2,[NULL],1,29,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_PRCE1,[NULL],NON-UNIQUE,ANALYZED,1,131,130,1,[NULL],1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""P"".""ID""(+)",[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_INST,61,[NULL],ANALYZED,[NULL],132,118,2,[NULL],1,345,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_INST1,[NULL],NON-UNIQUE,ANALYZED,1,133,132,1,[NULL],1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""I"".""CALYPSOSECURITYID""(+)",[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_GRD_BOOK,63,[NULL],ANALYZED,[NULL],134,117,2,2,1,31,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_GBA1,[NULL],NON-UNIQUE,ANALYZED,1,135,134,1,1,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"SYS_ALIAS_1.""CALYPSOBOOKNAME""=""GB"".""SYS_BOOK_POSTFIX""",[NULL]
[NULL],13/06/2008 12:10,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_GO1,[NULL],NON-UNIQUE,ANALYZED,1,136,116,2,1,1,5,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"GB.""PARENT_ORGANISATION_ID""=""GO"".""ORGANISATION_ID""(+)",[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_GRDW_SDM,62,[NULL],ANALYZED,[NULL],137,115,2,2,1,22,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],"GS.""COST_CENTRE"" IS NOT NULL"
[NULL],13/06/2008 12:10,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_GS1,[NULL],NON-UNIQUE,ANALYZED,1,138,137,1,1,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"GB.""SYS_BOOK""=""GS"".""SRC_SYS_BOOK""",[NULL]
[NULL],13/06/2008 12:10,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_GC1,[NULL],NON-UNIQUE,ANALYZED,1,139,114,2,2,1,9,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],"I.""ISSUERCISCODE""=""GC"".""CIS_CODE""(+)",[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,PRODUCT_SEC_CODE,75,[NULL],ANALYZED,[NULL],140,113,2,2,1,26,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],INDEX,UNIQUE SCAN,[NULL],CALYPSO_DEV10,PK_PRODUCT_SEC_CODE,[NULL],UNIQUE,ANALYZED,2,141,140,1,1,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""SYS_ALIAS_0000"".""PRODUCT_ID""(+) AND ""SYS_ALIAS_0000"".""SEC_CODE""(+)='INDUSTRY_SECTOR'",[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,PRODUCT_SEC_CODE,73,[NULL],ANALYZED,[NULL],142,112,2,2,1,26,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],INDEX,UNIQUE SCAN,[NULL],CALYPSO_DEV10,PK_PRODUCT_SEC_CODE,[NULL],UNIQUE,ANALYZED,2,143,142,1,1,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""SYS_ALIAS_0001"".""PRODUCT_ID""(+) AND ""SYS_ALIAS_0001"".""SEC_CODE""(+)='Collateral_Type'",[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,PRODUCT_SEC_CODE,71,[NULL],ANALYZED,[NULL],144,111,2,2,1,26,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],INDEX,UNIQUE SCAN,[NULL],CALYPSO_DEV10,PK_PRODUCT_SEC_CODE,[NULL],UNIQUE,ANALYZED,2,145,144,1,1,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""SYS_ALIAS_0002"".""PRODUCT_ID""(+) AND ""SYS_ALIAS_0002"".""SEC_CODE""(+)='RTG_DBRS'",[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,PRODUCT_SEC_CODE,69,[NULL],ANALYZED,[NULL],146,110,2,2,1,26,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],INDEX,UNIQUE SCAN,[NULL],CALYPSO_DEV10,PK_PRODUCT_SEC_CODE,[NULL],UNIQUE,ANALYZED,2,147,146,1,1,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""C"".""PRODUCT_ID""(+) AND ""C"".""SEC_CODE""(+)='INDUSTRY_GROUP'",[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,FULL,[NULL],CALYPSO_DEV10,CMPP_TMP_BADBOOKIDS,76,[NULL],ANALYZED,[NULL],148,109,2,2,2,10,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],"LNNVL(""CMPP_TMP_BADBOOKIDS"".""BOOK_ID""<>:B1)"
[NULL],13/06/2008 12:10,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_GS1,[NULL],NON-UNIQUE,ANALYZED,1,64,63,1,1,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"GB.""SYS_BOOK""=""GS"".""SRC_SYS_BOOK""",[NULL]
[NULL],13/06/2008 12:10,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_GC1,[NULL],NON-UNIQUE,ANALYZED,1,65,41,2,2,1,9,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],"I.""ISSUERCISCODE""=""I_GC"".""CIS_CODE""(+)",[NULL]
[NULL],13/06/2008 12:10,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_GC1,[NULL],NON-UNIQUE,ANALYZED,1,66,40,2,2,1,9,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],"SYS_ALIAS_1.""COUNTERPARTYCISID""=""D_GC"".""CIS_CODE""(+)",[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,PRODUCT_SEC_CODE,37,[NULL],ANALYZED,[NULL],67,39,2,2,1,26,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],INDEX,UNIQUE SCAN,[NULL],CALYPSO_DEV10,PK_PRODUCT_SEC_CODE,[NULL],UNIQUE,ANALYZED,2,68,67,1,1,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"DC.""CALYPSOSECURITYID""=""SYS_ALIAS_0000"".""PRODUCT_ID""(+) AND ""SYS_ALIAS_0000"".""SEC_CODE""(+)='INDUSTRY_SECTOR'",[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,PRODUCT_SEC_CODE,35,[NULL],ANALYZED,[NULL],69,38,2,2,1,26,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],INDEX,UNIQUE SCAN,[NULL],CALYPSO_DEV10,PK_PRODUCT_SEC_CODE,[NULL],UNIQUE,ANALYZED,2,70,69,1,1,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"DC.""CALYPSOSECURITYID""=""SYS_ALIAS_0001"".""PRODUCT_ID""(+) AND ""SYS_ALIAS_0001"".""SEC_CODE""(+)='Collateral_Type'",[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,PRODUCT_SEC_CODE,33,[NULL],ANALYZED,[NULL],71,37,2,2,1,26,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],INDEX,UNIQUE SCAN,[NULL],CALYPSO_DEV10,PK_PRODUCT_SEC_CODE,[NULL],UNIQUE,ANALYZED,2,72,71,1,1,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"DC.""CALYPSOSECURITYID""=""SYS_ALIAS_0002"".""PRODUCT_ID""(+) AND ""SYS_ALIAS_0002"".""SEC_CODE""(+)='RTG_DBRS'",[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,PRODUCT_SEC_CODE,31,[NULL],ANALYZED,[NULL],73,36,2,2,1,26,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],INDEX,UNIQUE SCAN,[NULL],CALYPSO_DEV10,PK_PRODUCT_SEC_CODE,[NULL],UNIQUE,ANALYZED,2,74,73,1,1,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"DC.""CALYPSOSECURITYID""=""C"".""PRODUCT_ID""(+) AND ""C"".""SEC_CODE""(+)='INDUSTRY_GROUP'",[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,FULL,[NULL],CALYPSO_DEV10,CMPP_TMP_BADBOOKIDS,38,[NULL],ANALYZED,[NULL],75,35,2,2,2,10,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],"LNNVL(""CMPP_TMP_BADBOOKIDS"".""BOOK_ID""<>:B1)"
[NULL],13/06/2008 12:10,[NULL],FILTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],76,1,3,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]," NOT EXISTS (SELECT /*+ */ 0 FROM ""CMPP_TMP_BADBOOKIDS"" ""CMPP_TMP_BADBOOKIDS"" WHERE LNNVL(""CMPP_TMP_BADBOOKIDS"".""BOOK_ID""<>:B1))"
[NULL],13/06/2008 12:10,[NULL],HASH JOIN,OUTER,:Q571311013,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],77,76,1,4165,1276,1006764,PARALLEL_TO_SERIAL,[NULL],[NULL],[NULL],"SELECT /*+ ORDERED NO_EXPAND USE_HASH(A2) */ A1.C1,A1.C2,A1.C3,A1.C4,A1.C5,A1.C6,A1.C7,A1.C8,A1.C9,A1.C10,A1.C11,A1.C12,A1.C13,A1.C14,A1.C15,A1.C16,A1.C17,A1.C18,A1.C19,A1.C20,A1.C21,A1.C22,A1.C23,A1.C24,A1.C25,A1.C26,A1.C27,A1.C28,A1.C29,A1.C30,A1.C31,A1.C32,A1.C33,A1.C34,A1.C35,A1.C36,A1.C37,A1.C38,A1.C39,A1.C40,A1.C41,A1.C42,A1.C43,A1.C44,A1.C45,A1.C46,A1.C47,A1.C48,A1.C49,A1.C50,A1.C51,A1.C52,A1.C53,A1.C54,A1.C55,A1.C56,A1.C57,A1.C58,A1.C59,A1.C60,A1.C61,A1.C62,A1.C63,A1.C64,A1.C65,A1.C66 FROM :Q571311011 A1,:Q571311012 A2 WHERE A1.C0=A2.C0(+)",QC (RANDOM),[NULL],4165,[NULL],"SYS_ALIAS_1.""COUNTERPARTYCISID""=""GC"".""CIS_CODE""(+)",[NULL]
[NULL],13/06/2008 12:10,[NULL],HASH JOIN,OUTER,:Q571311011,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],78,77,1,3937,1276,995280,PARALLEL_TO_PARALLEL,[NULL],[NULL],[NULL],"SELECT /*+ ORDERED NO_EXPAND USE_HASH(A2) */ A1.C19 C0,A1.C0 C1,A2.C0 C2,A1.C1 C3,A1.C2 C4,A1.C3 C5,A1.C4 C6,A1.C5 C7,A1.C6 C8,A1.C7 C9,A1.C8 C10,A1.C9 C11,A1.C10 C12,A1.C11 C13,A1.C12 C14,A1.C13 C15,A1.C14 C16,A1.C15 C17,A1.C16 C18,A1.C17 C19,A1.C18 C20,A2.C2 C21,A1.C20 C22,A1.C21 C23,A1.C22 C24,A1.C23 C25,A1.C24 C26,A1.C25 C27,A1.C26 C28,A1.C27 C29,A1.C28 C30,A1.C29 C31,A1.C30 C32,A1.C31 C33,A1.C32 C34,A1.C33 C35,A1.C34 C36,A1.C35 C37,A1.C36 C38,A1.C37 C39,A1.C38 C40,A1.C39 C41,A1.C40 C42,A1.C41 C43,A1.C42 C44,A1.C43 C45,A1.C44 C46,A1.C45 C47,A1.C46 C48,A1.C47 C49,A1.C48 C50,A1.C49 C51,A1.C50 C52,A1.C51 C53,A1.C52 C54,A1.C53 C55,A1.C54 C56,A1.C55 C57,A1.C56 C58,A1.C57 C59,A1.C58 C60,A1.C59 C61,A1.C60 C62,A1.C61 C63,A1.C62 C64,A1.C63 C65,A2.C1 C66 FROM (SELECT /*+ ORDERED NO_EXPAND USE_HASH(A4) */ A3.C0 C0,A4.C2 C1,A4.C0 C2,A3.C1 C3,A3.C2 C4,A3.C3 C5,A3.C4 C6,A3.C5 C7,A3.C6 C8,A3.C7 C9,A3.C8 C10,A3.C9 C11,A3.C10 C12,A3.C11 C13,A3.C12 C14,A3.C13 C15,A3.C14 C16,A3.C15 C17,A3.C16 C18,A3.C17 C19,A3.C18 C20,A3.C19 C21,A3.C20 C22,A3.C21 C23,A3.C22 C24,A3.C23 C25,A3.C24 C26,A3.C25 C27,A3.C26 C28,A3.C27 C29,A3.C28 C30,A3.C29 C31,A3.C30 C32,A3.C31 C33,A3.C32 C34,A3.C33 C35,A3.C34 C36,A3.C35 C37,A3.C36 C38,A3.C37 C39,A3.C38 C40,A3.C39 C41,A3.C40 C42,A3.C41 C43,A3.C42 C44,A3.C43 C45,A3.C44 C46,A3.C45 C47,A3.C46 C48,A3.C47 C49,A3.C48 C50,A3.C49 C51,A3.C50 C52,A3.C51 C53,A3.C52 C54,A3.C53 C55,A3.C54 C56,A3.C55 C57,A3.C56 C58,A3.C57 C59,A3.C58 C60,A3.C59 C61,A3.C60 C62,A4.C1 C63 FROM (SELECT /*+ ORDERED NO_EXPAND USE_HASH(A6) */ A5.C0 C0,A6.C2 C1,A6.C0 C2,A5.C1 C3,A5.C2 C4,A5.C3 C5,A5.C4 C6,A5.C5 C7,A5.C6 C8,A5.C7 C9,A5.C8 C10,A5.C9 C11,A5.C10 C12,A5.C11 C13,A5.C12 C14,A5.C13 C15,A5.C14 C16,A5.C15 C17,A5.C16 C18,A5.C17 C19,A5.C18 C20,A5.C19 C21,A5.C20 C22,A5.C21 C23,A5.C22 C24,A5.C23 C25,A5.C24 C26,A5.C25 C27,A5.C26 C28,A5.C27 C29,A5.C28 C30,A5.C29 C31,A5.C30 C32,A5.C31 C33,A5.C32 C34,A5.C33 C35,A5.C34 C36,A5.C35 C37,A5.C36 C38,A5.C37 C39,A5.C38 C40,A5.C39 C41,A5.C40 C42,A5.C41 C43,A5.C42 C44,A5.C43 C45,A5.C44 C46,A5.C45 C47,A5.C46 C48,A5.C47 C49,A5.C48 C50,A5.C49 C51,A5.C50 C52,A5.C51 C53,A5.C52 C54,A5.C53 C55,A5.C54 C56,A5.C55 C57,A5.C56 C58,A5.C57 C59,A6.C1 C60 FROM (SELECT /*+ ORDERED NO_EXPAND USE_HASH(A8) */ A7.C0 C0,A8.C2 C1,A8.C0 C2,A7.C1 C3,A7.C2 C4,A7.C3 C5,A7.C4 C6,A7.C5 C7,A7.C6 C8,A7.C7 C9,A7.C8 C10,A7.C9 C11,A7.C10 C12,A7.C11 C13,A7.C12 C14,A7.C13 C15,A7.C14 C16,A7.C15 C17,A7.C16 C18,A7.C17 C19,A7.C18 C20,A7.C19 C21,A7.C20 C22,A7.C21 C23,A7.C22 C24,A7.C23 C25,A7.C24 C26,A7.C25 C27,A7.C26 C28,A7.C27 C29,A7.C28 C30,A7.C29 C31,A7.C30 C32,A7.C31 C33,A7.C32 C34,A7.C33 C35,A7.C34 C36,A7.C35 C37,A7.C36 C38,A7.C37 C39,A7.C38 C40,A7.C39 C41,A7.C40 C42,A7.C41 C43,A7.C42 C44,A7.C43 C45,A7.C44 C46,A7.C45 C47,A7.C46 C48,A7.C47 C49,A7.C48 C50,A7.C49 C51,A7.C50 C52,A7.C51 C53,A7.C52 C54,A7.C53 C55,A7.C54 C56,A8.C1 C57 FROM :Q571311010 A7,:Q571311003 A8 WHERE A7.C0=A8.C0(+)) A5,:Q571311004 A6 WHERE A5.C0=A6.C0(+)) A3,:Q571311005 A4 WHERE A3.C0=A4.C0(+)) A1,:Q571311006 A2 WHERE A1.C0=A2.C0(+)",HASH,[NULL],3937,[NULL],"DC.""CALYPSOSECURITYID""=""SYS_ALIAS_0000"".""PRODUCT_ID""(+)",[NULL]
[NULL],13/06/2008 12:10,[NULL],HASH JOIN,OUTER,:Q571311011,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],79,78,1,3105,1069,806026,PARALLEL_COMBINED_WITH_PARENT,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],3105,[NULL],"DC.""CALYPSOSECURITYID""=""SYS_ALIAS_0001"".""PRODUCT_ID""(+)",[NULL]
[NULL],13/06/2008 12:10,[NULL],HASH JOIN,OUTER,:Q571311011,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],80,79,1,2273,896,652288,PARALLEL_COMBINED_WITH_PARENT,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2273,[NULL],"DC.""CALYPSOSECURITYID""=""SYS_ALIAS_0002"".""PRODUCT_ID""(+)",[NULL]
[NULL],13/06/2008 12:10,[NULL],HASH JOIN,OUTER,:Q571311011,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],81,80,1,1441,751,527202,PARALLEL_COMBINED_WITH_PARENT,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1441,[NULL],"DC.""CALYPSOSECURITYID""=""C"".""PRODUCT_ID""(+)",[NULL]
[NULL],13/06/2008 12:10,[NULL],FILTER,[NULL],:Q571311011,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],82,81,1,[NULL],[NULL],[NULL],PARALLEL_COMBINED_WITH_CHILD,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"DC.""REGION""=""P"".""REGION"" OR ""P"".""REGION"" IS NULL"
[NULL],13/06/2008 12:10,[NULL],NESTED LOOPS,OUTER,:Q571311010,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],83,82,1,[NULL],[NULL],[NULL],PARALLEL_TO_PARALLEL,[NULL],[NULL],[NULL],"SELECT /*+ ORDERED NO_EXPAND USE_NL(A2) INDEX(A2 ""IDX_CMPP_TMP_PRCE1"") */ A1.C45 C0,A1.C0 C1,A1.C1 C2,A1.C2 C3,A1.C3 C4,A1.C4 C5,A1.C5 C6,A1.C6 C7,A1.C7 C8,A1.C8 C9,A1.C9 C10,A1.C10 C11,A1.C11 C12,A1.C12 C13,A1.C13 C14,A1.C14 C15,A1.C15 C16,A1.C16 C17,A1.C17 C18,A1.C18 C19,A1.C19 C20,A1.C20 C21,A1.C21 C22,A1.C22 C23,A1.C23 C24,A1.C24 C25,A1.C25 C26,A1.C26 C27,A1.C27 C28,A1.C28 C29,A1.C29 C30,A1.C30 C31,A1.C31 C32,A1.C32 C33,A1.C33 C34,A1.C34 C35,A1.C35 C36,A1.C36 C37,A1.C37 C38,A1.C38 C39,A1.C39 C40,A1.C40 C41,A1.C41 C42,A1.C42 C43,A1.C43 C44,A1.C44 C45,A2.""REGION"" C46,A1.C46 C47,A1.C47 C48,A1.C48 C49,A1.C49 C50,A1.C50 C51,A2.ROWID C52,A2.""ID"" C53,A2.""BID"" C54 FROM (SELECT /*+ ORDERED NO_EXPAND USE_NL(A4) INDEX(A4 ""IDX_CMPP_TMP_RATE1"") */ A3.C0 C0,A3.C1 C1,A3.C2 C2,A3.C3 C3,A3.C4 C4,A3.C5 C5,A3.C6 C6,A3.C7 C7,A3.C8 C8,A3.C9 C9,A3.C10 C10,A3.C11 C11,A3.C12 C12,A3.C13 C13,A3.C14 C14,A3.C15 C15,A3.C16 C16,A3.C17 C17,A3.C18 C18,A3.C19 C19,A3.C20 C20,A3.C21 C21,A3.C22 C22,A3.C23 C23,A3.C24 C24,A3.C25 C25,A3.C26 C26,A3.C27 C27,A3.C28 C28,A3.C29 C29,A3.C30 C30,A3.C31 C31,A3.C32 C32,A3.C33 C33,A3.C34 C34,A3.C35 C35,A3.C36 C36,A3.C37 C37,A3.C38 C38,A3.C39 C39,A3.C40 C40,A3.C41 C41,A3.C42 C42,A3.C43 C43,A3.C44 C44,A3.C45 C45,A3.C46 C46,A4.ROWID C47,A4.""CALYPSOSECURITYID"" C48,A4.""RATINGTYPE"" C49,A4.""RATINGVALUE"" C50 FROM (SELECT /*+ ORDERED NO_EXPAND USE_HASH(A6) */ A5.C0 C0,A5.C1 C1,A5.C2 C2,A5.C3 C3,A5.C4 C4,A5.C5 C5,A5.C6 C6,A5.C7 C7,A5.C8 C8,A5.C9 C9,A5.C10 C10,A5.C11 C11,A5.C12 C12,A5.C13 C13,A5.C14 C14,A5.C15 C15,A5.C16 C16,A5.C17 C17,A5.C18 C18,A5.C19 C19,A5.C20 C20,A5.C21 C21,A5.C22 C22,A5.C23 C23,A5.C24 C24,A5.C25 C25,A5.C26 C26,A5.C27 C27,A5.C28 C28,A5.C29 C29,A5.C30 C30,A5.C31 C31,A5.C32 C32,A5.C33 C33,A5.C34 C34,A5.C35 C35,A5.C36 C36,A5.C37 C37,A5.C38 C38,A5.C39 C39,A5.C40 C40,A5.C41 C41,A6.C1 C42,A6.C2 C43,A6.C3 C44,A6.C4 C45,A6.C5 C46 FROM :Q571311009 A5,:Q571311002 A6 WHERE A6.C4 IS NULL AND A5.C0=A6.C0(+)) A3,""CMPP_TMP_RATE"" A4 WHERE (A4.""RATINGTYPE""='S & P' OR A4.""RATINGTYPE"" IS NULL) AND A3.C45=A4.""CALYPSOSECURITYID""(+)) A1,""CMPP_TMP_PRCE"" A2 WHERE (A1.C43=A2.""REGION"" OR A2.""REGION"" IS NULL) AND A1.C45=A2.""ID""(+)",HASH,[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],FILTER,[NULL],:Q571311010,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],84,83,1,[NULL],[NULL],[NULL],PARALLEL_COMBINED_WITH_CHILD,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"R.""RATINGTYPE""='S & P' OR ""R"".""RATINGTYPE"" IS NULL"
[NULL],13/06/2008 12:10,[NULL],NESTED LOOPS,OUTER,:Q571311010,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],85,84,1,[NULL],[NULL],[NULL],PARALLEL_COMBINED_WITH_PARENT,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],FILTER,[NULL],:Q571311010,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],86,85,1,[NULL],[NULL],[NULL],PARALLEL_COMBINED_WITH_CHILD,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"DC.""CALYPSOSECURITYID"" IS NULL"
[NULL],13/06/2008 12:10,[NULL],HASH JOIN,OUTER,:Q571311010,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],87,86,1,[NULL],[NULL],[NULL],PARALLEL_COMBINED_WITH_PARENT,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"SYS_ALIAS_1.""CALYPSOTRADEID""=""DC"".""CALYPSOTRADEID""(+)",[NULL]
[NULL],13/06/2008 12:10,[NULL],HASH JOIN,[NULL],:Q571311009,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],88,87,1,331,622,340234,PARALLEL_TO_PARALLEL,[NULL],[NULL],[NULL],"SELECT /*+ ORDERED NO_EXPAND USE_HASH(A2) */ A1.C5 C0,A1.C1 C1,A1.C2 C2,A1.C3 C3,A1.C4 C4,A1.C42 C5,A1.C6 C6,A1.C7 C7,A1.C8 C8,A1.C9 C9,A1.C10 C10,A1.C11 C11,A1.C12 C12,A1.C13 C13,A1.C14 C14,A1.C15 C15,A1.C16 C16,A1.C17 C17,A1.C18 C18,A1.C19 C19,A1.C20 C20,A1.C21 C21,A1.C22 C22,A1.C23 C23,A1.C24 C24,A1.C25 C25,A1.C26 C26,A1.C27 C27,A1.C28 C28,A1.C29 C29,A1.C30 C30,A1.C31 C31,A1.C32 C32,A1.C33 C33,A1.C34 C34,A1.C35 C35,A1.C36 C36,A1.C37 C37,A1.C38 C38,A1.C39 C39,A1.C40 C40,A1.C41 C41 FROM :Q571311008 A1,:Q571311001 A2 WHERE A1.C0=A2.C0",HASH,[NULL],331,[NULL],"GB.""SYS_BOOK""=""GS"".""SRC_SYS_BOOK""",[NULL]
[NULL],13/06/2008 12:10,[NULL],HASH JOIN,OUTER,:Q571311008,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],89,88,1,316,622,326550,PARALLEL_TO_PARALLEL,[NULL],[NULL],[NULL],"SELECT /*+ ORDERED NO_EXPAND USE_HASH(A2) */ A1.C2 C0,A1.C1 C1,A1.C43 C2,A1.C3 C3,A1.C4 C4,A1.C5 C5,A1.C6 C6,A1.C7 C7,A1.C8 C8,A1.C9 C9,A1.C10 C10,A1.C11 C11,A1.C12 C12,A1.C13 C13,A1.C14 C14,A1.C15 C15,A1.C16 C16,A1.C17 C17,A1.C18 C18,A1.C19 C19,A1.C20 C20,A1.C21 C21,A1.C22 C22,A1.C23 C23,A1.C24 C24,A1.C25 C25,A1.C26 C26,A1.C27 C27,A1.C28 C28,A1.C29 C29,A1.C30 C30,A1.C31 C31,A1.C32 C32,A1.C33 C33,A1.C34 C34,A1.C35 C35,A1.C36 C36,A1.C37 C37,A1.C38 C38,A1.C39 C39,A1.C40 C40,A1.C41 C41,A1.C42 C42 FROM :Q571311000 A1,:Q571311007 A2 WHERE A1.C0=A2.C0(+)",HASH,[NULL],316,[NULL],"GB.""PARENT_ORGANISATION_ID""=""GO"".""ORGANISATION_ID""(+)",[NULL]
[NULL],13/06/2008 12:10,[NULL],HASH JOIN,[NULL],:Q571311000,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],90,89,1,313,622,323440,PARALLEL_FROM_SERIAL,[NULL],[NULL],[NULL],[NULL],HASH,[NULL],313,[NULL],"SYS_ALIAS_1.""CALYPSOBOOKNAME""=""GB"".""SYS_BOOK_POSTFIX""",[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,FULL,[NULL],CALYPSO_DEV10,CMPP_TMP_GRD_BOOK,43,[NULL],ANALYZED,[NULL],91,90,1,5,1372,42532,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],5,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],92,90,2,306,621,303669,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],306,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,FULL,[NULL],CALYPSO_DEV10,CMPP_TMP_DEAL,39,[NULL],ANALYZED,[NULL],93,92,1,306,621,89424,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],306,[NULL],[NULL],"SYS_ALIAS_1.""FLATFILERECORDTYPE""='Repo Loan' OR ""SYS_ALIAS_1"".""FLATFILERECORDTYPE""='Security Loan'"
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_INST,41,[NULL],ANALYZED,[NULL],94,92,2,[NULL],1,345,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_INST1,[NULL],NON-UNIQUE,ANALYZED,1,95,94,1,[NULL],1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""I"".""CALYPSOSECURITYID""(+)",[NULL]
[NULL],13/06/2008 12:10,[NULL],INDEX,FAST FULL SCAN,:Q571311007,CALYPSO_DEV10,IDX_CMPP_TMP_GO1,[NULL],NON-UNIQUE,ANALYZED,[NULL],96,89,2,3,3230,16150,PARALLEL_TO_PARALLEL,[NULL],[NULL],[NULL],"SELECT /*+ INDEX_RRS(A1 ""IDX_CMPP_TMP_GO1"") */ A1.""ORGANISATION_ID"" C0 FROM ""CMPP_TMP_GRD_ORGN""  PX_GRANULE(0, BLOCK_RANGE, DYNAMIC) A1",HASH,[NULL],3,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,FULL,:Q571311001,CALYPSO_DEV10,CMPP_TMP_GRDW_SDM,42,[NULL],ANALYZED,[NULL],97,88,2,15,15513,341286,PARALLEL_FROM_SERIAL,[NULL],[NULL],[NULL],[NULL],HASH,[NULL],15,[NULL],[NULL],"GS.""COST_CENTRE"" IS NOT NULL"
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,FULL,:Q571311002,CALYPSO_DEV10,CMPP_TMP_DEAL_COLL,40,[NULL],ANALYZED,[NULL],98,87,2,278,27180,1657980,PARALLEL_FROM_SERIAL,[NULL],[NULL],[NULL],[NULL],HASH,[NULL],278,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,BY INDEX ROWID,:Q571311010,CALYPSO_DEV10,CMPP_TMP_RATE,46,[NULL],ANALYZED,[NULL],99,85,2,[NULL],1,39,PARALLEL_COMBINED_WITH_PARENT,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],INDEX,RANGE SCAN,:Q571311010,CALYPSO_DEV10,IDX_CMPP_TMP_RATE1,[NULL],NON-UNIQUE,ANALYZED,1,100,99,1,[NULL],1,[NULL],PARALLEL_COMBINED_WITH_PARENT,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"DC.""CALYPSOSECURITYID""=""R"".""CALYPSOSECURITYID""(+)",[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,BY INDEX ROWID,:Q571311010,CALYPSO_DEV10,CMPP_TMP_PRCE,47,[NULL],ANALYZED,[NULL],101,83,2,[NULL],1,29,PARALLEL_COMBINED_WITH_PARENT,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],INDEX,RANGE SCAN,:Q571311010,CALYPSO_DEV10,IDX_CMPP_TMP_PRCE1,[NULL],NON-UNIQUE,ANALYZED,1,102,101,1,[NULL],1,[NULL],PARALLEL_COMBINED_WITH_PARENT,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"DC.""CALYPSOSECURITYID""=""P"".""ID""(+)",[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,FULL,:Q571311003,CALYPSO_DEV10,PRODUCT_SEC_CODE,49,[NULL],ANALYZED,[NULL],103,81,2,832,24386,634036,PARALLEL_FROM_SERIAL,[NULL],[NULL],[NULL],[NULL],HASH,[NULL],832,[NULL],[NULL],"C.""SEC_CODE""(+)='INDUSTRY_GROUP'"
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,FULL,:Q571311004,CALYPSO_DEV10,PRODUCT_SEC_CODE,51,[NULL],ANALYZED,[NULL],104,80,2,832,24386,634036,PARALLEL_FROM_SERIAL,[NULL],[NULL],[NULL],[NULL],HASH,[NULL],832,[NULL],[NULL],"SYS_ALIAS_0002.""SEC_CODE""(+)='RTG_DBRS'"
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,FULL,:Q571311005,CALYPSO_DEV10,PRODUCT_SEC_CODE,53,[NULL],ANALYZED,[NULL],105,79,2,832,24386,634036,PARALLEL_FROM_SERIAL,[NULL],[NULL],[NULL],[NULL],HASH,[NULL],832,[NULL],[NULL],"SYS_ALIAS_0001.""SEC_CODE""(+)='Collateral_Type'"
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,FULL,:Q571311006,CALYPSO_DEV10,PRODUCT_SEC_CODE,55,[NULL],ANALYZED,[NULL],106,78,2,832,24386,634036,PARALLEL_FROM_SERIAL,[NULL],[NULL],[NULL],[NULL],HASH,[NULL],832,[NULL],[NULL],"SYS_ALIAS_0000.""SEC_CODE""(+)='INDUSTRY_SECTOR'"
[NULL],13/06/2008 12:10,[NULL],SELECT STATEMENT,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],CHOOSE,[NULL],0,[NULL],12520,12520,2210,1739272,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],5752,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],UNION-ALL,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,0,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],FILTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,1,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]," NOT EXISTS (SELECT /*+ */ 0 FROM ""CMPP_TMP_BADBOOKIDS"" ""CMPP_TMP_BADBOOKIDS"" WHERE LNNVL(""CMPP_TMP_BADBOOKIDS"".""BOOK_ID""<>:B1))"
[NULL],13/06/2008 12:10,[NULL],HASH JOIN,OUTER,:Q571312011,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],3,2,1,3888,932,730688,PARALLEL_TO_SERIAL,[NULL],[NULL],[NULL],"SELECT /*+ ORDERED NO_EXPAND USE_HASH(A2) */ A1.C0,A2.C0,A1.C1,A1.C2,A1.C3,A1.C4,A1.C5,A1.C6,A1.C7,A1.C8,A1.C9,A1.C10,A1.C11,A1.C12,A1.C13,A1.C14,A1.C15,A1.C16,A1.C17,A1.C18,A1.C19,A1.C20,A1.C21,A1.C22,A1.C23,A1.C24,A1.C25,A1.C26,A1.C27,A1.C28,A1.C29,A1.C30,A1.C31,A1.C32,A1.C33,A1.C34,A1.C35,A1.C36,A1.C37,A1.C38,A1.C39,A1.C40,A1.C41,A1.C42,A1.C43,A1.C44,A1.C45,A1.C46,A1.C47,A1.C48,A1.C49,A1.C50,A1.C51,A1.C52,A1.C53,A1.C54,A1.C55,A1.C56,A1.C57,A1.C58,A1.C59,A1.C60,A1.C61,A1.C62,A1.C63,A1.C64,A1.C65,A2.C1,A2.C2 FROM (SELECT /*+ ORDERED NO_EXPAND USE_HASH(A4) */ A3.C0 C0,A4.C2 C1,A4.C0 C2,A3.C1 C3,A3.C2 C4,A3.C3 C5,A3.C4 C6,A3.C5 C7,A3.C6 C8,A3.C7 C9,A3.C8 C10,A3.C9 C11,A3.C10 C12,A3.C11 C13,A3.C12 C14,A3.C13 C15,A3.C14 C16,A3.C15 C17,A3.C16 C18,A3.C17 C19,A3.C18 C20,A3.C19 C21,A3.C20 C22,A3.C21 C23,A3.C22 C24,A3.C23 C25,A3.C24 C26,A3.C25 C27,A3.C26 C28,A3.C27 C29,A3.C28 C30,A3.C29 C31,A3.C30 C32,A3.C31 C33,A3.C32 C34,A3.C33 C35,A3.C34 C36,A3.C35 C37,A3.C36 C38,A3.C37 C39,A3.C38 C40,A3.C39 C41,A3.C40 C42,A3.C41 C43,A3.C42 C44,A3.C43 C45,A3.C44 C46,A3.C45 C47,A3.C46 C48,A3.C47 C49,A3.C48 C50,A3.C49 C51,A3.C50 C52,A3.C51 C53,A3.C52 C54,A3.C53 C55,A3.C54 C56,A3.C55 C57,A3.C56 C58,A3.C57 C59,A3.C58 C60,A3.C59 C61,A3.C60 C62,A3.C61 C63,A3.C62 C64,A4.C1 C65 FROM (SELECT /*+ ORDERED NO_EXPAND USE_HASH(A6) */ A5.C0 C0,A6.C2 C1,A6.C0 C2,A5.C1 C3,A5.C2 C4,A5.C3 C5,A5.C4 C6,A5.C5 C7,A5.C6 C8,A5.C7 C9,A5.C8 C10,A5.C9 C11,A5.C10 C12,A5.C11 C13,A5.C12 C14,A5.C13 C15,A5.C14 C16,A5.C15 C17,A5.C16 C18,A5.C17 C19,A5.C18 C20,A5.C19 C21,A5.C20 C22,A5.C21 C23,A5.C22 C24,A5.C23 C25,A5.C24 C26,A5.C25 C27,A5.C26 C28,A5.C27 C29,A5.C28 C30,A5.C29 C31,A5.C30 C32,A5.C31 C33,A5.C32 C34,A5.C33 C35,A5.C34 C36,A5.C35 C37,A5.C36 C38,A5.C37 C39,A5.C38 C40,A5.C39 C41,A5.C40 C42,A5.C41 C43,A5.C42 C44,A5.C43 C45,A5.C44 C46,A5.C45 C47,A5.C46 C48,A5.C47 C49,A5.C48 C50,A5.C49 C51,A5.C50 C52,A5.C51 C53,A5.C52 C54,A5.C53 C55,A5.C54 C56,A5.C55 C57,A5.C56 C58,A5.C57 C59,A5.C58 C60,A5.C59 C61,A6.C1 C62 FROM (SELECT /*+ ORDERED NO_EXPAND USE_HASH(A8) */ A7.C0 C0,A8.C2 C1,A8.C0 C2,A7.C1 C3,A7.C2 C4,A7.C3 C5,A7.C4 C6,A7.C5 C7,A7.C6 C8,A7.C7 C9,A7.C8 C10,A7.C9 C11,A7.C10 C12,A7.C11 C13,A7.C12 C14,A7.C13 C15,A7.C14 C16,A7.C15 C17,A7.C16 C18,A7.C17 C19,A7.C18 C20,A7.C19 C21,A7.C20 C22,A7.C21 C23,A7.C22 C24,A7.C23 C25,A7.C24 C26,A7.C25 C27,A7.C26 C28,A7.C27 C29,A7.C28 C30,A7.C29 C31,A7.C30 C32,A7.C31 C33,A7.C32 C34,A7.C33 C35,A7.C34 C36,A7.C35 C37,A7.C36 C38,A7.C37 C39,A7.C38 C40,A7.C39 C41,A7.C40 C42,A7.C41 C43,A7.C42 C44,A7.C43 C45,A7.C44 C46,A7.C45 C47,A7.C46 C48,A7.C47 C49,A7.C48 C50,A7.C49 C51,A7.C50 C52,A7.C51 C53,A7.C52 C54,A7.C53 C55,A7.C54 C56,A7.C55 C57,A7.C56 C58,A8.C1 C59 FROM :Q571312010 A7,:Q571312002 A8 WHERE A7.C0=A8.C0(+)) A5,:Q571312003 A6 WHERE A5.C0=A6.C0(+)) A3,:Q571312004 A4 WHERE A3.C0=A4.C0(+)) A1,:Q571312005 A2 WHERE A1.C0=A2.C0(+)",QC (RANDOM),[NULL],3888,[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""SYS_ALIAS_0000"".""PRODUCT_ID""(+)",[NULL]
[NULL],13/06/2008 12:10,[NULL],HASH JOIN,OUTER,:Q571312011,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],4,3,1,3056,932,706456,PARALLEL_COMBINED_WITH_PARENT,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],3056,[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""SYS_ALIAS_0001"".""PRODUCT_ID""(+)",[NULL]
[NULL],13/06/2008 12:10,[NULL],HASH JOIN,OUTER,:Q571312011,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],5,4,1,2224,932,682224,PARALLEL_COMBINED_WITH_PARENT,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2224,[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""SYS_ALIAS_0002"".""PRODUCT_ID""(+)",[NULL]
[NULL],13/06/2008 12:10,[NULL],HASH JOIN,OUTER,:Q571312011,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],6,5,1,1392,932,657992,PARALLEL_COMBINED_WITH_PARENT,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1392,[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""C"".""PRODUCT_ID""(+)",[NULL]
[NULL],13/06/2008 12:10,[NULL],HASH JOIN,OUTER,:Q571312010,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],7,6,1,560,932,633760,PARALLEL_TO_PARALLEL,[NULL],[NULL],[NULL],"SELECT /*+ ORDERED NO_EXPAND USE_HASH(A2) */ A1.C18 C0,A1.C1 C1,A1.C2 C2,A1.C3 C3,A1.C4 C4,A1.C5 C5,A1.C6 C6,A1.C7 C7,A1.C8 C8,A1.C9 C9,A1.C10 C10,A1.C11 C11,A1.C12 C12,A1.C13 C13,A1.C14 C14,A1.C15 C15,A1.C16 C16,A1.C17 C17,A1.C57 C18,A1.C19 C19,A1.C20 C20,A1.C21 C21,A1.C22 C22,A1.C23 C23,A1.C24 C24,A1.C25 C25,A1.C26 C26,A1.C27 C27,A1.C28 C28,A1.C29 C29,A1.C30 C30,A1.C31 C31,A1.C32 C32,A1.C33 C33,A1.C34 C34,A1.C35 C35,A1.C36 C36,A1.C37 C37,A1.C38 C38,A1.C39 C39,A1.C40 C40,A1.C41 C41,A1.C42 C42,A1.C43 C43,A1.C44 C44,A1.C45 C45,A1.C46 C46,A1.C47 C47,A1.C48 C48,A1.C49 C49,A1.C50 C50,A1.C51 C51,A1.C52 C52,A1.C53 C53,A1.C54 C54,A1.C55 C55,A1.C56 C56 FROM :Q571312008 A1,:Q571312009 A2 WHERE A1.C0=A2.C0(+)",HASH,[NULL],560,[NULL],"SYS_ALIAS_1.""COUNTERPARTYCISID""=""GC"".""CIS_CODE""(+)",[NULL]
[NULL],13/06/2008 12:10,[NULL],HASH JOIN,[NULL],:Q571312008,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],8,7,1,332,932,625372,PARALLEL_TO_PARALLEL,[NULL],[NULL],[NULL],"SELECT /*+ ORDERED NO_EXPAND USE_HASH(A2) SWAP_JOIN_INPUTS(A2) */ A1.C12 C0,A1.C1 C1,A1.C2 C2,A1.C3 C3,A1.C4 C4,A1.C5 C5,A1.C6 C6,A1.C7 C7,A1.C8 C8,A1.C9 C9,A1.C10 C10,A1.C11 C11,A1.C58 C12,A1.C13 C13,A1.C14 C14,A1.C15 C15,A1.C16 C16,A1.C17 C17,A1.C18 C18,A1.C19 C19,A1.C20 C20,A1.C21 C21,A1.C22 C22,A1.C23 C23,A1.C24 C24,A1.C25 C25,A1.C26 C26,A1.C27 C27,A1.C28 C28,A1.C29 C29,A1.C30 C30,A1.C31 C31,A1.C32 C32,A1.C33 C33,A1.C34 C34,A1.C35 C35,A1.C36 C36,A1.C37 C37,A1.C38 C38,A1.C39 C39,A1.C40 C40,A1.C41 C41,A1.C42 C42,A1.C43 C43,A1.C44 C44,A1.C45 C45,A1.C46 C46,A1.C47 C47,A1.C48 C48,A1.C49 C49,A1.C50 C50,A1.C51 C51,A1.C52 C52,A1.C53 C53,A1.C54 C54,A1.C55 C55,A1.C56 C56,A1.C57 C57 FROM :Q571312007 A1,:Q571312001 A2 WHERE A1.C0=A2.C0",HASH,[NULL],332,[NULL],"GB.""SYS_BOOK""=""GS"".""SRC_SYS_BOOK""",[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,FULL,:Q571312001,CALYPSO_DEV10,CMPP_TMP_GRDW_SDM,3,[NULL],ANALYZED,[NULL],9,8,1,15,15513,341286,PARALLEL_FROM_SERIAL,[NULL],[NULL],[NULL],[NULL],HASH,[NULL],15,[NULL],[NULL],"GS.""COST_CENTRE"" IS NOT NULL"
[NULL],13/06/2008 12:10,[NULL],HASH JOIN,OUTER,:Q571312007,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],10,8,2,317,932,604868,PARALLEL_TO_PARALLEL,[NULL],[NULL],[NULL],"SELECT /*+ ORDERED NO_EXPAND USE_HASH(A2) */ A1.C2 C0,A1.C1 C1,A1.C59 C2,A1.C3 C3,A1.C4 C4,A1.C5 C5,A1.C6 C6,A1.C7 C7,A1.C8 C8,A1.C9 C9,A1.C10 C10,A1.C11 C11,A1.C12 C12,A1.C13 C13,A1.C14 C14,A1.C15 C15,A1.C16 C16,A1.C17 C17,A1.C18 C18,A1.C19 C19,A1.C20 C20,A1.C21 C21,A1.C22 C22,A1.C23 C23,A1.C24 C24,A1.C25 C25,A1.C26 C26,A1.C27 C27,A1.C28 C28,A1.C29 C29,A1.C30 C30,A1.C31 C31,A1.C32 C32,A1.C33 C33,A1.C34 C34,A1.C35 C35,A1.C36 C36,A1.C37 C37,A1.C38 C38,A1.C39 C39,A1.C40 C40,A1.C41 C41,A1.C42 C42,A1.C43 C43,A1.C44 C44,A1.C45 C45,A1.C46 C46,A1.C47 C47,A1.C48 C48,A1.C49 C49,A1.C50 C50,A1.C51 C51,A1.C52 C52,A1.C53 C53,A1.C54 C54,A1.C55 C55,A1.C56 C56,A1.C57 C57,A1.C58 C58 FROM :Q571312000 A1,:Q571312006 A2 WHERE A1.C0=A2.C0(+)",HASH,[NULL],317,[NULL],"GB.""PARENT_ORGANISATION_ID""=""GO"".""ORGANISATION_ID""(+)",[NULL]
[NULL],13/06/2008 12:10,[NULL],HASH JOIN,[NULL],:Q571312000,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],11,10,1,314,932,600208,PARALLEL_FROM_SERIAL,[NULL],[NULL],[NULL],[NULL],HASH,[NULL],314,[NULL],"SYS_ALIAS_1.""CALYPSOBOOKNAME""=""GB"".""SYS_BOOK_POSTFIX""",[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,FULL,[NULL],CALYPSO_DEV10,CMPP_TMP_GRD_BOOK,4,[NULL],ANALYZED,[NULL],12,11,1,5,1372,42532,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],5,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],13,11,2,306,931,570703,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],306,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],FILTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],14,13,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"SYS_ALIAS_1.""REGION""=""P"".""REGION"" OR ""P"".""REGION"" IS NULL"
[NULL],13/06/2008 12:10,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],15,14,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],FILTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],16,15,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"R.""RATINGTYPE""='S & P' OR ""R"".""RATINGTYPE"" IS NULL"
[NULL],13/06/2008 12:10,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],17,16,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],18,17,1,306,931,457121,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],306,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,FULL,[NULL],CALYPSO_DEV10,CMPP_TMP_DEAL,1,[NULL],ANALYZED,[NULL],19,18,1,306,931,135926,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],306,[NULL],[NULL],"SYS_ALIAS_1.""FLATFILERECORDTYPE""='Collateral Movement' OR ""SYS_ALIAS_1"".""FLATFILERECORDTYPE""='Loan/Depo' OR ""SYS_ALIAS_1"".""FLATFILERECORDTYPE""='Security'"
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_INST,2,[NULL],ANALYZED,[NULL],20,18,2,[NULL],1,345,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_INST1,[NULL],NON-UNIQUE,ANALYZED,1,21,20,1,[NULL],1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""I"".""CALYPSOSECURITYID""(+)",[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_RATE,7,[NULL],ANALYZED,[NULL],22,17,2,[NULL],1,39,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_RATE1,[NULL],NON-UNIQUE,ANALYZED,1,23,22,1,[NULL],1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""R"".""CALYPSOSECURITYID""(+)",[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_PRCE,8,[NULL],ANALYZED,[NULL],24,15,2,[NULL],1,29,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_PRCE1,[NULL],NON-UNIQUE,ANALYZED,1,25,24,1,[NULL],1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""P"".""ID""(+)",[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_POSN,10,[NULL],ANALYZED,[NULL],26,13,2,[NULL],1,54,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"SYS_ALIAS_1.""CALYPSOBOOKID""=""CMPP_TMP_POSN"".""CALYPSOBOOKID""(+) AND ""CMPP_TMP_POSN"".""POSITIONTYPE""(+)='T' AND ""CMPP_TMP_POSN"".""POSITION""(+)<>0"
[NULL],13/06/2008 12:10,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_POSN2,[NULL],NON-UNIQUE,ANALYZED,1,27,26,1,[NULL],1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"SYS_ALIAS_1.""CALYPSOSECURITYID""=""CMPP_TMP_POSN"".""CALYPSOSECURITYID""(+)",[NULL]
[NULL],13/06/2008 12:10,[NULL],INDEX,FAST FULL SCAN,:Q571312006,CALYPSO_DEV10,IDX_CMPP_TMP_GO1,[NULL],NON-UNIQUE,ANALYZED,[NULL],28,10,2,3,3230,16150,PARALLEL_TO_PARALLEL,[NULL],[NULL],[NULL],"SELECT /*+ INDEX_RRS(A1 ""IDX_CMPP_TMP_GO1"") */ A1.""ORGANISATION_ID"" C0 FROM ""CMPP_TMP_GRD_ORGN""  PX_GRANULE(0, BLOCK_RANGE, DYNAMIC) A1",HASH,[NULL],3,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],INDEX,FAST FULL SCAN,:Q571312009,CALYPSO_DEV10,IDX_CMPP_TMP_GC1,[NULL],NON-UNIQUE,ANALYZED,[NULL],29,7,2,228,548749,4938741,PARALLEL_TO_PARALLEL,[NULL],[NULL],[NULL],"SELECT /*+ INDEX_RRS(A1 ""IDX_CMPP_TMP_GC1"") */ A1.""CIS_CODE"" C0 FROM ""CMPP_TMP_GRD_CPTY""  PX_GRANULE(0, BLOCK_RANGE, DYNAMIC) A1",HASH,[NULL],228,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,FULL,:Q571312002,CALYPSO_DEV10,PRODUCT_SEC_CODE,12,[NULL],ANALYZED,[NULL],30,6,2,832,24386,634036,PARALLEL_FROM_SERIAL,[NULL],[NULL],[NULL],[NULL],HASH,[NULL],832,[NULL],[NULL],"C.""SEC_CODE""(+)='INDUSTRY_GROUP'"
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,FULL,:Q571312003,CALYPSO_DEV10,PRODUCT_SEC_CODE,14,[NULL],ANALYZED,[NULL],31,5,2,832,24386,634036,PARALLEL_FROM_SERIAL,[NULL],[NULL],[NULL],[NULL],HASH,[NULL],832,[NULL],[NULL],"SYS_ALIAS_0002.""SEC_CODE""(+)='RTG_DBRS'"
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,FULL,:Q571312004,CALYPSO_DEV10,PRODUCT_SEC_CODE,16,[NULL],ANALYZED,[NULL],32,4,2,832,24386,634036,PARALLEL_FROM_SERIAL,[NULL],[NULL],[NULL],[NULL],HASH,[NULL],832,[NULL],[NULL],"SYS_ALIAS_0001.""SEC_CODE""(+)='Collateral_Type'"
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,FULL,:Q571312005,CALYPSO_DEV10,PRODUCT_SEC_CODE,18,[NULL],ANALYZED,[NULL],33,3,2,832,24386,634036,PARALLEL_FROM_SERIAL,[NULL],[NULL],[NULL],[NULL],HASH,[NULL],832,[NULL],[NULL],"SYS_ALIAS_0000.""SEC_CODE""(+)='INDUSTRY_SECTOR'"
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,FULL,[NULL],CALYPSO_DEV10,CMPP_TMP_BADBOOKIDS,19,[NULL],ANALYZED,[NULL],34,2,2,2,2,10,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],"LNNVL(""CMPP_TMP_BADBOOKIDS"".""BOOK_ID""<>:B1)"
[NULL],13/06/2008 12:10,[NULL],FILTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],35,1,2,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]," NOT EXISTS (SELECT /*+ */ 0 FROM ""CMPP_TMP_BADBOOKIDS"" ""CMPP_TMP_BADBOOKIDS"" WHERE LNNVL(""CMPP_TMP_BADBOOKIDS"".""BOOK_ID""<>:B1))"
[NULL],13/06/2008 12:10,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],36,35,1,31,1,796,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],31,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],37,36,1,29,1,770,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],29,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],38,37,1,27,1,744,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],27,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],39,38,1,25,1,718,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],25,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],40,39,1,23,1,692,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],23,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],41,40,1,21,1,683,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],21,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],NESTED LOOPS,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],42,41,1,19,1,674,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],19,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],43,42,1,17,1,652,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],17,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],NESTED LOOPS,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],44,43,1,16,1,647,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],16,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],NESTED LOOPS,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],45,44,1,14,1,616,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],14,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],FILTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],46,45,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"R.""RATINGTYPE""='S & P' OR ""R"".""RATINGTYPE"" IS NULL"
[NULL],13/06/2008 12:10,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],47,46,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],FILTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],48,47,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"DC.""REGION""=""P"".""REGION"" OR ""P"".""REGION"" IS NULL"
[NULL],13/06/2008 12:10,[NULL],NESTED LOOPS,OUTER,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],49,48,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],NESTED LOOPS,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],50,49,1,12,1,406,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],12,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,FULL,[NULL],CALYPSO_DEV10,CMPP_TMP_INST,22,[NULL],ANALYZED,[NULL],51,50,1,2,1,345,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_DEAL_COLL,21,[NULL],ANALYZED,[NULL],52,50,2,10,9,549,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],10,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_DEAL_COLL2,[NULL],NON-UNIQUE,ANALYZED,1,53,52,1,1,9,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"DC.""CALYPSOSECURITYID""=""I"".""CALYPSOSECURITYID""",[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_PRCE,29,[NULL],ANALYZED,[NULL],54,49,2,[NULL],1,29,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_PRCE1,[NULL],NON-UNIQUE,ANALYZED,1,55,54,1,[NULL],1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"DC.""CALYPSOSECURITYID""=""P"".""ID""(+)",[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_RATE,28,[NULL],ANALYZED,[NULL],56,47,2,[NULL],1,39,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_RATE1,[NULL],NON-UNIQUE,ANALYZED,1,57,56,1,[NULL],1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],"DC.""CALYPSOSECURITYID""=""R"".""CALYPSOSECURITYID""(+)",[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_DEAL,20,[NULL],ANALYZED,[NULL],58,45,2,2,1,142,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],"SYS_ALIAS_1.""FLATFILERECORDTYPE""='Repo Loan' OR ""SYS_ALIAS_1"".""FLATFILERECORDTYPE""='Security Loan'"
[NULL],13/06/2008 12:10,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_DEAL0B,[NULL],NON-UNIQUE,ANALYZED,1,59,58,1,1,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"SYS_ALIAS_1.""CALYPSOTRADEID""=""DC"".""CALYPSOTRADEID""",[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_GRD_BOOK,24,[NULL],ANALYZED,[NULL],60,44,2,2,1,31,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],[NULL]
[NULL],13/06/2008 12:10,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_GBA1,[NULL],NON-UNIQUE,ANALYZED,1,61,60,1,1,1,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"SYS_ALIAS_1.""CALYPSOBOOKNAME""=""GB"".""SYS_BOOK_POSTFIX""",[NULL]
[NULL],13/06/2008 12:10,[NULL],INDEX,RANGE SCAN,[NULL],CALYPSO_DEV10,IDX_CMPP_TMP_GO1,[NULL],NON-UNIQUE,ANALYZED,1,62,43,2,1,1,5,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],1,[NULL],"GB.""PARENT_ORGANISATION_ID""=""GO"".""ORGANISATION_ID""(+)",[NULL]
[NULL],13/06/2008 12:10,[NULL],TABLE ACCESS,BY INDEX ROWID,[NULL],CALYPSO_DEV10,CMPP_TMP_GRDW_SDM,23,[NULL],ANALYZED,[NULL],63,42,2,2,1,22,[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],[NULL],2,[NULL],[NULL],"GS.""COST_CENTRE"" IS NOT NULL"