where [KW_WHERE] (87 in 8 files)

Filename Line # Column # Match Text
./abl/checkout.p 00086 00010
where [KW_WHERE] @86:10
   expression [EXPRESSION] @0:0
      and [KW_AND] @86:69
         = [EQUALS] @86:43
            reservation.reservation-id [FIELD_INT] @86:16
            checkout.reservation-id [FIELD_INT] @86:45
         ( [LPARENS] @88:17
            or [KW_OR] @88:39
               = [EQUALS] @88:33
                  checkout.state [FIELD_CHAR] @88:18
                  'I' [STRING] @88:35
               = [EQUALS] @88:57
                  checkout.state [FIELD_CHAR] @88:42
                  "O" [STRING] @88:59
./abl/checkout.p 00095 00010
where [KW_WHERE] @95:10
   expression [EXPRESSION] @0:0
      = [EQUALS] @95:45
         checkout-room.reservation-id [FIELD_INT] @95:16
         checkout.reservation-id [FIELD_INT] @95:47
./abl/checkout.p 00117 00024
where [KW_WHERE] @117:24
   expression [EXPRESSION] @0:0
      = [EQUALS] @117:56
         b-out-room.reservation-id [FIELD_INT] @117:30
         reservation.reservation-id [FIELD_INT] @117:58
./abl/checkout.p 00138 00017
where [KW_WHERE] @138:17
   expression [EXPRESSION] @0:0
      = [EQUALS] @138:40
         room.room-number [FIELD_INT] @138:23
         checkout-room.room-number [FIELD_INT] @138:42
./abl/checkout.p 00149 00027
where [KW_WHERE] @149:27
   expression [EXPRESSION] @0:0
      = [EQUALS] @149:48
         guest.guest-id [FIELD_INT] @149:33
         cr-guest-ids [VAR_INT] @149:50
            [ [LBRACKET] @149:62
               gid [VAR_INT] @149:63
./abl/checkout.p 00164 00048
where [KW_WHERE] @164:48
   = [EQUALS] @164:69
      guest.guest-id [FIELD_INT] @164:54
      cr-guest-ids [VAR_INT] @164:71
         [ [LBRACKET] @164:83
            1 [NUM_LITERAL] @164:84
./abl/checkout.p 00165 00050
where [KW_WHERE] @165:50
   = [EQUALS] @165:71
      guest.guest-id [FIELD_INT] @165:56
      cr-guest-ids [VAR_INT] @165:73
         [ [LBRACKET] @165:85
            1 [NUM_LITERAL] @165:86
./abl/checkout.p 00166 00048
where [KW_WHERE] @166:48
   = [EQUALS] @166:69
      guest.guest-id [FIELD_INT] @166:54
      cr-guest-ids [VAR_INT] @166:71
         [ [LBRACKET] @166:83
            2 [NUM_LITERAL] @166:84
./abl/checkout.p 00167 00050
where [KW_WHERE] @167:50
   = [EQUALS] @167:71
      guest.guest-id [FIELD_INT] @167:56
      cr-guest-ids [VAR_INT] @167:73
         [ [LBRACKET] @167:85
            2 [NUM_LITERAL] @167:86
./abl/checkout.p 00168 00048
where [KW_WHERE] @168:48
   = [EQUALS] @168:69
      guest.guest-id [FIELD_INT] @168:54
      cr-guest-ids [VAR_INT] @168:71
         [ [LBRACKET] @168:83
            3 [NUM_LITERAL] @168:84
./abl/checkout.p 00169 00050
where [KW_WHERE] @169:50
   = [EQUALS] @169:71
      guest.guest-id [FIELD_INT] @169:56
      cr-guest-ids [VAR_INT] @169:73
         [ [LBRACKET] @169:85
            3 [NUM_LITERAL] @169:86
./abl/checkout.p 00170 00048
where [KW_WHERE] @170:48
   = [EQUALS] @170:69
      guest.guest-id [FIELD_INT] @170:54
      cr-guest-ids [VAR_INT] @170:71
         [ [LBRACKET] @170:83
            4 [NUM_LITERAL] @170:84
./abl/checkout.p 00171 00050
where [KW_WHERE] @171:50
   = [EQUALS] @171:71
      guest.guest-id [FIELD_INT] @171:56
      cr-guest-ids [VAR_INT] @171:73
         [ [LBRACKET] @171:85
            4 [NUM_LITERAL] @171:86
./abl/checkout.p 00273 00038
where [KW_WHERE] @273:38
   expression [EXPRESSION] @0:0
      = [EQUALS] @273:67
         b-out-room.room-number [FIELD_INT] @273:44
         g-room [VAR_INT] @273:69
./abl/checkout.p 00285 00016
where [KW_WHERE] @285:16
   expression [EXPRESSION] @0:0
      and [KW_AND] @285:105
         ( [LPARENS] @285:22
            if [FUNC_POLY] @285:23
               or [KW_OR] @285:36
                  = [EQUALS] @285:32
                     g-f-n [VAR_CHAR] @285:26
                     ? [UNKNOWN_VAL] @285:34
                  = [EQUALS] @285:45
                     g-f-n [VAR_CHAR] @285:39
                     "" [STRING] @285:47
               true [BOOL_TRUE] @285:55
               matches [KW_MATCHES] @285:84
                  b-guest.first-name [FIELD_CHAR] @285:65
                  + [PLUS] @285:98
                     g-f-n [VAR_CHAR] @285:92
                     "*" [STRING] @285:100
         ( [LPARENS] @286:22
            if [FUNC_POLY] @286:23
               or [KW_OR] @286:36
                  = [EQUALS] @286:32
                     g-l-n [VAR_CHAR] @286:26
                     ? [UNKNOWN_VAL] @286:34
                  = [EQUALS] @286:45
                     g-l-n [VAR_CHAR] @286:39
                     "" [STRING] @286:47
               true [BOOL_TRUE] @286:55
               matches [KW_MATCHES] @286:83
                  b-guest.last-name [FIELD_CHAR] @286:65
                  + [PLUS] @286:97
                     g-l-n [VAR_CHAR] @286:91
                     "*" [STRING] @286:99
./abl/checkout.p 00287 00028
where [KW_WHERE] @287:28
   expression [EXPRESSION] @0:0
      >= [GTE] @287:49
         b-res.checkout [FIELD_DATE] @287:34
         today [FUNC_DATE] @287:52
./abl/checkout.p 00288 00033
where [KW_WHERE] @288:33
   expression [EXPRESSION] @0:0
      and [KW_AND] @288:88
         = [EQUALS] @288:65
            b-out-room.reservation-id [FIELD_INT] @288:39
            b-res.reservation-id [FIELD_INT] @288:67
         ( [LPARENS] @289:22
            or [KW_OR] @291:66
               or [KW_OR] @290:66
                  or [KW_OR] @289:66
                     = [EQUALS] @289:47
                        b-out-room.guest-ids [FIELD_INT] @289:23
                           [ [LBRACKET] @289:43
                              1 [NUM_LITERAL] @289:44
                        b-guest.guest-id [FIELD_INT] @289:49
                     = [EQUALS] @290:47
                        b-out-room.guest-ids [FIELD_INT] @290:23
                           [ [LBRACKET] @290:43
                              2 [NUM_LITERAL] @290:44
                        b-guest.guest-id [FIELD_INT] @290:49
                  = [EQUALS] @291:47
                     b-out-room.guest-ids [FIELD_INT] @291:23
                        [ [LBRACKET] @291:43
                           3 [NUM_LITERAL] @291:44
                     b-guest.guest-id [FIELD_INT] @291:49
               = [EQUALS] @292:47
                  b-out-room.guest-ids [FIELD_INT] @292:23
                     [ [LBRACKET] @292:43
                        4 [NUM_LITERAL] @292:44
                  b-guest.guest-id [FIELD_INT] @292:49
./abl/checkout.p 00304 00027
where [KW_WHERE] @304:27
   expression [EXPRESSION] @0:0
      = [EQUALS] @304:57
         checkout.reservation-id [FIELD_INT] @304:33
         r-id [VAR_INT] @304:59
./abl/checkout.p 00305 00030
where [KW_WHERE] @305:30
   expression [EXPRESSION] @0:0
      = [EQUALS] @305:63
         reservation.reservation-id [FIELD_INT] @305:36
         r-id [VAR_INT] @305:65
./abl/checkout.p 00310 00032
where [KW_WHERE] @310:32
   expression [EXPRESSION] @0:0
      and [KW_AND] @310:74
         = [EQUALS] @310:67
            checkout-room.reservation-id [FIELD_INT] @310:38
            r-id [VAR_INT] @310:69
         = [EQUALS] @310:104
            checkout-room.room-number [FIELD_INT] @310:78
            f-room-id [VAR_INT] @310:106
./abl/checkout.p 00320 00033
where [KW_WHERE] @320:33
   expression [EXPRESSION] @0:0
      = [EQUALS] @320:65
         b-out-room.reservation-id [FIELD_INT] @320:39
         reservation.reservation-id [FIELD_INT] @320:67
./abl/checkout.p 00322 00028
where [KW_WHERE] @322:28
   expression [EXPRESSION] @0:0
      = [EQUALS] @322:53
         b-room.room-number [FIELD_INT] @322:34
         b-out-room.room-number [FIELD_INT] @322:55
./abl/checkout.p 00332 00029
where [KW_WHERE] @332:29
   expression [EXPRESSION] @0:0
      = [EQUALS] @332:53
         recid [FUNC_RECID] @332:35
            b-checkout [BUFFER] @332:41
         recid [FUNC_RECID] @332:55
            checkout [TABLE] @332:61
./abl/checkout.p 00334 00033
where [KW_WHERE] @334:33
   expression [EXPRESSION] @0:0
      = [EQUALS] @334:65
         b-out-room.reservation-id [FIELD_INT] @334:39
         reservation.reservation-id [FIELD_INT] @334:67
./abl/guests.p 00172 00016
where [KW_WHERE] @172:16
   expression [EXPRESSION] @0:0
      and [KW_AND] @173:104
         and [KW_AND] @172:105
            ( [LPARENS] @172:22
               if [FUNC_POLY] @172:23
                  or [KW_OR] @172:36
                     = [EQUALS] @172:32
                        g-f-n [VAR_CHAR] @172:26
                        ? [UNKNOWN_VAL] @172:34
                     = [EQUALS] @172:45
                        g-f-n [VAR_CHAR] @172:39
                        "" [STRING] @172:47
                  true [BOOL_TRUE] @172:55
                  matches [KW_MATCHES] @172:84
                     b-guest.first-name [FIELD_CHAR] @172:65
                     + [PLUS] @172:98
                        g-f-n [VAR_CHAR] @172:92
                        "*" [STRING] @172:100
            ( [LPARENS] @173:22
               if [FUNC_POLY] @173:23
                  or [KW_OR] @173:36
                     = [EQUALS] @173:32
                        g-l-n [VAR_CHAR] @173:26
                        ? [UNKNOWN_VAL] @173:34
                     = [EQUALS] @173:45
                        g-l-n [VAR_CHAR] @173:39
                        "" [STRING] @173:47
                  true [BOOL_TRUE] @173:55
                  matches [KW_MATCHES] @173:83
                     b-guest.last-name [FIELD_CHAR] @173:65
                     + [PLUS] @173:97
                        g-l-n [VAR_CHAR] @173:91
                        "*" [STRING] @173:99
         ( [LPARENS] @174:22
            if [FUNC_POLY] @174:23
               = [EQUALS] @174:32
                  g-dob [VAR_DATE] @174:26
                  ? [UNKNOWN_VAL] @174:34
               true [BOOL_TRUE] @174:41
               = [EQUALS] @174:73
                  b-guest.date-of-birth [FIELD_DATE] @174:51
                  g-dob [VAR_DATE] @174:75
./abl/guests.p 00193 00026
where [KW_WHERE] @193:26
   expression [EXPRESSION] @0:0
      = [EQUALS] @193:49
         b-guest.guest-id [FIELD_INT] @193:32
         guest.guest-id [FIELD_INT] @193:51
./abl/guests.p 00273 00021
where [KW_WHERE] @273:21
   expression [EXPRESSION] @0:0
      = [EQUALS] @273:42
         guest.guest-id [FIELD_INT] @273:27
         g-id [VAR_INT] @273:44
./abl/guests.p 00284 00026
where [KW_WHERE] @284:26
   expression [EXPRESSION] @0:0
      = [EQUALS] @284:49
         b-guest.guest-id [FIELD_INT] @284:32
         guest.guest-id [FIELD_INT] @284:51
./abl/rates-report.p 00106 00016
where [KW_WHERE] @106:16
   expression [EXPRESSION] @0:0
      ( [LPARENS] @106:22
         if [FUNC_POLY] @106:23
            by-room [VAR_LOGICAL] @106:26
            = [EQUALS] @106:56
               t-room-type.type [FIELD_INT] @106:39
               room-type [VAR_INT] @106:58
            true [BOOL_TRUE] @106:73
./abl/rates-report.p 00108 00016
where [KW_WHERE] @108:16
   expression [EXPRESSION] @0:0
      and [KW_AND] @110:87
         and [KW_AND] @109:59
            and [KW_AND] @108:49
               = [EQUALS] @108:33
                  rate.floor [FIELD_INT] @108:22
                  t-floor.floor [FIELD_INT] @108:35
               = [EQUALS] @109:40
                  rate.type-of-room [FIELD_INT] @109:22
                  t-room-type.type [FIELD_INT] @109:42
            ( [LPARENS] @110:22
               if [FUNC_POLY] @110:23
                  = [EQUALS] @110:37
                     start-date [VAR_DATE] @110:26
                     ? [UNKNOWN_VAL] @110:39
                  true [BOOL_TRUE] @110:46
                  <= [LTE] @110:72
                     rate.start-date [FIELD_DATE] @110:56
                     start-date [VAR_DATE] @110:75
         ( [LPARENS] @111:22
            if [FUNC_POLY] @111:23
               = [EQUALS] @111:35
                  end-date [VAR_DATE] @111:26
                  ? [UNKNOWN_VAL] @111:37
               true [BOOL_TRUE] @111:44
               >= [GTE] @111:68
                  rate.end-date [FIELD_DATE] @111:54
                  end-date [VAR_DATE] @111:71
./abl/rates-report.p 00148 00016
where [KW_WHERE] @148:16
   expression [EXPRESSION] @0:0
      ( [LPARENS] @148:22
         if [FUNC_POLY] @148:23
            by-room [VAR_LOGICAL] @148:26
            = [EQUALS] @148:56
               t-room-type.type [FIELD_INT] @148:39
               room-type [VAR_INT] @148:58
            true [BOOL_TRUE] @148:73
./abl/rates-report.p 00151 00016
where [KW_WHERE] @151:16
   expression [EXPRESSION] @0:0
      and [KW_AND] @153:87
         and [KW_AND] @152:59
            and [KW_AND] @151:49
               = [EQUALS] @151:33
                  rate.floor [FIELD_INT] @151:22
                  t-floor.floor [FIELD_INT] @151:35
               = [EQUALS] @152:40
                  rate.type-of-room [FIELD_INT] @152:22
                  t-room-type.type [FIELD_INT] @152:42
            ( [LPARENS] @153:22
               if [FUNC_POLY] @153:23
                  = [EQUALS] @153:37
                     start-date [VAR_DATE] @153:26
                     ? [UNKNOWN_VAL] @153:39
                  true [BOOL_TRUE] @153:46
                  <= [LTE] @153:72
                     rate.start-date [FIELD_DATE] @153:56
                     start-date [VAR_DATE] @153:75
         ( [LPARENS] @154:22
            if [FUNC_POLY] @154:23
               = [EQUALS] @154:35
                  end-date [VAR_DATE] @154:26
                  ? [UNKNOWN_VAL] @154:37
               true [BOOL_TRUE] @154:44
               >= [GTE] @154:68
                  rate.end-date [FIELD_DATE] @154:54
                  end-date [VAR_DATE] @154:71
./abl/rates-report.p 00254 00016
where [KW_WHERE] @254:16
   expression [EXPRESSION] @0:0
      ( [LPARENS] @254:22
         if [FUNC_POLY] @254:23
            by-room [VAR_LOGICAL] @254:26
            = [EQUALS] @254:56
               t-room-type.type [FIELD_INT] @254:39
               room-type [VAR_INT] @254:58
            true [BOOL_TRUE] @254:73
./abl/rates-report.p 00256 00016
where [KW_WHERE] @256:16
   expression [EXPRESSION] @0:0
      and [KW_AND] @258:87
         and [KW_AND] @257:59
            and [KW_AND] @256:49
               = [EQUALS] @256:33
                  rate.floor [FIELD_INT] @256:22
                  t-floor.floor [FIELD_INT] @256:35
               = [EQUALS] @257:40
                  rate.type-of-room [FIELD_INT] @257:22
                  t-room-type.type [FIELD_INT] @257:42
            ( [LPARENS] @258:22
               if [FUNC_POLY] @258:23
                  = [EQUALS] @258:37
                     start-date [VAR_DATE] @258:26
                     ? [UNKNOWN_VAL] @258:39
                  true [BOOL_TRUE] @258:46
                  <= [LTE] @258:72
                     rate.start-date [FIELD_DATE] @258:56
                     start-date [VAR_DATE] @258:75
         ( [LPARENS] @259:22
            if [FUNC_POLY] @259:23
               = [EQUALS] @259:35
                  end-date [VAR_DATE] @259:26
                  ? [UNKNOWN_VAL] @259:37
               true [BOOL_TRUE] @259:44
               >= [GTE] @259:68
                  rate.end-date [FIELD_DATE] @259:54
                  end-date [VAR_DATE] @259:71
./abl/rates-report.p 00296 00016
where [KW_WHERE] @296:16
   expression [EXPRESSION] @0:0
      ( [LPARENS] @296:22
         if [FUNC_POLY] @296:23
            by-room [VAR_LOGICAL] @296:26
            = [EQUALS] @296:56
               t-room-type.type [FIELD_INT] @296:39
               room-type [VAR_INT] @296:58
            true [BOOL_TRUE] @296:73
./abl/rates-report.p 00299 00016
where [KW_WHERE] @299:16
   expression [EXPRESSION] @0:0
      and [KW_AND] @301:87
         and [KW_AND] @300:59
            and [KW_AND] @299:49
               = [EQUALS] @299:33
                  rate.floor [FIELD_INT] @299:22
                  t-floor.floor [FIELD_INT] @299:35
               = [EQUALS] @300:40
                  rate.type-of-room [FIELD_INT] @300:22
                  t-room-type.type [FIELD_INT] @300:42
            ( [LPARENS] @301:22
               if [FUNC_POLY] @301:23
                  = [EQUALS] @301:37
                     start-date [VAR_DATE] @301:26
                     ? [UNKNOWN_VAL] @301:39
                  true [BOOL_TRUE] @301:46
                  <= [LTE] @301:72
                     rate.start-date [FIELD_DATE] @301:56
                     start-date [VAR_DATE] @301:75
         ( [LPARENS] @302:22
            if [FUNC_POLY] @302:23
               = [EQUALS] @302:35
                  end-date [VAR_DATE] @302:26
                  ? [UNKNOWN_VAL] @302:37
               true [BOOL_TRUE] @302:44
               >= [GTE] @302:68
                  rate.end-date [FIELD_DATE] @302:54
                  end-date [VAR_DATE] @302:71
./abl/rates.p 00101 00024
where [KW_WHERE] @101:24
   expression [EXPRESSION] @0:0
      ( [LPARENS] @101:30
         if [FUNC_POLY] @101:31
            = [EQUALS] @101:51
               current-floor-no [VAR_INT] @101:34
               ? [UNKNOWN_VAL] @101:53
            true [BOOL_TRUE] @101:60
            = [EQUALS] @101:84
               t-floor.floor [FIELD_INT] @101:70
               current-floor-no [VAR_INT] @101:86
./abl/rates.p 00102 00027
where [KW_WHERE] @102:27
   expression [EXPRESSION] @0:0
      ( [LPARENS] @102:33
         if [FUNC_POLY] @102:34
            = [EQUALS] @102:55
               current-room-type [VAR_INT] @102:37
               ? [UNKNOWN_VAL] @102:57
            true [BOOL_TRUE] @102:64
            = [EQUALS] @102:91
               t-room-type.type [FIELD_INT] @102:74
               current-room-type [VAR_INT] @102:93
./abl/rates.p 00103 00020
where [KW_WHERE] @103:20
   expression [EXPRESSION] @0:0
      and [KW_AND] @103:53
         = [EQUALS] @103:37
            rate.floor [FIELD_INT] @103:26
            t-floor.floor [FIELD_INT] @103:39
         = [EQUALS] @104:44
            rate.type-of-room [FIELD_INT] @104:26
            t-room-type.type [FIELD_INT] @104:46
./abl/rates.p 00141 00023
where [KW_WHERE] @141:23
   expression [EXPRESSION] @0:0
      = [EQUALS] @141:42
         b-rate.floor [FIELD_INT] @141:29
         f-to [VAR_INT] @141:44
./abl/rates.p 00145 00023
where [KW_WHERE] @145:23
   expression [EXPRESSION] @0:0
      = [EQUALS] @145:42
         b-rate.floor [FIELD_INT] @145:29
         f-from [VAR_INT] @145:44
./abl/rates.p 00165 00010
where [KW_WHERE] @165:10
   expression [EXPRESSION] @0:0
      and [KW_AND] @165:42
         = [EQUALS] @165:29
            b-rate.floor [FIELD_INT] @165:16
            rate.floor [FIELD_INT] @165:31
         = [EQUALS] @166:36
            b-rate.type-of-room [FIELD_INT] @166:16
            rate.type-of-room [FIELD_INT] @166:38
./abl/rates.p 00225 00019
where [KW_WHERE] @225:19
   expression [EXPRESSION] @0:0
      = [EQUALS] @225:39
         recid [FUNC_RECID] @225:25
            b-rate [BUFFER] @225:31
         recid [FUNC_RECID] @225:41
            rate [TABLE] @225:47
./abl/reservations.p 00089 00004
where [KW_WHERE] @89:4
   expression [EXPRESSION] @0:0
      <> [NOT_EQ] @89:67
         reservation.state [FIELD_CHAR] @89:49
         'C' [STRING] @89:70
./abl/reservations.p 00099 00021
where [KW_WHERE] @99:21
   expression [EXPRESSION] @0:0
      = [EQUALS] @99:54
         reservation.reservation-id [FIELD_INT] @99:27
         r-id [VAR_INT] @99:56
./abl/reservations.p 00106 00015
where [KW_WHERE] @106:15
   expression [EXPRESSION] @0:0
      = [EQUALS] @106:34
         recid [FUNC_RECID] @106:21
            b-res [BUFFER] @106:27
         recid [FUNC_RECID] @106:36
            reservation [TABLE] @106:42
./abl/reservations.p 00115 00017
where [KW_WHERE] @115:17
   expression [EXPRESSION] @0:0
      = [EQUALS] @115:40
         b-guest.guest-id [FIELD_INT] @115:23
         g-id [VAR_INT] @115:42
./abl/reservations.p 00151 00025
where [KW_WHERE] @151:25
   expression [EXPRESSION] @0:0
      = [EQUALS] @151:57
         b-res-room.reservation-id [FIELD_INT] @151:31
         r-id [VAR_INT] @151:59
./abl/reservations.p 00189 00010
where [KW_WHERE] @189:10
   expression [EXPRESSION] @0:0
      and [KW_AND] @190:98
         and [KW_AND] @189:99
            ( [LPARENS] @189:16
               if [FUNC_POLY] @189:17
                  or [KW_OR] @189:30
                     = [EQUALS] @189:26
                        g-f-n [VAR_CHAR] @189:20
                        ? [UNKNOWN_VAL] @189:28
                     = [EQUALS] @189:39
                        g-f-n [VAR_CHAR] @189:33
                        "" [STRING] @189:41
                  true [BOOL_TRUE] @189:49
                  matches [KW_MATCHES] @189:78
                     b-guest.first-name [FIELD_CHAR] @189:59
                     + [PLUS] @189:92
                        g-f-n [VAR_CHAR] @189:86
                        "*" [STRING] @189:94
            ( [LPARENS] @190:16
               if [FUNC_POLY] @190:17
                  or [KW_OR] @190:30
                     = [EQUALS] @190:26
                        g-l-n [VAR_CHAR] @190:20
                        ? [UNKNOWN_VAL] @190:28
                     = [EQUALS] @190:39
                        g-l-n [VAR_CHAR] @190:33
                        "" [STRING] @190:41
                  true [BOOL_TRUE] @190:49
                  matches [KW_MATCHES] @190:77
                     b-guest.last-name [FIELD_CHAR] @190:59
                     + [PLUS] @190:91
                        g-l-n [VAR_CHAR] @190:85
                        "*" [STRING] @190:93
         ( [LPARENS] @191:16
            if [FUNC_POLY] @191:17
               = [EQUALS] @191:26
                  g-dob [VAR_DATE] @191:20
                  ? [UNKNOWN_VAL] @191:28
               true [BOOL_TRUE] @191:35
               = [EQUALS] @191:67
                  b-guest.date-of-birth [FIELD_DATE] @191:45
                  g-dob [VAR_DATE] @191:69
./abl/reservations.p 00207 00013
where [KW_WHERE] @207:13
   expression [EXPRESSION] @0:0
      and [KW_AND] @208:98
         and [KW_AND] @207:102
            ( [LPARENS] @207:19
               if [FUNC_POLY] @207:20
                  or [KW_OR] @207:33
                     = [EQUALS] @207:29
                        g-f-n [VAR_CHAR] @207:23
                        ? [UNKNOWN_VAL] @207:31
                     = [EQUALS] @207:42
                        g-f-n [VAR_CHAR] @207:36
                        "" [STRING] @207:44
                  true [BOOL_TRUE] @207:52
                  matches [KW_MATCHES] @207:81
                     b-guest.first-name [FIELD_CHAR] @207:62
                     + [PLUS] @207:95
                        g-f-n [VAR_CHAR] @207:89
                        "*" [STRING] @207:97
            ( [LPARENS] @208:16
               if [FUNC_POLY] @208:17
                  or [KW_OR] @208:30
                     = [EQUALS] @208:26
                        g-l-n [VAR_CHAR] @208:20
                        ? [UNKNOWN_VAL] @208:28
                     = [EQUALS] @208:39
                        g-l-n [VAR_CHAR] @208:33
                        "" [STRING] @208:41
                  true [BOOL_TRUE] @208:49
                  matches [KW_MATCHES] @208:77
                     b-guest.last-name [FIELD_CHAR] @208:59
                     + [PLUS] @208:91
                        g-l-n [VAR_CHAR] @208:85
                        "*" [STRING] @208:93
         ( [LPARENS] @209:16
            if [FUNC_POLY] @209:17
               = [EQUALS] @209:26
                  g-dob [VAR_DATE] @209:20
                  ? [UNKNOWN_VAL] @209:28
               true [BOOL_TRUE] @209:35
               = [EQUALS] @209:67
                  b-guest.date-of-birth [FIELD_DATE] @209:45
                  g-dob [VAR_DATE] @209:69
./abl/reservations.p 00273 00020
where [KW_WHERE] @273:20
   expression [EXPRESSION] @0:0
      = [EQUALS] @273:43
         b-guest.guest-id [FIELD_INT] @273:26
         g-id [VAR_INT] @273:45
./abl/reservations.p 00392 00016
where [KW_WHERE] @392:16
   expression [EXPRESSION] @0:0
      and [KW_AND] @393:104
         and [KW_AND] @392:105
            ( [LPARENS] @392:22
               if [FUNC_POLY] @392:23
                  or [KW_OR] @392:36
                     = [EQUALS] @392:32
                        g-f-n [VAR_CHAR] @392:26
                        ? [UNKNOWN_VAL] @392:34
                     = [EQUALS] @392:45
                        g-f-n [VAR_CHAR] @392:39
                        "" [STRING] @392:47
                  true [BOOL_TRUE] @392:55
                  matches [KW_MATCHES] @392:84
                     b-guest.first-name [FIELD_CHAR] @392:65
                     + [PLUS] @392:98
                        g-f-n [VAR_CHAR] @392:92
                        "*" [STRING] @392:100
            ( [LPARENS] @393:22
               if [FUNC_POLY] @393:23
                  or [KW_OR] @393:36
                     = [EQUALS] @393:32
                        g-l-n [VAR_CHAR] @393:26
                        ? [UNKNOWN_VAL] @393:34
                     = [EQUALS] @393:45
                        g-l-n [VAR_CHAR] @393:39
                        "" [STRING] @393:47
                  true [BOOL_TRUE] @393:55
                  matches [KW_MATCHES] @393:83
                     b-guest.last-name [FIELD_CHAR] @393:65
                     + [PLUS] @393:97
                        g-l-n [VAR_CHAR] @393:91
                        "*" [STRING] @393:99
         ( [LPARENS] @394:22
            if [FUNC_POLY] @394:23
               = [EQUALS] @394:32
                  g-dob [VAR_DATE] @394:26
                  ? [UNKNOWN_VAL] @394:34
               true [BOOL_TRUE] @394:41
               = [EQUALS] @394:73
                  b-guest.date-of-birth [FIELD_DATE] @394:51
                  g-dob [VAR_DATE] @394:75
./abl/reservations.p 00395 00029
where [KW_WHERE] @395:29
   expression [EXPRESSION] @0:0
      and [KW_AND] @395:69
         = [EQUALS] @395:50
            b-res.guest-id [FIELD_INT] @395:35
            b-guest.guest-id [FIELD_INT] @395:52
         >= [GTE] @395:88
            b-res.checkout [FIELD_DATE] @395:73
            today [FUNC_DATE] @395:91
./abl/reservations.p 00405 00027
where [KW_WHERE] @405:27
   expression [EXPRESSION] @0:0
      = [EQUALS] @405:60
         reservation.reservation-id [FIELD_INT] @405:33
         r-id [VAR_INT] @405:62
./abl/reservations.p 00482 00032
where [KW_WHERE] @482:32
   expression [EXPRESSION] @0:0
      = [EQUALS] @482:55
         b-guest.guest-id [FIELD_INT] @482:38
         g-id [VAR_INT] @482:57
./abl/reservations.p 00519 00033
where [KW_WHERE] @519:33
   expression [EXPRESSION] @0:0
      = [EQUALS] @519:57
         room.type-of-room [FIELD_INT] @519:39
         r-r-type [VAR_INT] @519:59
./abl/reservations.p 00524 00022
where [KW_WHERE] @524:22
   expression [EXPRESSION] @0:0
      and [KW_AND] @524:89
         and [KW_AND] @524:56
            >= [GTE] @524:43
               b-res2.checkin [FIELD_DATE] @524:28
               r-checkin [VAR_DATE] @524:46
            <= [LTE] @524:76
               b-res2.checkout [FIELD_DATE] @524:60
               r-checkin [VAR_DATE] @524:79
         <> [NOT_EQ] @525:41
            b-res2.state [FIELD_CHAR] @525:28
            res-state-ch [VAR_CHAR] @525:44
               [ [LBRACKET] @525:56
                  res-state-canceled [VAR_INT] @525:57
./abl/reservations.p 00554 00027
where [KW_WHERE] @554:27
   expression [EXPRESSION] @0:0
      = [EQUALS] @554:60
         reservation.reservation-id [FIELD_INT] @554:33
         r-id [VAR_INT] @554:62
./abl/reservations.p 00575 00024
where [KW_WHERE] @575:24
   expression [EXPRESSION] @0:0
      = [EQUALS] @575:51
         b-res.reservation-id [FIELD_INT] @575:30
         r-id [VAR_INT] @575:53
./abl/reservations.p 00586 00033
where [KW_WHERE] @586:33
   expression [EXPRESSION] @0:0
      = [EQUALS] @586:65
         b-res-room.reservation-id [FIELD_INT] @586:39
         b-res.reservation-id [FIELD_INT] @586:67
./abl/reservations.p 00602 00038
where [KW_WHERE] @602:38
   expression [EXPRESSION] @0:0
      = [EQUALS] @602:64
         b-room.type-of-room [FIELD_INT] @602:44
         b-res-room.type-of-room [FIELD_INT] @602:66
./abl/reservations.p 00613 00038
where [KW_WHERE] @613:38
   expression [EXPRESSION] @0:0
      and [KW_AND] @613:76
         >= [GTE] @613:59
            b-res2.checkin [FIELD_DATE] @613:44
            b-res.checkin [FIELD_DATE] @613:62
         <= [LTE] @613:95
            b-res2.checkin [FIELD_DATE] @613:80
            b-res.checkout [FIELD_DATE] @613:98
./abl/reservations.p 00615 00028
where [KW_WHERE] @615:28
   expression [EXPRESSION] @0:0
      and [KW_AND] @616:79
         and [KW_AND] @615:74
            <> [NOT_EQ] @615:53
               recid [FUNC_RECID] @615:34
                  b-out-room2 [BUFFER] @615:40
               recid [FUNC_RECID] @615:56
                  b-out-room [BUFFER] @615:62
            = [EQUALS] @616:58
               b-out-room2.room-number [FIELD_INT] @616:34
               b-room.room-number [FIELD_INT] @616:60
         = [EQUALS] @617:61
            b-out-room2.reservation-id [FIELD_INT] @617:34
            b-res2.reservation-id [FIELD_INT] @617:63
./abl/reservations.p 00641 00025
where [KW_WHERE] @641:25
   expression [EXPRESSION] @0:0
      and [KW_AND] @642:58
         and [KW_AND] @641:73
            = [EQUALS] @641:51
               b-rate.type-of-room [FIELD_INT] @641:31
               b-room.type-of-room [FIELD_INT] @641:53
            <= [LTE] @642:49
               b-rate.start-date [FIELD_DATE] @642:31
               today [FUNC_DATE] @642:52
         ( [LPARENS] @642:62
            or [KW_OR] @642:83
               = [EQUALS] @642:79
                  b-rate.end-date [FIELD_DATE] @642:63
                  ? [UNKNOWN_VAL] @642:81
               >= [GTE] @642:102
                  b-rate.end-date [FIELD_DATE] @642:86
                  today [FUNC_DATE] @642:105
./abl/reservations.p 00647 00028
where [KW_WHERE] @647:28
   expression [EXPRESSION] @0:0
      and [KW_AND] @647:76
         = [EQUALS] @647:54
            b-rate.type-of-room [FIELD_INT] @647:34
            b-room.type-of-room [FIELD_INT] @647:56
         <= [LTE] @648:50
            b-rate.end-date [FIELD_DATE] @648:34
            today [FUNC_DATE] @648:53
./abl/reservations.p 00674 00027
where [KW_WHERE] @674:27
   expression [EXPRESSION] @0:0
      = [EQUALS] @674:60
         reservation.reservation-id [FIELD_INT] @674:33
         r-id [VAR_INT] @674:62
./abl/reservations.p 00684 00027
where [KW_WHERE] @684:27
   expression [EXPRESSION] @0:0
      = [EQUALS] @684:54
         b-res.reservation-id [FIELD_INT] @684:33
         r-id [VAR_INT] @684:56
./abl/reservations.p 00699 00024
where [KW_WHERE] @699:24
   expression [EXPRESSION] @0:0
      = [EQUALS] @699:51
         b-res.reservation-id [FIELD_INT] @699:30
         r-id [VAR_INT] @699:53
./abl/reservations.p 00700 00033
where [KW_WHERE] @700:33
   expression [EXPRESSION] @0:0
      = [EQUALS] @700:65
         b-res-room.reservation-id [FIELD_INT] @700:39
         b-res.reservation-id [FIELD_INT] @700:67
./abl/rooms-add.p 00063 00017
where [KW_WHERE] @63:17
   expression [EXPRESSION] @0:0
      and [KW_AND] @63:53
         = [EQUALS] @63:34
            room.floor [FIELD_INT] @63:23
            current-floor-no [VAR_INT] @63:36
         = [EQUALS] @63:74
            room.room-number [FIELD_INT] @63:57
            r-no [VAR_INT] @63:76
./abl/rooms-overview.p 00051 00018
where [KW_WHERE] @51:18
   expression [EXPRESSION] @0:0
      and [KW_AND] @51:54
         = [EQUALS] @51:42
            room.type-of-room [FIELD_INT] @51:24
            room-type [VAR_INT] @51:44
         = [EQUALS] @51:69
            room.floor [FIELD_INT] @51:58
            f-no [VAR_INT] @51:71
./abl/rooms.p 00038 00017
where [KW_WHERE] @38:17
   expression [EXPRESSION] @0:0
      = [EQUALS] @38:34
         room.floor [FIELD_INT] @38:23
         current-floor-no [VAR_INT] @38:36
./abl/rooms.p 00069 00016
where [KW_WHERE] @69:16
   expression [EXPRESSION] @0:0
      = [EQUALS] @69:36
         recid [FUNC_RECID] @69:22
            b-room [BUFFER] @69:28
         c-room [VAR_RECID] @69:38
./abl/rooms.p 00075 00025
where [KW_WHERE] @75:25
   expression [EXPRESSION] @0:0
      and [KW_AND] @75:75
         = [EQUALS] @75:54
            room-state.room-number [FIELD_INT] @75:31
            b-room.room-number [FIELD_INT] @75:56
         <= [LTE] @75:101
            room-state.start-date [FIELD_DATE] @75:79
            today [FUNC_DATE] @75:104
./abl/rooms.p 00113 00025
where [KW_WHERE] @113:25
   expression [EXPRESSION] @0:0
      = [EQUALS] @113:42
         room.floor [FIELD_INT] @113:31
         current-floor-no [VAR_INT] @113:44
./abl/rooms.p 00120 00025
where [KW_WHERE] @120:25
   expression [EXPRESSION] @0:0
      = [EQUALS] @120:42
         room.floor [FIELD_INT] @120:31
         current-floor-no [VAR_INT] @120:44
./abl/rooms.p 00127 00026
where [KW_WHERE] @127:26
   expression [EXPRESSION] @0:0
      = [EQUALS] @127:43
         room.floor [FIELD_INT] @127:32
         current-floor-no [VAR_INT] @127:45
./abl/rooms.p 00134 00025
where [KW_WHERE] @134:25
   expression [EXPRESSION] @0:0
      = [EQUALS] @134:42
         room.floor [FIELD_INT] @134:31
         current-floor-no [VAR_INT] @134:44
./abl/rooms.p 00143 00075
where [KW_WHERE] @143:75
   = [EQUALS] @143:98
      room.room-number [FIELD_INT] @143:81
      r-no2 [VAR_INT] @143:100
./abl/rooms.p 00148 00020
where [KW_WHERE] @148:20
   expression [EXPRESSION] @0:0
      = [EQUALS] @148:43
         room.room-number [FIELD_INT] @148:26
         r-no2 [VAR_INT] @148:45
./abl/rooms.p 00157 00026
where [KW_WHERE] @157:26
   expression [EXPRESSION] @0:0
      = [EQUALS] @157:47
         recid [FUNC_RECID] @157:32
            b-room2 [BUFFER] @157:38
         c-room [VAR_RECID] @157:49
./abl/rooms.p 00159 00032
where [KW_WHERE] @159:32
   expression [EXPRESSION] @0:0
      = [EQUALS] @159:57
         b-room-state2.room [FIELD_INT] @159:38
         b-room2.room-number [FIELD_INT] @159:59
./abl/rooms.p 00186 00026
where [KW_WHERE] @186:26
   expression [EXPRESSION] @0:0
      = [EQUALS] @186:47
         recid [FUNC_RECID] @186:32
            b-room2 [BUFFER] @186:38
         c-room [VAR_RECID] @186:49
./abl/rooms.p 00188 00033
where [KW_WHERE] @188:33
   expression [EXPRESSION] @0:0
      = [EQUALS] @188:58
         b-room-state2.room [FIELD_INT] @188:39
         b-room2.room-number [FIELD_INT] @188:60
./abl/rooms.p 00221 00026
where [KW_WHERE] @221:26
   expression [EXPRESSION] @0:0
      = [EQUALS] @221:43
         room.floor [FIELD_INT] @221:32
         current-floor-no [VAR_INT] @221:45
./abl/rooms.p 00234 00026
where [KW_WHERE] @234:26
   expression [EXPRESSION] @0:0
      = [EQUALS] @234:43
         room.floor [FIELD_INT] @234:32
         current-floor-no [VAR_INT] @234:45
./abl/rooms.p 00247 00026
where [KW_WHERE] @247:26
   expression [EXPRESSION] @0:0
      = [EQUALS] @247:47
         recid [FUNC_RECID] @247:32
            b-room2 [BUFFER] @247:38
         c-room [VAR_RECID] @247:49

Conditions matched: [ parent.type == prog.record_phrase and !evalLib("literals", type) and !evalLib("record_types_rel", this) ]


Please see the Source File Index for the list of report inputs. Generated at 03/31/2017 21:16:32 EEST.