Consulta Padrao: JLB - Itens Grade de Aulas



Consulta Padrao(SXB): JLB - Itens Grade de Aulas
XB_ALIASXB_TIPOXB_SEQXB_COLUNAXB_DESCRIXB_CONTEM
JLB101DBItens Grade de AulasJBL
JLB20101Codigo
JLB40101Codigo do cursoJBL_CODCUR
JLB40102ProfessorPosicione("JAH",1,xFilial("JAH")+JBL->JBL_CODCUR,"JAH_DESC")
JLB40103Periodo LetivoJBL_PERLET
JLB40104TurmaJBL_TURMA
JLB40105Codigo da disciplinaJBL_CODDIS
JLB40201Matricula professorJBL_MATPRF
JLB40202Nome do professorPosicione("SRA",1,xFilial("SRA")+JBL->JBL_MATPRF, "RA_NOME")
JLB40203Codigo do cursoJBL_CODCUR
JLB40204Periodo LetivoJBL_PERLET
JLB40205TurmaJBL_TURMA
JLB501A420AtuVar()
JLB502Posicione("JAH",1,xFilial("JAH")+M->JAT_CODCUR,"JAH_DESC")
JLB503Posicione("JAR",1,xFilial("JAR")+M->JAT_CODCUR+M->JAT_PERLET+M->JAT_HABILI,"JAR_ANOLET")
JLB504JBL->JBL_PERLET
JLB505Posicione("JAH",1,xFilial("JAH")+M->JAT_CODCUR,"JAH_TURNO")
JLB506Tabela("F5",M->JAT_TURNO,.F.)
JLB507JBL->JBL_TURMA
JLB508JBL->JBL_CODDIS
JLB509Posicione("JAE",1,xFilial("JAE")+M->JAT_CODDIS,"JAE_DESC")
JLB510JBL->JBL_MATPRF
JLB511Posicione("SRA",1,xFilial("SRA")+M->JAT_MATPRF,"RA_NOME")
JLB512Posicione("JAR",1,xFilial("JAR")+M->JAT_CODCUR+M->JAT_PERLET+M->JAT_HABILI,"JAR_DATA1")
JLB513Posicione("JAR",1,xFilial("JAR")+M->JAT_CODCUR+M->JAT_PERLET+M->JAT_HABILI,"JAR_DATA2")