srjava.util.Vectorٗ}[;IcapacityIncrementI elementCount[ elementDatat[Ljava/lang/Object;xp ur[Ljava.lang.Object;Xs)lxp(srInfoPurple.Qlet ඳcTL colDetailstLjava/util/Vector;L qletLocationtLjava/awt/Point;LqletSizetLjava/awt/Dimension;LqpValuesq~LqueryStrtLjava/lang/String;LsqlWithFiltersq~ xppppsq~(uq~(t EUL Reportpt100tManualt1440t 1-JAN-1990tYsrjava.awt.Color3uFfalphaIvalueLcstLjava/awt/color/ColorSpace;[ frgbvaluet[F[fvalueq~xp޸pppsq~pppsq~pppt1sr java.awt.Fontš5VsIfontSerializedDataVersionF pointSizeIsizeIstyleLfRequestedAttributestLjava/util/Hashtable;Lnameq~ xpA0 ptArialxsq~pppt19tYsq~pppsq~A@ ptArialxsq~ffpppt dd-MMM-yyyyt #########tq0q~sq~A0 pq~xtTREEtappst No_PatterntVLETsq~pppq~tXXDISCOVERER_ADMINsrInfoPurple.DashboardSettings ඳc۬I currPletIdxI currQletIdxxp'tAuthor,Description etcq~t1000tDEFAULTtYtYtNsrjavax.swing.JTextArea^j$oI columnWidthIcolumnsI rowHeightIrowsZwordZwrapxrjavax.swing.text.JTextComponentQDawwZcheckedInputOverrideZ dragEnabledZeditableCfocusAcceleratorZneedToSendKeyTypedEventL caretColortLjava/awt/Color;LcomposedTextAttributet%Ljavax/swing/text/SimpleAttributeSet;LcomposedTextCarett3Ljavax/swing/text/JTextComponent$ComposedTextCaret;LcomposedTextContentq~ LcomposedTextEndtLjavax/swing/text/Position;LcomposedTextStartq~0gjהxpsr%java.util.Collections$UnmodifiableSetяUxr,java.util.Collections$UnmodifiableCollectionB^LctLjava/util/Collection;xpsrjava.util.HashSetD4xpw ?@srjavax.swing.KeyStrokeCŗuv >xrjava.awt.AWTKeyStroke"8|CkeyCharIkeyCodeI modifiersZ onKeyReleasexp xsq~asq~ew ?@sq~g xppsrjavax.swing.plaf.FontUIResourceBć"Gxq~A0 ptTahomaxsq~Wpppsrjava.util.Locale~`0IhashcodeLcountryq~ Llanguageq~ Lvariantq~ xptUStentpppppptfocusLsr1javax.swing.text.JTextComponent$MutableCaretEventGY|IdotZ dragActiveImarkxrjavax.swing.event.CaretEvent [rVPxrjava.util.EventObjectL Nm}xpq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wtmouseLq~zq~q~{q~q~|q~q~}q~q~~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~psrjava.awt.ComponentOrientationEcI orientationxpppxur[Ljava.awt.Component; uxppppppxA(psrjavax.swing.ActionMapzLparentq~Cxppwxppsrjavax.swing.InputMapf!ٟLparentq~Dxpsr#javax.swing.plaf.InputMapUIResourceHMכxq~sq~pw7sq~g&At selection-upsq~g'tcaret-next-wordsq~g%tselection-previous-wordsq~gAq~sq~g(t caret-downsq~gTtprevious-link-actionsq~g%tcaret-previous-wordsq~gtcut-to-clipboardsq~g#tcaret-end-linesq~g!Atselection-page-upsq~gtcaret-upsq~gt delete-nextsq~g$t caret-beginsq~g%Atselection-backwardsq~g#t caret-endsq~gtdelete-previoussq~g'tselection-next-wordsq~g%tcaret-backwardsq~gq~sq~gAtselection-forwardsq~g tactivate-link-actionsq~gHq~sq~g\tunselectsq~g t insert-breaksq~g$Atselection-begin-linesq~g't caret-forwardsq~g!tselection-page-leftsq~g(Atselection-downsq~g"t page-downsq~gAq~sq~gOttoggle-componentOrientationsq~gXq~sq~g"tselection-page-rightsq~gCtcopy-to-clipboardsq~gq~sq~g#Atselection-end-linesq~gq~sq~g$tcaret-begin-linesq~gVtpaste-from-clipboardsq~gq~sq~gAt select-allsq~g'Aq~sq~g#t selection-endsq~gq~sq~gq~sq~gTtnext-link-actionsq~gAq~sq~g t insert-tabsq~g&q~sq~g$tselection-beginsq~g"Atselection-page-downsq~gq~sq~gq~sq~g!tpage-upsq~gq~xwxwxpsr#javax.swing.event.EventListenerList6}Dxppxpppwxpppppppppppsrjavax.swing.text.PlainDocumentBιŅLaddedq~L defaultRoott3Ljavax/swing/text/AbstractDocument$AbstractElement;Lremovedq~xr!javax.swing.text.AbstractDocument^Lcontextt4Ljavax/swing/text/AbstractDocument$AttributeContext;Ldatat+Ljavax/swing/text/AbstractDocument$Content;LdocumentFiltert!Ljavax/swing/text/DocumentFilter;LdocumentPropertiestLjava/util/Dictionary;L listenerListq~Gxpsrjavax.swing.text.StyleContexto~{xI unusedSetsLstylestLjavax/swing/text/Style;xpsr(javax.swing.text.StyleContext$NamedStyle NL listenerListq~GLthis$0tLjavax/swing/text/StyleContext;xpsq~pxq~wtdefaultsq~sq~pxq~wt$javax.swing.text.StyleConstants.nameq~xxxsrjavax.swing.text.GapContent LL#xrjavax.swing.text.GapVector;#6VIg0Ig1Larrayq~Zxp ur[C&f]xp psrjava.util.Hashtable%!JF loadFactorI thresholdxp?@wsrjava.awt.font.TextAttributekx Fxr/java.text.AttributedCharacterIterator$Attributet&G\Lnameq~ xpt run_directionsrjava.lang.Boolean r՜Zvaluexpti18nsq~&ttabSizesrjava.lang.Integer⠤8Ivaluexrjava.lang.Number xpxsq~pxsq~uq~ ppppppppppxsr/javax.swing.text.AbstractDocument$BranchElementQ)f<I lastIndexI nchildren[childrent4[Ljavax/swing/text/AbstractDocument$AbstractElement;Lthis$0t#Ljavax/swing/text/AbstractDocument;xr1javax.swing.text.AbstractDocument$AbstractElementϲx7LparenttLjavax/swing/text/Element;Lthis$0q~3xppq~wxur4[Ljavax.swing.text.AbstractDocument$AbstractElement;t9w:ѝxpsr-javax.swing.text.AbstractDocument$LeafElementjcLthis$0q~3xq~4q~6q~wxq~wxpq~sq~uq~ ppppppppppxpppxtYxppsrInfoPurple.Plet ඳcL pletLocationq~LpletSizeq~LppValuesq~LqueryStrq~ xpsrjava.awt.PointĊr4~&IxIyxpXsrjava.awt.DimensionA׬_DIheightIwidthxp2sq~uq~(tWorkbook CreatorsrdbUtil.dbInstance ඳcL dbConnectNameq~ LdbDriverq~ L dbPasswordq~ LdbURLq~ LdbUserq~ LuserTypeq~ xptlink-obyone1525devt(Oracle - oracle.jdbc.driver.OracleDrivertapps_devtlink-obyone:1525:devtappst DATABASE_USERtALLtdistinct created_byt created_byt'ID2't'ID3't'ID4't'ID5'srInfoPurple.PletValue ඳcHL descriptionq~ L displayValueq~ Lid1q~ Lid2q~ Lid3q~ Lid4q~ Lid5q~ L internalValueq~ xppt ALL Valuest%q~Yq~Yq~YtALLpsq~pppsq~pppsq~A@ ptArialxtappstNONEtPLETtp35tYtNtAuthor,Description etctYt1tNsq~78pq~Xsq~Ypq~ipxsq~\t Text Cursorpuq~_sq~asq~ew ?@q~ixsq~asq~ew ?@q~lxppq~nq~psq~qq~sq~tq~uppppppq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~q~sq~q~tq~q~uq~q~vq~q~wq~q~xq~q~yq~q~zq~q~{q~q~|q~q~}q~q~~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~wtdefaultsq~sq~pxq~wq~q~xxxsq~ uq~ psq~ ?@wq~$sq~&ti18nsq~&ttabSizesq~+xsq~pxsq~uq~ ppppppppppxsq~1pq~wxuq~7sq~9q~q~wxq~wxpq~sq~uq~ ppppppppppxpppxppppppppppppppppxtfrom ( SELECT decode(G_PARAM.G_PARAM_get_isitapps_eul, 1, G_PARAM.G_PARAM_get_apps_userresp(o100588.doc_created_by), o100588.doc_created_by) created_by FROM G_PARAM.G_PARAM_documents o100588 WHERE (o100588.doc_content_type = 'application/vnd.oracle-disco.wb') AND(o100588.doc_content_type = 'application/vnd.oracle-disco.wb') ) sq~>sq~@sq~B.sq~uq~(t EUL Ownerq~HtALLtdistinct ownert'ID1't'ID2't'ID3't'ID4't'ID5'sq~VptXXLS_APPS_EUL_UStID1tID2tID3tID4tID5psq~pppsq~pppsq~A@ ptArialxtappstNONEtPLETtp32tNq~tAuthor,Description etctYt1tNsq~78pq~Xsq~Ypq~pxsq~\t Text Cursorpuq~_sq~asq~ew ?@q~ixsq~asq~ew ?@q~lxppq~nq~psq~qq~sq~tq~uppppppq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~wtdefaultsq~sq~pxq~wq~q~xxxsq~ uq~ psq~ ?@wq~$sq~&ti18nsq~&ttabSizesq~+xsq~pxsq~uq~ ppppppppppxsq~1pq~wxuq~7sq~9q~q~wxq~wxpq~sq~uq~ ppppppppppxpppxppppppppppppppppxt1from all_tables where table_name like 'EUL5_BAS' sq~>sq~@sq~B2sq~uq~(t BA Creatorq~HtALLtdistinct ba_created_byt ba_created_byt'ID2't'ID3't'ID4't'ID5'sq~Vpq~Xq~Yq~Yq~Yq~Yq~Zpq~[sq~pppsq~A@ ptArialxtappstNONEtPLETtp34tYtNtAuthor,Description etctYt1tNsq~78pq~Xsq~Ypq~5pxsq~\t Text Cursorpuq~_sq~asq~ew ?@q~ixsq~asq~ew ?@q~lxppq~nq~psq~qq~sq~tq~uppppppq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~q~?q~q~@q~q~Aq~q~Bq~q~Cq~q~Dq~q~Eq~q~Fq~q~Gq~q~Hq~q~Iq~q~Jq~q~Kq~q~Lq~q~Mq~q~Nq~q~Oq~q~Pq~q~Qq~q~Rq~q~Sq~q~Tq~q~Uq~q~Vq~q~Wq~q~Xq~q~Yq~q~Zq~q~[q~q~\q~q~]q~q~^psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~fwtdefaultsq~sq~pxq~fwq~q~ixxxsq~ uq~ psq~ ?@wq~$sq~&ti18nsq~&ttabSizesq~+xsq~pxsq~uq~ ppppppppppxsq~1pq~ewxuq~7sq~9q~wq~ewxq~ewxpq~esq~uq~ ppppppppppxpppxppppppppppppppppxt3 from G_PARAM.G_PARAM_bassq~>sq~@8sq~B2sq~uq~(t Show SQL forq~HtALLt Folder_typetvaluet'ID2't'ID3't'ID4't'ID5'sq~Vpt ALL Folderst%tID2tID3tID4tID5psq~pppsq~pppsq~A@ ptArialxtappstNONEtPLETtp38tNq~tAuthor,Description etctYt1q~sq~78pq~Xsq~Ypq~pxsq~\t Text Cursorpuq~_sq~asq~ew ?@q~ixsq~asq~ew ?@q~lxppq~nq~psq~qq~sq~tq~uppppppq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~wtdefaultsq~sq~pxq~wq~q~xxxsq~ uq~ psq~ ?@wq~$sq~&ttabSizesq~+ti18nsq~&xsq~pxsq~uq~ ppppppppppxsq~1pq~wxuq~7sq~9q~q~wxq~wxpq~sq~uq~ ppppppppppxpppxppppppppppppppppxtsfrom ( select 'ALL Folders' Folder_type, '%' value FROM dual union select 'Custom Folders only' , 'CUO' from dual )sq~>sq~@4sq~B2wsq~uq~(t BA Name likeq~HtALLt'%'t'ID1't'ID2't'ID3't'ID4't'ID5'sq~Vpt%tID1tID2tID3tID4tID5psq~pppsq~pppsq~A@ ptArialxtappstNONEtPLETtp36tNtYtAuthor,Description etctYt1tNsq~78pq~Xsq~Ypq~pxsq~\t Text Cursorpuq~_sq~asq~ew ?@q~ixsq~asq~ew ?@q~lxppq~nq~psq~qq~sq~tq~uppppppq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~q~q~q~q~q~q~q~ q~q~ q~q~ q~q~ q~q~ q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~ q~q~!q~q~"q~q~#q~q~$q~q~%psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~-wtdefaultsq~sq~pxq~-wq~q~0xxxsq~ uq~ psq~ ?@wq~$sq~&ti18nsq~&ttabSizesq~+xsq~pxsq~uq~ ppppppppppxsq~1pq~,wxuq~7sq~9q~>q~,wxq~,wxpq~,sq~uq~ ppppppppppxpppxppppppppppppppppxt FROM dualsq~>sq~@4sq~B2dsq~uq~(t Tablel Prefixq~HtALLt 'EUL5' prefixt'ID1't'ID2't'ID3't'ID4't'ID5'sq~VptEUL5tID1tID2tID3tID4tID5pq~sq~pppsq~A@ ptArialxtappstNONEtPLETtp33tNq~_tAuthor,Description etctYt1tNsq~78pq~Xsq~Ypq~dpxsq~\t Text Cursorpuq~_sq~asq~ew ?@q~ixsq~asq~ew ?@q~lxppq~nq~psq~qq~sq~tq~uppppppq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~q~nq~q~oq~q~pq~q~qq~q~rq~q~sq~q~tq~q~uq~q~vq~q~wq~q~xq~q~yq~q~zq~q~{q~q~|q~q~}q~q~~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~wtdefaultsq~sq~pxq~wq~q~xxxsq~ uq~ psq~ ?@wq~$sq~&ti18nsq~&ttabSizesq~+xsq~pxsq~uq~ ppppppppppxsq~1pq~wxuq~7sq~9q~q~wxq~wxpq~sq~uq~ ppppppppppxpppxppppppppppppppppxt from dual sq~>sq~@:1sq~B2dsq~uq~(t Folder Typeq~HtALLt Folder_typetvaluet'ID2't'ID3't'ID4't'ID5'sq~VptALLt%tID2tID3tID4tID5pq~sq~pppsq~A@ ptArialxtappstNONEtPLETtp39tNq~tAuthor,Description etctYt1tYsq~78pq~Xsq~Ypq~pxsq~\t Text Cursorpuq~_sq~asq~ew ?@q~ixsq~asq~ew ?@q~lxppq~nq~psq~qq~sq~tq~uppppppq~vsq~wq~vsq~wq~vsq~wq~vsq~w""q~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~wtdefaultsq~sq~pxq~wq~q~xxxsq~"Guq~H//<REFRESH_LIST>q32</REFRESH_LIST> psq~ ?@wq~$sq~&ttabSizesq~+ti18nsq~&xsq~pxsq~uq~ ppppppppppxsq~1pq~wxuq~7sq~9q~q~wxq~w#xpq~sq~uq~ ppppppppppxpppxppppppppppppppppxtfrom ( select 'ALL' Folder_type, '%' value FROM dual union select 'Custom' , 'CUO' from dual union select 'Complex' , 'COBJ' from dual union select 'Simple', 'SOBJ' from dual )sq~>sq~@X4sq~B2sq~uq~(tWorkbook Name Likeq~HtALLt'%'t'ID1't'ID2't'ID3't'ID4't'ID5'sq~Vpt%tID1tID2tID3tID4tID5psq~pppsq~pppsq~A@ ptArialxtappstNONEtPLETtp37tNtYtAuthor,Description etctYt1tNsq~78pq~Xsq~Ypq~+pxsq~\t Text Cursorpuq~_sq~asq~ew ?@q~ixsq~asq~ew ?@q~lxppq~nq~psq~qq~sq~tq~uppppppq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~q~5q~q~6q~q~7q~q~8q~q~9q~q~:q~q~;q~q~q~q~?q~q~@q~q~Aq~q~Bq~q~Cq~q~Dq~q~Eq~q~Fq~q~Gq~q~Hq~q~Iq~q~Jq~q~Kq~q~Lq~q~Mq~q~Nq~q~Oq~q~Pq~q~Qq~q~Rq~q~Sq~q~Tpsq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~\wtdefaultsq~sq~pxq~\wq~q~_xxxsq~ uq~ psq~ ?@wq~$sq~&ti18nsq~&ttabSizesq~+xsq~pxsq~uq~ ppppppppppxsq~1pq~[wxuq~7sq~9q~mq~[wxq~[wxpq~[sq~uq~ ppppppppppxpppxppppppppppppppppxt FROM dualsq~sq~uq~ srInfoPurple.ColumnPropertyValues ඳcٸL colPropValuesq~L drillValuesq~L parentQlettLInfoPurple/Qlet;xpsq~uq~t#RIGHTCLICKONEACHPARAMETERANDREFRESHt199sq~pppsq~@@@pppsq~pppt1q~~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyytYsq~A pq~xt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~ssq~vsq~uq~tFollow the stepst672q~}q~~q~t1q~~q~tNAtNt ##########t dd-MMM-yyyytYq~tFollow The StepstDEFAULTtNpppxsq~uq~ ppppppppppxq~ssq~vsq~uq~tSEQt34q~}q~~q~t4q~~sq~AP ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~AP pq~xtSeqtDEFAULTtYpppxsq~uq~ ppppppppppxq~spppppppxsq~@hsq~Bsq~(uq~(tFirst Timer Instructionsq~Ht100tManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~ q~!q~"q~$t dd-MMM-yyyyt #########tq182q~q~(q~tappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etctNt1tDEFAULTtYtYtNsq~78pq~Xsq~Ypq~pxsq~\t Text Cursorpuq~_sq~asq~ew ?@q~ixsq~asq~ew ?@q~lxppq~nq~psq~qq~sq~tq~uppppppq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~wtdefaultsq~sq~pxq~wq~q~xxxsq~ uq~ psq~ ?@wq~$sq~&ti18nsq~&ttabSizesq~+xsq~pxsq~uq~ ppppppppppxsq~1pq~wxuq~7sq~9q~q~wxq~wxpq~sq~uq~ ppppppppppxpppxtYxtselect * from ( select 1 seq, 'Right click on each parameter and Refresh' "Follow the steps" from dual union select 2 ,'For e.g. Right click on EUL Owner and refresh' from dual union select 3, 'Similarly refresh all the remaining parameters' from dual union select 4, 'Then refresh each portlet starting with Business Area and verify the drills' from dual union select 5,'OR Right click on the below link and launch the short video tutorial' from dual union select 6,'http://www.infocaptor.com/demo/disco_report_demo.htm' from dual union select 7, 'Once everything is set, optionally delete this Qlet (First Timer Instructions) by clicking on the scissor icon' from dual ) order by seq asctNsq~sq~ uq~ sq~vsq~uq~tInfoCaptor Messaget450sq~pppsq~@@@pppsq~pppt1q~ sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~$xtInfocaptor MessagetDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~t WORKBOOK_KEYt75q~q~ q~!t1q~ q~#tNAtNt ##########t dd-MMM-yyyyq~q~)t Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tFOLDERt172q~q~ q~!t1q~ q~#tNAtNt ##########t dd-MMM-yyyyq~q~)tFoldertDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tDEPENDENCY_NAMEt83q~q~ q~!t1q~ q~#tNAtNt ##########t dd-MMM-yyyyq~q~)tDependency NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~t FOLDER_KEYt52q~q~ q~!t1q~ q~#tNAtNt ##########t dd-MMM-yyyyq~q~)t Folder KeytDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tDEPENDENCY_KEYt50q~q~ q~!t1q~ q~#tNAtNt ##########t dd-MMM-yyyyq~q~)tDependency KeytDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~t TABLE_VIEWt219q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyytNq~(t Table ViewtDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~t WORKBOOK_NAMEt169q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~(t Workbook NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tDEPENDENCY_TYPEt42q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~(tDependency TypetDEFAULTtYpppxsq~uq~ ppppppppppxq~pxsq~@p7sq~B{sq~(uq~(tWorkbook Dependenciesq~Ht100tManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~ q~!q~"q~$t dd-MMM-yyyyt #########tq107q~q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etctYq~2tDEFAULTtYtYtNsq~78pq~Xsq~Ypq~pxsq~\t Text Cursorpuq~_sq~asq~ew ?@q~ixsq~asq~ew ?@q~lxppq~nq~psq~qq~sq~tq~uppppppq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~wtdefaultsq~sq~pxq~wq~q~xxxsq~ uq~ psq~ ?@wq~$sq~&ti18nsq~&ttabSizesq~+xsq~pxsq~uq~ ppppppppppxsq~1pq~wxuq~7sq~9q~q~wxq~wxpq~sq~uq~ ppppppppppxpppxtYxtSELECT o100588.doc_name workbook_name, -- o100588.doc_developer_key workbook_key, decode(o100590.ex_to_type, 'ITE', 'Item', 'JOI', 'Join', 'FIL', 'Condition', o100590.ex_to_type) dependency_type, o100590.ex_to_par_name folder, (decode(SUBSTR(o100590.ex_to_name, 1, 19), 'AUTO_GENERATED_NAME', (decode(o100590.ex_to_type, 'JOI', (decode((decode(o100590.ex_to_type, 'JOI', G_PARAM.G_PARAM_get_join_expid(o100590.ex_to_id, o100590.ex_to_devkey), to_number(NULL))), NULL, NULL, G_PARAM.G_PARAM_get_join((decode(o100590.ex_to_type, 'JOI', G_PARAM.G_PARAM_get_join_expid(o100590.ex_to_id, o100590.ex_to_devkey), to_number(NULL)))))), 'ITE', (decode((decode(o100590.ex_to_type, 'ITE', o100590.ex_to_id, to_number(NULL))), NULL, NULL, G_PARAM.G_PARAM_get_autogen_item_name((decode(o100590.ex_to_type, 'ITE', o100590.ex_to_id, to_number(NULL)))))), 'FIL', (decode((decode(o100590.ex_to_type, 'FIL', o100590.ex_to_id, to_number(NULL))), NULL, NULL, o100590.ex_to_name)), NULL)), o100590.ex_to_name)) Dependency_name , o100590.ex_to_par_devkey folder_key, ( select sobj_ext_table from G_PARAM.G_PARAM_OBJS where obj_developer_key=o100590.ex_to_par_devkey ) Table_View , o100590.ex_to_devkey Dependency_key FROM G_PARAM.G_PARAM_documents o100588, G_PARAM.G_PARAM_elem_xrefs o100590 WHERE(((to_number(o100590.ex_from_id)) = o100588.doc_id)) AND(o100588.doc_content_type = 'application/vnd.oracle-disco.wb') and ( o100588.doc_id = param or lower(o100588.doc_name) like lower('param') ) ORDER BY o100588.doc_developer_key ASC, o100588.doc_name ASC, decode(o100590.ex_to_type, 'ITE', 'Item', 'JOI', 'Join', 'FIL', 'Condition', o100590.ex_to_type) DESC, o100590.ex_to_par_name ASC, o100590.ex_to_par_devkey ASCtYsq~sq~uq~ sq~vsq~uq~t SHARED_WITHt322sq~pppsq~@@@pppsq~pppt1q~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~xt Shared WithtDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tInfoCaptor Messaget450q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~!t Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tWORKBOOKt264q~q~q~t1q~sq~A0 ptArialxtNAtNt ##########t dd-MMM-yyyytNsq~A0 pq~=xtWorkbooktDEFAULTtYpppxsq~uq~ ppppppppppxq~pppppppxsq~@^;sq~Bmsq~(uq~(tWorkbook Sharing Infoq~Ht100tManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~ q~!q~"q~$t dd-MMM-yyyyt #########tq127q~q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etctYq~2tDEFAULTtYtYtNsq~78pq~Xsq~Ypq~dpxsq~\t Text Cursorpuq~_sq~asq~ew ?@q~ixsq~asq~ew ?@q~lxppq~nq~psq~qq~sq~tq~uppppppq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~q~nq~q~oq~q~pq~q~qq~q~rq~q~sq~q~tq~q~uq~q~vq~q~wq~q~xq~q~yq~q~zq~q~{q~q~|q~q~}q~q~~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~wtdefaultsq~sq~pxq~wq~q~xxxsq~ uq~ psq~ ?@wq~$sq~&ti18nsq~&ttabSizesq~+xsq~pxsq~uq~ ppppppppppxsq~1pq~wxuq~7sq~9q~q~wxq~wxpq~sq~uq~ ppppppppppxpppxtYxt;SELECT o100588.doc_name workbook, '>> '|| decode(G_PARAM.G_PARAM_get_isitapps_eul, 1, decode(o100591.eu_role_flag, 1, G_PARAM.G_PARAM_get_apps_userresp(o100591.eu_username, 'R'), decode(o100591.eu_username, NULL, 'Document Not Shared', G_PARAM.G_PARAM_get_apps_userresp(o100591.eu_username))), nvl(o100591.eu_username, 'Document Not Shared')) shared_with, o100572.ap_created_date shared_with_date FROM G_PARAM.G_PARAM_access_privs o100572, G_PARAM.G_PARAM_documents o100588, G_PARAM.G_PARAM_eul_users o100591 WHERE((o100588.doc_id = o100572.gd_doc_id(+)) AND(o100591.eu_id(+) = o100572.ap_eu_id)) AND(o100588.doc_content_type = 'application/vnd.oracle-disco.wb') AND(o100588.doc_content_type = 'application/vnd.oracle-disco.wb') and ( o100588.doc_id = param or lower(o100588.doc_name) like lower('param') ) ORDER BY o100588.doc_name ASC, o100588.doc_created_date ASCtYsq~sq~ uq~sq~vsq~uq~tInfoCaptor Messaget450sq~pppsq~pppsq~pppt1q~sq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxtInfocaptor MessagetDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~t ITEM_NAMEt111q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt Item Name tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tEXP_ELEMENT_STATEt75sq~pppq~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tEXP_IDt41q~q~q~t1q~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~xtExp IdtDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~t IT_EXT_COLUMNt48q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t It Ext ColumntDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~t FOLDER_NAMEt100q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Folder NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tBA_NAMEt101q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tITEMt116q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tITEM_DEPENDENCYt189q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tITEM_KEYt105q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tItem KeytDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tITEM_DEPENDS_ONt83q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tItem Depends OntDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tFOLDERt169q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyytNq~(tFoldertDEFAULTtYpppxsq~uq~ ppppppppppxq~ppppppppxsq~@Ssq~B,sq~(uq~(t Folder Itemsq~Ht100tManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~ q~!q~"q~$t dd-MMM-yyyyt #########tq35q~q~(tNtappst No_PatterntQLETsq~pppq~tXXDBNAMEt tAuthor,Description etctYq~2tDEFAULTtYtYtNsq~78pq~Xsq~Ypq~pxsq~\t Text Cursorpuq~_sq~asq~ew ?@q~ixsq~asq~ew ?@q~lxppq~nq~psq~qq~sq~tq~uppppppq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~wtdefaultsq~sq~pxq~wq~q~xxxsq~ uq~ psq~ ?@wq~$sq~&ti18nsq~&ttabSizesq~+xsq~pxsq~uq~ ppppppppppxsq~1pq~wxuq~7sq~9q~q~wxq~wxpq~sq~uq~ ppppppppppxpppxtYxtselect i.exp_name item_name, i.exp_description item_description, G_PARAM.G_PARAM_get_item((i.exp_id)) Item_depends_on , i.it_ext_column, i.exp_developer_key item_key, i.exp_id item_id, f.obj_name folder from G_PARAM.G_PARAM_expressions i , G_PARAM.G_PARAM_objs f , G_PARAM.G_PARAM_ba_obj_links l , G_PARAM.G_PARAM_bas b where f.obj_id= i.it_obj_id and f.obj_id= l.bol_obj_id and b.ba_id= l.bol_ba_id and ( f.obj_id = param or lower(f.obj_name) like lower('param')) and lower(i.exp_name) like lower('param') order by b.ba_name,f.obj_name,i.exp_nametYsq~sq~ uq~sq~vsq~uq~tInfoCaptor Messaget450sq~pppsq~@@@pppsq~pppt1q~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~xtInfocaptor MessagetDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tFOLDERt199q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tFoldertDEFAULTtYpppxsq~uq~ srInfoPurple.DrillSettings ඳcL drillColumnsq~L drillNameq~ L drillQletIDq~ xpsq~uq~ t FOLDER_IDtFOLDERppppppppxtGet Folder Detailstq71sq~sq~uq~ t FOLDER_IDq~ t%pppppppxtGet Folder Itemsq~sq~sq~uq~ t FOLDER_IDq~ ppppppppxtGet Folder Joinstq37sq~sq~uq~ t FOLDER_IDq~ppppppppxtGet Folder SQLtq250ppppppxq~sq~vsq~uq~t FOLDER_HIDDENt44q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Folder HiddentDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~t FOLDER_TYPEt43q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Folder TypetDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~t FOLDER_IDt47q~q~q~t1q~q~.G_PARAM_expressions i , G_PARAM.G_PARAM_objs f where f.obj_id= i.it_obj_id and f.obj_id = o100607.obj_id ) Item_total, ( SELECT count( distinct decode(decode(SUBSTR(o100605x.key_name, 1, 19), 'AUTO_GENERATED_NAME', 'Yes', 'No'), 'Yes', G_PARAM.G_PARAM_get_join(o100592x.exp_id), o100605x.key_name) ) FROM G_PARAM.G_PARAM_ba_obj_links o100582x, G_PARAM.G_PARAM_objs o100607x, G_PARAM.G_PARAM_expressions o100592x, G_PARAM.G_PARAM_key_cons o100605x WHERE((o100607x.obj_id = o100582x.bol_obj_id) AND(o100605x.key_id = o100592x.jp_key_id) AND(o100607x.obj_id = o100605x.fk_obj_id_remote)) and ( o100607x.obj_id = o100607.obj_id ) ) Join_total, ( select count (distinct o100588x.doc_id) FROM G_PARAM.G_PARAM_objs o100607x, G_PARAM.G_PARAM_documents o100588x, G_PARAM.G_PARAM_elem_xrefs o100590x WHERE 1=1 and to_number(o100590x.ex_from_id) = o100588x.doc_id AND(o100588x.doc_content_type = 'application/vnd.oracle-disco.wb') and o100590x.ex_to_par_devkey = o100607x.obj_developer_key and o100607x.obj_id = o100607.obj_id ) work_book_total, -- o100607.obj_developer_key Folder_Key, -- o100607.obj_updated_date last_updated, o100607.sobj_ext_table, o100607.obj_id folder_id --o100577.ba_name FROM G_PARAM.G_PARAM_bas o100577, G_PARAM.G_PARAM_ba_obj_links o100582, G_PARAM.G_PARAM_objs o100607 WHERE((o100577.ba_id(+) = o100582.bol_ba_id) and ( o100577.ba_id = param or lower(o100577.ba_name) like lower('param') ) AND(o100607.obj_id = o100582.bol_obj_id)) and o100607.obj_type like 'G_PARAM' /*Folder type value*/ and upper(o100607.obj_name) like upper('param') and lower(o100607.sobj_ext_table) like lower('param') ) ORDER BY folder ASC tYsq~sq~uq~ sq~vsq~uq~q~t450sq~pppsq~@@@pppsq~pppt1q~ (sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~ ,xtInfocaptor MessagetDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~vsq~uq~tDEPENDENT_FOLDERSt95q~ 'q~ (q~ )t1q~ (q~ +tNAtNt ##########t dd-MMM-yyyyq~q~ 1tDependent FolderstDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~vsq~uq~tTABLE_COMPONENTSt134q~ 'q~ (q~ )t1q~ (q~ +tNAtNt ##########t dd-MMM-yyyyq~q~ 1tTable ComponentstDEFAULTtYpppxsq~uq~ ppppppppppxq~ pppppppxsq~@Ssq~BKsq~(uq~(tMore Folder Detailsq~Ht100tManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~ q~!q~"q~$t dd-MMM-yyyyt #########q~ q~q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etcq~Bq~2tDEFAULTtYtYtNsq~78pq~Xsq~Ypq~ npxsq~\t Text Cursorpuq~_sq~asq~ew ?@q~ixsq~asq~ew ?@q~lxppq~nq~psq~qq~sq~tq~uppppppq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~q~ xq~q~ yq~q~ zq~q~ {q~q~ |q~q~ }q~q~ ~q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~ wtdefaultsq~sq~pxq~ wq~q~ xxxsq~ uq~ psq~ ?@wq~$sq~&ti18nsq~&ttabSizesq~+xsq~pxsq~uq~ ppppppppppxsq~1pq~ wxuq~7sq~9q~ q~ wxq~ wxpq~ sq~uq~ ppppppppppxpppxtYxtSELECT REPLACE(G_PARAM.G_PARAM_get_object_name(G_PARAM.G_PARAM_get_complex_folder(o100607.obj_id), 'F'), ', ', CHR(10)) dependent_folders, REPLACE(G_PARAM.G_PARAM_get_object_name(G_PARAM.G_PARAM_get_simple_folder(o100607.obj_id), 'F'), ', ', CHR(10)) folder_components, G_PARAM.G_PARAM_get_analyzed(o100607.obj_id, 'T') Table_components, G_PARAM.G_PARAM_get_analyzed(o100607.obj_id, 'D') Analyzed FROM G_PARAM.G_PARAM_bas o100577, G_PARAM.G_PARAM_ba_obj_links o100582, G_PARAM.G_PARAM_objs o100607 WHERE((o100577.ba_id(+) = o100582.bol_ba_id) AND(o100607.obj_id = o100582.bol_obj_id)) and ( o100607.obj_id = param or lower(o100607.obj_name) like lower('param'))q~sq~sq~uq~ sq~vsq~uq~tKEY_DESCRIPTIONt711sq~pppsq~pppsq~pppt1q~ sq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxtKey Description tDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~vsq~uq~t JOIN_NAMEt298q~q~ q~t1q~ q~tNAtNt ##########t dd-MMM-yyyyq~q~t Join NametDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~vsq~uq~tJOIN_CONDITIONt282q~q~ q~t1q~ q~tNAtNt ##########t dd-MMM-yyyyq~q~tJoin ConditiontDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~vsq~uq~t JOIN_DETAILSt137q~q~ q~t1q~ q~tNAtNt ##########t dd-MMM-yyyyq~q~t Join DetailstDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~vsq~uq~tAUTOt33q~q~q~t1q~q~q~q~ ?q~q~ @q~q~ Aq~q~ Bq~q~ Cq~q~ Dq~q~ Eq~q~ Fq~q~ Gq~q~ Hq~q~ Iq~q~ Jq~q~ Kq~q~ Lq~q~ Mq~q~ Nq~q~ Oq~q~ Pq~q~ Qq~q~ Rq~q~ Sq~q~ Tq~q~ Uq~q~ Vq~q~ Wq~q~ Xq~q~ Yq~q~ Zq~q~ [q~q~ \q~q~ ]q~q~ ^q~q~ _psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~ gwtdefaultsq~sq~pxq~ gwq~q~ jxxxsq~ uq~ psq~ ?@wq~$sq~&ti18nsq~&ttabSizesq~+xsq~pxsq~uq~ ppppppppppxsq~1pq~ fwxuq~7sq~9q~ xq~ fwxq~ fwxpq~ fsq~uq~ ppppppppppxpppxtYxt;SELECT distinct decode(decode(SUBSTR(o100605.key_name, 1, 19), 'AUTO_GENERATED_NAME', 'Yes', 'No'), 'Yes', G_PARAM.G_PARAM_get_join(o100592.exp_id), o100605.key_name) join_name , G_PARAM.G_PARAM_get_join(o100592.exp_id, 'N') join_condition , decode(o100605.fk_mandatory, 1, 'Always exist in master folder', 'Might not exist in master folder') join_details , nvl(decode(o100605.fk_mstr_no_detail, 1, 'Outer join on detail' || CHR(10), NULL) || decode(o100605.fk_dtl_no_master, 1, 'Outer join on master' || CHR(10), NULL) || decode(o100605.fk_one_to_one, 1, 'One to one join', NULL), 'None') optional_join_configuration , decode(SUBSTR(o100605.key_name, 1, 19), 'AUTO_GENERATED_NAME', 'Yes', 'No') Auto ,o100607.obj_name folder FROM G_PARAM.G_PARAM_ba_obj_links o100582, G_PARAM.G_PARAM_objs o100607, G_PARAM.G_PARAM_expressions o100592, G_PARAM.G_PARAM_key_cons o100605 WHERE((o100607.obj_id = o100582.bol_obj_id) AND(o100605.key_id = o100592.jp_key_id) AND(o100607.obj_id = o100605.fk_obj_id_remote)) and ( o100607.obj_id = param or lower( o100607.obj_name) like lower('param') ) q~sq~sq~uq~ sq~vsq~uq~tSQL_CODEt698sq~pppsq~@@@pppsq~pppt1q~ sq~A ptArialxtNAtNt ##########t dd-MMM-yyyytNsq~A pq~ xtSql CodetDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~vsq~uq~tSEQUENCE_NUMBERt24q~ q~ q~ t1q~ q~ tNAtNt ##########t dd-MMM-yyyyq~ q~ tSequence NumbertDEFAULTtYpppxsq~uq~ ppppppppppxq~ ppppppppxsq~@sq~BKsq~(uq~(t Folder SQLq~Ht100tManualt300t 1-JAN-1990tYq~q~q~q~q~q~q~q~ q~!q~"q~$t dd-MMM-yyyyt #########q~q~q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etctYt1tDEFAULTq~ tNq~ sq~78pq~Xsq~Ypq~ pxsq~\t Text Cursorpuq~_sq~asq~ew ?@q~ixsq~asq~ew ?@q~lxppq~nq~psq~qq~sq~tq~uppppppq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~ wtdefaultsq~sq~pxq~ wq~q~ xxxsq~ uq~ psq~ ?@wq~$sq~&ti18nsq~&ttabSizesq~+xsq~pxsq~uq~ ppppppppppxsq~1pq~ wxuq~7sq~9q~ q~ wxq~ wxpq~ sq~uq~ ppppppppppxpppxq~ xtSELECT 1 SEQ, OBJ.OBJ_OBJECT_SQL1 || OBJ.OBJ_OBJECT_SQL2 || OBJ.OBJ_OBJECT_SQL3 SQL_CODE FROM G_PARAM.G_PARAM_OBJS OBJ WHERE 1=1 and OBJ.OBJ_TYPE like 'G_PARAM' /*value*/ AND OBJ_OBJECT_SQL1 IS NOT NULL and obj.obj_id = param UNION SELECT SEG.SEG_SEQUENCE SEQ, SEG.SEG_CHUNK1 || SEG.SEG_CHUNK2 || SEG.SEG_CHUNK3 || SEG.SEG_CHUNK4 SQL_CODE FROM G_PARAM.G_PARAM_SEGMENTS SEG, G_PARAM.G_PARAM_OBJS OBJ WHERE 1=1 and OBJ.OBJ_TYPE like 'G_PARAM' /*value*/ AND OBJ_OBJECT_SQL1 IS NULL AND SEG.SEG_OBJ_ID = OBJ.OBJ_ID AND SEG.SEG_SEG_TYPE = 1 and obj.obj_id= param ORDER BY 1 q~ sq~sq~uq~ sq~vsq~uq~q~t450sq~pppsq~@@@pppsq~pppt1q~ sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~ xtInfocaptor MessagetDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~vsq~uq~t BASE_OBJECTt267q~ q~ q~ t1q~ q~ tNAtNt ##########t dd-MMM-yyyyq~q~ t Base ObjecttDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~vsq~uq~tITEMt75q~q~q~t1q~q~.G_PARAM_get_autogen_item_name(o100592.exp_id)), NULL) used_in_condition, decode(o100592.exp_type, 'FIL', NULL, (G_PARAM.G_PARAM_get_autogen_item_name(o100592.exp_id))) item, o100577.ba_name , G_PARAM.G_PARAM_get_object(o100593.ped_exp_id) base_object, o100592_2.exp_name filter_name, decode(o100592_2.fil_runtime_filter, 0, 'Mandatory', 'Optional') filter_type, o100607_2.obj_name folder_name FROM G_PARAM.G_PARAM_expressions o100592, G_PARAM.G_PARAM_bas o100577, G_PARAM.G_PARAM_ba_obj_links o100582, G_PARAM.G_PARAM_objs o100607, G_PARAM.G_PARAM_expressions o100592_2, G_PARAM.G_PARAM_exp_deps o100593, G_PARAM.G_PARAM_objs o100607_2 WHERE((o100577.ba_id(+) = o100582.bol_ba_id) AND(o100607.obj_id = o100582.bol_obj_id) AND(o100592_2.exp_id = o100593.pd_p_id) AND(o100607_2.obj_id = o100592_2.fil_obj_id) AND(o100607.obj_id = o100607_2.obj_id) AND(o100593.ped_exp_id = o100592.exp_id)) and ( o100577.ba_id = param or lower(o100577.ba_name) like lower('param') ) order by o100577.ba_nameq~sq~sq~uq~ sq~vsq~uq~q~t450sq~pppsq~@@@pppsq~pppt1q~ sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~ xtInfocaptor MessagetDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~vsq~uq~tHIERARCHY_NAMEt157q~ q~ q~ t1q~ q~ tNAtNt ##########t dd-MMM-yyyyq~q~ tHierarchy NametDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~vsq~uq~t CREATED_BYt50q~ q~ q~ t1q~ q~ tNAtNt ##########t dd-MMM-yyyyq~q~ t Created BytDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~vsq~uq~tHIERARCHY_LEVELt60q~ q~ q~ t1q~ q~ tNAtNt ##########t dd-MMM-yyyyq~q~ tHierarchy LeveltDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~vsq~uq~tHIERARCHY_DETAILSt386q~ q~ q~ t1q~ q~ tNAtNt ##########t dd-MMM-yyyyq~q~ tHierarchy DetailstDEFAULTtYpppxsq~uq~ ppppppppppxq~ pppppxsq~@ usq~B sq~(uq~(t Hierarchiesq~Ht100tManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~ q~!q~"q~$t dd-MMM-yyyyt #########tq90q~q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etcq~q~2tDEFAULTtYtYtNsq~78pq~Xsq~Ypq~ pxsq~\t Text Cursorpuq~_sq~asq~ew ?@q~ixsq~asq~ew ?@q~lxppq~nq~psq~qq~sq~tq~uppppppq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ !q~q~ "q~q~ #q~q~ $q~q~ %q~q~ &q~q~ 'q~q~ (q~q~ )q~q~ *q~q~ +q~q~ ,q~q~ -q~q~ .q~q~ /psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~ 7wtdefaultsq~sq~pxq~ 7wq~q~ :xxxsq~ uq~ psq~ ?@wq~$sq~&ti18nsq~&ttabSizesq~+xsq~pxsq~uq~ ppppppppppxsq~1pq~ 6wxuq~7sq~9q~ Hq~ 6wxq~ 6wxpq~ 6sq~uq~ ppppppppppxpppxtYxt SELECT o100631.i102167 hierarchy_name, o100631.i102174 created_by, o100631.i102376 hierarchy_level, o100631.i102312 hierarchy_details FROM (SELECT o100577.ba_name AS i101816, o100607.obj_id AS i102327 FROM G_PARAM.G_PARAM_bas o100577, G_PARAM.G_PARAM_objs o100607, G_PARAM.G_PARAM_ba_obj_links o100582 WHERE(o100577.ba_id = o100582.bol_ba_id) AND(o100607.obj_id = o100582.bol_obj_id) and ( o100577.ba_id = param or lower(o100577.ba_name) like lower('param') )) o100627, (SELECT o100607.obj_id AS i102116, o100592.exp_id AS i102222 FROM G_PARAM.G_PARAM_expressions o100592, G_PARAM.G_PARAM_objs o100607 WHERE(o100607.obj_id = o100592.it_obj_id)) o100630, (SELECT o100603.hil_exp_id AS i102139, (decode(SUBSTR(o100600.hi_name, 1, 19), 'AUTO_GENERATED_NAME', (G_PARAM.G_PARAM_get_foldername((decode(o100600.ibh_dbh_id, NULL, to_number(NULL), G_PARAM.G_PARAM_get_hier_expid(o100600.hi_name))))) || '.' ||(G_PARAM.G_PARAM_get_autogen_item_name((decode(o100600.ibh_dbh_id, NULL, to_number(NULL), G_PARAM.G_PARAM_get_hier_expid(o100600.hi_name))))) || ' : ' ||(decode(o100600.ibh_dbh_id, NULL, NULL, G_PARAM.G_PARAM_get_datehier_tmplt_name(o100600.ibh_dbh_id))), o100600.hi_name)) AS i102167, decode((o100600.hi_sys_generated), 1, 'System', 'User') AS i102174, lpad('^------', 12 *((G_PARAM.G_PARAM_get_hierlvl((o100600.hi_id), (o100601.hn_id))) -1)) ||(decode(SUBSTR((o100601.hn_name), 1, 19), 'AUTO_GENERATED_NAME', ((G_PARAM.G_PARAM_get_foldername(G_PARAM.G_PARAM_get_hiernode_expid(o100601.hn_id))) || '.' ||(G_PARAM.G_PARAM_get_autogen_item_name(G_PARAM.G_PARAM_get_hiernode_expid(o100601.hn_id)))), (o100601.hn_name))) AS i102312, G_PARAM.G_PARAM_get_hierord((o100600.hi_id), (o100603.hil_hn_id)) AS i102376 FROM G_PARAM.G_PARAM_hierarchies o100600, G_PARAM.G_PARAM_hi_nodes o100601, G_PARAM.G_PARAM_ig_exp_links o100603 WHERE(o100600.hi_id = o100601.hn_hi_id) AND(o100601.hn_id = o100603.hil_hn_id)) o100631 WHERE((o100627.i102327 = o100630.i102116) AND(o100630.i102222 = o100631.i102139)) ORDER BY o100631.i102167 ASC, o100631.i102376 ASC tYsq~sq~uq~ sq~vsq~uq~tITEM_CLASS_NAMEt186sq~pppsq~@@@pppsq~pppt1q~ Ysq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~ ]xtItem Class NametDEFAULTtYpppxsq~uq~ ppppppppppxq~ Psq~vsq~uq~tPRIMARY_FOLDERt199q~ Xq~ Yq~ Zt1q~ Yq~ \tNAtNt ##########t dd-MMM-yyyyq~q~ btPrimary FoldertDEFAULTtYpppxsq~uq~ ppppppppppxq~ Psq~vsq~uq~tUSED_BYt231q~ Xq~ Yq~ Zt1q~ Yq~ \tNAtNt ##########t dd-MMM-yyyyq~q~ btUsed BytDEFAULTtYpppxsq~uq~ ppppppppppxq~ Psq~vsq~uq~tALTERNATE_SORTt176q~ Xq~ Yq~ Zt1q~ Yq~ \tNAtNt ##########t dd-MMM-yyyyq~q~ btAlternate SorttDEFAULTtYpppxsq~uq~ ppppppppppxq~ Psq~vsq~uq~tInfoCaptor Messaget450q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyytNq~t Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~ Ppppppxsq~@&sq~Bsq~(uq~(t Item Classesq~Ht100tManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~ q~!q~"q~$t dd-MMM-yyyyt #########tq92q~q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~ htAuthor,Description etcq~q~2tDEFAULTtYtYtNsq~78pq~Xsq~Ypq~ pxsq~\t Text Cursorpuq~_sq~asq~ew ?@q~ixsq~asq~ew ?@q~lxppq~nq~psq~qq~sq~tq~uppppppq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~ wtdefaultsq~sq~pxq~ wq~q~ xxxsq~ uq~ psq~ ?@wq~$sq~&ti18nsq~&ttabSizesq~+xsq~pxsq~uq~ ppppppppppxsq~1pq~ wxuq~7sq~9q~ q~ wxq~ wxpq~ sq~uq~ ppppppppppxpppxtYxt QSELECT o100632.i102368 item_class_name, o100632.i102366 || ' . ' || o100632.i102064 primary_folder, o100632.i102364 || ' . ' || o100632.i101789 used_by, nvl(o100632.i102356 || '.' || o100632.i101793, ' ') alternate_sort FROM (SELECT o100577.ba_name AS i101816, o100607.obj_id AS i102327 FROM G_PARAM.G_PARAM_bas o100577, G_PARAM.G_PARAM_objs o100607, G_PARAM.G_PARAM_ba_obj_links o100582 WHERE(o100577.ba_id = o100582.bol_ba_id) AND(o100607.obj_id = o100582.bol_obj_id) and ( o100577.ba_id = param or lower(o100577.ba_name) like lower('param') )) o100627, (SELECT o100607.obj_id AS i102116, o100592.exp_id AS i102222 FROM G_PARAM.G_PARAM_expressions o100592, G_PARAM.G_PARAM_objs o100607 WHERE(o100607.obj_id = o100592.it_obj_id)) o100630, (SELECT o100634.i101787 AS i101789, o100626.i101781 AS i101793, decode(SUBSTR((o100634.i101949), 1, 19), 'AUTO_GENERATED_NAME', 'Yes', 'No') AS i101953, o100634.i102044 AS i102046, o100633.i101785 AS i102064, o100626.i102350 AS i102356, o100634.i102360 AS i102364, o100633.i102358 AS i102366, decode(SUBSTR((o100634.i101949), 1, 19), 'AUTO_GENERATED_NAME', (o100633.i102358) || '.' ||(o100633.i101785), (o100634.i101949)) AS i102368 FROM (SELECT o100607.obj_name AS i102350, (G_PARAM.G_PARAM_get_autogen_item_name(o100592.exp_id)) AS i101781, o100589.dom_id AS i101907 FROM G_PARAM.G_PARAM_domains o100589, G_PARAM.G_PARAM_expressions o100592, G_PARAM.G_PARAM_objs o100607 WHERE(o100592.exp_id = o100589.dom_it_id_rank) AND(o100607.obj_id = o100592.it_obj_id)) o100626, (SELECT o100607.obj_name AS i102358, (G_PARAM.G_PARAM_get_autogen_item_name(o100592.exp_id)) AS i101785, o100589.dom_id AS i101909 FROM G_PARAM.G_PARAM_domains o100589, G_PARAM.G_PARAM_expressions o100592, G_PARAM.G_PARAM_objs o100607 WHERE(o100592.exp_id = o100589.dom_it_id_lov) AND(o100607.obj_id = o100592.it_obj_id)) o100633, (SELECT o100607.obj_name AS i102360, (G_PARAM.G_PARAM_get_autogen_item_name(o100592.exp_id)) AS i101787, o100589.dom_name AS i101949, o100592.exp_id AS i102044, o100589.dom_id AS i101911 FROM G_PARAM.G_PARAM_domains o100589, G_PARAM.G_PARAM_expressions o100592, G_PARAM.G_PARAM_objs o100607 WHERE(o100589.dom_id = o100592.it_dom_id) AND(o100607.obj_id = o100592.it_obj_id)) o100634 WHERE(o100626.i101907(+) = o100634.i101911) AND(o100633.i101909(+) = o100634.i101911)) o100632 WHERE((o100627.i102327 = o100630.i102116) AND(o100630.i102222 = o100632.i102046)) ORDER BY o100632.i102368 ASC, o100632.i101953 ASC, o100632.i102366 || ' . ' || o100632.i102064 ASC, nvl(o100632.i102356 || '.' || o100632.i101793, ' ') ASC, o100632.i102364 || ' . ' || o100632.i101789 ASC q~sq~sq~uq~ sq~vsq~uq~tADMINISTRATION_ALLOWEDt87sq~pppsq~@@@pppsq~pppt1q~ sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~ xtAdministration AllowedtDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~vsq~uq~tUSER_ROLE_RESPONSIBILITYt351q~ q~ q~ t1q~ q~ tNAtNt ##########t dd-MMM-yyyyq~q~ tUser Role ResponsibilitytDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~vsq~uq~tInfoCaptor Messaget450q~ q~ q~ t1q~ q~ tNAtNt ##########t dd-MMM-yyyyq~q~ tInfocaptor MessagetDEFAULTtYpppxsq~uq~ ppppppppppxq~ pppppppxsq~@T$sq~Bsq~(uq~(tSecurityq~Ht100tManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~ q~!q~"q~$t dd-MMM-yyyyt #########tq95q~q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~]tAuthor,Description etctNq~2tDEFAULTtYtYtNsq~78pq~Xsq~Ypq~ Ypxsq~\t Text Cursorpuq~_sq~asq~ew ?@q~ixsq~asq~ew ?@q~lxppq~nq~psq~qq~sq~tq~uppppppq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~q~ cq~q~ dq~q~ eq~q~ fq~q~ gq~q~ hq~q~ iq~q~ jq~q~ kq~q~ lq~q~ mq~q~ nq~q~ oq~q~ pq~q~ qq~q~ rq~q~ sq~q~ tq~q~ uq~q~ vq~q~ wq~q~ xq~q~ yq~q~ zq~q~ {q~q~ |q~q~ }q~q~ ~q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~ wtdefaultsq~sq~pxq~ wq~q~ xxxsq~ uq~ psq~ ?@wq~$sq~&ti18nsq~&ttabSizesq~+xsq~pxsq~uq~ ppppppppppxsq~1pq~ wxuq~7sq~9q~ q~ wxq~ wxpq~ sq~uq~ ppppppppppxpppxtYxtSELECT DISTINCT decode(o100572.ap_priv_level, 1, 'Yes', 'No') administration_allowed, decode(G_PARAM.G_PARAM_get_isitapps_eul, 1, decode(o100591.eu_role_flag, 1, G_PARAM.G_PARAM_get_apps_userresp(o100591.eu_username, 'R'), G_PARAM.G_PARAM_get_apps_userresp(o100591.eu_username)), o100591.eu_username) user_role_responsibility FROM G_PARAM.G_PARAM_bas o100577, G_PARAM.G_PARAM_ba_obj_links o100582, G_PARAM.G_PARAM_access_privs o100572, G_PARAM.G_PARAM_eul_users o100591 WHERE((o100577.ba_id = o100582.bol_ba_id) and ( o100577.ba_id = param or lower(o100577.ba_name) like lower('param') ) AND(o100591.eu_id(+) = o100572.ap_eu_id) AND(o100577.ba_id = o100572.gba_ba_id)) AND(o100572.gba_ba_id IS NOT NULL) q~sq~sq~uq~sq~vsq~uq~q~t450sq~pppsq~pppsq~pppt1q~ sq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxtInfocaptor MessagetDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~vsq~uq~t Business Areat166q~ q~ q~ t1q~ q~ tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxtBusiness Area tDEFAULTtYpppxsq~uq~ sq~sq~uq~ tBA_IDt Business Areat%t%ppppppxtGet Folder Detailsq~sq~sq~uq~ q~ t Business Areappppppppxt Get Filtersq~ ?sq~sq~uq~ q~ q~ ppppppppxtGet Hierarchiesq~ sq~sq~uq~ q~ q~ ppppppppxtGet Item Classesq~ sq~sq~uq~ tBA_IDq~ ppppppppxtGet Security Detailsq~ Ksq~sq~uq~ q~ q~ ppppppppxt Get Summariestq98ppppxq~ sq~vsq~uq~tKeyt145q~q~ q~t1q~ q~tNAtNt ##########t dd-MMM-yyyyq~q~tKeytDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~vsq~uq~tNumber of Times Modifiedt58q~q~ q~t1q~ q~tNAtNt ##########t dd-MMM-yyyyq~q~tNumber Of Times ModifiedtDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~vsq~uq~tCreatort38q~q~ q~t1q~ q~tNAtNt ##########t dd-MMM-yyyyq~q~tCreatortDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~vsq~uq~t Creation Datet66sq~pppq~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Creation DatetDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~vsq~uq~t Updated By t115q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Updated BytDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~vsq~uq~tLast Update Datet74q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tLast Update DatetDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~vsq~uq~tBA_IDt41q~q~q~t1q~q~.G_PARAM_bas o100577, G_PARAM.G_PARAM_ba_obj_links o100582, G_PARAM.G_PARAM_objs o100607 WHERE o100577.ba_id = o100582.bol_ba_id and o100577.ba_id = b.ba_id AND o100607.obj_id = o100582.bol_obj_id and o100607.obj_type like 'G_PARAM' /*Folder type value*/ ) G_PARAM_folder_total ,( select count(1) FROM G_PARAM.G_PARAM_expressions o100592, G_PARAM.G_PARAM_bas o100577, G_PARAM.G_PARAM_ba_obj_links o100582, G_PARAM.G_PARAM_objs o100607, G_PARAM.G_PARAM_expressions o100592_2, G_PARAM.G_PARAM_exp_deps o100593, G_PARAM.G_PARAM_objs o100607_2 WHERE((o100577.ba_id(+) = o100582.bol_ba_id) AND(o100607.obj_id = o100582.bol_obj_id) AND(o100592_2.exp_id = o100593.pd_p_id) AND(o100607_2.obj_id = o100592_2.fil_obj_id) AND(o100607.obj_id = o100607_2.obj_id) AND(o100593.ped_exp_id = o100592.exp_id)) and ( o100577.ba_id = b.ba_id ) ) filter_total , ( SELECT count (DISTINCT decode(G_PARAM.G_PARAM_get_isitapps_eul, 1, decode(o100591.eu_role_flag, 1, G_PARAM.G_PARAM_get_apps_userresp(o100591.eu_username, 'R'), G_PARAM.G_PARAM_get_apps_userresp(o100591.eu_username)), o100591.eu_username) ) FROM G_PARAM.G_PARAM_bas o100577, G_PARAM.G_PARAM_ba_obj_links o100582, G_PARAM.G_PARAM_access_privs o100572, G_PARAM.G_PARAM_eul_users o100591 WHERE((o100577.ba_id = o100582.bol_ba_id) and ( o100577.ba_id = b.ba_id ) AND(o100591.eu_id(+) = o100572.ap_eu_id) AND(o100577.ba_id = o100572.gba_ba_id)) AND(o100572.gba_ba_id IS NOT NULL) ) Access_Granted_total , ( select count (distinct o100588.doc_id) FROM G_PARAM.G_PARAM_bas o100577, G_PARAM.G_PARAM_ba_obj_links o100582, G_PARAM.G_PARAM_objs o100607, G_PARAM.G_PARAM_documents o100588, G_PARAM.G_PARAM_elem_xrefs o100590 WHERE 1=1 and to_number(o100590.ex_from_id) = o100588.doc_id AND(o100588.doc_content_type = 'application/vnd.oracle-disco.wb') and o100577.ba_id = o100582.bol_ba_id and o100607.obj_id = o100582.bol_obj_id and o100577.ba_id = b.ba_id and o100590.ex_to_par_devkey = o100607.obj_developer_key ) work_book_total --, decode(G_PARAM.G_PARAM_get_isitapps_eul, 1, G_PARAM.G_PARAM_get_apps_userresp(ba_created_by), ba_created_by) created_by --,ba_created_date "Creation Date" --, decode(G_PARAM.G_PARAM_get_isitapps_eul, 1, G_PARAM.G_PARAM_get_apps_userresp(ba_updated_by), ba_updated_by) Updated_By --,ba_updated_date "Last Update Date" --,notm "Number of Times Modified" ,ba_id from G_PARAM.G_PARAM_bas b where ba_created_by like 'G_PARAM' /*'ID1'*/ and lower(ba_name) like lower('G_PARAM') tNsq~sq~uq~ sq~vsq~uq~t TABLE_COLUMNt115sq~pppsq~@@@pppsq~pppt1q~^sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~bxt Table ColumntDEFAULTtYpppxsq~uq~ ppppppppppxq~Usq~vsq~uq~tSUMMARY_SET_NAMEt142q~]q~^q~_t1q~^q~atNAtNt ##########t dd-MMM-yyyyq~q~gtSummary Set NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Usq~vsq~uq~tOWNERt48q~]q~^q~_t1q~^q~atNAtNt ##########t dd-MMM-yyyyq~q~gtOwnertDEFAULTtYpppxsq~uq~ ppppppppppxq~Usq~vsq~uq~t TABLE_NAMEt139q~]q~^q~_t1q~^q~atNAtNt ##########t dd-MMM-yyyyq~q~gt Table NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Usq~vsq~uq~t FOLDER_NAMEt107q~]q~^q~_t1q~^q~atNAtNt ##########t dd-MMM-yyyyq~q~gt Folder NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Usq~vsq~uq~tMAP_TOt75q~]q~^q~_t1q~^q~atNAtNt ##########t dd-MMM-yyyyq~q~gtMap TotDEFAULTtYpppxsq~uq~ ppppppppppxq~Usq~vsq~uq~t ITEM_NAMEt93q~]q~^q~_t1q~^q~atNAtNt ##########t dd-MMM-yyyyq~q~gt Item NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Usq~vsq~uq~q~ 3t450q~]q~^q~_t1q~^q~atNAtNt ##########t dd-MMM-yyyyq~q~gtInfocaptor MessagetDEFAULTtYpppxsq~uq~ ppppppppppxq~Uppxsq~@ $sq~B sq~(uq~(t Summariesq~Ht100tManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~ q~!q~"q~$t dd-MMM-yyyyt #########q~ q~q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~]tAuthor,Description etcq~ Tq~2tDEFAULTtYtYtNsq~78pq~Xsq~Ypq~pxsq~\t Text Cursorpuq~_sq~asq~ew ?@q~ixsq~asq~ew ?@q~lxppq~nq~psq~qq~sq~tq~uppppppq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~ q~q~ q~q~ q~q~ q~q~ q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~ wtdefaultsq~sq~pxq~ wq~q~#xxxsq~ uq~ psq~ ?@wq~$sq~&ti18nsq~&ttabSizesq~+xsq~pxsq~uq~ ppppppppppxsq~1pq~wxuq~7sq~9q~1q~wxq~wxpq~sq~uq~ ppppppppppxpppxtYxt SELECT o100639.i102553 summary_set_name, o100639.i102555 owner, o100639.i102492 table_name, o100639.i102464 table_column, 'Maps To ===>' map_to, o100627.i101816 folder_name, decode(o100595.fun_name, NULL, 'Axis Item', initcap(o100595.fun_name)) aggregation, o100639.i101791 item_name FROM G_PARAM.G_PARAM_functions o100595, (SELECT o100577.ba_name AS i101816, o100607.obj_id AS i102327 FROM G_PARAM.G_PARAM_bas o100577, G_PARAM.G_PARAM_objs o100607, G_PARAM.G_PARAM_ba_obj_links o100582 WHERE(o100577.ba_id = o100582.bol_ba_id) AND(o100607.obj_id = o100582.bol_obj_id) and ( o100577.ba_id = param or lower(o100577.ba_name) like lower('param'))) o100627, (SELECT(G_PARAM.G_PARAM_get_autogen_item_name(o100592.exp_id)) AS i101791, o100607.obj_id AS i102348, o100607.obj_name AS i102362, o100620.seu_ext_column AS i102464, o100620.smiu_fun_id AS i102468, o100629.i102488 AS i102492, decode(o100629.i102498, 1, decode(o100629.i102502, 3, 'Yes', 6, 'Yes', 'No'), 'No') AS i102507, o100618_2.sdo_table_name AS i102553, o100618_2.sdo_table_owner AS i102555 FROM G_PARAM.G_PARAM_expressions o100592, G_PARAM.G_PARAM_objs o100607, G_PARAM.G_PARAM_sumo_exp_usgs o100620, G_PARAM.G_PARAM_summary_objs o100618, (SELECT o100622.srs_name AS i102488, o100622.srs_online AS i102498, o100622.srs_state AS i102502, o100618_2.sumo_id AS i102534 FROM G_PARAM.G_PARAM_summary_objs o100618_2, G_PARAM.G_PARAM_sum_rfsh_sets o100622 WHERE(o100622.srs_id = o100618_2.sbo_srs_id)) o100629, G_PARAM.G_PARAM_summary_objs o100618_2 WHERE(o100629.i102534(+) = o100618_2.sdo_sbo_id) AND(o100592.exp_id = o100620.siu_exp_id) AND(o100607.obj_id = o100592.it_obj_id) AND(o100618_2.sumo_id = o100618.sumo_id) AND(o100618.sumo_id = o100620.seu_sumo_id)) o100639 WHERE((o100627.i102327 = o100639.i102348) AND(o100639.i102468 = o100595.fun_id(+))) AND(o100639.i102492 IS NOT NULL) ORDER BY o100639.i102555 ASC, o100639.i102553 ASC, o100639.i102362 ASC, decode(o100595.fun_name, NULL, 'Axis Item', initcap(o100595.fun_name)) ASC q~sq~sq~uq~ sq~vsq~uq~tEX_TO_IDt30sq~pppsq~@@@pppsq~pppt1q~Asq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~dsq~A pq~ExtEx To IdtDEFAULTtYpppxsq~uq~ ppppppppppxq~8sq~vsq~uq~t EX_TO_TYPEt48q~@q~Aq~Bt1q~Aq~DtNAtNt ##########t dd-MMM-yyyyq~dq~Jt Ex To TypetDEFAULTtYpppxsq~uq~ ppppppppppxq~8sq~vsq~uq~t EX_TO_NAMEt163q~@q~Aq~Bt1q~Aq~DtNAtNt ##########t dd-MMM-yyyyq~dq~Jt Ex To NametDEFAULTtYpppxsq~uq~ ppppppppppxq~8sq~vsq~uq~tEX_TO_PAR_NAMEt138q~@q~Aq~Bt1q~Aq~DtNAtNt ##########t dd-MMM-yyyyq~dq~Jt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~8sq~vsq~uq~tEX_TO_PAR_DEVKEYt192q~@q~Aq~Bt1q~Aq~DtNAtNt ##########t dd-MMM-yyyyq~dq~Jt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~8pppppxsq~@sq~B@sq~(uq~(t Table Dataq~Ht100tManualt300t 1-JAN-1990tYq~q~q~q~q~q~q~q~ q~!q~"q~$t dd-MMM-yyyyt #########tq221q~q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt30:30tAuthor,Description etcq~Bt1tDEFAULTq~q~tNsq~78pq~Xsq~Ypq~pxsq~\t Text Cursorpuq~_sq~asq~ew ?@q~ixsq~asq~ew ?@q~lxppq~nq~psq~qq~sq~tq~uppppppq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~wtdefaultsq~sq~pxq~wq~q~xxxsq~ uq~ psq~ ?@wq~$sq~&ttabSizesq~+ti18nsq~&xsq~pxsq~uq~ ppppppppppxsq~1pq~wxuq~7sq~9q~q~wxq~wxpq~sq~uq~ ppppppppppxpppxq~xt7SELECT * from G_PARAM.param
q~sq~sq~uq~ sq~vsq~uq~tOWNERt159sq~pppsq~@@@pppsq~pppt1q~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~Bsq~A pq~xt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~t TABLE_NAMEt253q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~Bq~t Table NametDEFAULTtYpppxsq~uq~ sq~sq~uq~ q~pppppppppxt Get Dataq~pppppppppxq~ppppppppxsq~@xsq~B,sq~(uq~(t Meta Tablesq~HtALLtManualt300t 1-JAN-1990tYq~q~q~q~q~q~q~q~ q~!q~"q~$t dd-MMM-yyyyt #########tq218q~q~(q~Btappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~tAuthor,Description etcq~Bt218tDEFAULTq~q~tNsq~78pq~Xsq~Ypq~&pxsq~\t Text Cursorpuq~_sq~asq~ew ?@q~ixsq~asq~ew ?@q~lxppq~nq~psq~qq~sq~tq~uppppppq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~q~0q~q~1q~q~2q~q~3q~q~4q~q~5q~q~6q~q~7q~q~8q~q~9q~q~:q~q~;q~q~q~q~?q~q~@q~q~Aq~q~Bq~q~Cq~q~Dq~q~Eq~q~Fpsq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~Nwtdefaultsq~sq~pxq~Nwq~q~Qxxxsq~ uq~ psq~ ?@wq~$sq~&ttabSizesq~+ti18nsq~&xsq~pxsq~uq~ ppppppppppxsq~1pq~Mwxuq~7sq~9q~_q~Mwxq~Mwxpq~Msq~uq~ ppppppppppxpppxq~xtSELECT table_name from all_tables where table_name like 'EUL5%' and owner = 'G_PARAM' /*distinctowner*/ q~Tsq~sq~uq~ sq~vsq~uq~q~t450sq~pppsq~@@@pppsq~pppt1q~msq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~qxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~esq~vsq~uq~t PRIVLEGESt75sq~޸pppq~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t PrivlegestDEFAULTtYpppxsq~uq~ ppppppppppxq~eppppppppxsq~@%sq~Bsq~(uq~(t Privilegesq~Ht100tManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~ q~!q~"q~$t dd-MMM-yyyyt #########tq96q~q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etcq~Bq~2tDEFAULTtYtYtNsq~78pq~Xsq~Ypq~pxsq~\t Text Cursorpuq~_sq~asq~ew ?@q~ixsq~asq~ew ?@q~lxppq~nq~psq~qq~sq~tq~uppppppq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~wtdefaultsq~sq~pxq~wq~q~xxxsq~ uq~ psq~ ?@wq~$sq~&ti18nsq~&ttabSizesq~+xsq~pxsq~uq~ ppppppppppxsq~1pq~wxuq~7sq~9q~q~wxq~wxpq~sq~uq~ ppppppppppxpppxtYxt SELECT decode(G_PARAM.G_PARAM_get_isitapps_eul, 1, decode(o100591.eu_role_flag, 1, G_PARAM.G_PARAM_get_apps_userresp(o100591.eu_username, 'R'), G_PARAM.G_PARAM_get_apps_userresp(o100591.eu_username)), o100591.eu_username) user_role_responsibility ,decode(o100573.app_name_mn, 2300, 'User Edition', 2301, ' Create/Edit Query', 2302, ' Item Drill', 2303, ' Drill Out', 2304, ' Grant Workbook', 2305, ' Collect Query Statistics', 2306, 'Administration', 2307, ' Set Privilege', 2308, ' Create/Edit Business Area', 2309, ' Format Business Area', 2310, ' Create Summaries', 2311, ' Query Statistics Minimum Cost', 2312, ' Schedule Workbooks', 2313, 'Scheduled Workbooks Tab' || CHR(10) || ' Run Queries Online', 2314, ' Save Workbooks to Database', 2315, ' Manage Scheduled Workbooks', 2318, ' Change Password', 2317, ' Create Link', NULL, NULL, 'Unknown Privlege') privleges , decode(o100573.app_description_mn, 2400, 'Ability to use Oracle Discoverer User Edition', 2401, 'Ability to create new worksheets or edit existing ones. Without this option, a user only has the ability to run predefined worksheets', 2402, 'Ability to use item drills, drill to related items and drill from summary to detail items (hyperdrill) within Oracle Discoverer User Edition', 2403, 'Ability to drill out to launch other applications from Oracle Discoverer User Edition', 2404, 'Ability to grant access to workbooks to other users', 2405, 'Determines if running queries in Oracle Discoverer will then collect performance statistics', 2406, 'Ability to use Oracle Discoverer Administration Edition', 2407, 'Ability to grant and revoke End User Layer (TM) privileges', 2408, 'Ability to create new business areas and edit existing ones', 2409, 'Ability to edit only the formatting information in an existing business area', 2410, 'Ability to create summary tables', 2411, 'The minimum cost of query statistics to be recorded', 2412, 'Ability to Create and Edit Shedule Workbooks', 2413, 'Scheduling Repository must be enabled to run queries offline.' || CHR(10) || 'Ability to always run queries online. Without this option, the user can only schedule the workbook.', 2414, 'Ability to save workbooks to the database', 2415, 'Ability to maintain the scheduled workbooks of end-users', 2418, 'Ability to change password on current connection', 2417, 'Ability to create links in workbooks', NULL, NULL, 'Unknown Privlege') privilege_description FROM G_PARAM.G_PARAM_access_privs o100572, G_PARAM.G_PARAM_app_params o100573, G_PARAM.G_PARAM_eul_users o100591 WHERE((o100573.app_id = o100572.gp_app_id) AND(o100591.eu_id(+) = o100572.ap_eu_id)) AND(o100573.app_id <> 1018) AND(o100572.gba_ba_id IS NULL) ORDER BY 1, decode(o100573.app_name_mn, 2306, 1, 2309, 2, 2308, 3, 2310, 4, 2307, 5, 2315, 6, 2300, 7, 2301, 8, 2305, 9, 2302, 10, 2303, 11, 2304, 12, 2312, 13, 2314, 14, 2318, 15, 2313, 17, 2317, 16, 99) ASC q~ Tsq~sq~uq~ sq~vsq~uq~t>THEVERSIONOFTHEEULYOUARECURRENTLYUSINGIS-||O100624.VER_RELEASEt422sq~pppsq~@@@pppsq~pppt1q~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~xt>Theversionoftheeulyouarecurrentlyusingis-||o100624.ver ReleasetDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tVersiont364q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tVersiontDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tInfoCaptor Messaget450q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~pppppppxsq~@sq~BRdsq~(uq~(tVersionq~Ht100tManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~ q~!q~"q~$t dd-MMM-yyyyt #########tq47q~q~(q~Vtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etctNt2tDEFAULTtYtYtNsq~78pq~Xsq~Ypq~Bpxsq~\t Text Cursorpuq~_sq~asq~ew ?@q~ixsq~asq~ew ?@q~lxppq~nq~psq~qq~sq~tq~uppppppq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~q~Lq~q~Mq~q~Nq~q~Oq~q~Pq~q~Qq~q~Rq~q~Sq~q~Tq~q~Uq~q~Vq~q~Wq~q~Xq~q~Yq~q~Zq~q~[q~q~\q~q~]q~q~^q~q~_q~q~`q~q~aq~q~bq~q~cq~q~dq~q~eq~q~fq~q~gq~q~hq~q~iq~q~jq~q~kq~q~lq~q~mpsq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~uwtdefaultsq~sq~pxq~uwq~q~xxxxsq~ uq~ psq~ ?@wq~$sq~&ti18nsq~&ttabSizesq~+xsq~pxsq~uq~ ppppppppppxsq~1pq~twxuq~7sq~9q~q~twxq~twxpq~tsq~uq~ ppppppppppxpppxtYxthSELECT O100624.VER_RELEASE "Version" FROM G_PARAM.G_PARAM_VERSIONS O100624 q~ sq~sq~uq~sq~vsq~uq~q~t450sq~pppsq~@@@pppsq~pppt1q~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~xtInfocaptor MessagetDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~t WORKBOOK_NAMEt180q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Workbook NametDEFAULTtYpppxsq~uq~ sq~sq~uq~ tDOC_IDt WORKBOOK_NAMEppppppppxtGet Workbook Dependenciesq~sq~sq~uq~ tDOC_IDq~ppppppppxtGet sharing Detailsq~Uppppppppxq~sq~vsq~uq~t CREATED_BYt55q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Created BytDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~t WORKBOOK_SIZEt51q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~t CREATION_DATEt67q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Creation DatetDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~t SHARED_WITHt131q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Shared WithtDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tsize[KB]t26q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~t size [KB]t42q~oq~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~dq~t Size [kb]tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tDOC_DEVELOPER_KEYt75q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tDoc Developer KeytDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tDAYS_OLDt42sq~pppq~q~t1q~q~tNAtNt ##########t dd-MMM-yyyytNq~(tDays OldtDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~t ITEM_TOTALt49sq~pppq~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~dq~(t Item TotaltDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~t JOIN_TOTALt44sq~pppq~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~dq~(t Join TotaltDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tCONDITION_TOTALt53q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~dq~(t Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tSHARED_TO_TOTALt55sq~ópppq~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~dq~(tShared To TotaltDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tDAYS_SINCE_LAST_RUNt38q~,q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~2q~(tDays Since Last RuntRIGHTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~t LAST_RUN_DATEt70q~,q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~2q~(t Last Run Dateq~tYpppxsq~uq~ ppppppppppxq~ppppxsq~@8sq~Bsq~(uq~(tWorkbook Detailsq~Ht300tManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~ q~!q~"q~$t dd-MMM-yyyyt #########tq102q~q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etctYt30tDEFAULTtYtYtNsq~78pq~Xsq~Ypq~pxsq~\t Text Cursorpuq~_sq~asq~ew ?@q~ixsq~asq~ew ?@q~lxppq~nq~psq~qq~sq~tq~uppppppq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~wtdefaultsq~sq~pxq~wq~q~xxxsq~ uq~ psq~ ?@wq~$sq~&ti18nsq~&ttabSizesq~+xsq~pxsq~uq~ ppppppppppxsq~1pq~wxuq~7sq~9q~q~wxq~wxpq~sq~uq~ ppppppppppxpppxtYxt_SELECT o100588.doc_name workbook_name, -- decode(G_PARAM.G_PARAM_get_isitapps_eul, 1, G_PARAM.G_PARAM_get_apps_userresp(o100588.doc_created_by), o100588.doc_created_by) created_by, o100588.doc_length / 1024 "size [KB]", trunc(sysdate-o100588.doc_created_date) days_old, trunc(sysdate - wb_stats.last_run_date) days_since_last_run, to_char(wb_stats.last_run_date,'dd-Mon-yyyy') last_run_date, sum(decode(o100590.ex_to_type, 'ITE', 1,0 ) )Item_total , sum(decode(o100590.ex_to_type, 'JOI', 1,0)) join_total, ( SELECT count(1) FROM G_PARAM.G_PARAM_access_privs o100572 WHERE o100572.gd_doc_id = o100588.doc_id ) shared_to_total, o100588.doc_developer_key, o100588.doc_id FROM G_PARAM.G_PARAM_access_privs o100572, G_PARAM.G_PARAM_documents o100588, G_PARAM.G_PARAM_eul_users o100591, G_PARAM.G_PARAM_elem_xrefs o100590, ( select qs_doc_name,max(qs_created_date) last_run_date from G_PARAM.G_PARAM_qpp_stats group by qs_doc_name ) wb_stats WHERE((o100588.doc_id = o100572.gd_doc_id(+)) AND(o100591.eu_id(+) = o100572.ap_eu_id)) and lower(o100588.doc_name) like lower('G_PARAM') AND(o100588.doc_content_type = 'application/vnd.oracle-disco.wb') and to_number(o100590.ex_from_id) = o100588.doc_id and o100588.doc_name = wb_stats.qs_doc_name(+) and decode(G_PARAM.G_PARAM_get_isitapps_eul, 1, G_PARAM.G_PARAM_get_apps_userresp(o100588.doc_created_by), o100588.doc_created_by) like 'G_PARAM' /*'ID1'*/ group by o100588.doc_name, -- decode(G_PARAM.G_PARAM_get_isitapps_eul, 1, G_PARAM.G_PARAM_get_apps_userresp(o100588.doc_created_by), o100588.doc_created_by) created_by, o100588.doc_length, o100588.doc_created_date, o100588.doc_developer_key, o100588.doc_id, wb_stats.last_run_date ORDER BY o100588.doc_name ASC, o100588.doc_created_date ASC tNsq~sq~uq~ sq~vsq~uq~t REPORT_NAMEt155sq~pppsq~@@@pppsq~pppt1q~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyytYsq~A pq~ xt Report NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~t WORK_SHEETt181q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Work SheettDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tTABLE_VIEW_USEDt75q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tJOINSt313q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tTABLE_JOIN_USEDt302q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~t ITEMS_USEDt86q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Items UsedtDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~t FOLDERS_USEDt98q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Folders UsedtDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tWORKSHEET_JOINSt192q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tWorksheet JoinstDEFAULTtYpppxsq~uq~ ppppppppppxq~ppxsq~@sq~Bsq~(uq~(tWorkbook Summaryq~Ht100tManualt300t 1-JAN-1990tYq~q~q~q~q~q~q~q~q~!q~"q~$t dd-MMM-yyyyt #########tq393q~q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etctNt49tDEFAULTq~tNq~sq~78pq~Xsq~Ypq~pxsq~\t Text Cursorpuq~_sq~asq~ew ?@q~ixsq~asq~ew ?@q~lxppq~nq~psq~qq~sq~tq~uppppppq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~wtdefaultsq~sq~pxq~wq~q~xxxsq~ uq~ psq~ ?@wq~$sq~&ti18nsq~&ttabSizesq~+xsq~pxsq~uq~ ppppppppppxsq~1pq~wxuq~7sq~9q~q~wxq~wxpq~sq~uq~ ppppppppppxpppxq~xtmSELECT DISTINCT QS_DOC_NAME Report_Name, QS_DOC_DETAILS Work_Sheet, (G_PARAM.G_PARAM_GET_OBJECT_NAME(SUBSTR(QS_OBJECT_USE_KEY,1, DECODE(INSTR(QS_OBJECT_USE_KEY,'S',1,1),0, LENGTH(QS_OBJECT_USE_KEY), INSTR(QS_OBJECT_USE_KEY,'S',1,1)-2)),'F')) Folders_Used, (G_PARAM.G_PARAM_GET_OBJECT_NAME(G_PARAM.G_PARAM_GET_ITEM_NAME(QS_ID),'I')) Items_Used, (G_PARAM.G_PARAM_GET_OBJECT_NAME(G_PARAM.G_PARAM_GET_FORJ_ITEMID(QS_ID),'I')) Items_Used_in_condition, (G_PARAM.G_PARAM_GET_OBJECT_NAME((G_PARAM.G_PARAM_GET_FORJ_ITEMID(QS_ID,'JOIN')),'J')) worksheet_Joins from ( select qs_doc_name, qs_doc_details, max(qs_id) qs_id, qs_object_use_key FROM G_PARAM.G_PARAM_QPP_STATS where lower(QS_DOC_NAME) like lower( 'G_PARAM' ) group by qs_doc_name, qs_doc_details, qs_object_use_key ) ORDER BY QS_DOC_NAME ASC q~sq~sq~uq~ sq~vsq~uq~tXXLS_APPS_EUL_USt122sq~pppsq~@@@pppsq~pppt1q~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~xt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tInfoCaptor Messaget450q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tInfocaptor MessagetDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tNOt30q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tNotDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~t PARAMETERt145q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t ParametertDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tVALUEt287q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tValuetDEFAULTtYpppxsq~uq~ ppppppppppxq~pppppxsq~@\rsq~Bsq~(uq~(t Parametersq~Ht100tManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~ q~!q~"q~$t dd-MMM-yyyyt #########tq147q~q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~tAuthor,Description etcq~' Value from dual union select 3, 'EUL Prefix', 'G_PARAM' /*distinctsubstr(table_name,1,4)*/ from dual union select 4, 'Workbook Creator', 'G_PARAM' /*distinctcreated_by*/ from dual union select 5, 'BA Creator', 'G_PARAM' /*distinctba_created_by*/ from dual union select 1,'Date/Time', 'Report generated on '||to_char(sysdate,'dd-MON-yyyy hh:mi:ss') from dual ) order by noq~sq~sq~uq~ sq~vsq~uq~tDEPENDENCY_NAMEt103sq~pppsq~@@@pppsq~pppt1q~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyytNsq~A pq~xtDependency NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~t WORKBOOK_NAMEt170q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Workbook NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tDEPENDENCY_KEYt93q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tDependency KeytDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tDEPENDENCY_TYPEt39q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tDependency TypetDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tFOLDERt210q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tFoldertDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~tInfoCaptor Messaget642q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyytNq~tInfocaptor MessagetDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~vsq~uq~t FOLDER_KEYt185q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Folder KeytDEFAULTtYpppxsq~uq~ ppppppppppxq~pppxsq~@ sq~Bsq~(uq~(tFind Columns in Workbookq~Ht100tManualt300t 1-JAN-1990tYq~q~q~q~q~q~q~q~ q~!q~"q~$t dd-MMM-yyyyt #########tq193q~q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~tAuthor,Description etcq~Bt1tDEFAULTq~q~tNsq~78pq~Xsq~Ypq~ pxsq~\t Text Cursorpuq~_sq~asq~ew ?@q~ixsq~asq~ew ?@q~lxppq~nq~psq~qq~sq~tq~uppppppq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~ q~q~!q~q~"q~q~#q~q~$q~q~%q~q~&q~q~'q~q~(q~q~)q~q~*q~q~+q~q~,q~q~-q~q~.q~q~/q~q~0q~q~1q~q~2q~q~3q~q~4q~q~5q~q~6psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~>wtdefaultsq~sq~pxq~>wq~q~Axxxsq~ uq~ psq~ ?@wq~$sq~&ti18nsq~&ttabSizesq~+xsq~pxsq~uq~ ppppppppppxsq~1pq~=wxuq~7sq~9q~Oq~=wxq~=wxpq~=sq~uq~ ppppppppppxpppxtYxtselect * from ( SELECT o100588.doc_name workbook_name, o100588.doc_developer_key workbook_key, decode(o100590.ex_to_type, 'ITE', 'Item', 'JOI', 'Join', 'FIL', 'Condition', o100590.ex_to_type) dependency_type, o100590.ex_to_par_name folder, (decode(SUBSTR(o100590.ex_to_name, 1, 19), 'AUTO_GENERATED_NAME', (decode(o100590.ex_to_type, 'JOI', (decode((decode(o100590.ex_to_type, 'JOI', G_PARAM.G_PARAM_get_join_expid(o100590.ex_to_id, o100590.ex_to_devkey), to_number(NULL))), NULL, NULL, G_PARAM.G_PARAM_get_join((decode(o100590.ex_to_type, 'JOI', G_PARAM.G_PARAM_get_join_expid(o100590.ex_to_id, o100590.ex_to_devkey), to_number(NULL)))))), 'ITE', (decode((decode(o100590.ex_to_type, 'ITE', o100590.ex_to_id, to_number(NULL))), NULL, NULL, G_PARAM.G_PARAM_get_autogen_item_name((decode(o100590.ex_to_type, 'ITE', o100590.ex_to_id, to_number(NULL)))))), 'FIL', (decode((decode(o100590.ex_to_type, 'FIL', o100590.ex_to_id, to_number(NULL))), NULL, NULL, o100590.ex_to_name)), NULL)), o100590.ex_to_name)) Dependency_name , o100590.ex_to_par_devkey folder_key, o100590.ex_to_devkey Dependency_key FROM G_PARAM.G_PARAM_documents o100588, G_PARAM.G_PARAM_elem_xrefs o100590 WHERE(((to_number(o100590.ex_from_id)) = o100588.doc_id)) AND(o100588.doc_content_type = 'application/vnd.oracle-disco.wb') and o100590.ex_to_type = 'ITE' ) where upper(workbook_name) like upper('param') and upper(dependency_name) like upper('param') ORDER BY workbook_name, folder,dependency_name tYsq~sq~uq~ sq~vsq~uq~t WORKBOOK_NAMEt256sq~pppsq~@@@pppsq~pppt1q~`sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~dxt Workbook NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Wsq~vsq~uq~t TABLE_VIEWt221q~_q~`q~at1q~`q~ctNAtNt ##########t dd-MMM-yyyyq~q~it Table ViewtDEFAULTtYpppxsq~uq~ ppppppppppxq~Wsq~vsq~uq~tFOLDERt200q~_q~`q~at1q~`q~ctNAtNt ##########t dd-MMM-yyyyq~q~itFoldertDEFAULTtYpppxsq~uq~ ppppppppppxq~Wpppppppxsq~@sq~B8sq~(uq~(tWorkbooks by Table/Viewq~Ht100tManualt300t 1-JAN-1990tYq~q~q~q~q~q~q~q~ q~!q~"q~$t dd-MMM-yyyyt #########tq381q~q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~tAuthor,Description etctNt1tDEFAULTq~q~q~sq~78pq~Xsq~Ypq~pxsq~\t Text Cursorpuq~_sq~asq~ew ?@q~ixsq~asq~ew ?@q~lxppq~nq~psq~qq~sq~tq~uppppppq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~vsq~wq~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~wtdefaultsq~sq~pxq~wq~q~xxxsq~ uq~ psq~ ?@wq~$sq~&ti18nsq~&ttabSizesq~+xsq~pxsq~uq~ ppppppppppxsq~1pq~wxuq~7sq~9q~q~wxq~wxpq~sq~uq~ ppppppppppxpppxq~xtdselect distinct workbook_name,table_view,folder from ( SELECT o100588.doc_name workbook_name, -- o100588.doc_developer_key workbook_key, decode(o100590.ex_to_type, 'ITE', 'Item', 'JOI', 'Join', 'FIL', 'Condition', o100590.ex_to_type) dependency_type, o100590.ex_to_par_name folder, (decode(SUBSTR(o100590.ex_to_name, 1, 19), 'AUTO_GENERATED_NAME', (decode(o100590.ex_to_type, 'JOI', (decode((decode(o100590.ex_to_type, 'JOI', G_PARAM.G_PARAM_get_join_expid(o100590.ex_to_id, o100590.ex_to_devkey), to_number(NULL))), NULL, NULL, G_PARAM.G_PARAM_get_join((decode(o100590.ex_to_type, 'JOI', G_PARAM.G_PARAM_get_join_expid(o100590.ex_to_id, o100590.ex_to_devkey), to_number(NULL)))))), 'ITE', (decode((decode(o100590.ex_to_type, 'ITE', o100590.ex_to_id, to_number(NULL))), NULL, NULL, G_PARAM.G_PARAM_get_autogen_item_name((decode(o100590.ex_to_type, 'ITE', o100590.ex_to_id, to_number(NULL)))))), 'FIL', (decode((decode(o100590.ex_to_type, 'FIL', o100590.ex_to_id, to_number(NULL))), NULL, NULL, o100590.ex_to_name)), NULL)), o100590.ex_to_name)) Dependency_name , o100590.ex_to_par_devkey folder_key, ( select sobj_ext_table from G_PARAM.G_PARAM_OBJS where obj_developer_key=o100590.ex_to_par_devkey ) Table_View , o100590.ex_to_devkey Dependency_key FROM G_PARAM.G_PARAM_documents o100588, G_PARAM.G_PARAM_elem_xrefs o100590 WHERE(((to_number(o100590.ex_from_id)) = o100588.doc_id)) AND(o100588.doc_content_type = 'application/vnd.oracle-disco.wb') and ( lower(o100588.doc_name) like lower('param') ) ) where lower(table_view) like lower('param
') order by 1,2,3q~Vppppppppx