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:
Post a Comment