Navigation:  Supply >

Supply data

 Previous  Top  Next

Overview

This command will list the data of a supply.

 

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

OBOBJECTTYPE

Item/Asset/Supply type

CDOBJECTTYPE

ADMEASUNITY

ADTEAM

GNMASK

GNREVCONFIG

GNTYPEROLE

OBINPUT

Supply data record

CDINPUT

CDREVISION

ADMEASUNITY

OBCLASSIFICATION

OBOBJECT

WMCOLOR

WMDANGEROUSNESS

WMODOR

WMODOR

Odor data

CDODOR

WMCOLOR

Color data

CDCOLOR

WMDANGEROUSNESS

Hazard data

CDDANGEROUSNESS

GNGENTYPE

Type data

CDGENTYPE

ADCHECKLIST

GNACTIVITYTIMECFG

GNASSOC

GNELETRONICFILECFG

GNEVAL

GNFAVORITE

GNMASK

GNREVCONFIG

GNSECURITY

GNTRANSLATION

GNTYPEROLE

ADMEASUNITY

Measurement unit

CDMEASUNITY

ADTEAM

Teams

CDTEAM

ADAUTHLDAPCONFIG

GNMAPPING

GNPERMISSION

 

Oracle/Postgres/SQL Server

SELECT
   OBJ.IDOBJECT,
   OBJ.NMOBJECT,
   GNREV.IDREVISION,
   GNREV.DTREVISION,
   OBJTYPE.IDOBJECTTYPE + ' - ' + OBJTYPE.NMOBJECTTYPE AS NMOBJECTTYPE,
   ADT.IDTEAM + ' - ' + ADT.NMTEAM AS NMRESPONSIBLETEAM,
   OBINPT.VLCOST,
   ADMEAS.IDMEASUNITY + ' - ' + ADMEAS.NMMEASUNITY AS NMMEASUNITY,
   OBINPT.FGLOTSERIAL,
   OBJ.DSOBSERVATION,
   OBINPT.FGPHYSICALSTATE,
   WMOD.IDODOR + ' - ' + WMOD.NMODOR AS NMODOR,
   WMCL.IDCOLOR + ' - ' + WMCL.NMCOLOR AS NMCOLOR,
   OBINPT.IDONUCODE,
   OBINPT.IDABNTCODE,
   WMDG.IDDANGEROUSNESS + ' - ' + WMDG.NMDANGEROUSNESS AS NMDANGEROUSNESS,
   GNTP.IDGENTYPE + ' - ' + GNTP.NMGENTYPE AS NMCLASSIFICATION,
   OBINPT.DSCONSTITUENTS
FROM OBOBJECT OBJ
   INNER JOIN GNREVISION GNREV ON (OBJ.CDREVISION = GNREV.CDREVISION)
   INNER JOIN OBOBJECTGROUP OBJGRP ON (OBJ.CDOBJECT = OBJGRP.CDOBJECTGROUP)
   INNER JOIN OBOBJECTTYPE OBJTYPE ON (OBJTYPE.CDOBJECTTYPE = OBJGRP.CDOBJECTTYPE)
   INNER JOIN OBINPUT OBINPT ON (OBINPT.CDINPUT = OBJ.CDOBJECT AND OBINPT.CDREVISION = OBJ.CDREVISION)
   LEFT JOIN WMODOR WMOD ON (WMOD.CDODOR = OBINPT.CDODOR)
   LEFT JOIN WMCOLOR WMCL ON (WMCL.CDCOLOR = OBINPT.CDCOLOR)
   LEFT JOIN WMDANGEROUSNESS WMDG ON (WMDG.CDDANGEROUSNESS = OBINPT.CDDANGEROUSNESS)
   LEFT JOIN GNGENTYPE GNTP ON (GNTP.CDGENTYPE = OBINPT.CDCLASSIFICATION)
   LEFT JOIN ADMEASUNITY ADMEAS ON (ADMEAS.CDMEASUNITY = OBINPT.CDMEASUNITY)
   LEFT JOIN ADTEAM ADT ON (ADT.CDTEAM = OBJ.CDTEAMRESPONSABLE)
WHERE OBJ.IDOBJECT = 'SUPPLY_ID' /*NOTE 1*/

 

Notes

▪1: ID # of the supply to be filtered.

 

Fields used on the view screen

 

supply-01

 

supply-02

 

#

Field ID

Type

Description

1

IDOBJECTTYPE

VARCHAR(50)

Supply ID #

2

NMOBJECTTYPE

VARCHAR(255)

Supply name

3

IDREVISION

VARCHAR(50)

Revision

4

DTREVISION

DATETIME

Revision date

5

NMOBJECTTYPE

VARCHAR(255)

Supply type

6

NMRESPONSIBLETEAM

VARCHAR(255)

Responsible team

7

VLCOST

NUMERIC(28,12)

Cost

8

NMMEASUNITY

VARCHAR(255)

Measurement unit

9

FGLOTSERIAL

NUMERIC(2)

Traceability by lot number or serial number:

1– Lot #

2– Serial #

10

DSOBSERVATION

TEXT

Notes

11

FGPHYSICALSTATE

NUMERIC(2)

Physical state:

1 – Solid

2 – Liquid

3 – Gas

4 – Sludge

12

NMODOR

VARCHAR(255)

Odor

13

NMCOLOR

VARCHAR(255)

Color

14

IDONUCODE

VARCHAR(50)

UN code

15

IDABNTCODE

VARCHAR(50)

ABNT code

16

NMDANGEROUSNESS

VARCHAR(255)

Hazard

17

NMCLASSIFICATION

VARCHAR(255)

Classification

18

DSCONSTITUENTS

TEXT

Composition description