1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
|
SELECT AM.PARTNUMBER, AM.PARTCAGE, AM.PARTICD, AM.PARTID, AM.PARTDESCRIPTIONFR,N.MODSNUMBER
FROM ARTICLE A,
ARTICLEMASTER AM,
CLASSIFICATION C,
WTVIEW W,
WTPARTDESCRIBELINK DESCLINK,
TYPEDOCUMENT TD,
COMSYSDOCUMENTMASTER DM,
COMSYSDOCUMENT D,
NTP N,
CTA CT,
(select max(NN.MODSNUMBER) as MaxN from ARTICLEMASTER AM, NTP NN where AM.IDA2A2 = NN.IDA3A5) VNTP
WHERE
A.TCCVERSION = (select max(tccversion) from ARTICLE AA, WTVIEW W where AA.IDA3MASTERREFERENCE = A.IDA3MASTERREFERENCE and aa.STATESTATE = 'RFPr' AND aa.IDA3VIEW = W.IDA2A2 AND W.NAME = 'MFG_GUY') AND
A.IDA3MASTERREFERENCE = AM.IDA2A2 AND
AM.ORACLESUBSCRIPTION = 1 AND
A.LATESTITERATIONINFO = 1 AND
A.IDA2A2 = DESCLINK.IDA3A5(+) AND
DESCLINK.IDA3B5 = D.IDA2A2(+) AND
D.IDA3MASTERREFERENCE = DM.IDA2A2(+) AND
DM.IDA3B6 = TD.IDA2A2(+) AND
AM.IDA2A2 = N.IDA3A5(+) AND
N.MODSNUMBER = VNTP.MaxN(+) AND
AM.IDA3C6 = C.IDA2A2(+) AND
AM.IDA3G6 = CT.IDA2A2(+) AND
A.IDA3VIEW = W.IDA2A2 AND
W.NAME = 'MFG_GUY'; |
Partager