Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT t_08.puid FROM PWORKSPACEOBJECT t_06 , PRELEASE_STATUS_LIST t_07 , PITEMREVISION t_08 , PRELEASESTATUS t_02 , PE9_MANUFACTURERSTORAGE t_09 , PEN_ITEMREVMASTER t_01 , PFORM t_05 , PIMANRELATION t_03 , PIMANRELATION t_04 WHERE ( ( UPPER(t_06.pobject_type) IN ( UPPER( 'EN_Item Revision' ) , UPPER( 'EN_Item Revision' ) ) AND ( ( ( t_07.pvalu_0 = t_02.puid ) AND UPPER(t_02.pname) IN ( UPPER( 'V' ) , UPPER( 'E9_D' ) , UPPER( 'F' ) , UPPER( 'E9_to_F' ) , UPPER( 'E9_M' ) ) ) AND ( ( ( t_08.puid = t_03.rprimary_objectu ) AND ( ( t_03.rrelation_typeu = 'gMx8h03uVJFL2B' ) AND ( ( t_03.rsecondary_objectu = t_05.puid ) AND ( ( t_05.rdata_fileu = t_01.puid ) AND ( ( t_01.re9_manufactureru = t_09.puid ) AND ( UPPER(t_09.pe9_id) = UPPER( '7300007' ) ) ) ) ) ) ) AND ( ( t_08.puid = t_04.rprimary_objectu ) AND ( ( t_04.rrelation_typeu = 'gMx8h03uVJFL2B' ) AND ( ( t_04.rsecondary_objectu = t_05.puid ) AND ( ( t_05.rdata_fileu = t_01.puid ) AND ( UPPER(t_01.phersteller_artikelnr) = UPPER( '00100893' ) ) ) ) ) ) ) ) ) AND ( t_06.puid = t_07.puid AND t_07.puid = t_08.puid ) );
Add Comment
Please, Sign In to add comment