Shell Programming and Scripting

select c.net_svc_id, c.inst_st_dt into ${REO_RECON_USERID_LUZON_TEMP} from ${WO_INST_SITE_COMP_FIELDS} a, ${WO_INST_SITE_COMPONENTS} b, ${WO_INST} c where a.cust_ac_no = b.cust_ac_no and a.inst_seq_no = b.inst_seq_no and a.site_no = b.site_no and a.comp_no = b.comp_no and a.comp_type = b.comp_type and b.cust_ac_no = c.cust_ac_no and b.inst_seq_no = c.inst_seq_no and a.field_id = 'USERID' and a.field_value like '%@globelines.com.ph%' and convert( char(8), c.inst_st_dt, 112) <= "${ICCBS_DATE}"
select net_svc_id, max(inst_st_dt)inststdt into ${REO_RECON_USERID_LUZON_UPDATE} from ${REO_RECON_USERID_LUZON_TEMP} group by net_svc_id

select
  c.net_svc_id,
  c.inst_st_dt
 into ${REO_RECON_USERID_LUZON_TEMP} -- Creates a table
 from -- three way inner join using where
  ${WO_INST_SITE_COMP_FIELDS} a, -- assume variables have relation names
  ${WO_INST_SITE_COMPONENTS} b,
  ${WO_INST} c
 where a.cust_ac_no = b.cust_ac_no
    and a.inst_seq_no = b.inst_seq_no
    and a.site_no = b.site_no
    and a.comp_no = b.comp_no
    and a.comp_type = b.comp_type
    and b.cust_ac_no = c.cust_ac_no
    and b.inst_seq_no = c.inst_seq_no
    and a.field_id = 'USERID'
    and a.field_value like '%@globelines.com.ph%'
    and convert( char(8), c.inst_st_dt, 112) <= "${ICCBS_DATE}" -- better to compare as datetime not char.
 
select
  net_svc_id,
  max(inst_st_dt) inststdt
 into ${REO_RECON_USERID_LUZON_UPDATE} -- creates a table
 from ${REO_RECON_USERID_LUZON_TEMP}
 group by net_svc_id

select
  c.net_svc_id,
  c.inst_st_dt
 into ${REO_RECON_USERID_LUZON_TEMP} -- Creates a table
 from -- three way inner join using where
  ${WO_INST_SITE_COMP_FIELDS} a -- assume variables have relation names
 join ${WO_INST_SITE_COMPONENTS} b
  ON    a.cust_ac_no = b.cust_ac_no
    and a.inst_seq_no = b.inst_seq_no
    and a.site_no = b.site_no
    and a.comp_no = b.comp_no
    and a.comp_type = b.comp_type
 join ${WO_INST} c
  ON    b.cust_ac_no = c.cust_ac_no
    and b.inst_seq_no = c.inst_seq_no
 where a.field_id = 'USERID'
    and a.field_value like '%@globelines.com.ph%'
    and convert( char(8), c.inst_st_dt, 112) <= "${ICCBS_DATE}" -- better to compare as datetime not char.