Visão geral

Este comando listará as reservas de ativos.

Tabelas relacionadas

Tabela	Descrição	Chave primária (PK)	Tabelas de ligação
ASRESERVE	Cadastro de reservas dos ativos	CDRESERVE	ADALLUSERS ADDEPARTMENT
ASASSETRESERVE	Associação de ativos nas reservas	CDRESERVE CDASSET CDREVISION	ASASSET ASRESERVE
ASASSET	Cadastro de ativos	CDASSET CDREVISION	ADCHECKLIST ADCOMPANY ADTEAM ASCONTROLS ASDEPRECIATION ASGENCONFIG ASSTATE DCDOCUMENT
OBOBJECT	Cadastro dos dados de item/ativo/insumo por revisão	CDOBJECT CDREVISION	ADTEAM GNASSOC GNREVISION OBOBJECTGROUP OBSUBREASON
GNREVISION	Revisão	CDREVISION	ADALLUSERS GNACTIONASSOC GNASSOC GNREASON GNREVCONFIG GNREVISIONSTATUS
OBOBJECTGROUP	Cadastro de item/ativo/insumo	CDOBJECTGROUP	GNFAVORITE
OBOBJECTTYPE	Cadastro de tipo de item/ativo/insumo	CDOBJECTTYPE	ADMEASUNITY ADTEAM GNMASK GNREVCONFIG GNTYPEROLE
ADDEPARTMENT	Área	CDDEPARTMENT	ADALLUSERS ADDEPARTMENT ADTEAM COWORKSPACE GNASSOC GNFAVORITE GNMAPPING
ADALLUSERS	Usuário	CDUSER	ADALLUSERS ADUSEREXTERNALDATA GNFAVORITE
PRTASK	Projeto/Atividade/Atividade isolada/Evento monitorado	CDTASK	ADALLUSERS ADDEPARTMENT ADTEAM GNACTIVITYTIMECFG GNAPPROV GNASSOC GNCALENDAR GNCHECKLISTANSWER GNFAVORITE GNREVISIONSTATUS PRCONFRECURRING PRPRIORITY PRTASKTYPE

Oracle

SELECT
   PRTK1.FGTASKTYPE,
   GRP.FGSTATUS,
   ASA.FGASSTATUS,
   ASTR.FGSTATUS FGSTATUSRESERVE,
   OBTY.IDOBJECTTYPE,
   OBJ.IDOBJECT,
   OBJ.NMOBJECT,
   GNR.IDREVISION,
   ASR.IDRESERVE,
   ASR.DTCHECKOUT,
   ASTR.DTDUEDATE,
   ASTR.DTEND,
   ASTR.FGTYPERESERVE,
   ADDPTEMISSOR.IDDEPARTMENT || ' - ' || ADDPTEMISSOR.NMDEPARTMENT AS NMDEPARTMENTEMISSOR_FULLNAME,
   USREMISSOR.IDUSER,
   USREMISSOR.NMUSER AS NMUSEREMISSOR,
   ADDPTDESTINATARIO.IDDEPARTMENT || ' - ' || ADDPTDESTINATARIO.NMDEPARTMENT AS NMDEPARTMENTDEST_FULLNAME,
   USRDESTINATARIO.IDUSER AS USRDEST,
   USRDESTINATARIO.NMUSER AS NMUSERDESTINATARIO

FROM
   ASRESERVE ASR
   INNER JOIN ASASSETRESERVE ASTR ON ( ASR.CDRESERVE = ASTR.CDRESERVE )
   INNER JOIN ASASSET ASA ON ( ASTR.CDASSET = ASA.CDASSET )
   INNER JOIN OBOBJECT OBJ ON ( OBJ.CDOBJECT = ASTR.CDASSET AND OBJ.FGCURRENT = 1 )
   INNER JOIN GNREVISION GNR ON ( OBJ.CDREVISION = GNR.CDREVISION )
   INNER JOIN OBOBJECTGROUP GRP ON ( ASTR.CDASSET = GRP.CDOBJECTGROUP )
   INNER JOIN OBOBJECTTYPE OBTY ON ( GRP.CDOBJECTTYPE = OBTY.CDOBJECTTYPE )
   INNER JOIN ADDEPARTMENT ADDPTEMISSOR ON ( ASR.CDSENDERDEPT = ADDPTEMISSOR.CDDEPARTMENT )
   INNER JOIN ADUSER USREMISSOR ON ( ASR.CDSENDERUSER = USREMISSOR.CDUSER )
   INNER JOIN ADDEPARTMENT ADDPTDESTINATARIO ON ( ASR.CDDESTDEPT = ADDPTDESTINATARIO.CDDEPARTMENT )
   INNER JOIN ADUSER USRDESTINATARIO ON ( ASR.CDDESTUSER = USRDESTINATARIO.CDUSER )
   LEFT OUTER JOIN PRTASK PRTK1 ON (PRTK1.CDTASK = ASR.CDTASK)
WHERE
   OBJ.FGTEMPLATE <> 1 /*OBS 1*/
   AND (ASA.FGASSTATUS IS NULL OR ASA.FGASSTATUS <> 4) /*OBS 2

Postgres

SQL Server

SELECT
   PRTK1.FGTASKTYPE,
   GRP.FGSTATUS,
   ASA.FGASSTATUS,
   ASTR.FGSTATUS FGSTATUSRESERVE,
   OBTY.IDOBJECTTYPE,
   OBJ.IDOBJECT,
   OBJ.NMOBJECT,
   GNR.IDREVISION,
   ASR.IDRESERVE,
   ASR.DTCHECKOUT,
   ASTR.DTDUEDATE,
   ASTR.DTEND,
   ASTR.FGTYPERESERVE,
   ADDPTEMISSOR.IDDEPARTMENT + ' - ' + ADDPTEMISSOR.NMDEPARTMENT AS NMDEPARTMENTEMISSOR_FULLNAME,
   USREMISSOR.IDUSER,
   USREMISSOR.NMUSER AS NMUSEREMISSOR,
   ADDPTDESTINATARIO.IDDEPARTMENT + ' - ' + ADDPTDESTINATARIO.NMDEPARTMENT AS NMDEPARTMENTDEST_FULLNAME,
   USRDESTINATARIO.IDUSER AS USRDEST,
   USRDESTINATARIO.NMUSER AS NMUSERDESTINATARIO

FROM
   ASRESERVE ASR
   INNER JOIN ASASSETRESERVE ASTR ON ( ASR.CDRESERVE = ASTR.CDRESERVE )
   INNER JOIN ASASSET ASA ON ( ASTR.CDASSET = ASA.CDASSET )
   INNER JOIN OBOBJECT OBJ ON ( OBJ.CDOBJECT = ASTR.CDASSET AND OBJ.FGCURRENT = 1 )
   INNER JOIN GNREVISION GNR ON ( OBJ.CDREVISION = GNR.CDREVISION )
   INNER JOIN OBOBJECTGROUP GRP ON ( ASTR.CDASSET = GRP.CDOBJECTGROUP )
   INNER JOIN OBOBJECTTYPE OBTY ON ( GRP.CDOBJECTTYPE = OBTY.CDOBJECTTYPE )
   INNER JOIN ADDEPARTMENT ADDPTEMISSOR ON ( ASR.CDSENDERDEPT = ADDPTEMISSOR.CDDEPARTMENT )
   INNER JOIN ADUSER USREMISSOR ON ( ASR.CDSENDERUSER = USREMISSOR.CDUSER )
   INNER JOIN ADDEPARTMENT ADDPTDESTINATARIO ON ( ASR.CDDESTDEPT = ADDPTDESTINATARIO.CDDEPARTMENT )
   INNER JOIN ADUSER USRDESTINATARIO ON ( ASR.CDDESTUSER = USRDESTINATARIO.CDUSER )
   LEFT OUTER JOIN PRTASK PRTK1 ON (PRTK1.CDTASK = ASR.CDTASK)
WHERE
   OBJ.FGTEMPLATE <> 1 /*OBS 1*/
   AND (ASA.FGASSTATUS IS NULL OR ASA.FGASSTATUS <> 4) /*OBS 2*/

Observações

▪1: O campo FGTEMPLATE da tabela OBOBJECT indica se o ativo é modelo, 1 – Sim; 2 – Não;

▪2: O campo FGSTATUS da tabela ASASSET indica a situação do ativo, o valor 4 é desativado.

Campos utilizados na consulta

ativo-03

ativo-04