Guest User

Untitled

a guest
Jan 24th, 2019
184
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.08 KB | None | 0 0
  1. 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