VIEW: APPS.CMPELEMENT_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 from EDWCMPAllClasses WHERE s2_1 in ( 'CMPWBTriggerType', 'CMPInstallation', 'CMPWBLineOwner', 'CMPWBGeneratedObject', 'CMPWBFieldDelimiterUsage', 'CMPWBTemplate', 'CMPWBConfigRole', 'CMPWBLine', 'CMPWBProject', 'CMPWBFlexFieldUsage', 'CMPWBFileDelimiterUsage', 'CMPWBCatalogACEUsage', 'CMPWBDSIntegratorMap', 'CMPUILabelFolder', 'CMPWBNavigationTree', 'CMPWBConfigurationTree', 'CMPWBActualParameter', 'CMPWBConfigurationParameterUsage', 'CMPWBModelMapUsage', 'CMPWBFlexField', 'CMPWBValueSet', 'CMPWBFunctionCategUsage', 'CMPWBFormatMask', 'CMPUser', 'CMPWBIMProjectUsage', 'CMPWBConfigurationUsage', 'CMPWBItemSetUsage', 'CMPLevelRelationship', 'CMPWBValidConfigTree', 'CMPWBConfigurationParameter', 'CMPAccessControlledElement', 'CMPLanguage', 'CMPSoftwareModule', 'CMPWBSystemType', 'CMPWBIntegrator', 'CMPWBApplicationType', 'CMPWBSystem', 'CMPFunctionImplementation', 'CMPEnterprise', 'CMPDatatype', 'CMPSite', 'CMPWBConfigurableObject', 'CMPAttribute', 'CMPWBStructure', 'CMPItemSet', 'CMPForeignKey', 'CMPWBIndex', 'CMPWBNamedItemSet', 'CMPWBHierarchicalAttSet', 'CMPUniqueKey', 'CMPWBCheckConstraint', 'CMPItem', 'CMPWBVariable', 'CMPWBCubeAttribute', 'CMPFunctionArgument', 'CMPWBField', 'CMPRelationalDBItem', 'CMPWBRelationUsage', 'CMPRelation', 'CMPFunction', 'CMPWBBAPI', 'CMPRelationMapping', 'CMPWBCube', 'CMPLevel', 'CMPRelationalDBObject', 'CMPWBSequence', 'CMPWBView', 'CMPWBVirtualTable', 'CMPWBMaterializedView', 'CMPWBTable', 'CMPWBTemporaryTable', 'CMPWBFile', 'CMPItemHierarchy', 'CMPWBModel', 'CMPWBDimension', 'CMPWBPsftTreeStrct', 'CMPInstalledModule', 'CMPWBSAPInstalledModule', 'CMPWBPsftInstalledModule', 'CMPWBFileInstalledModule', 'CMPWBRepInstalledModule', 'CMPWBDataWarehouse', 'CMPWBOracleInstalledModule', 'CMPWBGatewayInstalledModule', 'CMPWBItemUsage', 'CMPFunctionCategory', 'CMPWBFunctionUsage', 'CMPMachine', 'CMPCatalog', 'CMPWBValidationResult', 'CMPWBTemplateUsage', 'CMPWBProjectUserMap', 'CMPWBContextACETypeUsage', 'CMPUIObject', 'CMPUIModel', 'CMPUIElement', 'CMPUIMap', 'CMPWBForeignKeyUsage', 'CMPWBConfigurationTreeUsage', 'CMPWBACETypeUsage', 'CMPWBIntgACETypeUsage', 'CMPWBConfigParamValue', 'CMPWBEmergencyUseOnly', 'CMPWBDelimiter', 'CMPWBMapType', 'CMPWBContext', 'CMPACEType', 'CMPWBValidDataTypeList', 'CMPWBValidationMessage', 'CMPElement') 

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
FROM EDWCMPALLCLASSES
WHERE S2_1 IN ( 'CMPWBTRIGGERTYPE'
, 'CMPINSTALLATION'
, 'CMPWBLINEOWNER'
, 'CMPWBGENERATEDOBJECT'
, 'CMPWBFIELDDELIMITERUSAGE'
, 'CMPWBTEMPLATE'
, 'CMPWBCONFIGROLE'
, 'CMPWBLINE'
, 'CMPWBPROJECT'
, 'CMPWBFLEXFIELDUSAGE'
, 'CMPWBFILEDELIMITERUSAGE'
, 'CMPWBCATALOGACEUSAGE'
, 'CMPWBDSINTEGRATORMAP'
, 'CMPUILABELFOLDER'
, 'CMPWBNAVIGATIONTREE'
, 'CMPWBCONFIGURATIONTREE'
, 'CMPWBACTUALPARAMETER'
, 'CMPWBCONFIGURATIONPARAMETERUSAGE'
, 'CMPWBMODELMAPUSAGE'
, 'CMPWBFLEXFIELD'
, 'CMPWBVALUESET'
, 'CMPWBFUNCTIONCATEGUSAGE'
, 'CMPWBFORMATMASK'
, 'CMPUSER'
, 'CMPWBIMPROJECTUSAGE'
, 'CMPWBCONFIGURATIONUSAGE'
, 'CMPWBITEMSETUSAGE'
, 'CMPLEVELRELATIONSHIP'
, 'CMPWBVALIDCONFIGTREE'
, 'CMPWBCONFIGURATIONPARAMETER'
, 'CMPACCESSCONTROLLEDELEMENT'
, 'CMPLANGUAGE'
, 'CMPSOFTWAREMODULE'
, 'CMPWBSYSTEMTYPE'
, 'CMPWBINTEGRATOR'
, 'CMPWBAPPLICATIONTYPE'
, 'CMPWBSYSTEM'
, 'CMPFUNCTIONIMPLEMENTATION'
, 'CMPENTERPRISE'
, 'CMPDATATYPE'
, 'CMPSITE'
, 'CMPWBCONFIGURABLEOBJECT'
, 'CMPATTRIBUTE'
, 'CMPWBSTRUCTURE'
, 'CMPITEMSET'
, 'CMPFOREIGNKEY'
, 'CMPWBINDEX'
, 'CMPWBNAMEDITEMSET'
, 'CMPWBHIERARCHICALATTSET'
, 'CMPUNIQUEKEY'
, 'CMPWBCHECKCONSTRAINT'
, 'CMPITEM'
, 'CMPWBVARIABLE'
, 'CMPWBCUBEATTRIBUTE'
, 'CMPFUNCTIONARGUMENT'
, 'CMPWBFIELD'
, 'CMPRELATIONALDBITEM'
, 'CMPWBRELATIONUSAGE'
, 'CMPRELATION'
, 'CMPFUNCTION'
, 'CMPWBBAPI'
, 'CMPRELATIONMAPPING'
, 'CMPWBCUBE'
, 'CMPLEVEL'
, 'CMPRELATIONALDBOBJECT'
, 'CMPWBSEQUENCE'
, 'CMPWBVIEW'
, 'CMPWBVIRTUALTABLE'
, 'CMPWBMATERIALIZEDVIEW'
, 'CMPWBTABLE'
, 'CMPWBTEMPORARYTABLE'
, 'CMPWBFILE'
, 'CMPITEMHIERARCHY'
, 'CMPWBMODEL'
, 'CMPWBDIMENSION'
, 'CMPWBPSFTTREESTRCT'
, 'CMPINSTALLEDMODULE'
, 'CMPWBSAPINSTALLEDMODULE'
, 'CMPWBPSFTINSTALLEDMODULE'
, 'CMPWBFILEINSTALLEDMODULE'
, 'CMPWBREPINSTALLEDMODULE'
, 'CMPWBDATAWAREHOUSE'
, 'CMPWBORACLEINSTALLEDMODULE'
, 'CMPWBGATEWAYINSTALLEDMODULE'
, 'CMPWBITEMUSAGE'
, 'CMPFUNCTIONCATEGORY'
, 'CMPWBFUNCTIONUSAGE'
, 'CMPMACHINE'
, 'CMPCATALOG'
, 'CMPWBVALIDATIONRESULT'
, 'CMPWBTEMPLATEUSAGE'
, 'CMPWBPROJECTUSERMAP'
, 'CMPWBCONTEXTACETYPEUSAGE'
, 'CMPUIOBJECT'
, 'CMPUIMODEL'
, 'CMPUIELEMENT'
, 'CMPUIMAP'
, 'CMPWBFOREIGNKEYUSAGE'
, 'CMPWBCONFIGURATIONTREEUSAGE'
, 'CMPWBACETYPEUSAGE'
, 'CMPWBINTGACETYPEUSAGE'
, 'CMPWBCONFIGPARAMVALUE'
, 'CMPWBEMERGENCYUSEONLY'
, 'CMPWBDELIMITER'
, 'CMPWBMAPTYPE'
, 'CMPWBCONTEXT'
, 'CMPACETYPE'
, 'CMPWBVALIDDATATYPELIST'
, 'CMPWBVALIDATIONMESSAGE'
, 'CMPELEMENT')