FOR EACH EACH EACH (5 in 2 files)

Filename Line # Column # Match Text
./abl/checkout.p 00284 00013
for [KW_FOR] @284:13
   each [KW_EACH] @284:17
   record phrase [RECORD_PHRASE] @0:0
      b-guest [BUFFER] @284:22
      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
      no-lock [KW_NO_LOCK] @286:104
   each [KW_EACH] @287:17
   record phrase [RECORD_PHRASE] @0:0
      b-res [BUFFER] @287:22
      where [KW_WHERE] @287:28
         expression [EXPRESSION] @0:0
            >= [GTE] @287:49
               b-res.checkout [FIELD_DATE] @287:34
               today [FUNC_DATE] @287:52
      use-index [KW_USE_IDX] @287:58
         idx-r-checkin [INDEX] @287:68
      no-lock [KW_NO_LOCK] @287:82
   each [KW_EACH] @288:17
   record phrase [RECORD_PHRASE] @0:0
      b-out-room [BUFFER] @288:22
      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
      no-lock [KW_NO_LOCK] @292:67
./abl/rates-report.p 00104 00010
for [KW_FOR] @104:10
   each [KW_EACH] @104:14
   record phrase [RECORD_PHRASE] @0:0
      t-floor [TEMP_TABLE] @104:19
   each [KW_EACH] @105:13
   record phrase [RECORD_PHRASE] @0:0
      t-room-type [TEMP_TABLE] @105:18
      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
   each [KW_EACH] @107:13
   record phrase [RECORD_PHRASE] @0:0
      rate [TABLE] @107:18
      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
      no-lock [KW_NO_LOCK] @112:16
   break [KW_BREAK] @113:13
   by [KW_BY] @113:19
      expression [EXPRESSION] @0:0
         t-floor.floor [FIELD_INT] @113:22
   by [KW_BY] @114:19
      expression [EXPRESSION] @0:0
         t-room-type.type [FIELD_INT] @114:22
./abl/rates-report.p 00147 00010
for [KW_FOR] @147:10
   each [KW_EACH] @147:14
   record phrase [RECORD_PHRASE] @0:0
      t-room-type [TEMP_TABLE] @147:19
      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
   each [KW_EACH] @149:13
   record phrase [RECORD_PHRASE] @0:0
      t-floor [TEMP_TABLE] @149:18
   each [KW_EACH] @150:13
   record phrase [RECORD_PHRASE] @0:0
      rate [TABLE] @150:18
      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
      no-lock [KW_NO_LOCK] @155:16
   break [KW_BREAK] @156:13
   by [KW_BY] @156:19
      expression [EXPRESSION] @0:0
         t-room-type.type [FIELD_INT] @156:22
   by [KW_BY] @157:19
      expression [EXPRESSION] @0:0
         t-floor.floor [FIELD_INT] @157:22
./abl/rates-report.p 00252 00010
for [KW_FOR] @252:10
   each [KW_EACH] @252:14
   record phrase [RECORD_PHRASE] @0:0
      t-floor [TEMP_TABLE] @252:19
   each [KW_EACH] @253:13
   record phrase [RECORD_PHRASE] @0:0
      t-room-type [TEMP_TABLE] @253:18
      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
   each [KW_EACH] @255:13
   record phrase [RECORD_PHRASE] @0:0
      rate [TABLE] @255:18
      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
      no-lock [KW_NO_LOCK] @260:16
   break [KW_BREAK] @261:13
   by [KW_BY] @261:19
      expression [EXPRESSION] @0:0
         t-floor.floor [FIELD_INT] @261:22
   by [KW_BY] @262:19
      expression [EXPRESSION] @0:0
         t-room-type.type [FIELD_INT] @262:22
./abl/rates-report.p 00295 00010
for [KW_FOR] @295:10
   each [KW_EACH] @295:14
   record phrase [RECORD_PHRASE] @0:0
      t-room-type [TEMP_TABLE] @295:19
      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
   each [KW_EACH] @297:13
   record phrase [RECORD_PHRASE] @0:0
      t-floor [TEMP_TABLE] @297:18
   each [KW_EACH] @298:13
   record phrase [RECORD_PHRASE] @0:0
      rate [TABLE] @298:18
      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
      no-lock [KW_NO_LOCK] @303:16
   break [KW_BREAK] @304:13
   by [KW_BY] @304:19
      expression [EXPRESSION] @0:0
         t-room-type.type [FIELD_INT] @304:22
   by [KW_BY] @305:19
      expression [EXPRESSION] @0:0
         t-floor.floor [FIELD_INT] @305:22

Conditions matched: [ evalLib("static_record_retrieval", this) ]


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