srjava.util.Vectorٗ}[;IcapacityIncrementI elementCount[ elementDatat[Ljava/lang/Object;xpur[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~(tSysAdminsrdbUtil.dbInstance ඳcLdbDriverq~ L dbPasswordq~ LdbURLq~ LdbUserq~ xptoracle.jdbc.driver.OracleDriverptora-prod.cisco.com:1523:prj1tappst100tManualt1440t 1-JAN-1990tYsrjava.awt.Color3uFfalphaIvalueLcstLjava/awt/color/ColorSpace;[ frgbvaluet[F[fvalueq~xp̙pppsq~pppsq~pppt1sr java.awt.Fontš5VsIfontSerializedDataVersionF pointSizeIsizeIstyleLfRequestedAttributestLjava/util/Hashtable;Lnameq~ xpA@ ptArialxsq~pppt18q~sq~۽pppsq~A@ ptArialxsq~ffpppt dd-MMM-yyyyt #########tq0q~#sq~A@ pq~"xq~tappst No_PatterntVLETsq~pppq~#t XXSYSADMINsrInfoPurple.DashboardSettings ඳc۬I currPletIdxI currQletIdxxp#CtAuthor,Description etctNt1tDEFAULTtYtNtNsrjavax.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~@LdisabledTextColorq~=Leditort!Ljavax/swing/text/JTextComponent;LlatestCommittedTextEndq~@LlatestCommittedTextStartq~@LmargintLjava/awt/Insets;LmodeltLjavax/swing/text/Document;LnavigationFiltert#Ljavax/swing/text/NavigationFilter;LselectedTextColorq~=LselectionColorq~=xrjavax.swing.JComponentmFB*75!ZaaTextF alignmentXF alignmentYZ autoscrollsIflagsZisAlignmentXSetZisAlignmentYSetZverifyInputWhenFocusTargetLaccessibleContextt'Ljavax/accessibility/AccessibleContext;L actionMaptLjavax/swing/ActionMap;LancestorInputMaptLjavax/swing/InputMap;LbordertLjavax/swing/border/Border;L focusInputMapq~HL inputVerifiertLjavax/swing/InputVerifier;L listenerListt%Ljavax/swing/event/EventListenerList;L popupMenutLjavax/swing/JPopupMenu;LvetoableChangeSupportt"Ljava/beans/VetoableChangeSupport;LwindowInputMaptLjavax/swing/ComponentInputMap;xrjava.awt.Container@s 'IcontainerSerializedDataVersionZfocusCycleRootZfocusTraversalPolicyProviderI ncomponents[ componentt[Ljava/awt/Component;L dispatchert Ljava/awt/LightweightDispatcher;L layoutMgrtLjava/awt/LayoutManager;LmaxSizeq~xrjava.awt.ComponentY<#IboundsOpIcomponentSerializedDataVersionZenabledJ eventMaskZfocusTraversalKeysEnabledZ focusableIheightZ ignoreRepaintIisFocusTraversableOverriddenZisPackedZ maxSizeSetZ minSizeSetZnameExplicitlySetZ newEventsOnlyZ prefSizeSetZvalidZvisibleIwidthIxIyLaccessibleContextq~FL backgroundq~=L changeSupportt"Ljava/beans/PropertyChangeSupport;LcursortLjava/awt/Cursor;L dropTargettLjava/awt/dnd/DropTarget;[focusTraversalKeyst[Ljava/util/Set;LfonttLjava/awt/Font;L foregroundq~=LlocaletLjava/util/Locale;LmaxSizeq~LminSizeq~Lnameq~ LpeerFontq~XLpopupsq~LprefSizeq~xp8psr javax.swing.plaf.ColorUIResourcekSxq~pppsr java.beans.PropertyChangeSupportXdWH`I*propertyChangeSupportSerializedDataVersionLchildrenq~ LsourcetLjava/lang/Object;xppq~Zpxsrjava.awt.CursorojwItypeLnameq~ xpt Text Cursorpur[Ljava.util.Set;>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~esq~iw ?@sq~k xppsrjavax.swing.plaf.FontUIResourceBć"Gxq~A0 ptTahomaxsq~[pppsrjava.util.Locale~`0IhashcodeLcountryq~ Llanguageq~ Lvariantq~ xptUStentpppppptfocusLsr1javax.swing.text.JTextComponent$MutableCaretEventGY|IdotZ dragActiveImarkxrjavax.swing.event.CaretEvent [rVPxrjava.util.EventObjectL Nm}xpq~zsq~{tmouseLq~~q~q~psrjava.awt.ComponentOrientationEcI orientationxpppxur[Ljava.awt.Component; uxppppppxA(psrjavax.swing.ActionMapzLparentq~Gxppwxppsrjavax.swing.InputMapf!ٟLparentq~Hxpsr#javax.swing.plaf.InputMapUIResourceHMכxq~sq~pw7sq~k&At selection-upsq~k'tcaret-next-wordsq~k%tselection-previous-wordsq~kAq~sq~k(t caret-downsq~kTtprevious-link-actionsq~k%tcaret-previous-wordsq~ktcut-to-clipboardsq~k#tcaret-end-linesq~k!Atselection-page-upsq~ktcaret-upsq~kt delete-nextsq~k$t caret-beginsq~k%Atselection-backwardsq~k#t caret-endsq~ktdelete-previoussq~k'tselection-next-wordsq~k%tcaret-backwardsq~kq~sq~kAtselection-forwardsq~k tactivate-link-actionsq~kHq~sq~k\tunselectsq~k t insert-breaksq~k$Atselection-begin-linesq~k't caret-forwardsq~k!tselection-page-leftsq~k(Atselection-downsq~k"t page-downsq~kAq~sq~kOttoggle-componentOrientationsq~kXq~sq~k"tselection-page-rightsq~kCtcopy-to-clipboardsq~kq~sq~k#Atselection-end-linesq~kq~sq~k$tcaret-begin-linesq~kVtpaste-from-clipboardsq~kq~sq~kAt select-allsq~k'Aq~sq~k#t selection-endsq~kq~sq~kq~sq~kTtnext-link-actionsq~kAq~sq~k t insert-tabsq~k&q~sq~k$tselection-beginsq~k"Atselection-page-downsq~kq~sq~kq~sq~k!tpage-upsq~kq~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~Kxpsrjavax.swing.text.StyleContexto~{xI unusedSetsLstylestLjavax/swing/text/Style;xpsr(javax.swing.text.StyleContext$NamedStyle NL listenerListq~KLthis$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~^xp 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~xppq~wxur4[Ljavax.swing.text.AbstractDocument$AbstractElement;t9w:ѝxpsr-javax.swing.text.AbstractDocument$LeafElementjcLthis$0q~xq~q~q~wxq~wxpq~sq~uq~ ppppppppppxpppxtYxppsrInfoPurple.Plet ඳcL pletLocationq~LpletSizeq~LppValuesq~LqueryStrq~ xpsrjava.awt.PointĊr4~&IxIyxp%srjava.awt.DimensionA׬_DIheightIwidthxp2sq~uq~(tResponsibility Countsq~t* Oracle - oracle.jdbc.driver.OracleDrivertapps_devtlink-obyone:1525:DEVtappstALLt20t'ID1't'ID2't'ID3't'ID4't'ID5'srInfoPurple.PletValue ඳcHL descriptionq~ L displayValueq~ Lid1q~ Lid2q~ Lid3q~ Lid4q~ Lid5q~ L internalValueq~ xppt20tID1tID2tID3tID4tID5psq~pppsq~pppsq~A@ ptArialxtappstNONEtPLETtp34tNtYtAuthor,Description etctYt1tNsq~;8pq~\sq~]pq~Mpxsq~`t Text Cursorpuq~csq~esq~iw ?@q~mxsq~esq~iw ?@q~pxppq~rq~tsq~uq~wq~xq~yppppppq~zsq~{q~zsq~{q~q~Wq~q~Xpsq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~`wtdefaultsq~sq~pxq~`wq~q~cxxxsq~ uq~ psq~?@wq~sq~ ti18nsq~ ttabSizesq~xsq~pxsq~uq~ ppppppppppxsq~pq~_wxuq~sq~q~qq~_wxq~_wxpq~_sq~uq~ ppppppppppxpppxppppppppppppppppxt from dualsq~"sq~$sq~&2 sq~uq~(tResponsibilitiesq~+tALLtresponsibility_nametresponsibility_idt'ID2't'ID3't'ID4't'ID5'sq~7ptProject Billing Super Usert20432tID2tID3tID4tID5psq~pppsq~pppsq~A@ ptArialxtappstNONEtPLETtp35tNtNtAuthor,Description etctYt1tNsq~;8pq~\sq~]pq~pxsq~`t Text Cursorpuq~csq~esq~iw ?@q~mxsq~esq~iw ?@q~pxppq~rq~tsq~uq~wq~xq~yppppppq~zsq~{q~zsq~{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~pq~wxuq~sq~q~q~wxq~wxpq~sq~uq~ ppppppppppxpppxppppppppppppppppxt|from FND_RESPONSIBILITY_VL where sysdate between start_date and nvl(end_date,sysdate) and responsibility_name like '%Super%'sq~"sq~$sq~&2dsq~uq~(tPhaseq~+tALLtmeaningt lookup_codet'ID2't'ID3't'ID4't'ID5'sq~7pt ALL Valuest%q~q~q~tALLpsq~pppsq~pppsq~A@ ptArialxtappstNONEtPLETtp32tYtNtAuthor,Description etctYt1tNsq~;8pq~\sq~]pq~pxsq~`t Text Cursorpuq~csq~esq~iw ?@q~mxsq~esq~iw ?@q~pxppq~rq~tsq~uq~wq~xq~yppppppq~zsq~{q~zsq~{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~pq~wxuq~sq~q~q~wxq~wxpq~sq~uq~ ppppppppppxpppxppppppppppppppppxtGfrom fnd_lookups where lookup_type='CP_PHASE_CODE' and enabled_flag='Y'sq~"sq~$2sq~&2sq~uq~(tPast Days (Bucket)q~+tALLtdayst'ID1't'ID2't'ID3't'ID4't'ID5'sq~7pt1tID1tID2tID3tID4tID5psq~pppsq~pppsq~A@ ptArialxtappstNONEtPLETtp31tNq~tAuthor,Description etctYt1tNsq~;8pq~\sq~]pq~-pxsq~`t Text Cursorpuq~csq~esq~iw ?@q~mxsq~esq~iw ?@q~pxppq~rq~tsq~uq~wq~xq~yppppppq~zsq~{q~zsq~{q~q~7q~q~8psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~@wtdefaultsq~sq~pxq~@wq~q~Cxxxsq~ uq~ psq~?@wq~sq~ ti18nsq~ ttabSizesq~xsq~pxsq~uq~ ppppppppppxsq~pq~?wxuq~sq~q~Qq~?wxq~?wxpq~?sq~uq~ ppppppppppxpppxppppppppppppppppxtSfrom ( select 1 days from dual union select 2 from dual union select 3 from dual union select 4 from dual union select 5 from dual union select 6 from dual union select 7 from dual union select 15 from dual union select 30 from dual union select 45 from dual union select 60 from dual union select 75 from dual union select 90 from dual )sq~"sq~$sq~&2dsq~uq~(tStatusq~+tALLtmeaningt lookup_codet'ID2't'ID3't'ID4't'ID5'sq~7pq~q~q~q~q~q~psq~pppsq~pppsq~A@ ptArialxtappstNONEtPLETtp33q~tNtAuthor,Description etctYt1tNsq~;8pq~\sq~]pq~rpxsq~`t Text Cursorpuq~csq~esq~iw ?@q~mxsq~esq~iw ?@q~pxppq~rq~tsq~uq~wq~xq~yppppppq~zsq~{q~zsq~{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~pq~wxuq~sq~q~q~wxq~wxpq~sq~uq~ ppppppppppxpppxppppppppppppppppxtHfrom fnd_lookups where lookup_type='CP_STATUS_CODE' and enabled_flag='Y'sq~sq~uq~ srInfoPurple.ColumnPropertyValues ඳcٸL colPropValuesq~L drillValuesq~L parentQlettLInfoPurple/Qlet;xpsq~uq~tTOTALt41sq~pppsq~pppsq~pppt1q~sq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyytYsq~A@ ptArialxtTotal tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t DESCRIPTIONt118q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt Description tDEFAULTtYpppxsq~uq~ ppppppppppxq~ppppppppxsq~$sq~&sq~(uq~(tUsers with Max Responsibilitiesq~+t100tManualt1440t 1-JAN-1990tYq~q~q~t1q~q~t18q~q~%q~&q~(t dd-MMM-yyyyt #########tq39q~sq~A@ pq~xq~tappst No_PatterntQLETsq~pppq~tXXDBNAMEt tAuthor,Description etctNt1tDEFAULTtYtNtNsq~;8pq~\sq~]pq~pxsq~`t Text Cursorpuq~csq~esq~iw ?@q~mxsq~esq~iw ?@q~pxppq~rq~tsq~uq~wq~xq~yppppppq~zsq~{q~zsq~{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~pq~wxuq~sq~q~ q~wxq~wxpq~sq~uq~ ppppppppppxpppxtNxttselect * from ( select fu.user_name, fu.description,count(*) Total ,fur.user_id from FND_USER_RESP_GROUPS fur , fnd_user fu where sysdate between fur.start_date and nvl(fur.end_date,sysdate) and fur.user_id = fu.user_id group by fu.user_name, fu.description,fur.user_id having count(*) >= 'G_PARAM' /*20*/ order by count(*) desc ) where rownum < 21tNsq~sq~uq~ sq~sq~uq~tInfoCaptor Messaget450sq~pppsq~pppsq~pppt1q~sq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t USER_NAMEt104q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt User Name tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t DESCRIPTIONt75q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyytNsq~A@ ptArialxt Description tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tUSER_IDt75q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyytNsq~A@ ptArialxtUser Id tDEFAULTtYpppxsq~uq~ ppppppppppxq~ppppppxsq~$sq~&-sq~(uq~(tUsers with Respq~+t100tManualt1440t 1-JAN-1990tYq~q~q~t1q~q~t18q~iq~%q~&q~(t dd-MMM-yyyyt #########tq41q~sq~A@ pq~xq~itappst No_PatterntQLETsq~pppq~tXXDBNAMEq~tAuthor,Description etctNt1tDEFAULTtYtNtNsq~;8pq~\sq~]pq~|pxsq~`t Text Cursorpuq~csq~esq~iw ?@q~mxsq~esq~iw ?@q~pxppq~rq~tsq~uq~wq~xq~yppppppq~zsq~{q~zsq~{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~pq~wxuq~sq~q~q~wxq~wxpq~sq~uq~ ppppppppppxpppxtNxtselect * from ( select fu.user_name, fu.description,fur.user_id,fu.person_party_id, fu.employee_id from FND_USER_RESP_GROUPS fur , fnd_user fu where sysdate between fur.start_date and nvl(fur.end_date,sysdate) and fur.user_id = fu.user_id and fur.responsibility_id = G_PARAM /*responsibility_id*/ and sysdate between fu.start_date and nvl(fur.end_date,sysdate) ) q~srInfoPurple.Glet ඳcL GletLocationq~LGletSizeq~L colDetailsq~LgpValuesq~LqueryStrq~ xpsq~$,sq~& ^psq~uq~(tMax Responsibilitiesq~+t100tBartApps User NametTotal ResponsibilitiestManualt1440sq~pppsq~A@ ptArialxsq~ppptYtg44q~Ftappst No_PatterntGlett tYtYtVerticalt0tYsq~AptArialxt##.#tYtAUTOtAUTOtNsq~;8pq~\sq~]pq~pxsq~`t Text Cursorpuq~csq~esq~iw ?@q~mxsq~esq~iw ?@q~pxppq~rq~tsq~uq~wq~xq~yppppppq~zsq~{q~zsq~{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~pq~wxuq~sq~q~q~wxq~wxpq~sq~uq~ ppppppppppxpppxt1pppppppppxt=select * from ( select fu.user_name, count(*) Total from FND_USER_RESP_GROUPS fur , fnd_user fu where sysdate between fur.start_date and nvl(fur.end_date,sysdate) and fur.user_id = fu.user_id group by fu.user_name having count(*) >= 'G_PARAM' /*20*/ order by count(*) desc ) where rownum < 21sq~sq~$XKsq~&ypsq~uq~(tRequest Statusq~+t100tPietXtYtManualt1440sq~pppsq~A@ ptArialxsq~pppq~tg33q~Ftappst No_PatterntGletq~tYtYtVerticalt0tYsq~AptArialxt##.#tYtAUTOtAUTOtNsq~;8pq~\sq~]pq~pxsq~`t Text Cursorpuq~csq~esq~iw ?@q~mxsq~esq~iw ?@q~pxppq~rq~tsq~uq~wq~xq~yppppppq~zsq~{q~zsq~{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~pq~'wxuq~sq~q~9q~'wxq~'wxpq~'sq~uq~ ppppppppppxpppxt1pppppppppxtZselect phase||' - '||status Request_Status, count(*) Total from ( select l1.meaning status, l2.meaning phase, cp.concurrent_program_id, cp.concurrent_program_name, cp.user_concurrent_program_name,cp.description , cp.executable_id, cr.* from FND_CONC_REQUESTS_FORM_V cr , fnd_lookups l1 , fnd_lookups l2 , fnd_concurrent_programs_vl cp where l1.lookup_type = 'CP_STATUS_CODE' and l2.lookup_type = 'CP_PHASE_CODE' and l2.lookup_code = cr.phase_code and l1.lookup_code = cr.status_code and l1.lookup_code like 'G_PARAM' /*lookup_code*/ and l2.lookup_code like 'G_PARAM' /*lookup_code*/ and cr.concurrent_program_id = cp.concurrent_program_id --and cp.user_concurrent_program_name not in ('Workflow Background Process') and request_date between sysdate- G_PARAM and sysdate ) group by status, phase sq~sq~uq~ sq~sq~uq~tUSER_CONCURRENT_PROGRAM_NAMEt230sq~pppsq~pppsq~pppt1q~Isq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxtUser Concurrent Program Name tDEFAULTtYpppxsq~uq~ ppppppppppxq~@sq~sq~uq~tInfoCaptor Messaget450q~Hq~Iq~Jt1q~Iq~LtNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxtInfocaptor Message tDEFAULTtYpppxsq~uq~ ppppppppppxq~@ppppppppxsq~$Ksq~&'sq~(uq~(tConcurrent Request Detailsq~+t100tManualt1440t 1-JAN-1990tYq~q~q~t1q~Lq~It18q~sq~%q~&q~(t dd-MMM-yyyyt #########tq34q~Isq~A@ pq~Mxq~Ftappst No_PatterntQLETsq~pppq~ItXXDBNAMEq~tAuthor,Description etctNt1tDEFAULTtYtNtNsq~;8pq~\sq~]pq~pxsq~`t Text Cursorpuq~csq~esq~iw ?@q~mxsq~esq~iw ?@q~pxppq~rq~tsq~uq~wq~xq~yppppppq~zsq~{q~zsq~{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~pq~wxuq~sq~q~q~wxq~wxpq~sq~uq~ ppppppppppxpppxtNxtselect l1.meaning status, l2.meaning phase, cp.concurrent_program_id, cp.concurrent_program_name, cp.user_concurrent_program_name,cp.description , cp.executable_id from FND_CONC_REQUESTS_FORM_V cr , fnd_lookups l1 , fnd_lookups l2 , fnd_concurrent_programs_vl cp where l1.lookup_type = 'CP_STATUS_CODE' and l2.lookup_type = 'CP_PHASE_CODE' and l2.lookup_code = cr.phase_code and l1.lookup_code = cr.status_code and l1.lookup_code like 'G_PARAM' /*lookup_code*/ and l2.lookup_code like 'G_PARAM' /*lookup_code*/ and cr.concurrent_program_id = cp.concurrent_program_id and cp.user_concurrent_program_name like 'param' and cr.request_date between sysdate- G_PARAM and sysdate order by cr.request_date desc q~!sq~sq~uq~ sq~sq~uq~tPROGRAMt268q~sq~pppq~t1q~sq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxtProgram tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t TABLE_NAMEt189q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tCONCURRENT_PROGRAM_NAMEt134q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxtConcurrent Program Name tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tCONCURRENT_QUEUE_NAMEt178q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxtConcurrent Queue Name tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t TARGET_NODEt144q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t FILE_NAMEt395q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tACTUAL_START_DATEt95q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxtActual Start Date tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tROW_IDt35q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~Xsq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~ppxsq~$sq~&sq~(uq~(t View Dataq~+t100tManualt1440t 1-JAN-1990tYq~q~q~t1q~q~t18q~Hq~%q~&q~(t dd-MMM-yyyyt #########tq32q~#sq~A@ pq~xtNtappst No_PatterntQLETsq~pppq~tXXDBNAMEt tAuthor,Description etctNt1tDEFAULTtYtNtNsq~;8pq~\sq~]pq~]pxsq~`t Text Cursorpuq~csq~esq~iw ?@q~mxsq~esq~iw ?@q~pxppq~rq~tsq~uq~wq~xq~yppppppq~zsq~{q~zsq~{q~q~gq~q~hpsq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~pwtdefaultsq~sq~pxq~pwq~q~sxxxsq~ uq~ psq~?@wq~sq~ ti18nsq~ ttabSizesq~xsq~pxsq~uq~ ppppppppppxsq~pq~owxuq~sq~q~q~owxq~owxpq~osq~uq~ ppppppppppxpppxtNxt#select * from paramq~!sq~sq~uq~ sq~sq~uq~t FLEX_NAMEt199sq~pppsq~pppsq~pppt1q~sq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt Flex Name tDEFAULTtYpppxsq~uq~ srInfoPurple.DrillSettings ඳcL drillColumnsq~L drillNameq~ L drillQletIDq~ xpsq~uq~ t FLEX_CODEt%ppppppppxtGet Flex Columnstq47sq~sq~uq~ tCONCATENATED_SEGS_VIEW_NAMEpppppppppxtGet Concatenated View Detailsq~Mppppppppxq~sq~sq~uq~t BASE_TABLEt146q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt Base Table tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tInfoCaptor Messaget450q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t FLEX_CODEt154q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~Xsq~A@ ptArialxt Display NametDEFAULTtYpppxpq~ppppppxsq~$sq~&sq~(uq~(tQuery Flex fieldsq~+t100tManualt1440t 1-JAN-1990tYq~q~q~t1q~q~t18q~q~%q~&q~(t dd-MMM-yyyyt #########tq46q~sq~A@ pq~xtNtappst No_PatterntQLETsq~pppq~tXXDBNAMEt tAuthor,Description etctNt1tDEFAULTtYtNtNsq~;8pq~\sq~]pq~pxsq~`t Text Cursorpuq~csq~esq~iw ?@q~mxsq~esq~iw ?@q~pxppq~rq~tsq~uq~wq~xq~yppppppq~zsq~{q~zsq~{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~pq~wxuq~sq~q~!q~wxq~wxpq~sq~uq~ ppppppppppxpppxtNxtIselect * from ( SELECT 'Key' Flex_type, id_flex_name flex_name, id_flex_code flex_code, application_table_name base_table, unique_id_column_name unique_column, 'N/A' context_column, description, set_defining_column_name , nvl(concatenated_segs_view_name ,'dual') concatenated_segs_view_name FROM fnd_id_flexs union all SELECT 'Desc' flex_type, title flex_name, descriptive_flexfield_name flex_code, application_table_name base_table, 'N/A' unique_column, context_column_name context_column, description, 'N/A' set_defining_column_name, nvl(concatenated_segs_view_name,'dual') concatenated_segs_view_name FROM fnd_descriptive_flexs_vl ) where upper(flex_name) like upper('param') and upper(flex_code) like upper('param') and base_table like upper('param')q~!sq~sq~uq~ sq~sq~uq~t FLEX_VALUEt96sq~pppsq~pppsq~pppt1q~1sq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt Flex Value tDEFAULTtYpppxsq~uq~ ppppppppppxq~(sq~sq~uq~tFLEX_VALUE_MEANINGt100q~0q~1q~2t1q~1q~4tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxtFlex Value Meaning tDEFAULTtYpppxsq~uq~ ppppppppppxq~(ppppppppxsq~$]+sq~&Csq~(uq~(t Flex Valuesq~+t100tManualt1440t 1-JAN-1990tYq~q~q~t1q~4q~1t18q~[q~%q~&q~(t dd-MMM-yyyyt #########tq53q~1sq~A@ pq~5xtNtappst No_PatterntQLETsq~pppq~1tXXDBNAMEt tAuthor,Description etctNt1tDEFAULTtYtNtNsq~;8pq~\sq~]pq~ppxsq~`t Text Cursorpuq~csq~esq~iw ?@q~mxsq~esq~iw ?@q~pxppq~rq~tsq~uq~wq~xq~yppppppq~zsq~{q~zsq~{q~q~zq~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~pq~wxuq~sq~q~q~wxq~wxpq~sq~uq~ ppppppppppxpppxtNxtselect flex_value, flex_value_meaning , description, flex_value_id, flex_value_set_id from fnd_flex_values_vl where flex_value_set_id = param q~!sq~sq~uq~ sq~sq~uq~tUSER_COLUMN_NAMEt118sq~pppsq~pppsq~pppt1q~sq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxtUser Column Name tDEFAULTtYpppxsq~uq~ sq~sq~uq~ tFLEX_VALUE_SET_IDpppppppppxtGet Flex Column Valuesq~`pppppppppxq~pppppppppxsq~$ sq~&sq~(uq~(tFlex Field Columnsq~+t100tManualt1440t 1-JAN-1990tYq~q~q~t1q~q~t18q~q~%q~&q~(t dd-MMM-yyyyt #########q~q~sq~A@ pq~xtNtappst No_PatterntQLETsq~pppq~tXXDBNAMEq~tAuthor,Description etctNt1tDEFAULTtYtNtNsq~;8pq~\sq~]pq~pxsq~`t Text Cursorpuq~csq~esq~iw ?@q~mxsq~esq~iw ?@q~pxppq~rq~tsq~uq~wq~xq~yppppppq~zsq~{q~zsq~{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~pq~wxuq~sq~q~q~wxq~wxpq~sq~uq~ ppppppppppxpppxtNxtMselect * from ( SELECT dfc.end_user_column_name user_column_name, dfc.column_seq_num column_sequence, dfc.application_column_name table_column_name, dfc.flex_value_set_id, dff.application_table_name base_table, dff.descriptive_flexfield_name flex_code, dff.title flex_name FROM fnd_descr_flex_col_usage_vl dfc, fnd_descriptive_flexs_vl dff WHERE dff.descriptive_flexfield_name = dfc.descriptive_flexfield_name union all SELECT kfc.segment_name, kfc.segment_num, kfc.application_column_name, kfc.flex_value_set_id, kff.application_table_name, kff.id_flex_code flex_code, kff.id_flex_name flex_name FROM fnd_id_flex_segments_vl kfc, fnd_id_flexs kff WHERE kfc.id_flex_code = kff.id_flex_code ) where flex_code like 'param' and upper(user_column_name) like upper('param') order by column_sequence ascq~!sq~sq~uq~ sq~sq~uq~t VIEW_NAMEt270sq~pppsq~pppsq~pppt1q~ sq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt View Name tDEFAULTtYpppxsq~uq~ sq~sq~uq~ q~pppppppppxt View Dataq~Mpppppppppxq~sq~sq~uq~tOWNERt45q~q~ q~t1q~ q~ tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxtOwner tDEFAULTtYpppxsq~uq~ ppppppppppxq~ppppppppxsq~$sq~&Gsq~(uq~(t FND Viewsq~+t100tManualt1440t 1-JAN-1990tYq~q~q~t1q~ q~ t18q~7q~%q~&q~(t dd-MMM-yyyyt #########tq31q~#sq~A@ pq~ xq~Otappst No_PatterntQLETsq~pppq~ tXXDBNAMEq~tAuthor,Description etctNt1tDEFAULTtYtNtNsq~;8pq~\sq~]pq~Jpxsq~`t Text Cursorpuq~csq~esq~iw ?@q~mxsq~esq~iw ?@q~pxppq~rq~tsq~uq~wq~xq~yppppppq~zsq~{q~zsq~{q~q~Tq~q~Upsq~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~pq~\wxuq~sq~q~nq~\wxq~\wxpq~\sq~uq~ ppppppppppxpppxtNxt3select * from all_views where view_name like 'FND%'q~ppppppppppppppppppppppppx