Tuesday 7 April 2015

Bad security design slowing you down

Here is an awesome example of some really poor security design and how this is translated at the database.  This is the extract of the public and user records from the security workbench application.

User / Role    Object Name    Object Description    From Value    Thru Value    Security Type    Description    Data Item    Alias    View    Add    Change    Delete    Product Code    BU Security
*PUBLIC    *ALL                        1    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
*PUBLIC    *ALL           133999999       133999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
*PUBLIC    *ALL           141999999       141999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
*PUBLIC    *ALL           146999999       146999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
*PUBLIC    *ALL           147999999       147999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
*PUBLIC    *ALL           168999999       168999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
*PUBLIC    *ALL           173999999       173999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
*PUBLIC    *ALL           178999999       178999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
*PUBLIC    *ALL           222999999       222999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
*PUBLIC    *ALL           227999999       227999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
*PUBLIC    *ALL           244999999       244999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
*PUBLIC    *ALL           246999999       246999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
*PUBLIC    *ALL           252999999       252999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
*PUBLIC    *ALL           253999999       253999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
*PUBLIC    *ALL           254999999       254999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
*PUBLIC    *ALL           255999999       255999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
*PUBLIC    *ALL           257999999       257999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
*PUBLIC    *ALL           268999999       268999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
*PUBLIC    *ALL           275999999       275999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
*PUBLIC    *ALL           291999999       291999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
*PUBLIC    *ALL           298999999       298999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
*PUBLIC    *ALL           314999999       314999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
*PUBLIC    *ALL           318999999       318999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
*PUBLIC    *ALL           327999999       327999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
*PUBLIC    *ALL           352999999       352999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
*PUBLIC    *ALL           710999999       710999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
*PUBLIC    *ALL           756999999       756999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
*PUBLIC    *ALL           758999999       758999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
*PUBLIC    *ALL           800999999       800999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
*PUBLIC    *ALL           NEWSMODEL       NEWSMODEL    4    Row Security    CostCenter    MCU    Y    N    N    N
    

And

Individual – holy moly!!!

User / Role    Object Name    Object Description    From Value    Thru Value    Security Type    Description    Data Item    Alias    View    Add    Change    Delete    Product Code    BU Security
NSGTRAIN1    *ALL                        5    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                   9               9    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 108             124    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 132             155    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 161             165    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 167             171    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 173             178    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 202             202    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 205             205    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 215             215    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 218             218    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 222             222    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 226             228    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 234             234    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 240             240    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 243             247    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 249             249    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 250             257    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 261             266    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 268             269    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 271             271    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 273             291    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 294             294    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 298             314    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 317             319    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 327             328    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 336             336    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 345             345    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 348             349    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 352             352    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 354             357    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 364             364    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 373             373    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 393             393    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 395             395    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 397             398    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 600             629    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 710             758    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 800             800    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 840             840    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 900             900    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 902             902    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 908             908    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 910             911    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 950             950    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 960             963    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 966             969    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 972             975    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 983             983    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 987             988    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 990             990    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL                 995             995    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL             8000000         8009999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL            ABM00000        ABMZZZZZ    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL            ANL00000        ANLZZZZZ    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL            CCN00000        CCNZZZZZ    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL            CNS00000        CNSZZZZZ    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL            COR00000        CORZZZZZ    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL            DBL00000        DBLZZZZZ    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL            GAA00000        GZZZZZZZ    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL            HWT00000        HWTZZZZZ    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL            LDR00000        LDRZZZZZ    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL            MNG00000        MNGZZZZZ    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL            MRC00000        MRCZZZZZ    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL            NDM00000        NDMZZZZZ    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL            NHO00000        NHOZZZZZ    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL            NLM00000        NLMZZZZZ    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL            NQN00000        NQNZZZZZ    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL            NSA00000        NSAZZZZZ    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL            NSL00000        NSLZZZZZ    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL            NSS00000        NSSZZZZZ    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL            NSW00000        NSWZZZZZ    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL            NTN00000        NTNZZZZZ    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL            NWN00000        NWNZZZZZ    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL            PPT00000        PPTZZZZZ    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL            PST00000        PSTZZZZZ    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL            QLD00000        QLDZZZZZ    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL            QNP00000        QNPZZZZZ    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL            QST00000        QSTZZZZZ    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL            VIC00000        VICZZZZZ    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL            WES00000        WESZZZZZ    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL           108000000       124999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL           133000000       155999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL           168000000       168999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL           173000000       178999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL           222000000       222999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL           227000000       227999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL           243000000       244999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL           246000000       246999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL           250000000       253999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL           254000000       254999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL           255000000       257999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL           268000000       268999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL           273000000       273999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL           275000000       291999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL           298000000       314999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL           318999999       318999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL           327000000       327999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL           352000000       352999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL           364000000       364999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL           710000000       758999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL           800999999       800999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL           950000000       950999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL           955999999       955999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL           963999999       963999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL           983000000       983999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL           987000000       987999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL           988999999       988999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL           990000000       990999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL           995000000       995999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL           NEWSMODEL       NEWSMODEL    4    Row Security    CostCenter    MCU    Y    N    N    N         
NSGTRAIN1    *ALL          1320000000      1329999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          1510000000      1519999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          1610000000      1659999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          1670000000      1679999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          1690000000      1719999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          2020000000      2029999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          2050000000      2059999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          2150000000      2159999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          2180000000      2189999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          2220000000      2229999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          2260000000      2269999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          2280000000      2289999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          2340000000      2349999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          2400000000      2409999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          2450000000      2459999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          2470000000      2479999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          2490000000      2499999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          2540000000      2549999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          2610000000      2669999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          2690000000      2699999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          2710000000      2719999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          2740000000      2749999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          2940000000      2949999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          3000000000      3019999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          3170000000      3199999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          3280000000      3289999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          3360000000      3369999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          3450000000      3459999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          3480000000      3499999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          3540000000      3579999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          3730000000      3739999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          3930000000      3939999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          3950000000      3959999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          3970000000      3989999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          6000000000      6299999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          8400000000      8409999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          9020000000      9029999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          9080000000      9089999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          9100000000      9119999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          9500000000      9509999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          9600000000      9629999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          9630000000      9639999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          9660000000      9699999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          9720000000      9759999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          9830000000      9839999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         
NSGTRAIN1    *ALL          9870000000      9889999999    4    Row Security    CostCenter    MCU    Y    Y    Y    Y         

 

Printing out the SQL details in EM12C shows:

-- ============================================================================================== --
-- This file is generated by EM Database Express. --
-- The SQL bind variables, if any, will be declared below. --
-- ============================================================================================== --


-- Note: If bind names were invalid SQL identifiers, then the bind variables may have been renamed below. --


declare
430c87hnzs3xp_bind1 NVARCHAR2(32) := '1234%';
430c87hnzs3xp_bind2 NVARCHAR2(32) := '1234%';
430c87hnzs3xp_bind3 NVARCHAR2(32) := 'NWN00000';
430c87hnzs3xp_bind4 NVARCHAR2(32) := 'NWNZZZZZ';
430c87hnzs3xp_bind5 NVARCHAR2(32) := 'PPT00000';
430c87hnzs3xp_bind6 NVARCHAR2(32) := 'PPTZZZZZ';
430c87hnzs3xp_bind7 NVARCHAR2(32) := 'CCN00000';
430c87hnzs3xp_bind8 NVARCHAR2(32) := 'CCNZZZZZ';
430c87hnzs3xp_bind9 NVARCHAR2(32) := 'CNS00000';
430c87hnzs3xp_bind10 NVARCHAR2(32) := 'CNSZZZZZ';
430c87hnzs3xp_bind11 NVARCHAR2(32) := 'COR00000';
430c87hnzs3xp_bind12 NVARCHAR2(32) := 'CORZZZZZ';
430c87hnzs3xp_bind13 NVARCHAR2(32) := 'DBL00000';
430c87hnzs3xp_bind14 NVARCHAR2(32) := 'DBLZZZZZ';
430c87hnzs3xp_bind15 NVARCHAR2(32) := 'GAA00000';
430c87hnzs3xp_bind16 NVARCHAR2(32) := 'GZZZZZZZ';
430c87hnzs3xp_bind17 NVARCHAR2(32) := 'HWT00000';
430c87hnzs3xp_bind18 NVARCHAR2(32) := 'HWTZZZZZ';
430c87hnzs3xp_bind19 NVARCHAR2(32) := 'LDR00000';
430c87hnzs3xp_bind20 NVARCHAR2(32) := 'LDRZZZZZ';
430c87hnzs3xp_bind21 NVARCHAR2(32) := 'MNG00000';
430c87hnzs3xp_bind22 NVARCHAR2(32) := 'MNGZZZZZ';
430c87hnzs3xp_bind23 NVARCHAR2(32) := '249';
430c87hnzs3xp_bind24 NVARCHAR2(32) := '250';
430c87hnzs3xp_bind25 NVARCHAR2(32) := '257';
430c87hnzs3xp_bind26 NVARCHAR2(32) := '261';
430c87hnzs3xp_bind27 NVARCHAR2(32) := '266';
430c87hnzs3xp_bind28 NVARCHAR2(32) := '268';
430c87hnzs3xp_bind29 NVARCHAR2(32) := '269';
430c87hnzs3xp_bind30 NVARCHAR2(32) := '271';
430c87hnzs3xp_bind31 NVARCHAR2(32) := '273';
430c87hnzs3xp_bind32 NVARCHAR2(32) := '291';
430c87hnzs3xp_bind33 NVARCHAR2(32) := '294';
430c87hnzs3xp_bind34 NVARCHAR2(32) := NULL;
430c87hnzs3xp_bind35 NVARCHAR2(32) := '5';
430c87hnzs3xp_bind36 NVARCHAR2(32) := '9';
430c87hnzs3xp_bind37 NVARCHAR2(32) := '108';
430c87hnzs3xp_bind38 NVARCHAR2(32) := '124';
430c87hnzs3xp_bind39 NVARCHAR2(32) := '168000000';
430c87hnzs3xp_bind40 NVARCHAR2(32) := '168999999';
430c87hnzs3xp_bind41 NVARCHAR2(32) := '173000000';
430c87hnzs3xp_bind42 NVARCHAR2(32) := '178999999';
430c87hnzs3xp_bind43 NVARCHAR2(32) := '298';
430c87hnzs3xp_bind44 NVARCHAR2(32) := '314';
430c87hnzs3xp_bind45 NVARCHAR2(32) := '317';
430c87hnzs3xp_bind46 NVARCHAR2(32) := '319';
430c87hnzs3xp_bind47 NVARCHAR2(32) := '327';
430c87hnzs3xp_bind48 NVARCHAR2(32) := '328';
430c87hnzs3xp_bind49 NVARCHAR2(32) := '132';
430c87hnzs3xp_bind50 NVARCHAR2(32) := '155';
430c87hnzs3xp_bind51 NVARCHAR2(32) := '161';
430c87hnzs3xp_bind52 NVARCHAR2(32) := '165';
430c87hnzs3xp_bind53 NVARCHAR2(32) := '167';
430c87hnzs3xp_bind54 NVARCHAR2(32) := '171';
430c87hnzs3xp_bind55 NVARCHAR2(32) := '222000000';
430c87hnzs3xp_bind56 NVARCHAR2(32) := '222999999';
430c87hnzs3xp_bind57 NVARCHAR2(32) := '227000000';
430c87hnzs3xp_bind58 NVARCHAR2(32) := '227999999';
430c87hnzs3xp_bind59 NVARCHAR2(32) := '243000000';
430c87hnzs3xp_bind60 NVARCHAR2(32) := '244999999';
430c87hnzs3xp_bind61 NVARCHAR2(32) := '246000000';
430c87hnzs3xp_bind62 NVARCHAR2(32) := '246999999';
430c87hnzs3xp_bind63 NVARCHAR2(32) := '250000000';
430c87hnzs3xp_bind64 NVARCHAR2(32) := '253999999';
430c87hnzs3xp_bind65 NVARCHAR2(32) := '254000000';
430c87hnzs3xp_bind66 NVARCHAR2(32) := '254999999';
430c87hnzs3xp_bind67 NVARCHAR2(32) := '255000000';
430c87hnzs3xp_bind68 NVARCHAR2(32) := '257999999';
430c87hnzs3xp_bind69 NVARCHAR2(32) := '268000000';
430c87hnzs3xp_bind70 NVARCHAR2(32) := '268999999';
430c87hnzs3xp_bind71 NVARCHAR2(32) := '336';
430c87hnzs3xp_bind72 NVARCHAR2(32) := '345';
430c87hnzs3xp_bind73 NVARCHAR2(32) := '348';
430c87hnzs3xp_bind74 NVARCHAR2(32) := '349';
430c87hnzs3xp_bind75 NVARCHAR2(32) := '352';
430c87hnzs3xp_bind76 NVARCHAR2(32) := '354';
430c87hnzs3xp_bind77 NVARCHAR2(32) := '357';
430c87hnzs3xp_bind78 NVARCHAR2(32) := '364';
430c87hnzs3xp_bind79 NVARCHAR2(32) := '373';
430c87hnzs3xp_bind80 NVARCHAR2(32) := '173';
430c87hnzs3xp_bind81 NVARCHAR2(32) := '178';
430c87hnzs3xp_bind82 NVARCHAR2(32) := '202';
430c87hnzs3xp_bind83 NVARCHAR2(32) := '205';
430c87hnzs3xp_bind84 NVARCHAR2(32) := '215';
430c87hnzs3xp_bind85 NVARCHAR2(32) := '218';
430c87hnzs3xp_bind86 NVARCHAR2(32) := '222';
430c87hnzs3xp_bind87 NVARCHAR2(32) := '226';
430c87hnzs3xp_bind88 NVARCHAR2(32) := '228';
430c87hnzs3xp_bind89 NVARCHAR2(32) := '273000000';
430c87hnzs3xp_bind90 NVARCHAR2(32) := '273999999';
430c87hnzs3xp_bind91 NVARCHAR2(32) := '275000000';
430c87hnzs3xp_bind92 NVARCHAR2(32) := '291999999';
430c87hnzs3xp_bind93 NVARCHAR2(32) := '393';
430c87hnzs3xp_bind94 NVARCHAR2(32) := '395';
430c87hnzs3xp_bind95 NVARCHAR2(32) := '397';
430c87hnzs3xp_bind96 NVARCHAR2(32) := '398';
430c87hnzs3xp_bind97 NVARCHAR2(32) := '234';
430c87hnzs3xp_bind98 NVARCHAR2(32) := '240';
430c87hnzs3xp_bind99 NVARCHAR2(32) := '243';
430c87hnzs3xp_bind100 NVARCHAR2(32) := '247';
430c87hnzs3xp_bind101 NVARCHAR2(32) := '298000000';
430c87hnzs3xp_bind102 NVARCHAR2(32) := '314999999';
430c87hnzs3xp_bind103 NVARCHAR2(32) := '318999999';
430c87hnzs3xp_bind104 NVARCHAR2(32) := '327000000';
430c87hnzs3xp_bind105 NVARCHAR2(32) := '327999999';
430c87hnzs3xp_bind106 NVARCHAR2(32) := '352000000';
430c87hnzs3xp_bind107 NVARCHAR2(32) := '352999999';
430c87hnzs3xp_bind108 NVARCHAR2(32) := '364000000';
430c87hnzs3xp_bind109 NVARCHAR2(32) := '364999999';
430c87hnzs3xp_bind110 NVARCHAR2(32) := '710000000';
430c87hnzs3xp_bind111 NVARCHAR2(32) := '758999999';
430c87hnzs3xp_bind112 NVARCHAR2(32) := '800999999';
430c87hnzs3xp_bind113 NVARCHAR2(32) := '950000000';
430c87hnzs3xp_bind114 NVARCHAR2(32) := '950999999';
430c87hnzs3xp_bind115 NVARCHAR2(32) := '600';
430c87hnzs3xp_bind116 NVARCHAR2(32) := '629';
430c87hnzs3xp_bind117 NVARCHAR2(32) := '710';
430c87hnzs3xp_bind118 NVARCHAR2(32) := '758';
430c87hnzs3xp_bind119 NVARCHAR2(32) := '800';
430c87hnzs3xp_bind120 NVARCHAR2(32) := '840';
430c87hnzs3xp_bind121 NVARCHAR2(32) := '900';
430c87hnzs3xp_bind122 NVARCHAR2(32) := '902';
430c87hnzs3xp_bind123 NVARCHAR2(32) := '908';
430c87hnzs3xp_bind124 NVARCHAR2(32) := 'PST00000';
430c87hnzs3xp_bind125 NVARCHAR2(32) := 'PSTZZZZZ';
430c87hnzs3xp_bind126 NVARCHAR2(32) := 'QLD00000';
430c87hnzs3xp_bind127 NVARCHAR2(32) := 'QLDZZZZZ';
430c87hnzs3xp_bind128 NVARCHAR2(32) := 'QNP00000';
430c87hnzs3xp_bind129 NVARCHAR2(32) := 'QNPZZZZZ';
430c87hnzs3xp_bind130 NVARCHAR2(32) := 'QST00000';
430c87hnzs3xp_bind131 NVARCHAR2(32) := 'QSTZZZZZ';
430c87hnzs3xp_bind132 NVARCHAR2(32) := 'VIC00000';
430c87hnzs3xp_bind133 NVARCHAR2(32) := 'VICZZZZZ';
430c87hnzs3xp_bind134 NVARCHAR2(32) := 'WES00000';
430c87hnzs3xp_bind135 NVARCHAR2(32) := 'WESZZZZZ';
430c87hnzs3xp_bind136 NVARCHAR2(32) := '108000000';
430c87hnzs3xp_bind137 NVARCHAR2(32) := '124999999';
430c87hnzs3xp_bind138 NVARCHAR2(32) := '133000000';
430c87hnzs3xp_bind139 NVARCHAR2(32) := '155999999';
430c87hnzs3xp_bind140 NVARCHAR2(32) := '910';
430c87hnzs3xp_bind141 NVARCHAR2(32) := '911';
430c87hnzs3xp_bind142 NVARCHAR2(32) := '950';
430c87hnzs3xp_bind143 NVARCHAR2(32) := '960';
430c87hnzs3xp_bind144 NVARCHAR2(32) := '963';
430c87hnzs3xp_bind145 NVARCHAR2(32) := '966';
430c87hnzs3xp_bind146 NVARCHAR2(32) := '969';
430c87hnzs3xp_bind147 NVARCHAR2(32) := '972';
430c87hnzs3xp_bind148 NVARCHAR2(32) := '975';
430c87hnzs3xp_bind149 NVARCHAR2(32) := '983';
430c87hnzs3xp_bind150 NVARCHAR2(32) := '987';
430c87hnzs3xp_bind151 NVARCHAR2(32) := '988';
430c87hnzs3xp_bind152 NVARCHAR2(32) := '990';
430c87hnzs3xp_bind153 NVARCHAR2(32) := '995';
430c87hnzs3xp_bind154 NVARCHAR2(32) := '8000000';
430c87hnzs3xp_bind155 NVARCHAR2(32) := '8009999';
430c87hnzs3xp_bind156 NVARCHAR2(32) := 'MRC00000';
430c87hnzs3xp_bind157 NVARCHAR2(32) := 'MRCZZZZZ';
430c87hnzs3xp_bind158 NVARCHAR2(32) := 'NDM00000';
430c87hnzs3xp_bind159 NVARCHAR2(32) := 'NDMZZZZZ';
430c87hnzs3xp_bind160 NVARCHAR2(32) := 'NHO00000';
430c87hnzs3xp_bind161 NVARCHAR2(32) := 'NHOZZZZZ';
430c87hnzs3xp_bind162 NVARCHAR2(32) := 'NLM00000';
430c87hnzs3xp_bind163 NVARCHAR2(32) := 'NLMZZZZZ';
430c87hnzs3xp_bind164 NVARCHAR2(32) := 'NQN00000';
430c87hnzs3xp_bind165 NVARCHAR2(32) := 'NQNZZZZZ';
430c87hnzs3xp_bind166 NVARCHAR2(32) := 'NSA00000';
430c87hnzs3xp_bind167 NVARCHAR2(32) := 'NSAZZZZZ';
430c87hnzs3xp_bind168 NVARCHAR2(32) := 'NSL00000';
430c87hnzs3xp_bind169 NVARCHAR2(32) := 'NSLZZZZZ';
430c87hnzs3xp_bind170 NVARCHAR2(32) := 'NSS00000';
430c87hnzs3xp_bind171 NVARCHAR2(32) := 'NSSZZZZZ';
430c87hnzs3xp_bind172 NVARCHAR2(32) := 'NSW00000';
430c87hnzs3xp_bind173 NVARCHAR2(32) := 'NSWZZZZZ';
430c87hnzs3xp_bind174 NVARCHAR2(32) := 'NTN00000';
430c87hnzs3xp_bind175 NVARCHAR2(32) := 'NTNZZZZZ';
430c87hnzs3xp_bind176 NVARCHAR2(32) := 'ABM00000';
430c87hnzs3xp_bind177 NVARCHAR2(32) := 'ABMZZZZZ';
430c87hnzs3xp_bind178 NVARCHAR2(32) := 'ANL00000';
430c87hnzs3xp_bind179 NVARCHAR2(32) := 'ANLZZZZZ';
430c87hnzs3xp_bind180 NVARCHAR2(32) := '955999999';
430c87hnzs3xp_bind181 NVARCHAR2(32) := '963999999';
430c87hnzs3xp_bind182 NVARCHAR2(32) := '983000000';
430c87hnzs3xp_bind183 NVARCHAR2(32) := '983999999';
430c87hnzs3xp_bind184 NVARCHAR2(32) := '987000000';
430c87hnzs3xp_bind185 NVARCHAR2(32) := '987999999';
430c87hnzs3xp_bind186 NVARCHAR2(32) := '988999999';
430c87hnzs3xp_bind187 NVARCHAR2(32) := '990000000';
430c87hnzs3xp_bind188 NVARCHAR2(32) := '990999999';
430c87hnzs3xp_bind189 NVARCHAR2(32) := '995000000';
430c87hnzs3xp_bind190 NVARCHAR2(32) := '995999999';
430c87hnzs3xp_bind191 NVARCHAR2(32) := 'NEWSMODEL';
430c87hnzs3xp_bind192 NVARCHAR2(32) := '1320000000';
430c87hnzs3xp_bind193 NVARCHAR2(32) := '1329999999';
430c87hnzs3xp_bind194 NVARCHAR2(32) := '1510000000';
430c87hnzs3xp_bind195 NVARCHAR2(32) := '1519999999';
430c87hnzs3xp_bind196 NVARCHAR2(32) := '9660000000';
430c87hnzs3xp_bind197 NVARCHAR2(32) := '9699999999';
430c87hnzs3xp_bind198 NVARCHAR2(32) := '9720000000';
430c87hnzs3xp_bind199 NVARCHAR2(32) := '9759999999';
430c87hnzs3xp_bind200 NVARCHAR2(32) := '9630000000';
430c87hnzs3xp_bind201 NVARCHAR2(32) := '9639999999';
430c87hnzs3xp_bind202 NVARCHAR2(32) := '9830000000';
430c87hnzs3xp_bind203 NVARCHAR2(32) := '9839999999';
430c87hnzs3xp_bind204 NVARCHAR2(32) := '2940000000';
430c87hnzs3xp_bind205 NVARCHAR2(32) := '2949999999';
430c87hnzs3xp_bind206 NVARCHAR2(32) := '3000000000';
430c87hnzs3xp_bind207 NVARCHAR2(32) := '3019999999';
430c87hnzs3xp_bind208 NVARCHAR2(32) := '3170000000';
430c87hnzs3xp_bind209 NVARCHAR2(32) := '3199999999';
430c87hnzs3xp_bind210 NVARCHAR2(32) := '3280000000';
430c87hnzs3xp_bind211 NVARCHAR2(32) := '3289999999';
430c87hnzs3xp_bind212 NVARCHAR2(32) := '3360000000';
430c87hnzs3xp_bind213 NVARCHAR2(32) := '3369999999';
430c87hnzs3xp_bind214 NVARCHAR2(32) := '3450000000';
430c87hnzs3xp_bind215 NVARCHAR2(32) := '3459999999';
430c87hnzs3xp_bind216 NVARCHAR2(32) := '3480000000';
430c87hnzs3xp_bind217 NVARCHAR2(32) := '3499999999';
430c87hnzs3xp_bind218 NVARCHAR2(32) := '3540000000';
430c87hnzs3xp_bind219 NVARCHAR2(32) := '3579999999';
430c87hnzs3xp_bind220 NVARCHAR2(32) := '3730000000';
430c87hnzs3xp_bind221 NVARCHAR2(32) := '3739999999';
430c87hnzs3xp_bind222 NVARCHAR2(32) := '3930000000';
430c87hnzs3xp_bind223 NVARCHAR2(32) := '3939999999';
430c87hnzs3xp_bind224 NVARCHAR2(32) := '1610000000';
430c87hnzs3xp_bind225 NVARCHAR2(32) := '1659999999';
430c87hnzs3xp_bind226 NVARCHAR2(32) := '1670000000';
430c87hnzs3xp_bind227 NVARCHAR2(32) := '1679999999';
430c87hnzs3xp_bind228 NVARCHAR2(32) := '1690000000';
430c87hnzs3xp_bind229 NVARCHAR2(32) := '1719999999';
430c87hnzs3xp_bind230 NVARCHAR2(32) := '2020000000';
430c87hnzs3xp_bind231 NVARCHAR2(32) := '2029999999';
430c87hnzs3xp_bind232 NVARCHAR2(32) := '2050000000';
430c87hnzs3xp_bind233 NVARCHAR2(32) := '2059999999';
430c87hnzs3xp_bind234 NVARCHAR2(32) := '2150000000';
430c87hnzs3xp_bind235 NVARCHAR2(32) := '2159999999';
430c87hnzs3xp_bind236 NVARCHAR2(32) := '2180000000';
430c87hnzs3xp_bind237 NVARCHAR2(32) := '2189999999';
430c87hnzs3xp_bind238 NVARCHAR2(32) := '2220000000';
430c87hnzs3xp_bind239 NVARCHAR2(32) := '2229999999';
430c87hnzs3xp_bind240 NVARCHAR2(32) := '2260000000';
430c87hnzs3xp_bind241 NVARCHAR2(32) := '2269999999';
430c87hnzs3xp_bind242 NVARCHAR2(32) := '2280000000';
430c87hnzs3xp_bind243 NVARCHAR2(32) := '2289999999';
430c87hnzs3xp_bind244 NVARCHAR2(32) := '3950000000';
430c87hnzs3xp_bind245 NVARCHAR2(32) := '3959999999';
430c87hnzs3xp_bind246 NVARCHAR2(32) := '3970000000';
430c87hnzs3xp_bind247 NVARCHAR2(32) := '3989999999';
430c87hnzs3xp_bind248 NVARCHAR2(32) := '6000000000';
430c87hnzs3xp_bind249 NVARCHAR2(32) := '6299999999';
430c87hnzs3xp_bind250 NVARCHAR2(32) := '8400000000';
430c87hnzs3xp_bind251 NVARCHAR2(32) := '8409999999';
430c87hnzs3xp_bind252 NVARCHAR2(32) := '9020000000';
430c87hnzs3xp_bind253 NVARCHAR2(32) := '9029999999';
430c87hnzs3xp_bind254 NVARCHAR2(32) := '9080000000';
430c87hnzs3xp_bind255 NVARCHAR2(32) := '9089999999';
430c87hnzs3xp_bind256 NVARCHAR2(32) := '9100000000';
430c87hnzs3xp_bind257 NVARCHAR2(32) := '9119999999';
430c87hnzs3xp_bind258 NVARCHAR2(32) := '9500000000';
430c87hnzs3xp_bind259 NVARCHAR2(32) := '9509999999';
430c87hnzs3xp_bind260 NVARCHAR2(32) := '9600000000';
430c87hnzs3xp_bind261 NVARCHAR2(32) := '9629999999';
430c87hnzs3xp_bind262 NVARCHAR2(32) := '2340000000';
430c87hnzs3xp_bind263 NVARCHAR2(32) := '2349999999';
430c87hnzs3xp_bind264 NVARCHAR2(32) := '2400000000';
430c87hnzs3xp_bind265 NVARCHAR2(32) := '2409999999';
430c87hnzs3xp_bind266 NVARCHAR2(32) := '2450000000';
430c87hnzs3xp_bind267 NVARCHAR2(32) := '2459999999';
430c87hnzs3xp_bind268 NVARCHAR2(32) := '2470000000';
430c87hnzs3xp_bind269 NVARCHAR2(32) := '2479999999';
430c87hnzs3xp_bind270 NVARCHAR2(32) := '2490000000';
430c87hnzs3xp_bind271 NVARCHAR2(32) := '2499999999';
430c87hnzs3xp_bind272 NVARCHAR2(32) := '2540000000';
430c87hnzs3xp_bind273 NVARCHAR2(32) := '2549999999';
430c87hnzs3xp_bind274 NVARCHAR2(32) := '2610000000';
430c87hnzs3xp_bind275 NVARCHAR2(32) := '2669999999';
430c87hnzs3xp_bind276 NVARCHAR2(32) := '2690000000';
430c87hnzs3xp_bind277 NVARCHAR2(32) := '2699999999';
430c87hnzs3xp_bind278 NVARCHAR2(32) := '2710000000';
430c87hnzs3xp_bind279 NVARCHAR2(32) := '2719999999';
430c87hnzs3xp_bind280 NVARCHAR2(32) := '2740000000';
430c87hnzs3xp_bind281 NVARCHAR2(32) := '2749999999';
430c87hnzs3xp_bind282 NVARCHAR2(32) := '9870000000';
430c87hnzs3xp_bind283 NVARCHAR2(32) := '9889999999';
begin
-- SELECT T0.ABAN8,T0.ABALPH,T0.ABALKY,T0.ABAT1,T1.ALCTY1 FROM PRODDTA.F0101 T0, PRODDTA.F0116 T1 WHERE ((((T0.ABALPH LIKE :1 OR T0.ABALKY LIKE :2 )) AND (T0.ABMCU BETWEEN :3 AND :4 OR T0.ABMCU BETWEEN :5 AND :6 OR T0.ABMCU BETWEEN :7 AND :8 OR T0.ABMCU BETWEEN :9 AND :10 OR T0.ABMCU BETWEEN :11 AND :12 OR T0.ABMCU BETWEEN :13 AND :14 OR T0.ABMCU BETWEEN :15 AND :16 OR T0.ABMCU BETWEEN :17 AND :18 OR T0.ABMCU BETWEEN :19 AND :20 OR T0.ABMCU BETWEEN :21 AND :22 OR T0.ABMCU = :23 OR T0.ABMCU BETWEEN :24 AND :25 OR T0.ABMCU BETWEEN :26 AND :27 OR T0.ABMCU BETWEEN :28 AND :29 OR T0.ABMCU = :30 OR T0.ABMCU BETWEEN :31 AND :32 OR T0.ABMCU = :33 OR T0.ABMCU BETWEEN :34 AND :35 OR T0.ABMCU = :36 OR T0.ABMCU BETWEEN :37 AND :38 OR T0.ABMCU BETWEEN :39 AND :40 OR T0.ABMCU BETWEEN :41 AND :42 OR T0.ABMCU BETWEEN :43 AND :44 OR T0.ABMCU BETWEEN :45 AND :46 OR T0.ABMCU BETWEEN :47 AND :48 OR T0.ABMCU BETWEEN :49 AND :50 OR T0.ABMCU BETWEEN :51 AND :52 OR T0.ABMCU BETWEEN :53 AND :54 OR T0.ABMCU BETWEEN :55 AND :56 OR T0.ABMCU BETWEEN :57 AND :58 OR T0.ABMCU BETWEEN :59 AND :60 OR T0.ABMCU BETWEEN :61 AND :62 OR T0.ABMCU BETWEEN :63 AND :64 OR T0.ABMCU BETWEEN :65 AND :66 OR T0.ABMCU BETWEEN :67 AND :68 OR T0.ABMCU BETWEEN :69 AND :70 OR T0.ABMCU = :71 OR T0.ABMCU = :72 OR T0.ABMCU BETWEEN :73 AND :74 OR T0.ABMCU = :75 OR T0.ABMCU BETWEEN :76 AND :77 OR T0.ABMCU = :78 OR T0.ABMCU = :79 OR T0.ABMCU BETWEEN :80 AND :81 OR T0.ABMCU = :82 OR T0.ABMCU = :83 OR T0.ABMCU = :84 OR T0.ABMCU = :85 OR T0.ABMCU = :86 OR T0.ABMCU BETWEEN :87 AND :88 OR T0.ABMCU BETWEEN :89 AND :90 OR T0.ABMCU BETWEEN :91 AND :92 OR T0.ABMCU = :93 OR T0.ABMCU = :94 OR T0.ABMCU BETWEEN :95 AND :96 OR T0.ABMCU = :97 OR T0.ABMCU = :98 OR T0.ABMCU BETWEEN :99 AND :100 OR T0.ABMCU BETWEEN :101 AND :102 OR T0.ABMCU = :103 OR T0.ABMCU BETWEEN :104 AND :105 OR T0.ABMCU BETWEEN :106 AND :107 OR T0.ABMCU BETWEEN :108 AND :109 OR T0.ABMCU BETWEEN :110 AND :111 OR T0.ABMCU = :112 OR T0.ABMCU BETWEEN :113 AND :114 OR T0.ABMCU BETWEEN :115 AND :116 OR T0.ABMCU BETWEEN :117 AND :118 OR T0.ABMCU = :119 OR T0.ABMCU = :120 OR T0.ABMCU = :121 OR T0.ABMCU = :122 OR T0.ABMCU = :123 OR T0.ABMCU BETWEEN :124 AND :125 OR T0.ABMCU BETWEEN :126 AND :127 OR T0.ABMCU BETWEEN :128 AND :129 OR T0.ABMCU BETWEEN :130 AND :131 OR T0.ABMCU BETWEEN :132 AND :133 OR T0.ABMCU BETWEEN :134 AND :135 OR T0.ABMCU BETWEEN :136 AND :137 OR T0.ABMCU BETWEEN :138 AND :139 OR T0.ABMCU BETWEEN :140 AND :141 OR T0.ABMCU = :142 OR T0.ABMCU BETWEEN :143 AND :144 OR T0.ABMCU BETWEEN :145 AND :146 OR T0.ABMCU BETWEEN :147 AND :148 OR T0.ABMCU = :149 OR T0.ABMCU BETWEEN :150 AND :151 OR T0.ABMCU = :152 OR T0.ABMCU = :153 OR T0.ABMCU BETWEEN :154 AND :155 OR T0.ABMCU BETWEEN :156 AND :157 OR T0.ABMCU BETWEEN :158 AND :159 OR T0.ABMCU BETWEEN :160 AND :161 OR T0.ABMCU BETWEEN :162 AND :163 OR T0.ABMCU BETWEEN :164 AND :165 OR T0.ABMCU BETWEEN :166 AND :167 OR T0.ABMCU BETWEEN :168 AND :169 OR T0.ABMCU BETWEEN :170 AND :171 OR T0.ABMCU BETWEEN :172 AND :173 OR T0.ABMCU BETWEEN :174 AND :175 OR T0.ABMCU BETWEEN :176 AND :177 OR T0.ABMCU BETWEEN :178 AND :179 OR T0.ABMCU = :180 OR T0.ABMCU = :181 OR T0.ABMCU BETWEEN :182 AND :183 OR T0.ABMCU BETWEEN :184 AND :185 OR T0.ABMCU = :186 OR T0.ABMCU BETWEEN :187 AND :188 OR T0.ABMCU BETWEEN :189 AND :190 OR T0.ABMCU = :191 OR T0.ABMCU BETWEEN :192 AND :193 OR T0.ABMCU BETWEEN :194 AND :195 OR T0.ABMCU BETWEEN :196 AND :197 OR T0.ABMCU BETWEEN :198 AND :199 OR T0.ABMCU BETWEEN :200 AND :201 OR T0.ABMCU BETWEEN :202 AND :203 OR T0.ABMCU BETWEEN :204 AND :205 OR T0.ABMCU BETWEEN :206 AND :207 OR T0.ABMCU BETWEEN :208 AND :209 OR T0.ABMCU BETWEEN :210 AND :211 OR T0.ABMCU BETWEEN :212 AND :213 OR T0.ABMCU BETWEEN :214 AND :215 OR T0.ABMCU BETWEEN :216 AND :217 OR T0.ABMCU BETWEEN :218 AND :219 OR T0.ABMCU BETWEEN :220 AND :221 OR T0.ABMCU BETWEEN :222 AND :223 OR T0.ABMCU BETWEEN :224 AND :225 OR T0.ABMCU BETWEEN :226 AND :227 OR T0.ABMCU BETWEEN :228 AND :229 OR T0.ABMCU BETWEEN :230 AND :231 OR T0.ABMCU BETWEEN :232 AND :233 OR T0.ABMCU BETWEEN :234 AND :235 OR T0.ABMCU BETWEEN :236 AND :237 OR T0.ABMCU BETWEEN :238 AND :239 OR T0.ABMCU BETWEEN :240 AND :241 OR T0.ABMCU BETWEEN :242 AND :243 OR T0.ABMCU BETWEEN :244 AND :245 OR T0.ABMCU BETWEEN :246 AND :247 OR T0.ABMCU BETWEEN :248 AND :249 OR T0.ABMCU BETWEEN :250 AND :251 OR T0.ABMCU BETWEEN :252 AND :253 OR T0.ABMCU BETWEEN :254 AND :255 OR T0.ABMCU BETWEEN :256 AND :257 OR T0.ABMCU BETWEEN :258 AND :259 OR T0.ABMCU BETWEEN :260 AND :261 OR T0.ABMCU BETWEEN :262 AND :263 OR T0.ABMCU BETWEEN :264 AND :265 OR T0.ABMCU BETWEEN :266 AND :267 OR T0.ABMCU BETWEEN :268 AND :269 OR T0.ABMCU BETWEEN :270 AND :271 OR T0.ABMCU BETWEEN :272 AND :273 OR T0.ABMCU BETWEEN :274 AND :275 OR T0.ABMCU BETWEEN :276 AND :277 OR T0.ABMCU BETWEEN :278 AND :279 OR T0.ABMCU BETWEEN :280 AND :281 OR T0.ABMCU BETWEEN :282 AND :283 ))) AND (T0.ABAN8 = T1.ALAN8) ORDER BY T0.ABALPH ASC , T0.ABALKY ASC
end;
/
    

 
 
 
SELECT  T0.ABAN8 ,
T0.ABALPH,
T0.ABALKY,
T0.ABAT1 ,
T1.ALCTY1
FROM PRODDTA.F0101 T0,
PRODDTA.F0116 T1
WHERE
(
(
(
(
T0.ABALPH LIKE :1
OR T0.ABALKY LIKE :2
)
)
AND
(
T0.ABMCU BETWEEN :3 AND :4
OR T0.ABMCU BETWEEN :5 AND :6
OR T0.ABMCU BETWEEN :7 AND :8
OR T0.ABMCU BETWEEN :9 AND :10
OR T0.ABMCU BETWEEN :11 AND :12
OR T0.ABMCU BETWEEN :13 AND :14
OR T0.ABMCU BETWEEN :15 AND :16
OR T0.ABMCU BETWEEN :17 AND :18
OR T0.ABMCU BETWEEN :19 AND :20
OR T0.ABMCU BETWEEN :21 AND :22
OR T0.ABMCU = :23
OR T0.ABMCU BETWEEN :24 AND :25
OR T0.ABMCU BETWEEN :26 AND :27
OR T0.ABMCU BETWEEN :28 AND :29
OR T0.ABMCU = :30
OR T0.ABMCU BETWEEN :31 AND :32
OR T0.ABMCU = :33
OR T0.ABMCU BETWEEN :34 AND :35
OR T0.ABMCU = :36
OR T0.ABMCU BETWEEN :37 AND :38
OR T0.ABMCU BETWEEN :39 AND :40
OR T0.ABMCU BETWEEN :41 AND :42
OR T0.ABMCU BETWEEN :43 AND :44
OR T0.ABMCU BETWEEN :45 AND :46
OR T0.ABMCU BETWEEN :47 AND :48
OR T0.ABMCU BETWEEN :49 AND :50
OR T0.ABMCU BETWEEN :51 AND :52
OR T0.ABMCU BETWEEN :53 AND :54
OR T0.ABMCU BETWEEN :55 AND :56
OR T0.ABMCU BETWEEN :57 AND :58
OR T0.ABMCU BETWEEN :59 AND :60
OR T0.ABMCU BETWEEN :61 AND :62
OR T0.ABMCU BETWEEN :63 AND :64
OR T0.ABMCU BETWEEN :65 AND :66
OR T0.ABMCU BETWEEN :67 AND :68
OR T0.ABMCU BETWEEN :69 AND :70
OR T0.ABMCU = :71
OR T0.ABMCU = :72
OR T0.ABMCU BETWEEN :73 AND :74
OR T0.ABMCU = :75
OR T0.ABMCU BETWEEN :76 AND :77
OR T0.ABMCU = :78
OR T0.ABMCU = :79
OR T0.ABMCU BETWEEN :80 AND :81
OR T0.ABMCU = :82
OR T0.ABMCU = :83
OR T0.ABMCU = :84
OR T0.ABMCU = :85
OR T0.ABMCU = :86
OR T0.ABMCU BETWEEN :87 AND :88
OR T0.ABMCU BETWEEN :89 AND :90
OR T0.ABMCU BETWEEN :91 AND :92
OR T0.ABMCU = :93
OR T0.ABMCU = :94
OR T0.ABMCU BETWEEN :95 AND :96
OR T0.ABMCU = :97
OR T0.ABMCU = :98
OR T0.ABMCU BETWEEN :99 AND :100
OR T0.ABMCU BETWEEN :101 AND :102
OR T0.ABMCU = :103
OR T0.ABMCU BETWEEN :104 AND :105
OR T0.ABMCU BETWEEN :106 AND :107
OR T0.ABMCU BETWEEN :108 AND :109
OR T0.ABMCU BETWEEN :110 AND :111
OR T0.ABMCU = :112
OR T0.ABMCU BETWEEN :113 AND :114
OR T0.ABMCU BETWEEN :115 AND :116
OR T0.ABMCU BETWEEN :117 AND :118
OR T0.ABMCU = :119
OR T0.ABMCU = :120
OR T0.ABMCU = :121
OR T0.ABMCU = :122
OR T0.ABMCU = :123
OR T0.ABMCU BETWEEN :124 AND :125
OR T0.ABMCU BETWEEN :126 AND :127
OR T0.ABMCU BETWEEN :128 AND :129
OR T0.ABMCU BETWEEN :130 AND :131
OR T0.ABMCU BETWEEN :132 AND :133
OR T0.ABMCU BETWEEN :134 AND :135
OR T0.ABMCU BETWEEN :136 AND :137
OR T0.ABMCU BETWEEN :138 AND :139
OR T0.ABMCU BETWEEN :140 AND :141
OR T0.ABMCU = :142
OR T0.ABMCU BETWEEN :143 AND :144
OR T0.ABMCU BETWEEN :145 AND :146
OR T0.ABMCU BETWEEN :147 AND :148
OR T0.ABMCU = :149
OR T0.ABMCU BETWEEN :150 AND :151
OR T0.ABMCU = :152
OR T0.ABMCU = :153
OR T0.ABMCU BETWEEN :154 AND :155
OR T0.ABMCU BETWEEN :156 AND :157
OR T0.ABMCU BETWEEN :158 AND :159
OR T0.ABMCU BETWEEN :160 AND :161
OR T0.ABMCU BETWEEN :162 AND :163
OR T0.ABMCU BETWEEN :164 AND :165
OR T0.ABMCU BETWEEN :166 AND :167
OR T0.ABMCU BETWEEN :168 AND :169
OR T0.ABMCU BETWEEN :170 AND :171
OR T0.ABMCU BETWEEN :172 AND :173
OR T0.ABMCU BETWEEN :174 AND :175
OR T0.ABMCU BETWEEN :176 AND :177
OR T0.ABMCU BETWEEN :178 AND :179
OR T0.ABMCU = :180
OR T0.ABMCU = :181
OR T0.ABMCU BETWEEN :182 AND :183
OR T0.ABMCU BETWEEN :184 AND :185
OR T0.ABMCU = :186
OR T0.ABMCU BETWEEN :187 AND :188
OR T0.ABMCU BETWEEN :189 AND :190
OR T0.ABMCU = :191
OR T0.ABMCU BETWEEN :192 AND :193
OR T0.ABMCU BETWEEN :194 AND :195
OR T0.ABMCU BETWEEN :196 AND :197
OR T0.ABMCU BETWEEN :198 AND :199
OR T0.ABMCU BETWEEN :200 AND :201
OR T0.ABMCU BETWEEN :202 AND :203
OR T0.ABMCU BETWEEN :204 AND :205
OR T0.ABMCU BETWEEN :206 AND :207
OR T0.ABMCU BETWEEN :208 AND :209
OR T0.ABMCU BETWEEN :210 AND :211
OR T0.ABMCU BETWEEN :212 AND :213
OR T0.ABMCU BETWEEN :214 AND :215
OR T0.ABMCU BETWEEN :216 AND :217
OR T0.ABMCU BETWEEN :218 AND :219
OR T0.ABMCU BETWEEN :220 AND :221
OR T0.ABMCU BETWEEN :222 AND :223
OR T0.ABMCU BETWEEN :224 AND :225
OR T0.ABMCU BETWEEN :226 AND :227
OR T0.ABMCU BETWEEN :228 AND :229
OR T0.ABMCU BETWEEN :230 AND :231
OR T0.ABMCU BETWEEN :232 AND :233
OR T0.ABMCU BETWEEN :234 AND :235
OR T0.ABMCU BETWEEN :236 AND :237
OR T0.ABMCU BETWEEN :238 AND :239
OR T0.ABMCU BETWEEN :240 AND :241
OR T0.ABMCU BETWEEN :242 AND :243
OR T0.ABMCU BETWEEN :244 AND :245
OR T0.ABMCU BETWEEN :246 AND :247
OR T0.ABMCU BETWEEN :248 AND :249
OR T0.ABMCU BETWEEN :250 AND :251
OR T0.ABMCU BETWEEN :252 AND :253
OR T0.ABMCU BETWEEN :254 AND :255
OR T0.ABMCU BETWEEN :256 AND :257
OR T0.ABMCU BETWEEN :258 AND :259
OR T0.ABMCU BETWEEN :260 AND :261
OR T0.ABMCU BETWEEN :262 AND :263
OR T0.ABMCU BETWEEN :264 AND :265
OR T0.ABMCU BETWEEN :266 AND :267
OR T0.ABMCU BETWEEN :268 AND :269
OR T0.ABMCU BETWEEN :270 AND :271
OR T0.ABMCU BETWEEN :272 AND :273
OR T0.ABMCU BETWEEN :274 AND :275
OR T0.ABMCU BETWEEN :276 AND :277
OR T0.ABMCU BETWEEN :278 AND :279
OR T0.ABMCU BETWEEN :280 AND :281
OR T0.ABMCU BETWEEN :282 AND :283
)
)
)
AND
(
T0.ABAN8 = T1.ALAN8
)
ORDER BY T0.ABALPH ASC ,
T0.ABALKY ASC

 


This is a Huge where clause which is hurting the parser.

No comments:

Extending JDE to generative AI