Overview
This command will list the data of an asset.
Related tables
Table
|
Description
|
Primary key (PK)
|
Connection tables
|
OBOBJECT
|
Item/Asset/Supply data based on revision
|
CDOBJECT
CDREVISION
|
ADTEAM
GNASSOC
GNREVISION
OBOBJECTGROUP
OBSUBREASON
|
GNREVISION
|
Revision
|
CDREVISION
|
ADALLUSERS
GNACTIONASSOC
GNASSOC
GNREASON
GNREVCONFIG
GNREVISIONSTATUS
|
OBOBJECTGROUP
|
Item/Asset/Supply
|
CDOBJECTGROUP
|
GNFAVORITE
|
ADTEAM
|
Teams
|
CDTEAM
|
ADAUTHLDAPCONFIG
GNMAPPING
GNPERMISSION
|
OBOBJECTTYPE
|
Item/Asset/Supply type
|
CDOBJECTTYPE
|
ADMEASUNITY
ADTEAM
GNMASK
GNREVCONFIG
GNTYPEROLE
|
ASASSET
|
Assets
|
CDASSET
CDREVISION
|
ADCHECKLIST
ADCOMPANY
ADTEA
ASCONTROLS
ASDEPRECIATION
ASGENCONFIG
ASSTATE
DCDOCUMENT
|
ADCOMPANY
|
Company
|
CDCOMPANY
|
ADCOMPANYTYPE
|
DCDOCREVISION
|
Document
|
CDDOCUMENT
CDREVISION
|
DCCATEGORY
DCDOCUMENT
EFREVISIONFORM
GNASSOC
GNCOMPFILECONTCOPY
GNREVISION
GNTRANSLATION
|
MAEQPT
|
Equipment
|
CDEQPT
CDREVISION
|
ADALLUSERS
ADMAILTASKREL
ASASSET
MAEQPTMETERREAD
MAEQPTMETERRESTART
MAEQPTUNITY
|
GNRESOURCE
|
Resources
|
CDRESOURCE
|
ADALLUSERS
ADCOMPANY
GNASSOC
GNCALENDAR
GNRESOURCETYPE
OBOBJECTGROUP
|
GNCALENDAR
|
Calendar
|
CDCALENDAR
|
|
ASHISTASSETSITE
|
Assets location history
|
CDHISTASSETSITE
|
ADALLUSERS
ASASSET
ASSITE
|
ASHISTASSETSTATE
|
Asset conditions history
|
CDHISTASSETSTATE
|
ADALLUSERS
ASASSET
ASSTATE
|
GNTRANSLATIONLANGUAGE
|
Translation
|
GNTRANSLATION
|
GNTRANSLATION
|
ADALLUSERS
|
User
|
ADUSEREXTERNALDATA
GNFAVORITE
|
ADUSEREXTERNALDATA
GNFAVORITE
|
ADDEPARTMENT
|
Department
|
ADALLUSERS
ADDEPARTMENT
ADTEAM
COWORKSPACE
GNASSOC
GNFAVORITE
GNMAPPING
|
ADALLUSERS
ADDEPARTMENT
ADTEAM
COWORKSPACE
GNASSOC
GNFAVORITE
GNMAPPING
|
Oracle
SELECT
OBJ.IDOBJECT,
OBJ.NMOBJECT,
GNREV.IDREVISION,
GNREV.DTREVISION,
OBJTYPE.IDOBJECTTYPE || ' - ' || OBJTYPE.NMOBJECTTYPE NMOBJECTTYPE,
TEAM.IDTEAM || ' - ' || TEAM.NMTEAM NMTEAMRESPONSABLE,
TBL_LASTSTATE.IDSTATE || ' - ' || TBL_LASTSTATE.NMSTATE NMLASTSTATE,
OBJ.FGAPPLICATION,
ASAST.DTSTARTOPER,
ASAST.QTQUANTITY,
ASAST.QTAVAILABLE,
AST_CALENDAR.IDCALENDAR || ' - ' || AST_CALENDAR.NMCALENDAR NMCALENDAR,
ASAST.FGASSTATUS,
TBL_LASTSITE.IDSITE || ' - ' || TBL_LASTSITE.NMSITE LASTSITE_NMSITE,
TBL_LASTSITE.IDUSER || ' - ' || TBL_LASTSITE.NMUSER LASTSITE_NMUSER,
TBL_LASTSITE.NMCOORD,
ASAST.FGVIEWACCESS,
TEAMACCESS.IDTEAM || ' - ' || TEAMACCESS.NMTEAM NMTEAMVIEWACCESS,
ASAST.FGOWNER,
ADCMP.IDCOMMERCIAL || ' - ' || ADCMP.NMCOMPANY NMCOMPANYOWNER,
ADMNFT.IDCOMMERCIAL || ' - ' || ADMNFT.NMCOMPANY NMMANUFACTURER,
ADMSUPP.IDCOMMERCIAL || ' - ' || ADMSUPP.NMCOMPANY NMSUPPLIER,
ASAST.IDSERIALNUMBER,
ASAST.IDMODEL,
ASAST.FGRESOURCE,
TBL_CHKWARRANTYDOC.IDDOCUMENT || ' - ' || TBL_CHKWARRANTYDOC.NMTITLE NMWARRANTYDOC,
TBL_CHKWARRANTYDOC.DTREVISION DTDOCREV,
CASE TBL_CHKWARRANTYDOC.FGVALIDITY
WHEN 1 THEN (TBL_CHKWARRANTYDOC.DTREVISION + TBL_CHKWARRANTYDOC.QTVALIDITY)
WHEN 2 THEN (TBL_CHKWARRANTYDOC.DTREVISION + (TBL_CHKWARRANTYDOC.QTVALIDITY*30))
WHEN 3 THEN (TBL_CHKWARRANTYDOC.DTREVISION + (TBL_CHKWARRANTYDOC.QTVALIDITY*365))
ELSE NULL
END VIEW_DTDOCREVVALIDITY,
ASAST.DSDESCRIPTION,
MAEQUIPMENT.DSEQPT,
OBJ.DSOBSERVATION,
ASAST.FGAUTOACQUISITION,
ASAST.IDIPADDRESS,
ASAST.IDPORT,
ASAST.QTTIMEOUT
FROM OBOBJECT OBJ
INNER JOIN GNREVISION GNREV ON (OBJ.CDREVISION = GNREV.CDREVISION)
INNER JOIN OBOBJECTGROUP OBJGRP ON (OBJ.CDOBJECT = OBJGRP.CDOBJECTGROUP)
LEFT JOIN ADTEAM TEAM ON (OBJ.CDTEAMRESPONSABLE = TEAM.CDTEAM)
INNER JOIN OBOBJECTTYPE OBJTYPE ON (OBJTYPE.CDOBJECTTYPE = OBJGRP.CDOBJECTTYPE)
INNER JOIN ASASSET ASAST ON (ASAST.CDASSET = OBJ.CDOBJECT AND ASAST.CDREVISION = OBJ.CDREVISION)
LEFT JOIN ADTEAM TEAMACCESS ON (ASAST.CDTEAMVIEWACCESS = TEAMACCESS.CDTEAM)
LEFT JOIN ADCOMPANY ADCMP ON (ADCMP.CDCOMPANY = ASAST.CDCOMPANYOWNER)
LEFT JOIN ADCOMPANY ADMNFT ON (ADMNFT.CDCOMPANY = ASAST.CDMANUFACTURER)
LEFT JOIN ADCOMPANY ADMSUPP ON (ADMSUPP.CDCOMPANY = ASAST.CDSUPPLIER)
LEFT JOIN (
SELECT CHKDCREV.CDDOCUMENT,
CHKDCREV.CDREVISION,
CHKDCREV.IDDOCUMENT,
COALESCE(TRLG.NMTRANSLATION, CHKDCREV.NMTITLE) NMTITLE,
CHKGNREV.DTREVISION,
CHKGNREV.QTVALIDITY,
CHKGNREV.FGVALIDITY
FROM DCDOCREVISION CHKDCREV
LEFT JOIN GNREVISION CHKGNREV ON (CHKDCREV.CDREVISION = CHKGNREV.CDREVISION)
LEFT JOIN DCCATEGORY CHKDCCAT ON (CHKDCCAT.CDCATEGORY = CHKDCREV.CDCATEGORY)
LEFT JOIN GNTRANSLATIONLANGUAGE TRLG ON (CHKDCREV.CDTRANSLATION = TRLG.CDTRANSLATION AND TRLG.FGLANGUAGE = 2)
WHERE CHKDCCAT.FGCATEGORYTYPE = 4
AND CHKDCREV.FGCURRENT = 1
) TBL_CHKWARRANTYDOC ON (TBL_CHKWARRANTYDOC.CDDOCUMENT = ASAST.CDWARRANTYDOC)
LEFT JOIN MAEQPT MAEQUIPMENT ON (MAEQUIPMENT.CDEQPT = ASAST.CDASSET AND MAEQUIPMENT.CDREVISION = ASAST.CDREVISION)
LEFT JOIN GNRESOURCE AST_RESOURCE ON (AST_RESOURCE.CDASSET = ASAST.CDASSET)
LEFT JOIN GNCALENDAR AST_CALENDAR ON (AST_CALENDAR.CDCALENDAR = AST_RESOURCE.CDCALENDAR)
LEFT JOIN (
SELECT ALIAS_ASHISTSITE.CDASSET,
ALIAS_ASHISTSITE.CDREVISION,
ALIAS_ASHISTSITE.FGSITETYPE,
ALIAS_ASHISTSITE.NMCOORD,
ALIAS_ASSITE.CDSITE,
ALIAS_ASSITE.IDSITE,
ALIAS_ASSITE.NMSITE,
ALIAS_ASSITE.NMCOUNTRY,
ALIAS_ASSITE.NMSTATE,
ALIAS_ASSITE.NMCITY,
ALIAS_ASSITE.NMPOSTALCODE,
ALIAS_ASSITE.NMCOORD AS NMCOORD_SITE,
ALIAS_ASSITE.DSADDRESS,
ALIAS_ADDEP.IDDEPARTMENT,
ALIAS_ADDEP.NMDEPARTMENT,
ALIAS_ADUSER.CDUSER,
ALIAS_ADUSER.IDUSER,
ALIAS_ADUSER.NMUSER
FROM ASHISTASSETSITE ALIAS_ASHISTSITE
LEFT JOIN ASSITE ALIAS_ASSITE ON (ALIAS_ASSITE.CDSITE = ALIAS_ASHISTSITE.CDSITE)
LEFT JOIN ADUSER ALIAS_ADUSER ON (ALIAS_ADUSER.CDUSER = ALIAS_ASHISTSITE.CDUSERSITE)
LEFT JOIN ADDEPARTMENT ALIAS_ADDEP ON (ALIAS_ASSITE.CDCOMPANY = ALIAS_ADDEP.CDDEPARTMENT)
WHERE ALIAS_ASHISTSITE.FGLASTSITE = 1
) TBL_LASTSITE ON (TBL_LASTSITE.CDASSET = ASAST.CDASSET)
LEFT JOIN (
SELECT ALIAS_ASHISTSSTATE.CDASSET,
ALIAS_ASHISTSSTATE.CDREVISION,
ALIAS_ASSTATE.CDSTATE,
ALIAS_ASSTATE.IDSTATE,
ALIAS_ASSTATE.NMSTATE
FROM ASHISTASSETSTATE ALIAS_ASHISTSSTATE
LEFT JOIN ASSTATE ALIAS_ASSTATE ON (ALIAS_ASSTATE.CDSTATE = ALIAS_ASHISTSSTATE.CDSTATE)
WHERE ALIAS_ASHISTSSTATE.FGLASTSTATE = 1
) TBL_LASTSTATE ON (TBL_LASTSTATE.CDASSET = ASAST.CDASSET)
WHERE
OBJ.FGCURRENT = 1 /*OBS 1*/ AND
OBJ.IDOBJECT = 'IDENTIFICADOR_DO_ATIVO' /*OBS 2*/
|
Postgres
SELECT
OBJ.IDOBJECT,
OBJ.NMOBJECT,
GNREV.IDREVISION,
GNREV.DTREVISION,
OBJTYPE.IDOBJECTTYPE || ' - ' || OBJTYPE.NMOBJECTTYPE NMOBJECTTYPE,
TEAM.IDTEAM || ' - ' || TEAM.NMTEAM NMTEAMRESPONSABLE,
TBL_LASTSTATE.IDSTATE || ' - ' || TBL_LASTSTATE.NMSTATE NMLASTSTATE,
OBJ.FGAPPLICATION,
ASAST.DTSTARTOPER,
ASAST.QTQUANTITY,
ASAST.QTAVAILABLE,
AST_CALENDAR.IDCALENDAR || ' - ' || AST_CALENDAR.NMCALENDAR NMCALENDAR,
ASAST.FGASSTATUS,
TBL_LASTSITE.IDSITE || ' - ' || TBL_LASTSITE.NMSITE LASTSITE_NMSITE,
TBL_LASTSITE.IDUSER || ' - ' || TBL_LASTSITE.NMUSER LASTSITE_NMUSER,
TBL_LASTSITE.NMCOORD,
ASAST.FGVIEWACCESS,
TEAMACCESS.IDTEAM || ' - ' || TEAMACCESS.NMTEAM NMTEAMVIEWACCESS,
ASAST.FGOWNER,
ADCMP.IDCOMMERCIAL || ' - ' || ADCMP.NMCOMPANY NMCOMPANYOWNER,
ADMNFT.IDCOMMERCIAL || ' - ' || ADMNFT.NMCOMPANY NMMANUFACTURER,
ADMSUPP.IDCOMMERCIAL || ' - ' || ADMSUPP.NMCOMPANY NMSUPPLIER,
ASAST.IDSERIALNUMBER,
ASAST.IDMODEL,
ASAST.FGRESOURCE,
TBL_CHKWARRANTYDOC.IDDOCUMENT || ' - ' || TBL_CHKWARRANTYDOC.NMTITLE NMWARRANTYDOC,
TBL_CHKWARRANTYDOC.DTREVISION DTDOCREV,
CASE TBL_CHKWARRANTYDOC.FGVALIDITY
WHEN 1 THEN (TBL_CHKWARRANTYDOC.DTREVISION + TBL_CHKWARRANTYDOC.QTVALIDITY)
WHEN 2 THEN (TBL_CHKWARRANTYDOC.DTREVISION + (TBL_CHKWARRANTYDOC.QTVALIDITY*30))
WHEN 3 THEN (TBL_CHKWARRANTYDOC.DTREVISION + (TBL_CHKWARRANTYDOC.QTVALIDITY*365))
ELSE NULL
END VIEW_DTDOCREVVALIDITY,
ASAST.DSDESCRIPTION,
MAEQUIPMENT.DSEQPT,
OBJ.DSOBSERVATION,
ASAST.FGAUTOACQUISITION,
ASAST.IDIPADDRESS,
ASAST.IDPORT,
ASAST.QTTIMEOUT
FROM OBOBJECT OBJ
INNER JOIN GNREVISION GNREV ON (OBJ.CDREVISION = GNREV.CDREVISION)
INNER JOIN OBOBJECTGROUP OBJGRP ON (OBJ.CDOBJECT = OBJGRP.CDOBJECTGROUP)
LEFT JOIN ADTEAM TEAM ON (OBJ.CDTEAMRESPONSABLE = TEAM.CDTEAM)
INNER JOIN OBOBJECTTYPE OBJTYPE ON (OBJTYPE.CDOBJECTTYPE = OBJGRP.CDOBJECTTYPE)
INNER JOIN ASASSET ASAST ON (ASAST.CDASSET = OBJ.CDOBJECT AND ASAST.CDREVISION = OBJ.CDREVISION)
LEFT JOIN ADTEAM TEAMACCESS ON (ASAST.CDTEAMVIEWACCESS = TEAMACCESS.CDTEAM)
LEFT JOIN ADCOMPANY ADCMP ON (ADCMP.CDCOMPANY = ASAST.CDCOMPANYOWNER)
LEFT JOIN ADCOMPANY ADMNFT ON (ADMNFT.CDCOMPANY = ASAST.CDMANUFACTURER)
LEFT JOIN ADCOMPANY ADMSUPP ON (ADMSUPP.CDCOMPANY = ASAST.CDSUPPLIER)
LEFT JOIN (
SELECT CHKDCREV.CDDOCUMENT,
CHKDCREV.CDREVISION,
CHKDCREV.IDDOCUMENT,
COALESCE(TRLG.NMTRANSLATION, CHKDCREV.NMTITLE) NMTITLE,
CHKGNREV.DTREVISION,
CHKGNREV.QTVALIDITY,
CHKGNREV.FGVALIDITY
FROM DCDOCREVISION CHKDCREV
LEFT JOIN GNREVISION CHKGNREV ON (CHKDCREV.CDREVISION = CHKGNREV.CDREVISION)
LEFT JOIN DCCATEGORY CHKDCCAT ON (CHKDCCAT.CDCATEGORY = CHKDCREV.CDCATEGORY)
LEFT JOIN GNTRANSLATIONLANGUAGE TRLG ON (CHKDCREV.CDTRANSLATION = TRLG.CDTRANSLATION AND TRLG.FGLANGUAGE = 2)
WHERE CHKDCCAT.FGCATEGORYTYPE = 4
AND CHKDCREV.FGCURRENT = 1
) TBL_CHKWARRANTYDOC ON (TBL_CHKWARRANTYDOC.CDDOCUMENT = ASAST.CDWARRANTYDOC)
LEFT JOIN MAEQPT MAEQUIPMENT ON (MAEQUIPMENT.CDEQPT = ASAST.CDASSET AND MAEQUIPMENT.CDREVISION = ASAST.CDREVISION)
LEFT JOIN GNRESOURCE AST_RESOURCE ON (AST_RESOURCE.CDASSET = ASAST.CDASSET)
LEFT JOIN GNCALENDAR AST_CALENDAR ON (AST_CALENDAR.CDCALENDAR = AST_RESOURCE.CDCALENDAR)
LEFT JOIN (
SELECT ALIAS_ASHISTSITE.CDASSET,
ALIAS_ASHISTSITE.CDREVISION,
ALIAS_ASHISTSITE.FGSITETYPE,
ALIAS_ASHISTSITE.NMCOORD,
ALIAS_ASSITE.CDSITE,
ALIAS_ASSITE.IDSITE,
ALIAS_ASSITE.NMSITE,
ALIAS_ASSITE.NMCOUNTRY,
ALIAS_ASSITE.NMSTATE,
ALIAS_ASSITE.NMCITY,
ALIAS_ASSITE.NMPOSTALCODE,
ALIAS_ASSITE.NMCOORD AS NMCOORD_SITE,
ALIAS_ASSITE.DSADDRESS,
ALIAS_ADDEP.IDDEPARTMENT,
ALIAS_ADDEP.NMDEPARTMENT,
ALIAS_ADUSER.CDUSER,
ALIAS_ADUSER.IDUSER,
ALIAS_ADUSER.NMUSER
FROM ASHISTASSETSITE ALIAS_ASHISTSITE
LEFT JOIN ASSITE ALIAS_ASSITE ON (ALIAS_ASSITE.CDSITE = ALIAS_ASHISTSITE.CDSITE)
LEFT JOIN ADUSER ALIAS_ADUSER ON (ALIAS_ADUSER.CDUSER = ALIAS_ASHISTSITE.CDUSERSITE)
LEFT JOIN ADDEPARTMENT ALIAS_ADDEP ON (ALIAS_ASSITE.CDCOMPANY = ALIAS_ADDEP.CDDEPARTMENT)
WHERE ALIAS_ASHISTSITE.FGLASTSITE = 1
) TBL_LASTSITE ON (TBL_LASTSITE.CDASSET = ASAST.CDASSET)
LEFT JOIN (
SELECT ALIAS_ASHISTSSTATE.CDASSET,
ALIAS_ASHISTSSTATE.CDREVISION,
ALIAS_ASSTATE.CDSTATE,
ALIAS_ASSTATE.IDSTATE,
ALIAS_ASSTATE.NMSTATE
FROM ASHISTASSETSTATE ALIAS_ASHISTSSTATE
LEFT JOIN ASSTATE ALIAS_ASSTATE ON (ALIAS_ASSTATE.CDSTATE = ALIAS_ASHISTSSTATE.CDSTATE)
WHERE ALIAS_ASHISTSSTATE.FGLASTSTATE = 1
) TBL_LASTSTATE ON (TBL_LASTSTATE.CDASSET = ASAST.CDASSET)
WHERE
OBJ.FGCURRENT = 1 /*OBS 1*/ AND
OBJ.IDOBJECT = 'IDENTIFICADOR_DO_ATIVO' /*OBS 2*/
|
SQL Server
SELECT
OBJ.IDOBJECT,
OBJ.NMOBJECT,
GNREV.IDREVISION,
GNREV.DTREVISION,
OBJTYPE.IDOBJECTTYPE + ' - ' + OBJTYPE.NMOBJECTTYPE NMOBJECTTYPE,
TEAM.IDTEAM + ' - ' + TEAM.NMTEAM NMTEAMRESPONSABLE,
TBL_LASTSTATE.IDSTATE + ' - ' + TBL_LASTSTATE.NMSTATE NMLASTSTATE,
OBJ.FGAPPLICATION,
ASAST.DTSTARTOPER,
ASAST.QTQUANTITY,
ASAST.QTAVAILABLE,
AST_CALENDAR.IDCALENDAR + ' - ' + AST_CALENDAR.NMCALENDAR NMCALENDAR,
ASAST.FGASSTATUS,
TBL_LASTSITE.IDSITE + ' - ' + TBL_LASTSITE.NMSITE LASTSITE_NMSITE,
TBL_LASTSITE.IDUSER + ' - ' + TBL_LASTSITE.NMUSER LASTSITE_NMUSER,
TBL_LASTSITE.NMCOORD,
ASAST.FGVIEWACCESS,
TEAMACCESS.IDTEAM + ' - ' + TEAMACCESS.NMTEAM NMTEAMVIEWACCESS,
ASAST.FGOWNER,
ADCMP.IDCOMMERCIAL + ' - ' + ADCMP.NMCOMPANY NMCOMPANYOWNER,
ADMNFT.IDCOMMERCIAL + ' - ' + ADMNFT.NMCOMPANY NMMANUFACTURER,
ADMSUPP.IDCOMMERCIAL + ' - ' + ADMSUPP.NMCOMPANY NMSUPPLIER,
ASAST.IDSERIALNUMBER,
ASAST.IDMODEL,
ASAST.FGRESOURCE,
TBL_CHKWARRANTYDOC.IDDOCUMENT + ' - ' + TBL_CHKWARRANTYDOC.NMTITLE NMWARRANTYDOC,
TBL_CHKWARRANTYDOC.DTREVISION DTDOCREV,
CASE TBL_CHKWARRANTYDOC.FGVALIDITY
WHEN 1 THEN (TBL_CHKWARRANTYDOC.DTREVISION + TBL_CHKWARRANTYDOC.QTVALIDITY)
WHEN 2 THEN (TBL_CHKWARRANTYDOC.DTREVISION + (TBL_CHKWARRANTYDOC.QTVALIDITY*30))
WHEN 3 THEN (TBL_CHKWARRANTYDOC.DTREVISION + (TBL_CHKWARRANTYDOC.QTVALIDITY*365))
ELSE NULL
END VIEW_DTDOCREVVALIDITY,
ASAST.DSDESCRIPTION,
MAEQUIPMENT.DSEQPT,
OBJ.DSOBSERVATION,
ASAST.FGAUTOACQUISITION,
ASAST.IDIPADDRESS,
ASAST.IDPORT,
ASAST.QTTIMEOUT
FROM OBOBJECT OBJ
INNER JOIN GNREVISION GNREV ON (OBJ.CDREVISION = GNREV.CDREVISION)
INNER JOIN OBOBJECTGROUP OBJGRP ON (OBJ.CDOBJECT = OBJGRP.CDOBJECTGROUP)
LEFT JOIN ADTEAM TEAM ON (OBJ.CDTEAMRESPONSABLE = TEAM.CDTEAM)
INNER JOIN OBOBJECTTYPE OBJTYPE ON (OBJTYPE.CDOBJECTTYPE = OBJGRP.CDOBJECTTYPE)
INNER JOIN ASASSET ASAST ON (ASAST.CDASSET = OBJ.CDOBJECT AND ASAST.CDREVISION = OBJ.CDREVISION)
LEFT JOIN ADTEAM TEAMACCESS ON (ASAST.CDTEAMVIEWACCESS = TEAMACCESS.CDTEAM)
LEFT JOIN ADCOMPANY ADCMP ON (ADCMP.CDCOMPANY = ASAST.CDCOMPANYOWNER)
LEFT JOIN ADCOMPANY ADMNFT ON (ADMNFT.CDCOMPANY = ASAST.CDMANUFACTURER)
LEFT JOIN ADCOMPANY ADMSUPP ON (ADMSUPP.CDCOMPANY = ASAST.CDSUPPLIER)
LEFT JOIN (
SELECT CHKDCREV.CDDOCUMENT,
CHKDCREV.CDREVISION,
CHKDCREV.IDDOCUMENT,
COALESCE(TRLG.NMTRANSLATION, CHKDCREV.NMTITLE) NMTITLE,
CHKGNREV.DTREVISION,
CHKGNREV.QTVALIDITY,
CHKGNREV.FGVALIDITY
FROM DCDOCREVISION CHKDCREV
LEFT JOIN GNREVISION CHKGNREV ON (CHKDCREV.CDREVISION = CHKGNREV.CDREVISION)
LEFT JOIN DCCATEGORY CHKDCCAT ON (CHKDCCAT.CDCATEGORY = CHKDCREV.CDCATEGORY)
LEFT JOIN GNTRANSLATIONLANGUAGE TRLG ON (CHKDCREV.CDTRANSLATION = TRLG.CDTRANSLATION AND TRLG.FGLANGUAGE = 2)
WHERE CHKDCCAT.FGCATEGORYTYPE = 4
AND CHKDCREV.FGCURRENT = 1
) TBL_CHKWARRANTYDOC ON (TBL_CHKWARRANTYDOC.CDDOCUMENT = ASAST.CDWARRANTYDOC)
LEFT JOIN MAEQPT MAEQUIPMENT ON (MAEQUIPMENT.CDEQPT = ASAST.CDASSET AND MAEQUIPMENT.CDREVISION = ASAST.CDREVISION)
LEFT JOIN GNRESOURCE AST_RESOURCE ON (AST_RESOURCE.CDASSET = ASAST.CDASSET)
LEFT JOIN GNCALENDAR AST_CALENDAR ON (AST_CALENDAR.CDCALENDAR = AST_RESOURCE.CDCALENDAR)
LEFT JOIN (
SELECT ALIAS_ASHISTSITE.CDASSET,
ALIAS_ASHISTSITE.CDREVISION,
ALIAS_ASHISTSITE.FGSITETYPE,
ALIAS_ASHISTSITE.NMCOORD,
ALIAS_ASSITE.CDSITE,
ALIAS_ASSITE.IDSITE,
ALIAS_ASSITE.NMSITE,
ALIAS_ASSITE.NMCOUNTRY,
ALIAS_ASSITE.NMSTATE,
ALIAS_ASSITE.NMCITY,
ALIAS_ASSITE.NMPOSTALCODE,
ALIAS_ASSITE.NMCOORD AS NMCOORD_SITE,
ALIAS_ASSITE.DSADDRESS,
ALIAS_ADDEP.IDDEPARTMENT,
ALIAS_ADDEP.NMDEPARTMENT,
ALIAS_ADUSER.CDUSER,
ALIAS_ADUSER.IDUSER,
ALIAS_ADUSER.NMUSER
FROM ASHISTASSETSITE ALIAS_ASHISTSITE
LEFT JOIN ASSITE ALIAS_ASSITE ON (ALIAS_ASSITE.CDSITE = ALIAS_ASHISTSITE.CDSITE)
LEFT JOIN ADUSER ALIAS_ADUSER ON (ALIAS_ADUSER.CDUSER = ALIAS_ASHISTSITE.CDUSERSITE)
LEFT JOIN ADDEPARTMENT ALIAS_ADDEP ON (ALIAS_ASSITE.CDCOMPANY = ALIAS_ADDEP.CDDEPARTMENT)
WHERE ALIAS_ASHISTSITE.FGLASTSITE = 1
) TBL_LASTSITE ON (TBL_LASTSITE.CDASSET = ASAST.CDASSET)
LEFT JOIN (
SELECT ALIAS_ASHISTSSTATE.CDASSET,
ALIAS_ASHISTSSTATE.CDREVISION,
ALIAS_ASSTATE.CDSTATE,
ALIAS_ASSTATE.IDSTATE,
ALIAS_ASSTATE.NMSTATE
FROM ASHISTASSETSTATE ALIAS_ASHISTSSTATE
LEFT JOIN ASSTATE ALIAS_ASSTATE ON (ALIAS_ASSTATE.CDSTATE = ALIAS_ASHISTSSTATE.CDSTATE)
WHERE ALIAS_ASHISTSSTATE.FGLASTSTATE = 1
) TBL_LASTSTATE ON (TBL_LASTSTATE.CDASSET = ASAST.CDASSET)
WHERE
OBJ.FGCURRENT = 1 /*OBS 1*/ AND
OBJ.IDOBJECT = 'IDENTIFICADOR_DO_ATIVO' /*OBS 2*/
|
Notes
▪1: FGCURRENT value 1 selects the last asset revision. ▪2: ID # of the asset to be filtered.
Fields used on the view screen
#
|
Field ID
|
Type
|
Description
|
1
|
IDOBJECT
|
VARCHAR(50)
|
Asset ID #
|
2
|
NMOBJECT
|
VARCHAR(255)
|
Asset name
|
3
|
IDREVISION
|
VARCHAR(50)
|
Revision ID #
|
4
|
DTREVISION
|
DATETIME
|
Revision date
|
5
|
NMOBJECTTYPE
|
VARCHAR(255)
|
Asset type
|
6
|
NMTEAMRESPONSABLE
|
VARCHAR(255)
|
Responsible team
|
7
|
NMLASTSTATE
|
VARCHAR(255)
|
Condition
|
8
|
FGAPPLICATION
|
NUMERIC(2)
|
Asset specification:
1– Gage
2– Equipment
3– Item
4– Others
5– Supplies
6– Tooling
8– Asset template
9– Waste
10– Item family
11– Computer
|
9
|
DTSTARTOPER
|
DATETIME
|
Operation start date
|
10
|
QTQUANTITY
|
NUMERIC(10)
|
Quantity
|
11
|
QTAVAILABLE
|
NUMERIC(10)
|
Available quantity
|
12
|
NMCALENDAR
|
VARCHAR(255)
|
Calendar name
|
13
|
FGASSTATUS
|
NUMERIC(2)
|
Asset status:
1– Verification
2– Usage event
3– Maintenance event
4– Disabled
5– Available
6– Calibration event
7– Calibration in progress
8– Calibration approval
9– Nonconformity analysis
10– Maintenance
|
14
|
LASTSITE_NMSITE
|
VARCHAR(255)
|
Asset location
|
15
|
LASTSITE_NMUSER
|
VARCHAR(255)
|
User
|
16
|
NMCOORD
|
VARCHAR(255)
|
Geographic coordinates
|
17
|
FGVIEWACCESS
|
NUMERIC(2)
|
Restrict access to view screens:
1– Yes
2– No
|
18
|
NMTEAMVIEWACCESS
|
VARCHAR(255)
|
View team
|
19
|
FGOWNER
|
NUMERIC(2)
|
Owner:
1– Internal
2– External
|
20
|
NMCOMPANYOWNER
|
VARCHAR(255)
|
Owner company
|
21
|
NMMANUFACTURER
|
VARCHAR(255)
|
Manufacturer
|
22
|
NMSUPPLIER
|
VARCHAR(255)
|
Supplier
|
23
|
IDSERIALNUMBER
|
VARCHAR(50)
|
Serial number
|
24
|
IDMODEL
|
VARCHAR(50)
|
Model
|
25
|
FGRESOURCE
|
NUMERIC(2)
|
Use asset as resource:
1– Yes
2– No
|
26
|
NMWARRANTYDOC
|
VARCHAR(255)
|
Warranty contract
|
27
|
DTDOCREV
|
DATETIME
|
Purchase date
|
28
|
VIEW_DTDOCREVVALIDITY
|
DATETIME
|
Expiration date
|
29
|
DSDESCRIPTION
|
TEXT
|
Description
|
30
|
DSEQPT
|
TEXT
|
Characteristics
|
31
|
DSOBSERVATION
|
TEXT
|
Observations
|
32
|
FGAUTOACQUISITION
|
NUMERIC(2)
|
Automated data input:
1– Yes
2– No
|
33
|
IDIPADDRESS
|
VARCHAR(50)
|
IP address
|
34
|
IDPORT
|
VARCHAR(50)
|
Porta
|
35
|
QTTIMEOUT
|
NUMERIC(10)
|
Timeout
|
|