Created
January 13, 2015 02:44
-
-
Save sanglt/aa263c0fdfea21f4b767 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT /*+ NOPARALLEL bypass_recursive_check */ | |
| SP_ALIAS_190, | |
| ((CASE SP_ALIAS_191 | |
| WHEN 1 | |
| THEN 'PROVIDER::ALL_PROV::' | |
| WHEN 0 | |
| THEN 'PROVIDER::PROV::' | |
| ELSE NULL END) || SP_ALIAS_190) ALIAS_3553, | |
| SP_ALIAS_194, | |
| SP_ALIAS_191, | |
| SP_ALIAS_192, | |
| SP_ALIAS_193, | |
| SP_ALIAS_205, | |
| D4_AGE_GROUP_ET, | |
| ((CASE D4_AGE_GROUP_GID | |
| WHEN 1 | |
| THEN 'AGE_GROUP::ALL_AGE_GRP::' | |
| WHEN 0 | |
| THEN 'AGE_GROUP::AGE_GRP::' | |
| ELSE NULL END) || D4_AGE_GROUP_ET) ALIAS_3554, | |
| D4_AGE_GROUP_HierarchyNumber, | |
| D4_AGE_GROUP_GID, | |
| D4_AGE_GROUP_ALL_AGE_GRP, | |
| D4_AGE_GROUP_AGE_GRP, | |
| T218.C2 D12_PROCEDURE_ET, | |
| ((CASE T218.C3 | |
| WHEN 3 | |
| THEN 'PROCEDURE::ALL_PROC::' | |
| WHEN 1 | |
| THEN 'PROCEDURE::PROC_GRP::' | |
| WHEN 0 | |
| THEN 'PROCEDURE::PROC::' | |
| ELSE NULL END) || T218.C2) ALIAS_3555, | |
| T218.C7 D12_PROCEDURE_HierarchyNumber, | |
| T218.C3 D12_PROCEDURE_GID, | |
| T218.C4 D12_PROCEDURE_ALL_PROC, | |
| T218.C5 D12_PROCEDURE_PROC_GRP, | |
| T218.C6 D12_PROCEDURE_PROC, | |
| T217.C2 D20_DIAGNOSIS_ET, | |
| ((CASE T217.C3 | |
| WHEN 3 | |
| THEN 'D2GROUP::ALL_D2GRP::' | |
| WHEN 1 | |
| THEN 'D2GROUP::D2GRP::' | |
| WHEN 0 | |
| THEN 'D2GROUP::ICD9::' | |
| ELSE NULL END) || T217.C2) ALIAS_3556, | |
| T217.C12 D20_DIAGNOSIS_HierarchyNumber, | |
| T217.C3 D20_DIAGNOSIS_GID, | |
| T217.C4 D20_DIAGNOSIS_ALL_D2GRP, | |
| T217.C5 D20_DIAGNOSIS_D2GRP, | |
| T217.C6 D20_DIAGNOSIS_ICD9, | |
| T217.C7 D20_DIAGNOSIS_ALL_ACC, | |
| T217.C8 D20_DIAGNOSIS_ACC, | |
| T217.C9 D20_DIAGNOSIS_CC, | |
| T217.C10 D20_DIAGNOSIS_DXGRP, | |
| T217.C11 D20_ALIAS5, | |
| D28_POS_ET, | |
| ((CASE D28_POS_GID | |
| WHEN 1 | |
| THEN 'POS::ALL_POS::' | |
| WHEN 0 | |
| THEN 'POS::POS::' | |
| ELSE NULL END) || D28_POS_ET) ALIAS_3557, | |
| D28_POS_HierarchyNumber, | |
| D28_POS_GID, | |
| D28_POS_ALL_POS, | |
| D28_POS_POS, | |
| T216.C2 D36_SPECIALTY_ET, | |
| ((CASE T216.C3 | |
| WHEN 1 | |
| THEN 'SPECIALTY::ALL_SPEC::' | |
| WHEN 0 | |
| THEN 'SPECIALTY::SPEC::' | |
| ELSE NULL END) || T216.C2) ALIAS_3558, | |
| T216.C6 D36_SPECIALTY_HierarchyNumber, | |
| T216.C3 D36_SPECIALTY_GID, | |
| T216.C4 D36_SPECIALTY_ALL_SPEC, | |
| T216.C5 D36_SPECIALTY_SPEC, | |
| D44_INCR_PAID_ET, | |
| ((CASE D44_INCR_PAID_GID | |
| WHEN 0 | |
| THEN 'INCR_PAID::INCR_PAID::' | |
| ELSE NULL END) || D44_INCR_PAID_ET) ALIAS_3559, | |
| D44_INCR_PAID_HierarchyNumber, | |
| D44_INCR_PAID_GID, | |
| D44_INCR_PAID_INCR_PAID, | |
| D52_BUSINESS_L_ET, | |
| ((CASE D52_BUSINESS_L_GID | |
| WHEN 15 | |
| THEN 'BUSINESS_LEVEL::ALL_BL::' | |
| WHEN 7 | |
| THEN 'BUSINESS_LEVEL::LVL1::' | |
| WHEN 3 | |
| THEN 'BUSINESS_LEVEL::LVL2::' | |
| WHEN 1 | |
| THEN 'BUSINESS_LEVEL::LVL3::' | |
| WHEN 0 | |
| THEN 'BUSINESS_LEVEL::LVL4::' | |
| ELSE NULL END) || D52_BUSINESS_L_ET) ALIAS_3560, | |
| ALIAS_R68, | |
| D52_BUSINESS_L_GID, | |
| D52_BUSINESS_L_ALL_BL, | |
| D52_BUSINESS_L_LVL1, | |
| D52_BUSINESS_L_LVL2, | |
| D52_BUSINESS_L_LVL3, | |
| D52_BUSINESS_L_LVL4, | |
| COUNT(*) OVER () ALIAS_3561 | |
| FROM | |
| ( | |
| SELECT | |
| SP_D61_DIAGNOSIS_ET, | |
| SP_D61_DIAGNOSIS_GID, | |
| SP_D63_PROCEDURE_ET, | |
| SP_D63_PROCEDURE_GID, | |
| SP_D65_PROVIDER_ET, | |
| SP_D67_BUSINESS_L_ET, | |
| SP_D67_BUSINESS_L_GID, | |
| SP_D69_SPECIALTY_ET, | |
| SP_D69_SPECIALTY_GID, | |
| SP_D73_POS_ET, | |
| SP_D73_POS_GID, | |
| SP_D75_AGE_GROUP_ET, | |
| SP_D75_AGE_GROUP_GID, | |
| SP_D77_INCR_PAID_ET, | |
| SP_D77_INCR_PAID_GID, | |
| SP_ALIAS_190, | |
| SP_ALIAS_194, | |
| SP_ALIAS_191, | |
| SP_ALIAS_192, | |
| SP_ALIAS_193, | |
| SP_ALIAS_262, | |
| SP_ALIAS_256, | |
| SP_ALIAS_257, | |
| SP_ALIAS_205 | |
| FROM | |
| ( | |
| SELECT | |
| CAST (NULL AS NUMBER) ALIAS_256, | |
| CAST (NULL AS NUMBER) ALIAS_257, | |
| ALIAS_169, | |
| ALIAS_190, | |
| ALIAS_191, | |
| ALIAS_192, | |
| ALIAS_193, | |
| ALIAS_194, | |
| ALIAS_205, | |
| C59_M_TIME_AWMEDICA_MED_PAIDA, | |
| D61_DIAGNOSIS_ET, | |
| D61_DIAGNOSIS_HierarchyNumber, | |
| D61_DIAGNOSIS_GID, | |
| D63_PROCEDURE_ET, | |
| D63_PROCEDURE_HierarchyNumber, | |
| D63_PROCEDURE_GID, | |
| D65_PROVIDER_ET, | |
| D65_PROVIDER_GID, | |
| D67_BUSINESS_L_ET, | |
| ALIAS_R81, | |
| D67_BUSINESS_L_GID, | |
| D69_SPECIALTY_ET, | |
| D69_SPECIALTY_HierarchyNumber, | |
| D69_SPECIALTY_GID, | |
| D71_TIME_ET, | |
| D71_TIME_HierarchyNumber, | |
| D71_TIME_GID, | |
| D73_POS_ET, | |
| D73_POS_HierarchyNumber, | |
| D73_POS_GID, | |
| D75_AGE_GROUP_ET, | |
| D75_AGE_GROUP_HierarchyNumber, | |
| D75_AGE_GROUP_GID, | |
| D77_INCR_PAID_ET, | |
| D77_INCR_PAID_HierarchyNumber, | |
| D77_INCR_PAID_GID, | |
| ALIAS_262 | |
| FROM | |
| ( | |
| SELECT | |
| T139.C2 ALIAS_169, | |
| T139.C3 ALIAS_190, | |
| T139.C4 ALIAS_191, | |
| T139.C5 ALIAS_192, | |
| T139.C6 ALIAS_193, | |
| T139.C7 ALIAS_194, | |
| T139.C8 ALIAS_205, | |
| ALIAS_3589 C59_M_TIME_AWMEDICA_MED_PAIDA, | |
| D61_DIAGNOSIS_ET D61_DIAGNOSIS_ET, | |
| ALIAS_3588 D61_DIAGNOSIS_HierarchyNumber, | |
| D61_DIAGNOSIS_GID D61_DIAGNOSIS_GID, | |
| D63_PROCEDURE_ET D63_PROCEDURE_ET, | |
| ALIAS_3588 D63_PROCEDURE_HierarchyNumber, | |
| D63_PROCEDURE_GID D63_PROCEDURE_GID, | |
| D65_PROVIDER_ET D65_PROVIDER_ET, | |
| D65_PROVIDER_GID D65_PROVIDER_GID, | |
| D67_BUSINESS_L_ET D67_BUSINESS_L_ET, | |
| ALIAS_3588 ALIAS_R81, | |
| D67_BUSINESS_L_GID D67_BUSINESS_L_GID, | |
| D69_SPECIALTY_ET D69_SPECIALTY_ET, | |
| ALIAS_3588 D69_SPECIALTY_HierarchyNumber, | |
| D69_SPECIALTY_GID D69_SPECIALTY_GID, | |
| D71_TIME_ET D71_TIME_ET, | |
| ALIAS_3588 D71_TIME_HierarchyNumber, | |
| D71_TIME_GID D71_TIME_GID, | |
| D73_POS_ET D73_POS_ET, | |
| ALIAS_3588 D73_POS_HierarchyNumber, | |
| D73_POS_GID D73_POS_GID, | |
| D75_AGE_GROUP_ET D75_AGE_GROUP_ET, | |
| ALIAS_3588 D75_AGE_GROUP_HierarchyNumber, | |
| D75_AGE_GROUP_GID D75_AGE_GROUP_GID, | |
| D77_INCR_PAID_ET D77_INCR_PAID_ET, | |
| ALIAS_3588 D77_INCR_PAID_HierarchyNumber, | |
| D77_INCR_PAID_GID D77_INCR_PAID_GID, | |
| ROW_NUMBER() OVER ( | |
| PARTITION BY | |
| D61_DIAGNOSIS_ET, | |
| D61_DIAGNOSIS_GID, | |
| ALIAS_3588, | |
| D63_PROCEDURE_ET, | |
| D63_PROCEDURE_GID, | |
| ALIAS_3588, | |
| D67_BUSINESS_L_ET, | |
| D67_BUSINESS_L_GID, | |
| ALIAS_3588, | |
| D69_SPECIALTY_ET, | |
| D69_SPECIALTY_GID, | |
| ALIAS_3588, | |
| D71_TIME_ET, | |
| D71_TIME_GID, | |
| ALIAS_3588, | |
| D73_POS_ET, | |
| D73_POS_GID, | |
| ALIAS_3588, | |
| D75_AGE_GROUP_ET, | |
| D75_AGE_GROUP_GID, | |
| ALIAS_3588, | |
| D77_INCR_PAID_ET, | |
| D77_INCR_PAID_GID, | |
| ALIAS_3588 | |
| ORDER BY | |
| ALIAS_3589 DESC NULLS FIRST , | |
| T139.C5 ASC NULLS FIRST , | |
| T139.C6 ASC NULLS FIRST ) ALIAS_262 | |
| FROM | |
| (SELECT ROW# R, C1, C2, C3, C4, C5, C6, C7, C8 FROM TABLE(OLAPRC_TABLE(1, '107:8104'))) T139, | |
| ( | |
| SELECT | |
| D61_DIAGNOSIS_ET, | |
| 0 ALIAS_3588, | |
| D61_DIAGNOSIS_GID, | |
| D63_PROCEDURE_ET, | |
| D63_PROCEDURE_GID, | |
| D65_PROVIDER_ET, | |
| D65_PROVIDER_GID, | |
| D67_BUSINESS_L_ET, | |
| D67_BUSINESS_L_GID, | |
| D69_SPECIALTY_ET, | |
| D69_SPECIALTY_GID, | |
| D71_TIME_ET, | |
| D71_TIME_GID, | |
| D73_POS_ET, | |
| D73_POS_GID, | |
| D75_AGE_GROUP_ET, | |
| D75_AGE_GROUP_GID, | |
| D77_INCR_PAID_ET, | |
| D77_INCR_PAID_GID, | |
| ALIAS_3589 | |
| FROM | |
| ( | |
| SELECT | |
| AW430.AW430_MEASURE_120 ALIAS_3589, | |
| AW430.AW430_ET_COL_107 D61_DIAGNOSIS_ET, | |
| AW430.AW430_GID_COL_109 D61_DIAGNOSIS_GID, | |
| AW430.AW430_ET_COL_82 D63_PROCEDURE_ET, | |
| AW430.AW430_GID_COL_84 D63_PROCEDURE_GID, | |
| AW430.AW430_ET_COL_74 D65_PROVIDER_ET, | |
| AW430.AW430_GID_COL_76 D65_PROVIDER_GID, | |
| AW430.AW430_ET_COL_17 D67_BUSINESS_L_ET, | |
| AW430.AW430_GID_COL_19 D67_BUSINESS_L_GID, | |
| AW430.AW430_ET_COL_99 D69_SPECIALTY_ET, | |
| AW430.AW430_GID_COL_101 D69_SPECIALTY_GID, | |
| AW430.AW430_ET_COL_1 D71_TIME_ET, | |
| AW430.AW430_GID_COL_3 D71_TIME_GID, | |
| AW430.AW430_ET_COL_91 D73_POS_ET, | |
| AW430.AW430_GID_COL_93 D73_POS_GID, | |
| AW430.AW430_ET_COL_28 D75_AGE_GROUP_ET, | |
| AW430.AW430_GID_COL_30 D75_AGE_GROUP_GID, | |
| AW430.AW430_ET_COL_36 D77_INCR_PAID_ET, | |
| AW430.AW430_GID_COL_38 D77_INCR_PAID_GID | |
| FROM | |
| (SELECT SYS$DV.* FROM ((SELECT * FROM TABLE(OLAP_TABLE('TIME_AW.D2HA_V1 duration session', | |
| NULL, | |
| NULL, | |
| ' MSR AW430_MEASURE_120 AS FLOAT FROM MEDICAL_MED_PAIDAMT DMNS AW430_ET_COL_107 AS VARCHAR2(100) FROM DIAGNOSIS WITH HRR DIAGNOSIS_PARENTREL(DIAGNOSIS_HIERLIST ''D2GROUP'') INH DIAGNOSIS_INHIER GID AW430_GID_COL_109 AS NUMBER FROM DIAGNOSIS_GID DMNS AW430_ET_COL_82 AS VARCHAR2(100) FROM PROCEDURE WITH HRR PROCEDURE_PARENTREL(PROCEDURE_HIERLIST ''PROCEDURE'') INH PROCEDURE_INHIER GID AW430_GID_COL_84 AS NUMBER FROM PROCEDURE_GID DMNS AW430_ET_COL_74 AS VARCHAR2(100) FROM PROVIDER WITH HRR PROVIDER_PARENTREL(PROVIDER_HIERLIST ''PROVIDER'') INH PROVIDER_INHIER GID AW430_GID_COL_76 AS NUMBER FROM PROVIDER_GID DMNS AW430_ET_COL_17 AS VARCHAR2(100) FROM BUSINESS_LEVEL WITH HRR BUSINESS_LEVEL_PARENTREL(BUSINESS_LEVEL_HIERLIST ''BUSINESS_LEVEL'') INH BUSINESS_LEVEL_INHIER GID AW430_GID_COL_19 AS NUMBER FROM BUSINESS_LEVEL_GID DMNS AW430_ET_COL_99 AS VARCHAR2(100) FROM SPECIALTY WITH HRR SPECIALTY_PARENTREL(SPECIALTY_HIERLIST ''SPECIALTY'') INH SPECIALTY_INHIER GID AW430_GID_COL_101 AS NUMBER FROM SPECIALTY_GID DMNS AW430_ET_COL_1 AS VARCHAR2(100) FROM TIME WITH HRR TIME_PARENTREL(TIME_HIERLIST ''CALENDER'') INH TIME_INHIER GID AW430_GID_COL_3 AS NUMBER FROM TIME_GID DMNS AW430_ET_COL_91 AS VARCHAR2(100) FROM POS WITH HRR POS_PARENTREL(POS_HIERLIST ''POS'') INH POS_INHIER GID AW430_GID_COL_93 AS NUMBER FROM POS_GID DMNS AW430_ET_COL_28 AS VARCHAR2(100) FROM AGE_GROUP WITH HRR AGE_GROUP_PARENTREL(AGE_GROUP_HIERLIST ''AGE_GROUP'') INH AGE_GROUP_INHIER GID AW430_GID_COL_30 AS NUMBER FROM AGE_GROUP_GID DMNS AW430_ET_COL_36 AS VARCHAR2(100) FROM INCR_PAID WITH HRR INCR_PAID_PARENTREL(INCR_PAID_HIERLIST ''INCR_PAID'') INH INCR_PAID_INHIER GID AW430_GID_COL_38 AS NUMBER FROM INCR_PAID_GID')) SQL MODEL DIMENSION BY(AW430_ET_COL_107, | |
| AW430_GID_COL_109, | |
| AW430_ET_COL_82, | |
| AW430_GID_COL_84, | |
| AW430_ET_COL_74, | |
| AW430_GID_COL_76, | |
| AW430_ET_COL_17, | |
| AW430_GID_COL_19, | |
| AW430_ET_COL_99, | |
| AW430_GID_COL_101, | |
| AW430_ET_COL_1, | |
| AW430_GID_COL_3, | |
| AW430_ET_COL_91, | |
| AW430_GID_COL_93, | |
| AW430_ET_COL_28, | |
| AW430_GID_COL_30, | |
| AW430_ET_COL_36, | |
| AW430_GID_COL_38) MEASURES(AW430_MEASURE_120) UNIQUE SINGLE REFERENCE RULES UPDATE SEQUENTIAL ORDER ()) SYS$DV)) AW430 ) | |
| V234 | |
| WHERE | |
| ((D61_DIAGNOSIS_GID = 3) | |
| AND (D63_PROCEDURE_GID = 3) | |
| AND (NOT ((D65_PROVIDER_ET) IN (('ALL_PROV_NOTAPP') , ('PROV_NOTAPP') ) ) ) | |
| AND (D67_BUSINESS_L_GID = 15) | |
| AND (D69_SPECIALTY_GID = 1) | |
| AND ((D71_TIME_ET) = ('CAL_ALL_YR_1') ) | |
| AND (D73_POS_GID = 1) | |
| AND (D75_AGE_GROUP_GID = 1) | |
| AND (1 = 1)) ) | |
| C59 | |
| WHERE | |
| ((NOT (((CASE | |
| WHEN (ALIAS_3589 > 0) | |
| THEN ALIAS_3589 | |
| ELSE -1 END) ) = (-1.000000) ) ) | |
| AND (NOT ((T139.C3) IN (('ALL_PROV_NOTAPP') , ('PROV_NOTAPP') ) ) ) | |
| AND (SYS_OP_MAP_NONNULL(D65_PROVIDER_GID) = SYS_OP_MAP_NONNULL(T139.C4) ) | |
| AND (SYS_OP_MAP_NONNULL(D65_PROVIDER_ET) = SYS_OP_MAP_NONNULL(T139.C3) ) | |
| AND ((D65_PROVIDER_ET) IN (('ALL_PROV_1') , ('PROV_1000001') , ('PROV_1000002') , ('PROV_1000003') , ('PROV_1000004') , ('PROV_1000005') , ('PROV_1000006') , ('PROV_1000007') , ('PROV_1000008') , ('PROV_1000009') , ('PROV_1000010') , ('PROV_1000011') , ('PROV_1000012') , ('PROV_1000013') , ('PROV_1000014') , ('PROV_1000015') , ('PROV_1000016') , ('PROV_1000017') , ('PROV_1000018') , ('PROV_1000019') , ('PROV_1000020') , ('PROV_1000021') , ('PROV_1000022') , ('PROV_1000023') , ('PROV_1000024') , | |
| ('PROV_1000025') , ('PROV_1000026') , ('PROV_1000027') , ('PROV_1000028') , ('PROV_1000029') , ('PROV_1000030') , ('PROV_1000031') , ('PROV_1000032') , ('PROV_1000033') , ('PROV_1000034') , ('PROV_1000035') , ('PROV_1000036') , ('PROV_1000037') , ('PROV_1000038') , ('PROV_1000039') , ('PROV_1000040') , ('PROV_1000041') , ('PROV_1000042') , ('PROV_1000043') , ('PROV_1000044') , ('PROV_1000045') , ('PROV_1000046') , ('PROV_1000047') , ('PROV_1000048') , ('PROV_1000049') , | |
| ('PROV_1000050') , ('PROV_1000051') , ('PROV_1000052') , ('PROV_1000053') , ('PROV_1000054') , ('PROV_1000055') , ('PROV_1000056') , ('PROV_1000057') , ('PROV_1000058') , ('PROV_1000059') , ('PROV_1000060') , ('PROV_1000061') , ('PROV_1000062') , ('PROV_1000063') , ('PROV_1000064') , ('PROV_1000065') , ('PROV_1000066') , ('PROV_1000067') , ('PROV_1000068') , ('PROV_1000069') , ('PROV_1000070') , ('PROV_1000071') , ('PROV_1000072') , ('PROV_1000073') , ('PROV_1000074') , | |
| ('PROV_1000075') , ('PROV_1000076') , ('PROV_1000077') , ('PROV_1000078') , ('PROV_1000079') , ('PROV_1000080') , ('PROV_1000081') , ('PROV_1000082') , ('PROV_1000083') , ('PROV_1000084') , ('PROV_1000085') , ('PROV_1000086') , ('PROV_1000087') , ('PROV_1000088') , ('PROV_1000089') , ('PROV_1000090') , ('PROV_1000091') , ('PROV_1000092') , ('PROV_1000093') , ('PROV_1000094') , ('PROV_1000095') , ('PROV_1000096') , ('PROV_1000097') , ('PROV_1000098') , ('PROV_1000099') , | |
| ('PROV_1000100') , ('PROV_1000101') , ('PROV_1000102') , ('PROV_1000103') , ('PROV_1000104') , ('PROV_1000105') , ('PROV_1000106') , ('PROV_1000107') , ('PROV_1000108') , ('PROV_1000109') , ('PROV_1000110') , ('PROV_1000111') , ('PROV_1000112') , ('PROV_1000113') , ('PROV_1000114') , ('PROV_1000115') , ('PROV_1000116') , ('PROV_1000117') , ('PROV_1000118') , ('PROV_1000119') , ('PROV_1000120') , ('PROV_1000121') , ('PROV_1000122') , ('PROV_1000123') , ('PROV_1000124') , | |
| ('PROV_1000125') , ('PROV_1000126') , ('PROV_1000127') , ('PROV_1000128') , ('PROV_1000129') , ('PROV_1000130') , ('PROV_1000131') , ('PROV_1000132') , ('PROV_1000133') , ('PROV_1000134') , ('PROV_1000135') , ('PROV_1000136') , ('PROV_1000137') , ('PROV_1000138') , ('PROV_1000139') , ('PROV_1000140') , ('PROV_1000141') , ('PROV_1000142') , ('PROV_1000143') , ('PROV_1000144') , ('PROV_1000145') , ('PROV_1000146') , ('PROV_1000147') , ('PROV_1000148') , ('PROV_1000149') , | |
| ('PROV_1000150') , ('PROV_1000151') , ('PROV_1000152') , ('PROV_1000153') , ('PROV_1000154') , ('PROV_1000155') , ('PROV_1000156') , ('PROV_1000157') , ('PROV_1000158') , ('PROV_1000159') , ('PROV_1000160') , ('PROV_1000161') , ('PROV_1000162') , ('PROV_1000163') , ('PROV_1000164') , ('PROV_1000165') , ('PROV_1000166') , ('PROV_1000167') , ('PROV_1000168') , ('PROV_1000169') , ('PROV_1000170') , ('PROV_1000171') , ('PROV_1000172') , ('PROV_1000173') , ('PROV_1000174') , | |
| ('PROV_1000175') , ('PROV_1000176') , ('PROV_1000177') , ('PROV_1000178') , ('PROV_1000179') , ('PROV_1000180') , ('PROV_1000181') , ('PROV_1000182') , ('PROV_1000183') , ('PROV_1000184') , ('PROV_1000185') , ('PROV_1000186') , ('PROV_1000187') , ('PROV_1000188') , ('PROV_1000189') , ('PROV_1000190') , ('PROV_1000191') , ('PROV_1000192') , ('PROV_1000193') , ('PROV_1000194') , ('PROV_1000195') , ('PROV_1000196') , ('PROV_1000197') , ('PROV_1000198') , ('PROV_1000199') , | |
| ('PROV_1000200') , ('PROV_1000201') , ('PROV_1000202') , ('PROV_1000203') , ('PROV_1000204') , ('PROV_1000205') , ('PROV_1000206') , ('PROV_1000207') , ('PROV_1000208') , ('PROV_1000209') , ('PROV_1000210') , ('PROV_1000211') , ('PROV_1000212') , ('PROV_1000213') , ('PROV_1000214') , ('PROV_1000215') , ('PROV_1000216') , ('PROV_1000217') , ('PROV_1000218') , ('PROV_1000219') , ('PROV_1000220') , ('PROV_1000221') , ('PROV_1000222') , ('PROV_1000223') , ('PROV_1000224') , | |
| ('PROV_1000225') , ('PROV_1000226') , ('PROV_1000227') , ('PROV_1000228') , ('PROV_1000229') , ('PROV_1000230') , ('PROV_1000231') , ('PROV_1000232') , ('PROV_1000233') , ('PROV_1000234') , ('PROV_1000235') , ('PROV_1000236') , ('PROV_1000237') , ('PROV_1000238') , ('PROV_1000239') , ('PROV_1000240') , ('PROV_1000241') , ('PROV_1000242') , ('PROV_1000243') , ('PROV_1000244') , ('PROV_1000245') , ('PROV_1000246') , ('PROV_1000247') , ('PROV_1000248') , ('PROV_1000249') , | |
| ('PROV_1000250') , ('PROV_1000251') , ('PROV_1000252') , ('PROV_1000253') , ('PROV_1000254') , ('PROV_1000255') , ('PROV_1000256') , ('PROV_1000257') , ('PROV_1000258') , ('PROV_1000259') , ('PROV_1000260') , ('PROV_1000261') , ('PROV_1000262') , ('PROV_1000263') , ('PROV_1000264') , ('PROV_1000265') , ('PROV_1000266') , ('PROV_1000267') , ('PROV_1000268') , ('PROV_1000269') , ('PROV_1000270') , ('PROV_1000271') , ('PROV_1000272') , ('PROV_1000273') , ('PROV_1000274') , | |
| ('PROV_1000275') , ('PROV_1000276') , ('PROV_1000277') , ('PROV_1000278') , ('PROV_1000279') , ('PROV_1000280') , ('PROV_1000281') , ('PROV_1000282') , ('PROV_1000283') , ('PROV_1000284') , ('PROV_1000285') , ('PROV_1000286') , ('PROV_1000287') , ('PROV_1000288') , ('PROV_1000289') , ('PROV_1000290') , ('PROV_1000291') , ('PROV_1000292') , ('PROV_1000293') , ('PROV_1000294') , ('PROV_1000295') , ('PROV_1000296') , ('PROV_1000297') , ('PROV_1000298') , ('PROV_1000299') , | |
| ('PROV_1000300') , ('PROV_1000301') , ('PROV_1000302') , ('PROV_1000303') , ('PROV_1000304') , ('PROV_1000305') , ('PROV_1000306') , ('PROV_1000307') , ('PROV_1000308') , ('PROV_1000309') , ('PROV_1000310') , ('PROV_1000311') , ('PROV_1000312') , ('PROV_1000313') , ('PROV_1000314') , ('PROV_1000315') , ('PROV_1000316') , ('PROV_1000317') , ('PROV_1000318') , ('PROV_1000319') , ('PROV_1000320') , ('PROV_1000321') , ('PROV_1000322') , ('PROV_1000323') , ('PROV_1000324') , | |
| ('PROV_1000325') , ('PROV_1000326') , ('PROV_1000327') , ('PROV_1000328') , ('PROV_1000329') , ('PROV_1000330') , ('PROV_1000331') , ('PROV_1000332') , ('PROV_1000333') , ('PROV_1000334') , ('PROV_1000335') , ('PROV_1000336') , ('PROV_1000337') , ('PROV_1000338') , ('PROV_1000339') , ('PROV_1000340') , ('PROV_1000341') , ('PROV_1000342') , ('PROV_1000343') , ('PROV_1000344') , ('PROV_1000345') , ('PROV_1000346') , ('PROV_1000347') , ('PROV_1000348') , ('PROV_1000349') , | |
| ('PROV_1000350') , ('PROV_1000351') , ('PROV_1000352') , ('PROV_1000353') , ('PROV_1000354') , ('PROV_1000355') , ('PROV_1000356') , ('PROV_1000357') , ('PROV_1000358') , ('PROV_1000359') , ('PROV_1000360') , ('PROV_1000361') , ('PROV_1000362') , ('PROV_1000363') , ('PROV_1000364') , ('PROV_1000365') , ('PROV_1000366') , ('PROV_1000367') , ('PROV_1000368') , ('PROV_1000369') , ('PROV_1000370') , ('PROV_1000371') , ('PROV_1000372') , ('PROV_1000373') , ('PROV_1000374') , | |
| ('PROV_1000375') , ('PROV_1000376') , ('PROV_1000377') , ('PROV_1000378') , ('PROV_1000379') , ('PROV_1000380') , ('PROV_1000381') , ('PROV_1000382') , ('PROV_1000383') , ('PROV_1000384') , ('PROV_1000385') , ('PROV_1000386') , ('PROV_1000387') , ('PROV_1000388') , ('PROV_1000389') , ('PROV_1000390') , ('PROV_1000391') , ('PROV_1000392') , ('PROV_1000393') , ('PROV_1000394') , ('PROV_1000395') , ('PROV_1000396') , ('PROV_1000397') , ('PROV_1000398') , ('PROV_1000399') , | |
| ('PROV_1000400') , ('PROV_1000401') , ('PROV_1000402') , ('PROV_1000403') , ('PROV_1000404') , ('PROV_1000405') , ('PROV_1000406') , ('PROV_1000407') , ('PROV_1000408') , ('PROV_1000409') , ('PROV_1000410') , ('PROV_1000411') , ('PROV_1000412') , ('PROV_1000413') , ('PROV_1000414') , ('PROV_1000415') , ('PROV_1000416') , ('PROV_1000417') , ('PROV_1000418') , ('PROV_1000419') , ('PROV_1000420') , ('PROV_1000421') , ('PROV_1000422') , ('PROV_1000423') , ('PROV_1000424') , | |
| ('PROV_1000425') , ('PROV_1000426') , ('PROV_1000427') , ('PROV_1000428') , ('PROV_1000429') , ('PROV_1000430') , ('PROV_1000431') , ('PROV_1000432') , ('PROV_1000433') , ('PROV_1000434') , ('PROV_1000435') , ('PROV_1000436') , ('PROV_1000437') , ('PROV_1000438') , ('PROV_1000439') , ('PROV_1000440') , ('PROV_1000441') , ('PROV_1000442') , ('PROV_1000443') , ('PROV_1000444') , ('PROV_1000445') , ('PROV_1000446') , ('PROV_1000447') , ('PROV_1000448') , ('PROV_1000449') , | |
| ('PROV_1000450') , ('PROV_1000451') , ('PROV_1000452') , ('PROV_1000453') , ('PROV_1000454') , ('PROV_1000455') , ('PROV_1000456') , ('PROV_1000457') , ('PROV_1000458') , ('PROV_1000459') , ('PROV_1000460') , ('PROV_1000461') , ('PROV_1000462') , ('PROV_1000463') , ('PROV_1000464') , ('PROV_1000465') , ('PROV_1000466') , ('PROV_1000467') , ('PROV_1000468') , ('PROV_1000469') , ('PROV_1000470') , ('PROV_1000471') , ('PROV_1000472') , ('PROV_1000473') , ('PROV_1000474') , | |
| ('PROV_1000475') , ('PROV_1000476') , ('PROV_1000477') , ('PROV_1000478') , ('PROV_1000479') , ('PROV_1000480') , ('PROV_1000481') , ('PROV_1000482') , ('PROV_1000483') , ('PROV_1000484') , ('PROV_1000485') , ('PROV_1000486') , ('PROV_1000487') , ('PROV_1000488') , ('PROV_1000489') , ('PROV_1000490') , ('PROV_1000491') , ('PROV_1000492') , ('PROV_1000493') , ('PROV_1000494') , ('PROV_1000495') , ('PROV_1000496') , ('PROV_1000497') , ('PROV_1000498') , ('PROV_1000499') , | |
| ('PROV_1000500') , ('PROV_1000501') , ('PROV_1000502') , ('PROV_1000503') , ('PROV_1000504') , ('PROV_1000505') , ('PROV_1000506') , ('PROV_1000507') , ('PROV_1000508') , ('PROV_1000509') , ('PROV_1000510') , ('PROV_1000511') , ('PROV_1000512') , ('PROV_1000513') , ('PROV_1000514') , ('PROV_1000515') , ('PROV_1000516') , ('PROV_1000517') , ('PROV_1000518') , ('PROV_1000519') , ('PROV_1000520') , ('PROV_1000521') , ('PROV_1000522') , ('PROV_1000523') , ('PROV_1000524') , | |
| ('PROV_1000525') , ('PROV_1000526') , ('PROV_1000527') , ('PROV_1000528') , ('PROV_1000529') , ('PROV_1000530') , ('PROV_1000531') , ('PROV_1000532') , ('PROV_1000533') , ('PROV_1000534') , ('PROV_1000535') , ('PROV_1000536') , ('PROV_1000537') , ('PROV_1000538') , ('PROV_1000539') , ('PROV_1000540') , ('PROV_1000541') , ('PROV_1000542') , ('PROV_1000543') , ('PROV_1000544') , ('PROV_1000545') , ('PROV_1000546') , ('PROV_1000547') , ('PROV_1000548') , ('PROV_1000549') , | |
| ('PROV_1000550') , ('PROV_1000551') , ('PROV_1000552') , ('PROV_1000553') , ('PROV_1000554') , ('PROV_1000555') , ('PROV_1000556') , ('PROV_1000557') , ('PROV_1000558') , ('PROV_1000559') , ('PROV_1000560') , ('PROV_1000561') , ('PROV_1000562') , ('PROV_1000563') , ('PROV_1000564') , ('PROV_1000565') , ('PROV_1000566') , ('PROV_1000567') , ('PROV_1000568') , ('PROV_1000569') , ('PROV_1000570') , ('PROV_1000571') , ('PROV_1000572') , ('PROV_1000573') , ('PROV_1000574') , | |
| ('PROV_1000575') , ('PROV_1000576') , ('PROV_1000577') , ('PROV_1000578') , ('PROV_1000579') , ('PROV_1000580') , ('PROV_1000581') , ('PROV_1000582') , ('PROV_1000583') , ('PROV_1000584') , ('PROV_1000585') , ('PROV_1000586') , ('PROV_1000587') , ('PROV_1000588') , ('PROV_1000589') , ('PROV_1000590') , ('PROV_1000591') , ('PROV_1000592') , ('PROV_1000593') , ('PROV_1000594') , ('PROV_1000595') , ('PROV_1000596') , ('PROV_1000597') , ('PROV_1000598') , ('PROV_1000599') , | |
| ('PROV_1000600') , ('PROV_1000601') , ('PROV_1000602') , ('PROV_1000603') , ('PROV_1000604') , ('PROV_1000605') , ('PROV_1000606') , ('PROV_1000607') , ('PROV_1000608') , ('PROV_1000609') , ('PROV_1000610') , ('PROV_1000611') , ('PROV_1000612') , ('PROV_1000613') , ('PROV_1000614') , ('PROV_1000615') , ('PROV_1000616') , ('PROV_1000617') , ('PROV_1000618') , ('PROV_1000619') , ('PROV_1000620') , ('PROV_1000621') , ('PROV_1000622') , ('PROV_1000623') , ('PROV_1000624') , | |
| ('PROV_1000625') , ('PROV_1000626') , ('PROV_1000627') , ('PROV_1000628') , ('PROV_1000629') , ('PROV_1000630') , ('PROV_1000631') , ('PROV_1000632') , ('PROV_1000633') , ('PROV_1000634') , ('PROV_1000635') , ('PROV_1000636') , ('PROV_1000637') , ('PROV_1000638') , ('PROV_1000639') , ('PROV_1000640') , ('PROV_1000641') , ('PROV_1000642') , ('PROV_1000643') , ('PROV_1000644') , ('PROV_1000645') , ('PROV_1000646') , ('PROV_1000647') , ('PROV_1000648') , ('PROV_1000649') , | |
| ('PROV_1000650') , ('PROV_1000651') , ('PROV_1000652') , ('PROV_1000653') , ('PROV_1000654') , ('PROV_1000655') , ('PROV_1000656') , ('PROV_1000657') , ('PROV_1000658') , ('PROV_1000659') , ('PROV_1000660') , ('PROV_1000661') , ('PROV_1000662') , ('PROV_1000663') , ('PROV_1000664') , ('PROV_1000665') , ('PROV_1000666') , ('PROV_1000667') , ('PROV_1000668') , ('PROV_1000669') , ('PROV_1000670') , ('PROV_1000671') , ('PROV_1000672') , ('PROV_1000673') , ('PROV_1000674') , | |
| ('PROV_1000675') , ('PROV_1000676') , ('PROV_1000677') , ('PROV_1000678') , ('PROV_1000679') , ('PROV_1000680') , ('PROV_1000681') , ('PROV_1000682') , ('PROV_1000683') , ('PROV_1000684') , ('PROV_1000685') , ('PROV_1000686') , ('PROV_1000687') , ('PROV_1000688') , ('PROV_1000689') , ('PROV_1000690') , ('PROV_1000691') , ('PROV_1000692') , ('PROV_1000693') , ('PROV_1000694') , ('PROV_1000695') , ('PROV_1000696') , ('PROV_1000697') , ('PROV_1000698') , ('PROV_1000699') , | |
| ('PROV_1000700') , ('PROV_1000701') , ('PROV_1000702') , ('PROV_1000703') , ('PROV_1000704') , ('PROV_1000705') , ('PROV_1000706') , ('PROV_1000707') , ('PROV_1000708') , ('PROV_1000709') , ('PROV_1000710') , ('PROV_1000711') , ('PROV_1000712') , ('PROV_1000713') , ('PROV_1000714') , ('PROV_1000715') , ('PROV_1000716') , ('PROV_1000717') , ('PROV_1000718') , ('PROV_1000719') , ('PROV_1000720') , ('PROV_1000721') , ('PROV_1000722') , ('PROV_1000723') , ('PROV_1000724') , | |
| ('PROV_1000725') , ('PROV_1000726') , ('PROV_1000727') , ('PROV_1000728') , ('PROV_1000729') , ('PROV_1000730') , ('PROV_1000731') , ('PROV_1000732') , ('PROV_1000733') , ('PROV_1000734') , ('PROV_1000735') , ('PROV_1000736') , ('PROV_1000737') , ('PROV_1000738') , ('PROV_1000739') , ('PROV_1000740') , ('PROV_1000741') , ('PROV_1000742') , ('PROV_1000743') , ('PROV_1000744') , ('PROV_1000745') , ('PROV_1000746') , ('PROV_1000747') , ('PROV_1000748') , ('PROV_1000749') , | |
| ('PROV_1000750') , ('PROV_1000751') , ('PROV_1000752') , ('PROV_1000753') , ('PROV_1000754') , ('PROV_1000755') , ('PROV_1000756') , ('PROV_1000757') , ('PROV_1000758') , ('PROV_1000759') , ('PROV_1000760') , ('PROV_1000761') , ('PROV_1000762') , ('PROV_1000763') , ('PROV_1000764') , ('PROV_1000765') , ('PROV_1000766') , ('PROV_1000767') , ('PROV_1000768') , ('PROV_1000769') , ('PROV_1000770') , ('PROV_1000771') , ('PROV_1000772') , ('PROV_1000773') , ('PROV_1000774') , | |
| ('PROV_1000775') , ('PROV_1000776') , ('PROV_1000777') , ('PROV_1000778') , ('PROV_1000779') , ('PROV_1000780') , ('PROV_1000781') , ('PROV_1000782') , ('PROV_1000783') , ('PROV_1000784') , ('PROV_1000785') , ('PROV_1000786') , ('PROV_1000787') , ('PROV_1000788') , ('PROV_1000789') , ('PROV_1000790') , ('PROV_1000791') , ('PROV_1000792') , ('PROV_1000793') , ('PROV_1000794') , ('PROV_1000795') , ('PROV_1000796') , ('PROV_1000797') , ('PROV_1000798') , ('PROV_1000799') , | |
| ('PROV_1000800') , ('PROV_1000801') , ('PROV_1000802') , ('PROV_1000803') , ('PROV_1000804') , ('PROV_1000805') , ('PROV_1000806') , ('PROV_1000807') , ('PROV_1000808') , ('PROV_1000809') , ('PROV_1000810') , ('PROV_1000811') , ('PROV_1000812') , ('PROV_1000813') , ('PROV_1000814') , ('PROV_1000815') , ('PROV_1000816') , ('PROV_1000817') , ('PROV_1000818') , ('PROV_1000819') , ('PROV_1000820') , ('PROV_1000821') , ('PROV_1000822') , ('PROV_1000823') , ('PROV_1000824') , | |
| ('PROV_1000825') , ('PROV_1000826') , ('PROV_1000827') , ('PROV_1000828') , ('PROV_1000829') , ('PROV_1000830') , ('PROV_1000831') , ('PROV_1000832') , ('PROV_1000833') , ('PROV_1000834') , ('PROV_1000835') , ('PROV_1000836') , ('PROV_1000837') , ('PROV_1000838') , ('PROV_1000839') , ('PROV_1000840') , ('PROV_1000841') , ('PROV_1000842') , ('PROV_1000843') , ('PROV_1000844') , ('PROV_1000845') , ('PROV_1000846') , ('PROV_1000847') , ('PROV_1000848') , ('PROV_1000849') , | |
| ('PROV_1000850') , ('PROV_1000851') , ('PROV_1000852') , ('PROV_1000853') , ('PROV_1000854') , ('PROV_1000855') , ('PROV_1000856') , ('PROV_1000857') , ('PROV_1000858') , ('PROV_1000859') , ('PROV_1000860') , ('PROV_1000861') , ('PROV_1000862') , ('PROV_1000863') , ('PROV_1000864') , ('PROV_1000865') , ('PROV_1000866') , ('PROV_1000867') , ('PROV_1000868') , ('PROV_1000869') , ('PROV_1000870') , ('PROV_1000871') , ('PROV_1000872') , ('PROV_1000873') , ('PROV_1000874') , | |
| ('PROV_1000875') , ('PROV_1000876') , ('PROV_1000877') , ('PROV_1000878') , ('PROV_1000879') , ('PROV_1000880') , ('PROV_1000881') , ('PROV_1000882') , ('PROV_1000883') , ('PROV_1000884') , ('PROV_1000885') , ('PROV_1000886') , ('PROV_1000887') , ('PROV_1000888') , ('PROV_1000889') , ('PROV_1000890') , ('PROV_1000891') , ('PROV_1000892') , ('PROV_1000893') , ('PROV_1000894') , ('PROV_1000895') , ('PROV_1000896') , ('PROV_1000897') , ('PROV_1000898') , ('PROV_1000899') , | |
| ('PROV_1000900') , ('PROV_1000901') , ('PROV_1000902') , ('PROV_1000903') , ('PROV_1000904') , ('PROV_1000905') , ('PROV_1000906') , ('PROV_1000907') , ('PROV_1000908') , ('PROV_1000909') , ('PROV_1000910') , ('PROV_1000911') , ('PROV_1000912') , ('PROV_1000913') , ('PROV_1000914') , ('PROV_1000915') , ('PROV_1000916') , ('PROV_1000917') , ('PROV_1000918') , ('PROV_1000919') , ('PROV_1000920') , ('PROV_1000921') , ('PROV_1000922') , ('PROV_1000923') , ('PROV_1000924') , | |
| ('PROV_1000925') , ('PROV_1000926') , ('PROV_1000927') , ('PROV_1000928') , ('PROV_1000929') , ('PROV_1000930') , ('PROV_1000931') , ('PROV_1000932') , ('PROV_1000933') , ('PROV_1000934') , ('PROV_1000935') , ('PROV_1000936') , ('PROV_1000937') , ('PROV_1000938') , ('PROV_1000939') , ('PROV_1000940') , ('PROV_1000941') , ('PROV_1000942') , ('PROV_1000943') , ('PROV_1000944') , ('PROV_1000945') , ('PROV_1000946') , ('PROV_1000947') , ('PROV_1000948') , ('PROV_1000949') , | |
| ('PROV_1000950') , ('PROV_1000951') , ('PROV_1000952') , ('PROV_1000953') , ('PROV_1000954') , ('PROV_1000955') , ('PROV_1000956') , ('PROV_1000957') , ('PROV_1000958') , ('PROV_1000959') , ('PROV_1000960') , ('PROV_1000961') , ('PROV_1000962') , ('PROV_1000963') , ('PROV_1000964') , ('PROV_1000965') , ('PROV_1000966') , ('PROV_1000967') , ('PROV_1000968') , ('PROV_1000969') , ('PROV_1000970') , ('PROV_1000971') , ('PROV_1000972') , ('PROV_1000973') , ('PROV_1000974') , | |
| ('PROV_1000975') , ('PROV_1000976') , ('PROV_1000977') , ('PROV_1000978') , ('PROV_1000979') , ('PROV_1000980') , ('PROV_1000981') , ('PROV_1000982') , ('PROV_1000983') , ('PROV_1000984') , ('PROV_1000985') , ('PROV_1000986') , ('PROV_1000987') , ('PROV_1000988') , ('PROV_1000989') , ('PROV_1000990') , ('PROV_1000991') , ('PROV_1000992') , ('PROV_1000993') , ('PROV_1000994') , ('PROV_1000995') , ('PROV_1000996') , ('PROV_1000997') , ('PROV_1000998') , ('PROV_1000999') ) | |
| OR | |
| (D65_PROVIDER_ET) IN (('PROV_1001000') , ('PROV_1001001') , ('PROV_1001002') , ('PROV_1001003') , ('PROV_1001004') , ('PROV_1001005') , ('PROV_1001006') , ('PROV_1001007') , ('PROV_1001008') , ('PROV_1001009') , ('PROV_1001010') , ('PROV_1001011') , ('PROV_1001012') , ('PROV_1001013') , ('PROV_1001014') , ('PROV_1001015') , ('PROV_1001016') , ('PROV_1001017') , ('PROV_1001018') , ('PROV_1001019') , ('PROV_1001020') , ('PROV_1001021') , ('PROV_1001022') , ('PROV_1001023') , ('PROV_1001024') , | |
| ('PROV_1001025') , ('PROV_1001026') , ('PROV_1001027') , ('PROV_1001028') , ('PROV_1001029') , ('PROV_1001030') , ('PROV_1001031') , ('PROV_1001032') , ('PROV_1001033') , ('PROV_1001034') , ('PROV_1001035') , ('PROV_1001036') , ('PROV_1001037') , ('PROV_1001038') , ('PROV_1001039') , ('PROV_1001040') , ('PROV_1001041') , ('PROV_1001042') , ('PROV_1001043') , ('PROV_1001044') , ('PROV_1001045') , ('PROV_1001046') , ('PROV_1001047') , ('PROV_1001048') , ('PROV_1001049') , | |
| ('PROV_1001050') , ('PROV_1001051') , ('PROV_1001052') , ('PROV_1001053') , ('PROV_1001054') , ('PROV_1001055') , ('PROV_1001056') , ('PROV_1001057') , ('PROV_1001058') , ('PROV_1001059') , ('PROV_1001060') , ('PROV_1001061') , ('PROV_1001062') , ('PROV_1001063') , ('PROV_1001064') , ('PROV_1001065') , ('PROV_1001066') , ('PROV_1001067') , ('PROV_1001068') , ('PROV_1001069') , ('PROV_1001070') , ('PROV_1001071') , ('PROV_1001072') , ('PROV_1001073') , ('PROV_1001074') , | |
| ('PROV_1001075') , ('PROV_1001076') , ('PROV_1001077') , ('PROV_1001078') , ('PROV_1001079') , ('PROV_1001080') , ('PROV_1001081') , ('PROV_1001082') , ('PROV_1001083') , ('PROV_1001084') , ('PROV_1001085') , ('PROV_1001086') , ('PROV_1001087') , ('PROV_1001088') , ('PROV_1001089') , ('PROV_1001090') , ('PROV_1001091') , ('PROV_1001092') , ('PROV_1001093') , ('PROV_1001094') , ('PROV_1001095') , ('PROV_1001096') , ('PROV_1001097') , ('PROV_1001098') , ('PROV_1001099') , | |
| ('PROV_1001100') , ('PROV_1001101') , ('PROV_1001102') , ('PROV_1001103') , ('PROV_1001104') , ('PROV_1001105') , ('PROV_1001106') , ('PROV_1001107') , ('PROV_1001108') , ('PROV_1001109') , ('PROV_1001110') , ('PROV_1001111') , ('PROV_1001112') , ('PROV_1001113') , ('PROV_1001114') , ('PROV_1001115') , ('PROV_1001116') , ('PROV_1001117') , ('PROV_1001118') , ('PROV_1001119') , ('PROV_1001120') , ('PROV_1001121') , ('PROV_1001122') , ('PROV_1001123') , ('PROV_1001124') , | |
| ('PROV_1001125') , ('PROV_1001126') , ('PROV_1001127') , ('PROV_1001128') , ('PROV_1001129') , ('PROV_1001130') , ('PROV_1001131') , ('PROV_1001132') , ('PROV_1001133') , ('PROV_1001134') , ('PROV_1001135') , ('PROV_1001136') , ('PROV_1001137') , ('PROV_1001138') , ('PROV_1001139') , ('PROV_1001140') , ('PROV_1001141') , ('PROV_1001142') , ('PROV_1001143') , ('PROV_1001144') , ('PROV_1001145') , ('PROV_1001146') , ('PROV_1001147') , ('PROV_1001148') , ('PROV_1001149') , | |
| ('PROV_1001150') , ('PROV_1001151') , ('PROV_1001152') , ('PROV_1001153') , ('PROV_1001154') , ('PROV_1001155') , ('PROV_1001156') , ('PROV_1001157') , ('PROV_1001158') , ('PROV_1001159') , ('PROV_1001160') , ('PROV_1001161') , ('PROV_1001162') , ('PROV_1001163') , ('PROV_1001164') , ('PROV_1001165') , ('PROV_1001166') , ('PROV_1001167') , ('PROV_1001168') , ('PROV_1001169') , ('PROV_1001170') , ('PROV_1001171') , ('PROV_1001172') , ('PROV_1001173') , ('PROV_1001174') , | |
| ('PROV_1001175') , ('PROV_1001176') , ('PROV_1001177') , ('PROV_1001178') , ('PROV_1001179') , ('PROV_1001180') , ('PROV_1001181') , ('PROV_1001182') , ('PROV_1001183') , ('PROV_1001184') , ('PROV_1001185') , ('PROV_1001186') , ('PROV_1001187') , ('PROV_1001188') , ('PROV_1001189') , ('PROV_1001190') , ('PROV_1001191') , ('PROV_1001192') , ('PROV_1001193') , ('PROV_1001194') , ('PROV_1001195') , ('PROV_1001196') , ('PROV_1001197') , ('PROV_1001198') , ('PROV_1001199') , | |
| ('PROV_1001200') , ('PROV_1001201') , ('PROV_1001202') , ('PROV_1001203') , ('PROV_1001204') , ('PROV_1001205') , ('PROV_1001206') , ('PROV_1001207') , ('PROV_1001208') , ('PROV_1001209') , ('PROV_1001210') , ('PROV_1001211') , ('PROV_1001212') , ('PROV_1001213') , ('PROV_1001214') , ('PROV_1001215') , ('PROV_1001216') , ('PROV_1001217') , ('PROV_1001218') , ('PROV_1001219') , ('PROV_1001220') , ('PROV_1001221') , ('PROV_1001222') , ('PROV_1001223') , ('PROV_1001224') , | |
| ('PROV_1001225') , ('PROV_1001226') , ('PROV_1001227') , ('PROV_1001228') , ('PROV_1001229') , ('PROV_1001230') , ('PROV_1001231') , ('PROV_1001232') , ('PROV_1001233') , ('PROV_1001234') , ('PROV_1001235') , ('PROV_1001236') , ('PROV_1001237') , ('PROV_1001238') , ('PROV_1001239') , ('PROV_1001240') , ('PROV_1001241') , ('PROV_1001242') , ('PROV_1001243') , ('PROV_1001244') , ('PROV_1001245') , ('PROV_1001246') , ('PROV_1001247') , ('PROV_1001248') , ('PROV_1001249') , | |
| ('PROV_1001250') , ('PROV_1001251') , ('PROV_1001252') , ('PROV_1001253') , ('PROV_1001254') , ('PROV_1001255') , ('PROV_1001256') , ('PROV_1001257') , ('PROV_1001258') , ('PROV_1001259') , ('PROV_1001260') , ('PROV_1001261') , ('PROV_1001262') , ('PROV_1001263') , ('PROV_1001264') , ('PROV_1001265') , ('PROV_1001266') , ('PROV_1001267') , ('PROV_1001268') , ('PROV_1001269') , ('PROV_1001270') , ('PROV_1001271') , ('PROV_1001272') , ('PROV_1001273') , ('PROV_1001274') , | |
| ('PROV_1001275') , ('PROV_1001276') , ('PROV_1001277') , ('PROV_1001278') , ('PROV_1001279') , ('PROV_1001280') , ('PROV_1001281') , ('PROV_1001282') , ('PROV_1001283') , ('PROV_1001284') , ('PROV_1001285') , ('PROV_1001286') , ('PROV_1001287') , ('PROV_1001288') , ('PROV_1001289') , ('PROV_1001290') , ('PROV_1001291') , ('PROV_1001292') , ('PROV_1001293') , ('PROV_1001294') , ('PROV_1001295') , ('PROV_1001296') , ('PROV_1001297') , ('PROV_1001298') , ('PROV_1001299') , | |
| ('PROV_1001300') , ('PROV_1001301') , ('PROV_1001302') , ('PROV_1001303') , ('PROV_1001304') , ('PROV_1001305') , ('PROV_1001306') , ('PROV_1001307') , ('PROV_1001308') , ('PROV_1001309') , ('PROV_1001310') , ('PROV_1001311') , ('PROV_1001312') , ('PROV_1001313') , ('PROV_1001314') , ('PROV_1001315') , ('PROV_1001316') , ('PROV_1001317') , ('PROV_1001318') , ('PROV_1001319') , ('PROV_1001320') , ('PROV_1001321') , ('PROV_1001322') , ('PROV_1001323') , ('PROV_1001324') , | |
| ('PROV_1001325') , ('PROV_1001326') , ('PROV_1001327') , ('PROV_1001328') , ('PROV_1001329') , ('PROV_1001330') , ('PROV_1001331') , ('PROV_1001332') , ('PROV_1001333') , ('PROV_1001334') , ('PROV_1001335') , ('PROV_1001336') , ('PROV_1001337') , ('PROV_1001338') , ('PROV_1001339') , ('PROV_1001340') , ('PROV_1001341') , ('PROV_1001342') , ('PROV_1001343') , ('PROV_1001344') , ('PROV_1001345') , ('PROV_1001346') , ('PROV_1001347') , ('PROV_1001348') , ('PROV_1001349') , | |
| ('PROV_1001350') , ('PROV_1001351') , ('PROV_1001352') , ('PROV_1001353') , ('PROV_1001354') , ('PROV_1001355') , ('PROV_1001356') , ('PROV_1001357') , ('PROV_1001358') , ('PROV_1001359') , ('PROV_1001360') , ('PROV_1001361') , ('PROV_1001362') , ('PROV_1001363') , ('PROV_1001364') , ('PROV_1001365') , ('PROV_1001366') , ('PROV_1001367') , ('PROV_1001368') , ('PROV_1001369') , ('PROV_1001370') , ('PROV_1001371') , ('PROV_1001372') , ('PROV_1001373') , ('PROV_1001374') , | |
| ('PROV_1001375') , ('PROV_1001376') , ('PROV_1001377') , ('PROV_1001378') , ('PROV_1001379') , ('PROV_1001380') , ('PROV_1001381') , ('PROV_1001382') , ('PROV_1001383') , ('PROV_1001384') , ('PROV_1001385') , ('PROV_1001386') , ('PROV_1001387') , ('PROV_1001388') , ('PROV_1001389') , ('PROV_1001390') , ('PROV_1001391') , ('PROV_1001392') , ('PROV_1100001') , ('PROV_1100002') , ('PROV_1100003') , ('PROV_1100004') , ('PROV_1100005') , ('PROV_1100006') , ('PROV_1100007') , | |
| ('PROV_1100008') , ('PROV_1100009') , ('PROV_1100010') , ('PROV_1100011') , ('PROV_1100012') , ('PROV_1100013') , ('PROV_1100014') , ('PROV_1100015') , ('PROV_1100016') , ('PROV_1100017') , ('PROV_1100018') , ('PROV_1100019') , ('PROV_1100020') , ('PROV_1100021') , ('PROV_1100022') , ('PROV_1100023') , ('PROV_1100024') , ('PROV_1100025') , ('PROV_1100026') , ('PROV_1100027') , ('PROV_1100028') , ('PROV_1100029') , ('PROV_1100030') , ('PROV_1100031') , ('PROV_1100032') , | |
| ('PROV_1100033') , ('PROV_1100034') , ('PROV_1100035') , ('PROV_1100036') , ('PROV_1100037') , ('PROV_1100038') , ('PROV_1100039') , ('PROV_1100040') , ('PROV_1100041') , ('PROV_1100042') , ('PROV_1100043') , ('PROV_1100044') , ('PROV_1100045') , ('PROV_1100046') , ('PROV_1100047') , ('PROV_1100048') , ('PROV_1100049') , ('PROV_1100050') , ('PROV_1100051') , ('PROV_1100052') , ('PROV_1100053') , ('PROV_1100054') , ('PROV_1100055') , ('PROV_1100056') , ('PROV_1100057') , | |
| ('PROV_1100058') , ('PROV_1100059') , ('PROV_1100060') , ('PROV_1100061') , ('PROV_1100062') , ('PROV_1100063') , ('PROV_1100064') , ('PROV_1100065') , ('PROV_1100066') , ('PROV_1100067') , ('PROV_1100068') , ('PROV_1100069') , ('PROV_1100070') , ('PROV_1100071') , ('PROV_1100072') , ('PROV_1100073') , ('PROV_1100074') , ('PROV_1100075') , ('PROV_1100076') , ('PROV_1100077') , ('PROV_1100078') , ('PROV_1100079') , ('PROV_1100080') , ('PROV_1100081') ) ) | |
| AND (NOT ((D65_PROVIDER_ET) IN (('ALL_PROV_NOTAPP') , ('PROV_NOTAPP') ) ) ) | |
| AND ((D69_SPECIALTY_ET) = ('ALL_SPEC_1') ) | |
| AND ((D61_DIAGNOSIS_ET) = ('ALL_D2GRP_1') ) | |
| AND ((D63_PROCEDURE_ET) = ('ALL_PROC_1') ) | |
| AND (D67_BUSINESS_L_GID = 15) | |
| AND (D73_POS_GID = 1) | |
| AND (D75_AGE_GROUP_GID = 1) | |
| AND (D67_BUSINESS_L_GID = 15) | |
| AND (D69_SPECIALTY_GID = 1) | |
| AND (D73_POS_GID = 1) | |
| AND (D61_DIAGNOSIS_GID = 3) | |
| AND (D63_PROCEDURE_GID = 3) | |
| AND (D75_AGE_GROUP_GID = 1) ) ) | |
| V142 ) | |
| V143 | |
| MODEL | |
| PARTITION BY ( | |
| D61_DIAGNOSIS_GID SP_D61_DIAGNOSIS_GID, | |
| D61_DIAGNOSIS_ET SP_D61_DIAGNOSIS_ET, | |
| D61_DIAGNOSIS_HierarchyNumber SP_ALIAS_3591, | |
| D63_PROCEDURE_GID SP_D63_PROCEDURE_GID, | |
| D63_PROCEDURE_ET SP_D63_PROCEDURE_ET, | |
| D63_PROCEDURE_HierarchyNumber SP_ALIAS_3592, | |
| D67_BUSINESS_L_GID SP_D67_BUSINESS_L_GID, | |
| D67_BUSINESS_L_ET SP_D67_BUSINESS_L_ET, | |
| ALIAS_R81 SP_ALIAS_R81, | |
| D69_SPECIALTY_GID SP_D69_SPECIALTY_GID, | |
| D69_SPECIALTY_ET SP_D69_SPECIALTY_ET, | |
| D69_SPECIALTY_HierarchyNumber SP_ALIAS_3593, | |
| D71_TIME_GID SP_D71_TIME_GID, | |
| D71_TIME_ET SP_D71_TIME_ET, | |
| D71_TIME_HierarchyNumber SP_D71_TIME_HierarchyNumber, | |
| D73_POS_GID SP_D73_POS_GID, | |
| D73_POS_ET SP_D73_POS_ET, | |
| D73_POS_HierarchyNumber SP_D73_POS_HierarchyNumber, | |
| D75_AGE_GROUP_GID SP_D75_AGE_GROUP_GID, | |
| D75_AGE_GROUP_ET SP_D75_AGE_GROUP_ET, | |
| D75_AGE_GROUP_HierarchyNumber SP_ALIAS_3594, | |
| D77_INCR_PAID_GID SP_D77_INCR_PAID_GID, | |
| D77_INCR_PAID_ET SP_D77_INCR_PAID_ET, | |
| D77_INCR_PAID_HierarchyNumber SP_ALIAS_3595) | |
| DIMENSION BY ( | |
| ALIAS_190 SP_ALIAS_190, | |
| ALIAS_191 SP_ALIAS_191, | |
| ALIAS_169 SP_ALIAS_169, | |
| D65_PROVIDER_ET SP_D65_PROVIDER_ET, | |
| D65_PROVIDER_GID SP_D65_PROVIDER_GID) | |
| MEASURES ( | |
| ALIAS_194 SP_ALIAS_194, | |
| ALIAS_192 SP_ALIAS_192, | |
| ALIAS_193 SP_ALIAS_193, | |
| C59_M_TIME_AWMEDICA_MED_PAIDA SP_ALIAS_3590, | |
| ALIAS_262 SP_ALIAS_262, | |
| ALIAS_256 SP_ALIAS_256, | |
| ALIAS_257 SP_ALIAS_257, | |
| ALIAS_205 SP_ALIAS_205) | |
| RULES UPDATE | |
| ( | |
| SP_ALIAS_256[ANY , ANY , ANY , ANY , ANY ] = MAX(SP_ALIAS_3590) [ | |
| SP_ALIAS_192[CV(SP_ALIAS_190) , CV(SP_ALIAS_191) , CV(SP_ALIAS_169) , CV(SP_D65_PROVIDER_ET) , CV(SP_D65_PROVIDER_GID) ] , | |
| 1, | |
| ANY , | |
| ANY , | |
| ANY ] , | |
| SP_ALIAS_257[ANY , ANY , ANY , ANY , ANY ] = MAX(SP_ALIAS_3590) [ | |
| SP_ALIAS_193[CV(SP_ALIAS_190) , CV(SP_ALIAS_191) , CV(SP_ALIAS_169) , CV(SP_D65_PROVIDER_ET) , CV(SP_D65_PROVIDER_GID) ] , | |
| 0, | |
| ANY , | |
| ANY , | |
| ANY ] | |
| ) ) | |
| V144, | |
| ( | |
| SELECT | |
| D52_BUSINESS_L_ET, | |
| D52_BUSINESS_L_GID, | |
| D52_BUSINESS_L_ALL_BL, | |
| D52_BUSINESS_L_LVL1, | |
| D52_BUSINESS_L_LVL2, | |
| D52_BUSINESS_L_LVL3, | |
| D52_BUSINESS_L_LVL4, | |
| ALIAS_R68 | |
| FROM | |
| ( | |
| SELECT | |
| D52_BUSINESS_L_ET, | |
| D52_BUSINESS_L_GID, | |
| D52_BUSINESS_L_ALL_BL, | |
| D52_BUSINESS_L_LVL1, | |
| D52_BUSINESS_L_LVL2, | |
| D52_BUSINESS_L_LVL3, | |
| D52_BUSINESS_L_LVL4, | |
| ALIAS_R68, | |
| ROW_NUMBER() OVER ( | |
| ORDER BY | |
| D52_BUSINESS_L_ET ASC NULLS FIRST ) ALIAS_72 | |
| FROM | |
| ( | |
| SELECT /*+ no_expand_gset_to_union index_combine(*) */ | |
| AW429.AW429_ET_COL_17 D52_BUSINESS_L_ET, | |
| AW429.AW429_GID_COL_19 D52_BUSINESS_L_GID, | |
| AW429.AW429_LEVEL_27 D52_BUSINESS_L_ALL_BL, | |
| AW429.AW429_LEVEL_26 D52_BUSINESS_L_LVL1, | |
| AW429.AW429_LEVEL_25 D52_BUSINESS_L_LVL2, | |
| AW429.AW429_LEVEL_24 D52_BUSINESS_L_LVL3, | |
| AW429.AW429_LEVEL_23 D52_BUSINESS_L_LVL4, | |
| 0 ALIAS_R68 | |
| FROM | |
| (SELECT SYS$DV.* FROM ((SELECT * FROM TABLE(OLAP_TABLE('TIME_AW.D2HA_V1 duration session', | |
| NULL, | |
| NULL, | |
| ' DMNS AW429_ET_COL_17 AS VARCHAR2(100) FROM BUSINESS_LEVEL WITH HRR BUSINESS_LEVEL_PARENTREL(BUSINESS_LEVEL_HIERLIST ''BUSINESS_LEVEL'') INH BUSINESS_LEVEL_INHIER GID AW429_GID_COL_19 AS NUMBER FROM BUSINESS_LEVEL_GID LRL AW429_LEVEL_23 AS VARCHAR2(100), AW429_LEVEL_24 AS VARCHAR2(100), AW429_LEVEL_25 AS VARCHAR2(100), AW429_LEVEL_26 AS VARCHAR2(100), AW429_LEVEL_27 AS VARCHAR2(100) FROM BUSINESS_LEVEL_FAMILYREL(BUSINESS_LEVEL_LEVELLIST ''LVL4''), BUSINESS_LEVEL_FAMILYREL(BUSINESS_LEVEL_LEVELLIST ''LVL3''), BUSINESS_LEVEL_FAMILYREL(BUSINESS_LEVEL_LEVELLIST ''LVL2''), BUSINESS_LEVEL_FAMILYREL(BUSINESS_LEVEL_LEVELLIST ''LVL1''), BUSINESS_LEVEL_FAMILYREL(BUSINESS_LEVEL_LEVELLIST ''ALL_BL'') MSR OLAP_EXPRESSION_14 FROM AW_EXPR(CONVERT(ISSESSION(&(__XML_GET_FULLTOAW_NAME(''BUSINESS_LEVEL.DIMENSION''))), INTEGER ))')) SQL MODEL DIMENSION BY(AW429_ET_COL_17, | |
| AW429_GID_COL_19) MEASURES(AW429_LEVEL_23, | |
| AW429_LEVEL_24, | |
| AW429_LEVEL_25, | |
| AW429_LEVEL_26, | |
| AW429_LEVEL_27, | |
| OLAP_EXPRESSION_14) UNIQUE SINGLE REFERENCE RULES UPDATE SEQUENTIAL ORDER ()) SYS$DV)) AW429 ) | |
| D52 | |
| WHERE | |
| (D52_BUSINESS_L_GID = 15) ) | |
| V53 | |
| WHERE | |
| (((ALIAS_72) = (1) ) | |
| AND (D52_BUSINESS_L_GID = 15) | |
| AND (D52_BUSINESS_L_GID = 15) ) ) | |
| V54, | |
| ( | |
| SELECT | |
| D44_INCR_PAID_ET, | |
| D44_INCR_PAID_GID, | |
| D44_INCR_PAID_INCR_PAID, | |
| D44_INCR_PAID_HierarchyNumber | |
| FROM | |
| ( | |
| SELECT | |
| D44_INCR_PAID_ET, | |
| D44_INCR_PAID_GID, | |
| D44_INCR_PAID_INCR_PAID, | |
| D44_INCR_PAID_HierarchyNumber, | |
| ROW_NUMBER() OVER ( | |
| ORDER BY | |
| D44_INCR_PAID_ET ASC NULLS FIRST ) ALIAS_60 | |
| FROM | |
| ( | |
| SELECT /*+ no_expand_gset_to_union index_combine(*) */ | |
| AW428.AW428_ET_COL_36 D44_INCR_PAID_ET, | |
| AW428.AW428_GID_COL_38 D44_INCR_PAID_GID, | |
| AW428.AW428_LEVEL_42 D44_INCR_PAID_INCR_PAID, | |
| 0 D44_INCR_PAID_HierarchyNumber | |
| FROM | |
| (SELECT SYS$DV.* FROM ((SELECT * FROM TABLE(OLAP_TABLE('TIME_AW.D2HA_V1 duration session', | |
| NULL, | |
| NULL, | |
| ' DMNS AW428_ET_COL_36 AS VARCHAR2(100) FROM INCR_PAID WITH HRR INCR_PAID_PARENTREL(INCR_PAID_HIERLIST ''INCR_PAID'') INH INCR_PAID_INHIER GID AW428_GID_COL_38 AS NUMBER FROM INCR_PAID_GID LRL AW428_LEVEL_42 AS VARCHAR2(100) FROM INCR_PAID_FAMILYREL(INCR_PAID_LEVELLIST ''INCR_PAID'') MSR OLAP_EXPRESSION_12 FROM AW_EXPR(CONVERT(ISSESSION(&(__XML_GET_FULLTOAW_NAME(''INCR_PAID.DIMENSION''))), INTEGER ))')) SQL MODEL DIMENSION BY(AW428_ET_COL_36, | |
| AW428_GID_COL_38) MEASURES(AW428_LEVEL_42, | |
| OLAP_EXPRESSION_12) UNIQUE SINGLE REFERENCE RULES UPDATE SEQUENTIAL ORDER ()) SYS$DV)) AW428 ) | |
| D44 ) | |
| V45 | |
| WHERE | |
| ((ALIAS_60) = (1) ) ) | |
| V46, | |
| (SELECT 1 R, 1 C1, 'ALL_SPEC_1' C2, 1 C3, 'ALL_SPEC_1' C4, CAST(NULL AS VARCHAR2(30)) C5, 0 C6 FROM DUAL ) T216, | |
| ( | |
| SELECT | |
| D28_POS_ET, | |
| D28_POS_GID, | |
| D28_POS_ALL_POS, | |
| D28_POS_POS, | |
| D28_POS_HierarchyNumber | |
| FROM | |
| ( | |
| SELECT | |
| D28_POS_ET, | |
| D28_POS_GID, | |
| D28_POS_ALL_POS, | |
| D28_POS_POS, | |
| D28_POS_HierarchyNumber, | |
| ROW_NUMBER() OVER ( | |
| ORDER BY | |
| D28_POS_ET ASC NULLS FIRST ) ALIAS_40 | |
| FROM | |
| ( | |
| SELECT /*+ no_expand_gset_to_union index_combine(*) */ | |
| AW427.AW427_ET_COL_91 D28_POS_ET, | |
| AW427.AW427_GID_COL_93 D28_POS_GID, | |
| AW427.AW427_LEVEL_98 D28_POS_ALL_POS, | |
| AW427.AW427_LEVEL_97 D28_POS_POS, | |
| 0 D28_POS_HierarchyNumber | |
| FROM | |
| (SELECT SYS$DV.* FROM ((SELECT * FROM TABLE(OLAP_TABLE('TIME_AW.D2HA_V1 duration session', | |
| NULL, | |
| NULL, | |
| ' DMNS AW427_ET_COL_91 AS VARCHAR2(100) FROM POS WITH HRR POS_PARENTREL(POS_HIERLIST ''POS'') INH POS_INHIER GID AW427_GID_COL_93 AS NUMBER FROM POS_GID LRL AW427_LEVEL_97 AS VARCHAR2(100), AW427_LEVEL_98 AS VARCHAR2(100) FROM POS_FAMILYREL(POS_LEVELLIST ''POS''), POS_FAMILYREL(POS_LEVELLIST ''ALL_POS'') MSR OLAP_EXPRESSION_9 FROM AW_EXPR(CONVERT(ISSESSION(&(__XML_GET_FULLTOAW_NAME(''POS.DIMENSION''))), INTEGER ))')) SQL MODEL DIMENSION BY(AW427_ET_COL_91, | |
| AW427_GID_COL_93) MEASURES(AW427_LEVEL_97, | |
| AW427_LEVEL_98, | |
| OLAP_EXPRESSION_9) UNIQUE SINGLE REFERENCE RULES UPDATE SEQUENTIAL ORDER ()) SYS$DV)) AW427 ) | |
| D28 | |
| WHERE | |
| (D28_POS_GID = 1) ) | |
| V29 | |
| WHERE | |
| (((ALIAS_40) = (1) ) | |
| AND (D28_POS_GID = 1) | |
| AND (D28_POS_GID = 1) ) ) | |
| V30, | |
| (SELECT 1 R, 1 C1, 'ALL_D2GRP_1' C2, 3 C3, 'ALL_D2GRP_1' C4, CAST(NULL AS VARCHAR2(30)) C5, CAST(NULL AS VARCHAR2(30)) C6, CAST(NULL AS VARCHAR2(30)) C7, CAST(NULL AS VARCHAR2(30)) C8, CAST(NULL AS VARCHAR2(30)) C9, CAST(NULL AS VARCHAR2(30)) C10, CAST(NULL AS VARCHAR2(30)) C11, 0 C12 FROM DUAL ) T217, | |
| (SELECT 1 R, 1 C1, 'ALL_PROC_1' C2, 3 C3, 'ALL_PROC_1' C4, CAST(NULL AS VARCHAR2(30)) C5, CAST(NULL AS VARCHAR2(30)) C6, 0 C7 FROM DUAL ) T218, | |
| ( | |
| SELECT | |
| D4_AGE_GROUP_ET, | |
| D4_AGE_GROUP_GID, | |
| D4_AGE_GROUP_ALL_AGE_GRP, | |
| D4_AGE_GROUP_AGE_GRP, | |
| D4_AGE_GROUP_HierarchyNumber | |
| FROM | |
| ( | |
| SELECT | |
| D4_AGE_GROUP_ET, | |
| D4_AGE_GROUP_GID, | |
| D4_AGE_GROUP_ALL_AGE_GRP, | |
| D4_AGE_GROUP_AGE_GRP, | |
| D4_AGE_GROUP_HierarchyNumber, | |
| ROW_NUMBER() OVER ( | |
| ORDER BY | |
| D4_AGE_GROUP_ET ASC NULLS FIRST ) ALIAS_9 | |
| FROM | |
| ( | |
| SELECT /*+ no_expand_gset_to_union index_combine(*) */ | |
| AW426.AW426_ET_COL_28 D4_AGE_GROUP_ET, | |
| AW426.AW426_GID_COL_30 D4_AGE_GROUP_GID, | |
| AW426.AW426_LEVEL_35 D4_AGE_GROUP_ALL_AGE_GRP, | |
| AW426.AW426_LEVEL_34 D4_AGE_GROUP_AGE_GRP, | |
| 0 D4_AGE_GROUP_HierarchyNumber | |
| FROM | |
| (SELECT SYS$DV.* FROM ((SELECT * FROM TABLE(OLAP_TABLE('TIME_AW.D2HA_V1 duration session', | |
| NULL, | |
| NULL, | |
| ' DMNS AW426_ET_COL_28 AS VARCHAR2(100) FROM AGE_GROUP WITH HRR AGE_GROUP_PARENTREL(AGE_GROUP_HIERLIST ''AGE_GROUP'') INH AGE_GROUP_INHIER GID AW426_GID_COL_30 AS NUMBER FROM AGE_GROUP_GID LRL AW426_LEVEL_34 AS VARCHAR2(100), AW426_LEVEL_35 AS VARCHAR2(100) FROM AGE_GROUP_FAMILYREL(AGE_GROUP_LEVELLIST ''AGE_GRP''), AGE_GROUP_FAMILYREL(AGE_GROUP_LEVELLIST ''ALL_AGE_GRP'') MSR OLAP_EXPRESSION_1 FROM AW_EXPR(CONVERT(ISSESSION(&(__XML_GET_FULLTOAW_NAME(''AGE_GROUP.DIMENSION''))), INTEGER ))')) SQL MODEL DIMENSION BY(AW426_ET_COL_28, | |
| AW426_GID_COL_30) MEASURES(AW426_LEVEL_34, | |
| AW426_LEVEL_35, | |
| OLAP_EXPRESSION_1) UNIQUE SINGLE REFERENCE RULES UPDATE SEQUENTIAL ORDER ()) SYS$DV)) AW426 ) | |
| D4 | |
| WHERE | |
| (D4_AGE_GROUP_GID = 1) ) | |
| V5 | |
| WHERE | |
| (((ALIAS_9) = (1) ) | |
| AND (D4_AGE_GROUP_GID = 1) | |
| AND (D4_AGE_GROUP_GID = 1) ) ) | |
| V6 | |
| WHERE | |
| ((NOT ((SP_ALIAS_190) IN (('ALL_PROV_NOTAPP') , ('PROV_NOTAPP') ) ) ) | |
| AND (T216.C3 = 1) | |
| AND ((T217.C3 = 3) | |
| AND (T217.C12 = 0) ) | |
| AND (T218.C3 = 3) | |
| AND (SYS_OP_MAP_NONNULL(SP_D67_BUSINESS_L_GID) = SYS_OP_MAP_NONNULL(D52_BUSINESS_L_GID) ) | |
| AND (SYS_OP_MAP_NONNULL(SP_D67_BUSINESS_L_ET) = SYS_OP_MAP_NONNULL(D52_BUSINESS_L_ET) ) | |
| AND (SYS_OP_MAP_NONNULL(SP_D77_INCR_PAID_GID) = SYS_OP_MAP_NONNULL(D44_INCR_PAID_GID) ) | |
| AND (SYS_OP_MAP_NONNULL(SP_D77_INCR_PAID_ET) = SYS_OP_MAP_NONNULL(D44_INCR_PAID_ET) ) | |
| AND (SYS_OP_MAP_NONNULL(T216.C3) = SYS_OP_MAP_NONNULL(SP_D69_SPECIALTY_GID) ) | |
| AND (SYS_OP_MAP_NONNULL(T216.C2) = SYS_OP_MAP_NONNULL(SP_D69_SPECIALTY_ET) ) | |
| AND (SYS_OP_MAP_NONNULL(SP_D73_POS_GID) = SYS_OP_MAP_NONNULL(D28_POS_GID) ) | |
| AND (SYS_OP_MAP_NONNULL(SP_D73_POS_ET) = SYS_OP_MAP_NONNULL(D28_POS_ET) ) | |
| AND (SYS_OP_MAP_NONNULL(T217.C3) = SYS_OP_MAP_NONNULL(SP_D61_DIAGNOSIS_GID) ) | |
| AND (SYS_OP_MAP_NONNULL(T217.C2) = SYS_OP_MAP_NONNULL(SP_D61_DIAGNOSIS_ET) ) | |
| AND (SYS_OP_MAP_NONNULL(T218.C3) = SYS_OP_MAP_NONNULL(SP_D63_PROCEDURE_GID) ) | |
| AND (SYS_OP_MAP_NONNULL(T218.C2) = SYS_OP_MAP_NONNULL(SP_D63_PROCEDURE_ET) ) | |
| AND (SYS_OP_MAP_NONNULL(SP_D75_AGE_GROUP_GID) = SYS_OP_MAP_NONNULL(D4_AGE_GROUP_GID) ) | |
| AND (SYS_OP_MAP_NONNULL(SP_D75_AGE_GROUP_ET) = SYS_OP_MAP_NONNULL(D4_AGE_GROUP_ET) ) | |
| AND (NOT ((SP_D65_PROVIDER_ET) IN (('ALL_PROV_NOTAPP') , ('PROV_NOTAPP') ) ) ) ) | |
| ORDER BY | |
| D4_AGE_GROUP_ALL_AGE_GRP ASC NULLS FIRST , | |
| D4_AGE_GROUP_AGE_GRP ASC NULLS FIRST , | |
| T218.C4 ASC NULLS FIRST , | |
| T218.C5 ASC NULLS FIRST , | |
| T218.C6 ASC NULLS FIRST , | |
| T217.C4 ASC NULLS FIRST , | |
| T217.C5 ASC NULLS FIRST , | |
| T217.C6 ASC NULLS FIRST , | |
| D28_POS_ALL_POS ASC NULLS FIRST , | |
| D28_POS_POS ASC NULLS FIRST , | |
| T216.C4 ASC NULLS FIRST , | |
| T216.C5 ASC NULLS FIRST , | |
| D44_INCR_PAID_ET ASC NULLS FIRST , | |
| D52_BUSINESS_L_ALL_BL ASC NULLS FIRST , | |
| D52_BUSINESS_L_LVL1 ASC NULLS FIRST , | |
| D52_BUSINESS_L_LVL2 ASC NULLS FIRST , | |
| D52_BUSINESS_L_LVL3 ASC NULLS FIRST , | |
| D52_BUSINESS_L_LVL4 ASC NULLS FIRST , | |
| SP_ALIAS_256 DESC NULLS FIRST , | |
| SP_ALIAS_192 ASC NULLS FIRST , | |
| SP_ALIAS_257 DESC NULLS FIRST , | |
| SP_ALIAS_193 ASC NULLS FIRST , | |
| SP_ALIAS_262 ASC NULLS FIRST |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment