VIEW: APPS.OE_PC_CONSTRAINTS_DFV

Source

View Text - Preformatted

SELECT ROWID, ENTITY_ID, (DECODE (ENTITY_ID, '8', QUALIFIER_ATTRIBUTE, '7', QUALIFIER_ATTRIBUTE, '6', QUALIFIER_ATTRIBUTE, '5', QUALIFIER_ATTRIBUTE, '2', QUALIFIER_ATTRIBUTE, '1025', QUALIFIER_ATTRIBUTE, '1024', QUALIFIER_ATTRIBUTE, '1019', QUALIFIER_ATTRIBUTE, '1018', QUALIFIER_ATTRIBUTE, '1', QUALIFIER_ATTRIBUTE, NULL)),  
 (DECODE (ENTITY_ID,  
      '1', ENTITY_ID || '.' || QUALIFIER_ATTRIBUTE,  
      '1018', ENTITY_ID || '.' || QUALIFIER_ATTRIBUTE,  
      '1019', ENTITY_ID || '.' || QUALIFIER_ATTRIBUTE,  
      '1024', ENTITY_ID || '.' || QUALIFIER_ATTRIBUTE,  
      '1025', ENTITY_ID || '.' || QUALIFIER_ATTRIBUTE,  
      '2', ENTITY_ID || '.' || QUALIFIER_ATTRIBUTE,  
      '5', ENTITY_ID || '.' || QUALIFIER_ATTRIBUTE,  
      '6', ENTITY_ID || '.' || QUALIFIER_ATTRIBUTE,  
      '7', ENTITY_ID || '.' || QUALIFIER_ATTRIBUTE,  
      '8', ENTITY_ID || '.' || QUALIFIER_ATTRIBUTE, NULL)) 
 FROM OE_PC_CONSTRAINTS

View Text - HTML Formatted

SELECT ROWID
, ENTITY_ID
, (DECODE (ENTITY_ID
, '8'
, QUALIFIER_ATTRIBUTE
, '7'
, QUALIFIER_ATTRIBUTE
, '6'
, QUALIFIER_ATTRIBUTE
, '5'
, QUALIFIER_ATTRIBUTE
, '2'
, QUALIFIER_ATTRIBUTE
, '1025'
, QUALIFIER_ATTRIBUTE
, '1024'
, QUALIFIER_ATTRIBUTE
, '1019'
, QUALIFIER_ATTRIBUTE
, '1018'
, QUALIFIER_ATTRIBUTE
, '1'
, QUALIFIER_ATTRIBUTE
, NULL))
, (DECODE (ENTITY_ID
, '1'
, ENTITY_ID || '.' || QUALIFIER_ATTRIBUTE
, '1018'
, ENTITY_ID || '.' || QUALIFIER_ATTRIBUTE
, '1019'
, ENTITY_ID || '.' || QUALIFIER_ATTRIBUTE
, '1024'
, ENTITY_ID || '.' || QUALIFIER_ATTRIBUTE
, '1025'
, ENTITY_ID || '.' || QUALIFIER_ATTRIBUTE
, '2'
, ENTITY_ID || '.' || QUALIFIER_ATTRIBUTE
, '5'
, ENTITY_ID || '.' || QUALIFIER_ATTRIBUTE
, '6'
, ENTITY_ID || '.' || QUALIFIER_ATTRIBUTE
, '7'
, ENTITY_ID || '.' || QUALIFIER_ATTRIBUTE
, '8'
, ENTITY_ID || '.' || QUALIFIER_ATTRIBUTE
, NULL))
FROM OE_PC_CONSTRAINTS