VIEW: APPS.CMPATTRIBUTE_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 ,b_14 ,i_5 ,i_6 ,r_73 ,r_74 from EDWCMPAllClasses WHERE s2_1 in ( 'CMPWBStructure', 'CMPItemSet', 'CMPForeignKey', 'CMPWBIndex', 'CMPWBNamedItemSet', 'CMPWBHierarchicalAttSet', 'CMPUniqueKey', 'CMPWBCheckConstraint', 'CMPItem', 'CMPWBVariable', 'CMPWBCubeAttribute', 'CMPFunctionArgument', 'CMPWBField', 'CMPRelationalDBItem', 'CMPAttribute') 

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
, B_14
, I_5
, I_6
, R_73
, R_74
FROM EDWCMPALLCLASSES
WHERE S2_1 IN ( 'CMPWBSTRUCTURE'
, 'CMPITEMSET'
, 'CMPFOREIGNKEY'
, 'CMPWBINDEX'
, 'CMPWBNAMEDITEMSET'
, 'CMPWBHIERARCHICALATTSET'
, 'CMPUNIQUEKEY'
, 'CMPWBCHECKCONSTRAINT'
, 'CMPITEM'
, 'CMPWBVARIABLE'
, 'CMPWBCUBEATTRIBUTE'
, 'CMPFUNCTIONARGUMENT'
, 'CMPWBFIELD'
, 'CMPRELATIONALDBITEM'
, 'CMPATTRIBUTE')