OPEN QUERY FOR EACH EACH EACH (1 in 1 files)

Filename Line # Column # Match Text
./abl/rates.p 00100 00004
open [OPEN_QUERY] @100:4
   q-room [QUERY] @100:15
   for [KW_FOR] @101:7
      each [KW_EACH] @101:11
      record phrase [RECORD_PHRASE] @0:0
         t-floor [TEMP_TABLE] @101:16
         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
      each [KW_EACH] @102:10
      record phrase [RECORD_PHRASE] @0:0
         t-room-type [TEMP_TABLE] @102:15
         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
      each [KW_EACH] @103:10
      record phrase [RECORD_PHRASE] @0:0
         rate [TABLE] @103:15
         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
         outer-join [KW_OUT_JOIN] @105:20
         use-index [KW_USE_IDX] @106:20
            idx-rate-e-date [INDEX] @106:30

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


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