DBA Data[Home] [Help]

VIEW: APPS.CMPWBTABLE_V

Source

View Text - Preformatted

select
    DeletionParent,
    s2_1
   ,d_1
   ,d_2
   ,s3_1
   ,i_1
   ,s1_1
   ,i_2
   ,s2_2
   ,s3_2
   ,s3_3
   ,b_1
   ,b_2
   ,b_3
   ,b_4
   ,b_5
   ,b_6
   ,b_7
   ,b_8
   ,b_9
   ,b_10
   ,s2_3
   ,r_1
   ,r_2
   ,r_3
   ,r_4
   ,i_3
   ,i_4
   ,b_11
   ,r_60
   ,r_61
   ,b_12
   ,r_72
   ,b_13
   ,s1_2
   ,b_14
   ,b_15
   ,s1_3
   ,s1_4
   ,s1_5
   ,s1_6
   ,b_16
   ,s1_7
   ,r_88
   ,s1_8
   ,b_17
   ,s1_9
from EDWCMPAllClasses
where s2_1 in (
          'CMPWBTable')

View Text - HTML Formatted

SELECT DELETIONPARENT
, S2_1
, D_1
, D_2
, S3_1
, I_1
, S1_1
, I_2
, S2_2
, S3_2
, S3_3
, B_1
, B_2
, B_3
, B_4
, B_5
, B_6
, B_7
, B_8
, B_9
, B_10
, S2_3
, R_1
, R_2
, R_3
, R_4
, I_3
, I_4
, B_11
, R_60
, R_61
, B_12
, R_72
, B_13
, S1_2
, B_14
, B_15
, S1_3
, S1_4
, S1_5
, S1_6
, B_16
, S1_7
, R_88
, S1_8
, B_17
, S1_9 FROM EDWCMPALLCLASSES WHERE S2_1 IN ( 'CMPWBTABLE')