rem ----------------------------------------------------------------------------
rem File:        $RCSfile: ckextlog.sql $
rem Author:      $Author: aobhrai $
rem Date:        $Date: 1998/03/19 08:38:29 $
rem Version:     $Revision: 1.5 $
rem Status:      $State: Exp $
rem Locked_by:   $Locker:  $
rem Description: <Enter global description here>
rem Notes:       <Global notes>
rem RealAuth:    <Full real name of code author>
rem IncepDate:   <nnth Xxxember 1994>
rem Copyright:   (c) Oracle Corporation 1994.  All Rights Reserved.
rem ----------------------------------------------------------------------------
rem Log of Changes from RCS
rem ----------------------------------------------------------------------------
rem $Log: ckextlog.sql $
rem Revision 1.5  1998/03/19  08:38:29  aobhrai
rem 630857 Changes for LOG_DIRECTORY_RAU
rem
rem Revision 1.4  1996/04/26  12:32:57  aobhrai
rem US bug 361916
rem
rem Revision 1.3  1995/09/15  14:33:33  dedwards
rem Remove control Z from end of file
rem
rem Revision 1.2  1995/07/14  13:51:42  dedwards
rem rem added to end of file
rem
rem Revision 1.1  1995/06/12  13:09:31  dedwards
rem Initial revision
rem
rem ----------------------------------------------------------------------------
rem  
rem
rem $Header: \\ukst76\rcsroot.4_0\model\repadm40\utl\RCS\ckextlog.sql 1.5 1998/03/19 08:38:29 aobhrai Exp $ ckextlog.sql Copyr (c) 1992, 1989 Oracle
rem
REM  Copyright (c) 1994 by Oracle Corporation
REM    NAME
REM      ckextlog.sql
REM    DESCRIPTION
REM      Logs UE Definitions Held In The UE Extract Tables
REM    RETURNS
REM
REM    NOTES
REM      <other useful comments, qualifications, etc.>
REM    MODIFIED   (MM/DD/YY)
REM     aobhrai     26/01/95 -  Initial Version

CLEAR BREAKS
CLEAR COLUMNS
COLUMN THISUSER NEW_VALUE TUSER
COLUMN TODAY    NEW_VALUE TDAY
COLUMN DESCRIPTION  FORMAT A50 HEADING DESCRIPTION
COLUMN TEXT_TYPE    FORMAT A9  HEADING 'TEXT TYPE'
COLUMN IS_EXTENDED  FORMAT A8  HEADING EXTENDED
COLUMN IS_PUBLISHED FORMAT A9  HEADING PUBLISHED 
COLUMN IS_USER_TYPE FORMAT A9  HEADING 'USER TYPE'
COLUMN NAME         FORMAT A37 HEADING NAME
COLUMN SHORT_NAME   FORMAT A12 HEADING 'ELEMENT TYPE'
COLUMN PART_OF      FORMAT A7  HEADING 'PART OF'
COLUMN USE_OF       FORMAT A7  HEADING 'USE OF'

PROMPT *******************************************************************************
PROMPT *    Producing Report on User Extension Meta Data Held In The Extract Table
PROMPT *    Please wait...                        
PROMPT *                                              
PROMPT *******************************************************************************


SET LINES 80
SET ARRAYSIZE 1
SET PAGES 68
SET ECHO OFF TERMOUT OFF FEEDBACK OFF WRAP ON VERIFY OFF RECSEP OFF HEADING ON

SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI') TODAY
,      USER                                    THISUSER
FROM   SYS.DUAL
/
SPOOL &1

SET TERMOUT OFF FEEDBACK OFF
PROMPT
PROMPT *******************************************************************************
PROMPT * Oracle Designer Repository Administration Utilities:
PROMPT *                            
PROMPT *    User Extension Meta Data Held In The Extract Tables
PROMPT *                                              
PROMPT *    Extract Definition On  : &TDAY
PROMPT *                      For  : &TUSER
PROMPT *                            
PROMPT *******************************************************************************
PROMPT
PROMPT The following UE TEXT TYPES are held in the extract tables:
SELECT TEXT_TYPE
,      DESCRIPTION
,      '       '||IS_EXTENDED   IS_EXTENDED
,      '        '||IS_PUBLISHED IS_PUBLISHED
FROM   XT_CIUE_TEXT_TYPES
ORDER  BY TEXT_TYPE
/
PROMPT
PROMPT The following UE TEXT USAGES are held in the extract tables:
SELECT XT.TEXT_TYPE
,      XT.XT_TU_SHORT_NAME SHORT_NAME
,      NAME 
,      '       '||XT.IS_EXTENDED   IS_EXTENDED
,      '        '||XT.IS_PUBLISHED IS_PUBLISHED
FROM   XT_CIUE_TEXT_USAGES  XT
,      XT_CIUE_ELEMENT_TYPES XET
WHERE  XT.XT_TU_SHORT_NAME  = XET.SHORT_NAME
UNION
SELECT XT.TEXT_TYPE
,      XT.XT_TU_SHORT_NAME SHORT_NAME
,      NAME 
,      '       '||XT.IS_EXTENDED   IS_EXTENDED
,      '        '||XT.IS_PUBLISHED IS_PUBLISHED
FROM   XT_CIUE_TEXT_USAGES  XT
,      RM_ELEMENT_TYPES ET
WHERE  XT.XT_TU_SHORT_NAME = ET.SHORT_NAME
ORDER  BY 1, 2
/
PROMPT 
PROMPT The following UE ELEMENT TYPES are held in the extract tables:
SELECT SHORT_NAME
,      NAME
,      '        '||IS_USER_TYPE IS_USER_TYPE
,      '       '||IS_EXTENDED   IS_EXTENDED
,      '        '||IS_PUBLISHED IS_PUBLISHED
FROM   XT_CIUE_ELEMENT_TYPES
ORDER  BY SHORT_NAME
/
COLUMN IS_EXTENDED  FORMAT A4  HEADING EXTD
COLUMN IS_PUBLISHED FORMAT A4  HEADING PUBD
COLUMN IS_USER_TYPE FORMAT A4  HEADING USER
COLUMN NAME         FORMAT A25 HEADING NAME
COLUMN DEGREE       FORMAT A9  HEADING DEGREE
PROMPT
PROMPT The following UE ASSOCIATION TYPES are held in the extract tables:
SELECT SHORT_NAME
,      NAME
,      PART_OF_SHORT_NAME PART_OF
,      USE_OF_SHORT_NAME  USE_OF
,      DECODE(PART_OF_DEGREE ,'1','ONE:','MANY:')||
       DECODE(USE_OF_DEGREE,  '1','ONE' ,'MANY') DEGREE	
,      '   '||IS_USER_TYPE IS_USER_TYPE 
,      '   '||IS_EXTENDED   IS_EXTENDED 
,      '   '||IS_PUBLISHED IS_PUBLISHED
FROM   XT_CIUE_ASSOCIATION_TYPES
ORDER BY SHORT_NAME, NAME
/
SET HEADING OFF 
SET WRAP OFF
SET TRUNC OFF
COLUMN A NEW_VALUE MOD
COLUMN B NEW_VALUE ELEMENT

COLUMN A FORMAT A25 NOPRINT
COLUMN B FORMAT A53 NOPRINT
COLUMN X FORMAT A25 NEWLINE 
COLUMN T FORMAT A53 NEWLINE
COLUMN C FORMAT A19 NEWLINE 
COLUMN D FORMAT A19 
COLUMN E FORMAT A19 
COLUMN F FORMAT A19  

BREAK ON A ON B SKIP PAGE
TTITLE LEFT '-------------------------------------------------------------------------------' SKIP 1 -
'USER EXTENDED PROPERTIES FOR ELEMENT TYPE  : ' MOD ' ('ELEMENT')'  SKIP 1 -
'-------------------------------------------------------------------------------' 
SELECT       ELEMENT_TYPE_SHORT_NAME                    A
,            ELEMENT_TYPE_NAME                          B
,            ' PROPERTY : '||NAME                       T
,            '    TITLE : '||DISPLAY_NAME               X
,            ' DATATYPE : '||DISPLAY_DATATYPE           C
,            '   LENGTH : '||TO_CHAR(DISPLAY_LENGTH)    D
,            'PRECISION : '||TO_CHAR(DISPLAY_PRECISION) E
,            '    SCALE : '||TO_CHAR(DISPLAY_SCALE)     F
,            'MANDATORY : '||IS_MANDATORY               C
,            '     CASE : '||DECODE(CASE_MODE,
                                    'U' ,'UPPER'
                             ,      'L' ,'LOWER'
                             ,           'MIXED')       D
,            ' SEQUENCE : '||TO_CHAR(DISPLAY_SEQUENCE)  E
,            'DISPLAYED : '||IS_DISPLAYED               F
,            'UPDATEBLE : '||IS_UPDATEABLE              C
,            '     USER : '||IS_USER_PROPERTY           D
,            ' EXTENDED : '||IS_EXTENDED                E
,            'PUBLISHED : '||IS_PUBLISHED               F
from XT_CIUE_PROPERTIES
ORDER BY 1,2,3
/

EXIT

rem  
rem ----------------------------------------------------------------------------
rem $$Header_is_done
rem  End of file $RCSfile: ckextlog.sql $
rem ----------------------------------------------------------------------------
rem

