SELECT
A.IDAPQP,
AR.IDREVISION AS IDAPQPREV,
A.FGSTATUS AS FGAPQPSTATUS,
OBJ.IDOBJECT,
OBJ.NMOBJECT,
OBJR.IDREVISION AS IDITEMREV,
C.IDCOMMERCIAL,
C.NMCOMPANY,
AR.FGSTATUS AS FGAPQPREVSTATUS,
AR.DTREVISION,
TY.IDGENTYPE,
TY.NMGENTYPE,
U.IDUSER,
U.NMUSER,
T.IDTEAM,
T.NMTEAM
FROM PAAPQP A
INNER JOIN GNREVISION AR ON (A.CDREVISION = AR.CDREVISION)
INNER JOIN PAAPQPGROUP G ON (G.CDAPQPGROUP = A.CDAPQP)
INNER JOIN GNGENTYPE TY ON (TY.CDGENTYPE = G.CDGENTYPE)
INNER JOIN OBOBJECT OBJ ON (OBJ.CDOBJECT = A.CDITEM AND OBJ.CDREVISION = A.CDITEMREVISION)
INNER JOIN GNREVISION OBJR ON (OBJ.CDREVISION = OBJR.CDREVISION)
INNER JOIN ADCOMPANY C ON (C.CDCOMPANY = A.CDCUSTOMER)
INNER JOIN ADALLUSERS U ON (U.CDUSER = A.CDRESPONSIBLE)
LEFT JOIN ADTEAM T ON (T.CDTEAM = A.CDTEAM)
WHERE
1=1
AND A.IDAPQP LIKE 'ID_APQP' /* OBS1 */
AND AR.IDREVISION LIKE 'ID_APQP_REVISION' /* OBS2 */
AND OBJ.IDOBJECT LIKE 'ID_ITEM' /* OBS3 */
AND OBJR.IDREVISION LIKE 'ID_ITEM_REVISION' /* OBS4 */
|
