[[BEGIN_OUTLINE_DATA]]
[[IGNORE_OPTIM_EMBEDDED_HINTS]]
[[OPTIMIZER_FEATURES_ENABLE('19.1.0')]]
[[DB_VERSION('19.1.0')]]
[[OPT_PARAM('_fix_control' '27268249:0')]]
[[ALL_ROWS]]
[[OUTLINE_LEAF(@"SEL$1")]]
[[OUTLINE_LEAF(@"SEL$D67CB2D9")]]
[[OUTLINE_LEAF(@"SEL$2")]]
[[OUTLINE_LEAF(@"SEL$4")]]
[[OUTLINE_LEAF(@"SEL$EC770CBC")]]
[[OUTLINE_LEAF(@"SEL$D67CB2D4")]]
[[OUTLINE_LEAF(@"SEL$0F3929D0")]]
[[OUTLINE_LEAF(@"SEL$EC770CBD")]]
[[OUTLINE_LEAF(@"SEL$D67CB2D5")]]
[[OUTLINE_LEAF(@"SEL$583AEB9A")]]
[[OUTLINE_LEAF(@"SET$CE5EDD29")]]
[[OUTLINE_LEAF(@"SEL$F61B142F")]]
[[MERGE(@"SEL$4119B633" >"SEL$FBFF865E")]]
[[OUTLINE_LEAF(@"SEL$EC770CBA")]]
[[MATERIALIZE(@"SEL$2")]]
[[OUTLINE_LEAF(@"SEL$D67CB2D2")]]
[[MATERIALIZE(@"SEL$1")]]
[[OUTLINE_LEAF(@"SEL$FED9171C")]]
[[OUTLINE_LEAF(@"SEL$EC770CBB")]]
[[OUTLINE_LEAF(@"SEL$D67CB2D3")]]
[[OUTLINE_LEAF(@"SEL$9FA593F3")]]
[[OUTLINE_LEAF(@"SET$CB26004B")]]
[[OUTLINE_LEAF(@"SEL$CE6FF33E")]]
[[MERGE(@"SEL$BBC9940B" >"SEL$9C1508C7")]]
[[OUTLINE_LEAF(@"SET$CD5DAC4C")]]
[[EXPAND_TABLE(@"SEL$3" "MDD"@"SEL$3")]]
[[OUTLINE_LEAF(@"SEL$ED6E2898")]]
[[OUTLINE(@"SEL$BDF4FBD0")]]
[[OUTLINE(@"SEL$D53A378B")]]
[[OUTLINE(@"SET$B37F4FFA")]]
[[FACTORIZE_JOIN(@"SET$9A7C2438"("edcp"@"SET$9A7C2438_2" "edcp"@"SET$9A7C2438_1"))]]
[[OUTLINE(@"SEL$FBFF865E")]]
[[OR_EXPAND(@"SET$CD5DAC4C_2" (1) (2))]]
[[OUTLINE(@"SEL$4119B633")]]
[[MERGE(@"SEL$0FA1E029" >"SEL$3B8FD131")]]
[[OUTLINE(@"SEL$E5EA116A")]]
[[OUTLINE(@"SEL$D6577BAE")]]
[[OUTLINE(@"SET$991F55A2")]]
[[FACTORIZE_JOIN(@"SET$136C5676"("edcp"@"SET$136C5676_2" "edcp"@"SET$136C5676_1"))]]
[[OUTLINE(@"SEL$9C1508C7")]]
[[OR_EXPAND(@"SET$CD5DAC4C_1" (1) (2))]]
[[OUTLINE(@"SEL$BBC9940B")]]
[[MERGE(@"SEL$AE92F862" >"SEL$AAA06791")]][[OUTLINE(@"SEL$3")]]
[[OUTLINE(@"SET$9A7C2438_1")]]
[[OUTLINE(@"SET$9A7C2438_2")]]
[[OUTLINE(@"SET$9A7C2438")]]
[[OUTLINE(@"SET$CD5DAC4C_2")]]
[[OUTLINE(@"SEL$3B8FD131")]]
[[OUTLINE(@"SEL$0FA1E029")]]
[[OUTLINE(@"SET$136C5676_1")]]
[[OUTLINE(@"SET$136C5676_2")]]
[[OUTLINE(@"SET$136C5676")]]
[[OUTLINE(@"SET$CD5DAC4C_1")]]
[[OUTLINE(@"SEL$AAA06791")]]
[[OUTLINE(@"SEL$AE92F862")]]
[[OUTLINE(@"SET$CD5DAC4C")]]
[[EXPAND_TABLE(@"SEL$3" "MDD"@"SEL$3")]]
[[NO_ACCESS(@"SEL$ED6E2898" "VW_TE_11"@"SEL$ED6E2898")]]
[[PQ_FILTER(@"SEL$ED6E2898" SERIAL)]]
[[NO_ACCESS(@"SEL$CE6FF33E" "VW_JF_SET$CB26004B"@"SEL$D6577BAE")]]
[[FULL(@"SEL$CE6FF33E" "edcp"@"SET$136C5676_2")]]
[[LEADING(@"SEL$CE6FF33E" "VW_JF_SET$CB26004B"@"SEL$D6577BAE" "edcp"@"SET$136C5676_2")]]
[[USE_HASH(@"SEL$CE6FF33E" "edcp"@"SET$136C5676_2")]]
[[NO_ACCESS(@"SEL$F61B142F" "VW_JF_SET$CE5EDD29"@"SEL$D53A378B")]]
[[FULL(@"SEL$F61B142F" "edcp"@"SET$9A7C2438_2")]]
[[LEADING(@"SEL$F61B142F" "VW_JF_SET$CE5EDD29"@"SEL$D53A378B" "edcp"@"SET$9A7C2438_2")]]
[[USE_HASH(@"SEL$F61B142F" "edcp"@"SET$9A7C2438_2")]]
[[NO_ACCESS(@"SEL$583AEB9A" "ref1"@"SET$9A7C2438_2")]]
[[FULL(@"SEL$583AEB9A" "MDD"@"SET$9A7C2438_2")]]
[[NO_ACCESS(@"SEL$583AEB9A" "ref2"@"SET$9A7C2438_2")]]
[[FULL(@"SEL$583AEB9A" "mtd"@"SET$9A7C2438_2")]]
[[LEADING(@"SEL$583AEB9A" "ref1"@"SET$9A7C2438_2" "MDD"@"SET$9A7C2438_2" "ref2"@"SET$9A7C2438_2" "mtd"@"SET$9A7C2438_2")]]
[[USE_NL(@"SEL$583AEB9A" "MDD"@"SET$9A7C2438_2")]]
[[USE_HASH(@"SEL$583AEB9A" "ref2"@"SET$9A7C2438_2")]]
[[USE_HASH(@"SEL$583AEB9A" "mtd"@"SET$9A7C2438_2")]]
[[PX_JOIN_FILTER(@"SEL$583AEB9A" "mtd"@"SET$9A7C2438_2")]]
[[SWAP_JOIN_INPUTS(@"SEL$583AEB9A" "ref2"@"SET$9A7C2438_2")]]
[[NO_ACCESS(@"SEL$0F3929D0" "ref1"@"SET$9A7C2438_1")]]
[[FULL(@"SEL$0F3929D0" "MDD"@"SET$9A7C2438_1")]]
[[NO_ACCESS(@"SEL$0F3929D0" "ref2"@"SET$9A7C2438_1")]]
[[FULL(@"SEL$0F3929D0" "mtd"@"SET$9A7C2438_1")]]
[[LEADING(@"SEL$0F3929D0" "ref1"@"SET$9A7C2438_1" "MDD"@"SET$9A7C2438_1" "ref2"@"SET$9A7C2438_1" "mtd"@"SET$9A7C2438_1")]]
[[USE_NL(@"SEL$0F3929D0" "MDD"@"SET$9A7C2438_1")]]
[[USE_HASH(@"SEL$0F3929D0" "ref2"@"SET$9A7C2438_1")]]
[[USE_HASH(@"SEL$0F3929D0" "mtd"@"SET$9A7C2438_1")]]
[[PX_JOIN_FILTER(@"SEL$0F3929D0" "mtd"@"SET$9A7C2438_1")]]
[[SWAP_JOIN_INPUTS(@"SEL$0F3929D0" "ref2"@"SET$9A7C2438_1")]]
[[FULL(@"SEL$EC770CBC" "T1"@"SEL$EC770CBC")]]
[[FULL(@"SEL$D67CB2D4" "T1"@"SEL$D67CB2D4")]]
[[FULL(@"SEL$EC770CBD" "T1"@"SEL$EC770CBD")]]
[[FULL(@"SEL$D67CB2D5" "T1"@"SEL$D67CB2D5")]]
[[NO_ACCESS(@"SEL$9FA593F3" "ref1"@"SET$136C5676_2")]]
[[FULL(@"SEL$9FA593F3" "MDD"@"SET$136C5676_2")]]
[[NO_ACCESS(@"SEL$9FA593F3" "ref2"@"SET$136C5676_2")]]
[[FULL(@"SEL$9FA593F3" "mtd"@"SET$136C5676_2")]]
[[LEADING(@"SEL$9FA593F3" "ref1"@"SET$136C5676_2" "MDD"@"SET$136C5676_2" "ref2"@"SET$136C5676_2" "mtd"@"SET$136C5676_2")]]
[[USE_NL(@"SEL$9FA593F3" "MDD"@"SET$136C5676_2")]]
[[USE_HASH(@"SEL$9FA593F3" "ref2"@"SET$136C5676_2")]]
[[USE_HASH(@"SEL$9FA593F3" "mtd"@"SET$136C5676_2")]]
[[PX_JOIN_FILTER(@"SEL$9FA593F3" "mtd"@"SET$136C5676_2")]]
[[SWAP_JOIN_INPUTS(@"SEL$9FA593F3" "ref2"@"SET$136C5676_2")]]
[[NO_ACCESS(@"SEL$FED9171C" "ref1"@"SET$136C5676_1")]]
[[FULL(@"SEL$FED9171C" "MDD"@"SET$136C5676_1")]]
[[NO_ACCESS(@"SEL$FED9171C" "ref2"@"SET$136C5676_1")]]
[[FULL(@"SEL$FED9171C" "mtd"@"SET$136C5676_1")]]
[[LEADING(@"SEL$FED9171C" "ref1"@"SET$136C5676_1" "MDD"@"SET$136C5676_1" "ref2"@"SET$136C5676_1" "mtd"@"SET$136C5676_1")]]
[[USE_NL(@"SEL$FED9171C" "MDD"@"SET$136C5676_1")]]
[[USE_HASH(@"SEL$FED9171C" "ref2"@"SET$136C5676_1")]]
[[USE_HASH(@"SEL$FED9171C" "mtd"@"SET$136C5676_1")]]
[[PX_JOIN_FILTER(@"SEL$FED9171C" "mtd"@"SET$136C5676_1")]]
[[SWAP_JOIN_INPUTS(@"SEL$FED9171C" "ref2"@"SET$136C5676_1")]]
[[FULL(@"SEL$EC770CBA" "T1"@"SEL$EC770CBA")]]
[[FULL(@"SEL$D67CB2D2" "T1"@"SEL$D67CB2D2")]]
[[FULL(@"SEL$EC770CBB" "T1"@"SEL$EC770CBB")]]
[[FULL(@"SEL$D67CB2D3" "T1"@"SEL$D67CB2D3")]]
[[FULL(@"SEL$4" "SPPEC"@"SEL$4")]]
[[NO_ACCESS(@"SEL$2" "ref1"@"SEL$2")]]
[[FULL(@"SEL$2" "bfid_stg"@"SEL$2")]]
[[FULL(@"SEL$2" "vcd_stg"@"SEL$2")]]
[[LEADING(@"SEL$2" "ref1"@"SEL$2" "bfid_stg"@"SEL$2" "vcd_stg"@"SEL$2")]]
[[USE_NL(@"SEL$2" "bfid_stg"@"SEL$2")]]
[[USE_HASH(@"SEL$2" "vcd_stg"@"SEL$2")]]
[[PX_JOIN_FILTER(@"SEL$2" "vcd_stg"@"SEL$2")]]
[[INDEX_RS_ASC(@"SEL$1" "essc"@"SEL$1" ("essc"."btid"))]]
[[FULL(@"SEL$D67CB2D9" "T1"@"SEL$D67CB2D9")]]
[[END_OUTLINE_DATA]]></hint></outline_data>