Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
13 rsolanki 1 
/* OS Details */
2 
SELECT os.OS_ID,
3 
	   os.OS_NAME,
4 
	   os.NODE_ID,
5 
	   os.OS_COMMENTS,
15 rsolanki 6 
                 os.NODE_SPEC_FILE,
7 
	   os.NOT_XML,
13 rsolanki 8 
	   obe.base_env_id,
9 
       be.BASE_ENV_NAME
10 
  FROM OPERATING_SYSTEMS os,
11 
	   BASE_ENV be,
12 
       OS_BASE_ENV obe
13 
 WHERE os.OS_ID = :OS_ID
14 
   AND obe.OS_ID (+) = os.OS_ID
15 
   AND obe.BASE_ENV_ID = be.BASE_ENV_ID (+)