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~(t GL AnalysissrdbUtil.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~pppt18tYsq~pppsq~A@ ptArialxsq~pppt dd-MMM-yyyyt#,###,###,##0.00tq0q~#sq~A@ pq~"xq~%tappst No_PatterntVLETq~q~#t XXGL_FINANCEsrInfoPurple.DashboardSettings ඳc۬I currPletIdxI currQletIdxxp'vtAuthor,Description etctYt1tDEFAULTtYtYtNsrjavax.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~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{tmouseLq~~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~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~2srjava.awt.DimensionA׬_DIheightIwidthxp2dsq~uq~(t Analysis Ofsq~t* Oracle - oracle.jdbc.driver.OracleDrivertapps_devtlink-obyone:1525:DEVtappstALLtglkp.descriptiontglkp.lookup_codet'ID2't'ID3't'ID4't'ID5'srInfoPurple.PletValue ඳcHL descriptionq~ L displayValueq~ Lid1q~ Lid2q~ Lid3q~ Lid4q~ Lid5q~ L internalValueq~ xpptExpensetEtID2tID3tID4tID5psq~pppsq~pppsq~A@ ptArialxtappstNONEtPLETtp11tNq~QtAuthor,Description etctYt1tYsq~;8pq~\sq~]pq~Vpxsq~`t Text Cursorpuq~csq~esq~iw ?@q~mxsq~esq~iw ?@q~pxppq~rq~tsq~uq~wq~xq~yppppppq~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~q~`q~q~aq~q~bq~q~cq~q~dq~q~eq~q~fq~q~gq~q~hq~q~iq~q~jq~q~kpsq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~swtdefaultsq~sq~pxq~swq~q~vxxxsq~ uq~ import InfoPurple.Global; import InfoPurple.PortletInterface; PortletInterface p = Global.getPortletObject("q5"); if (p!=null) { p.refreshPortlet(true); } psq~?@wq~sq~ti18nsq~ttabSizesq~xsq~pxsq~ uq~ sq~'sq~pq~rwx uq~%q~sq~'q~q~rwxq~rw>xsq~'q~q~rwxq~rw>?xsq~'q~q~rwxq~rw?sxsq~'q~q~rwxq~rwstxsq~'q~q~rwxq~rwtxsq~'q~q~rwxq~rwxsq~'q~q~rwxq~rwxsq~'q~q~rwxq~rwxpppppppppq~rq~rwxq~rwxq~q~q~q~q~q~q~q~pxq~sq~uq~ sq~'q~q~rwxq~rwxpppppppppxpppxppppppppppppppppxt:FROM gl_lookups glkp where glkp.lookup_type='ACCOUNT TYPE'sq~,sq~.0sq~02psq~uq~(t Balance Typeq~5tALLtmeaningt lookup_codet'ID2't'ID3't'ID4't'ID5'sq~AptActualtAtID2tID3tID4tID5psq~pppsq~pppsq~A@ ptArialxtappstNONEtPLETtp37tNq~tAuthor,Description etctYt1q~Usq~;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~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{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~ import InfoPurple.Global; import InfoPurple.PortletInterface; PortletInterface p = Global.getPortletObject("q5"); if (p!=null) { p.refreshPortlet(true); } psq~?@wq~sq~ti18nsq~ttabSizesq~xsq~pxsq~ uq~ sq~'sq~pq~wx uq~%q~sq~'q~q~wxq~w>xsq~'q~q~wxq~w>?xsq~'q~q~wxq~w?sxsq~'q~q~wxq~wstxsq~'q~q~wxq~wtxsq~'q~q~wxq~wxsq~'q~q~wxq~wxsq~'q~q~wxq~wxpppppppppq~q~wxq~wxq~q~q~q~q~q~q~q~pxq~sq~uq~ sq~'q~q~wxq~wxpppppppppxpppxppppppppppppppppxtLfrom gl_lookups where lookup_type='GL_DSS_BALANCE_TYPE' and enabled_flag='Y'sq~,sq~.\sq~02Nsq~uq~(tCurrencyq~5tALLtdistinct currency_codet'ID1't'ID2't'ID3't'ID4't'ID5'sq~AptUSDtID1tID2tID3tID4tID5psq~pppsq~pppsq~A@ ptArialxtappstNONEtPLETtp7tNq~ 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~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{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~1xxxsq~  uq~ psq~?@wq~sq~ti18nsq~ttabSizesq~xsq~pxsq~uq~ ppppppppppxsq~pq~-wxuq~%sq~'q~?q~-wxq~-wxpq~-sq~uq~ ppppppppppxpppxppppppppppppppppxt*from gl_currencies where enabled_flag='Y' sq~,sq~.sq~02sq~uq~(t Set of Booksq~5tALLtnametgsob.set_of_books_idtgsob.chart_of_accounts_idt$fav2.application_column_name Companyt'fav3.application_column_name departmentt,fav1.application_column_name account_segmentsq~Apt Linksys USt1t50214tSEGMENT4tSEGMENT3tSEGMENT1psq~pppsq~pppsq~A@ pq~xtappstNONEtPLETtp0tNtNtAuthor,Description etctYt1tYsq~;8pq~\sq~]pq~fpxsq~`t Text Cursorpuq~csq~esq~iw ?@q~mxsq~esq~iw ?@q~pxppq~rq~tsq~uq~wq~xq~yppppppq~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~q~pq~q~qq~q~rq~q~sq~q~tq~q~uq~q~vq~q~wq~q~xq~q~yq~q~zq~q~{psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~wtdefaultsq~sq~pxq~wq~q~xxxsq~ uq~ import InfoPurple.Global; import InfoPurple.Plet; Plet p= Global.getPletObject("p2"); if (p!=null) { p.refreshPletDisplay(true); }} psq~?@wq~sq~ti18nsq~ttabSizesq~xsq~pxsq~ uq~ sq~'sq~pq~wx uq~%q~sq~'q~q~wxq~w2xsq~'q~q~wxq~w23xsq~'q~q~wxq~w3Wxsq~'q~q~wxq~wWXxsq~'q~q~wxq~wXexsq~'q~q~wxq~wegxsq~'q~q~wxq~wgxsq~'q~q~wxq~wxpppppppppq~q~wxq~wxq~q~q~q~q~q~q~q~pxq~sq~uq~ sq~'q~q~wxq~wxpppppppppxpppxppppppppppppppppxtQfrom FND_SEGMENT_ATTRIBUTE_VALUES fav1, FND_SEGMENT_ATTRIBUTE_VALUES fav2, FND_SEGMENT_ATTRIBUTE_VALUES fav3, gl_sets_of_books gsob where 1=1 and fav1.id_flex_code='GL#' and fav1.id_flex_num=gsob.chart_of_accounts_id and fav1.attribute_value='Y' and fav1.segment_attribute_type='GL_ACCOUNT' and fav2.id_flex_code='GL#' and fav2.id_flex_num=gsob.chart_of_accounts_id and fav2.attribute_value='Y' and fav2.segment_attribute_type='GL_BALANCING' and fav3.id_flex_code='GL#' and fav3.id_flex_num=gsob.chart_of_accounts_id and fav3.attribute_value='Y' and fav3.segment_attribute_type='FA_COST_CTR' sq~,sq~.sq~02sq~uq~(tBalance View Byq~5t20t segment_nametapplication_column_namet segment_numtflex_value_set_idt'ID4't'ID5'sq~AptAccounttSEGMENT1t2t1005352tID4tID5psq~ܽpppsq~pppsq~A@ pq~xtappstNONEtPLETtp2tNtNtAuthor,Description etctYt1q~esq~;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~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{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~ import InfoPurple.Global; import InfoPurple.Plet; Plet p= Global.getPletObject("p4"); if (p!=null) { p.refreshPletDisplay(true); }} psq~?@wq~sq~ti18nsq~ttabSizesq~xsq~pxsq~ uq~ sq~'sq~pq~wx uq~%q~sq~'q~q~wxq~w2xsq~'q~q~wxq~w23xsq~'q~q~wxq~w3Wxsq~'q~q~wxq~wWXxsq~'q~q~wxq~wXexsq~'q~q~wxq~wegxsq~'q~q~wxq~wgxsq~'q~q~wxq~wxpppppppppq~q~wxq~wxq~q~q~q~q~q~q~q~pxq~sq~uq~ sq~'q~q~wxq~wxpppppppppxpppxppppppppppppppppxtFROM fnd_id_flex_segments where id_flex_code='GL#' and enabled_flag='Y' and id_flex_num= G_PARAM/*chart_of_accounts_id*/ --and application_column_name <> 'G_PARAM'/*fav.application_column_nameaccount_segment*/ sq~,sq~.|sq~02sq~uq~(t For valueq~5tALLtflex_value||' - '||descriptiont flex_value_idt flex_valuet'NA't'ID4't'ID5'sq~Apt ALL Valuest%q~q~q~tALLpsq~pppsq~pppsq~A@ pq~xtappstNONEtPLETtp4tYtNtAuthor,Description etctYt1q~esq~;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~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~q~'q~q~(q~q~)q~q~*q~q~+q~q~,q~q~-q~q~.q~q~/q~q~0q~q~1q~q~2psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~:wtdefaultsq~sq~pxq~:wq~q~=xxxsq~ uq~ import InfoPurple.Global; import InfoPurple.PortletInterface; PortletInterface p = Global.getPortletObject("q5"); if (p!=null) { p.refreshPortlet(true); } psq~?@wq~sq~ti18nsq~ttabSizesq~xsq~pxsq~ uq~ sq~'sq~pq~9wx uq~%q~Ksq~'q~Lq~9wxq~9w>xsq~'q~Lq~9wxq~9w>?xsq~'q~Lq~9wxq~9w?sxsq~'q~Lq~9wxq~9wstxsq~'q~Lq~9wxq~9wtxsq~'q~Lq~9wxq~9wxsq~'q~Lq~9wxq~9wxsq~'q~Lq~9wxq~9wxpppppppppq~9q~9wxq~9wxq~Nq~Oq~Pq~Qq~Rq~Sq~Tq~Upxq~Lsq~uq~ sq~'q~Lq~9wxq~9wxpppppppppxpppxppppppppppppppppxtmfrom fnd_flex_values_vl where flex_value_set_id = G_PARAM/*flex_value_set_id*/ order by flex_value sq~,sq~.sq~02Zsq~uq~(tPeriodq~5tALLt period_namet!to_char(start_Date,'DD-MON-YYYY')tto_char(end_date,'DD-MON-YYYY')t period_numt period_yeart&to_char(year_start_date,'DD-MON-YYYY')sq~AptJUN-06t 24-MAY-2006t 20-JUN-2006t11t2006t 27-JUL-2005psq~ۚpppsq~pppsq~A@ pq~xtappstNONEtPLETtp3tNtNtAuthor,Description etctYt1q~Usq~;8pq~\sq~]pq~zpxsq~`t Text Cursorpuq~csq~esq~iw ?@q~mxsq~esq~iw ?@q~pxppq~rq~tsq~uq~wq~xq~yppppppq~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{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~ import InfoPurple.Global; import InfoPurple.PortletInterface; PortletInterface p = Global.getPortletObject("q5"); if (p!=null) { p.refreshPortlet(true); } psq~?@wq~sq~ti18nsq~ttabSizesq~xsq~pxsq~ uq~ sq~'sq~pq~wx uq~%q~sq~'q~q~wxq~w>xsq~'q~q~wxq~w>?xsq~'q~q~wxq~w?sxsq~'q~q~wxq~wstxsq~'q~q~wxq~wtxsq~'q~q~wxq~wxsq~'q~q~wxq~wxsq~'q~q~wxq~wxpppppppppq~q~wxq~wxq~q~q~q~q~q~q~q~pxq~sq~uq~ sq~'q~q~wxq~wxpppppppppxpppxppppppppppppppppxt FROM gl_periods where period_set_name = (select period_set_name from gl_sets_of_books where set_of_books_id= G_PARAM) /*gsob.set_of_books_id*/ order by period_num desc sq~,sq~.]2sq~02sq~uq~(t Balance Forq~5tALLt balance_typetbalance_columnst'ID2't'ID3't'ID4't'ID5'sq~AptPeriod-to-Datet&sum(period_net_dr - period_net_cr) ptdtID2tID3tID4tID5psq~pppsq~pppsq~A@ ptArialxtappstNONEtPLETtp36tNq~tAuthor,Description etctYt1q~Usq~;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~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{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~ import InfoPurple.Global; import InfoPurple.PortletInterface; PortletInterface p = Global.getPortletObject("q5"); if (p!=null) { p.refreshPortlet(true); } psq~?@wq~sq~ti18nsq~ttabSizesq~xsq~pxsq~ uq~ sq~'sq~pq~wx uq~%q~sq~'q~q~wxq~w>xsq~'q~q~wxq~w>?xsq~'q~q~wxq~w?sxsq~'q~q~wxq~wstxsq~'q~q~wxq~wtxsq~'q~q~wxq~wxsq~'q~q~wxq~wxsq~'q~q~wxq~wxpppppppppq~q~wxq~wxq~q~ q~ q~ q~ q~ q~q~pxq~sq~uq~ sq~'q~q~wxq~wxpppppppppxpppxppppppppppppppppxtfrom ( select '1' seq, 'Period-to-Date' balance_type, 'sum(period_net_dr - period_net_cr) ptd' balance_columns from dual union select '2','Quarter-to-Date' , 'sum((Quarter_to_date_dr - Quarter_to_date_cr) + (period_net_dr- period_net_cr)) qtd' from dual union select '3', 'Year-to-Date' , 'sum((Begin_balance_dr- begin_balance_cr) + (period_net_dr- period_net_cr)) ytd' from dual union select '4','PTD, QTD, YTD' , 'sum(period_net_dr - period_net_cr) ptd, sum((Quarter_to_date_dr - Quarter_to_date_cr) + (period_net_dr- period_net_cr)) qtd, sum((Begin_balance_dr- begin_balance_cr) + (period_net_dr- period_net_cr)) ytd' from dual union select '5', 'All Columns' , 'sum(period_net_dr - period_net_cr) ptd, sum((Quarter_to_date_dr - Quarter_to_date_cr) + (period_net_dr- period_net_cr)) qtd, sum((Begin_balance_dr- begin_balance_cr) + (period_net_dr- period_net_cr)) ytd, sum(period_net_dr) period_net_dr, sum(period_net_cr) period_net_cr,sum(quarter_to_date_dr) quarter_to_date_dr, sum(quarter_to_date_cr) quarter_to_date_cr, sum(begin_balance_dr) begin_balance_dr, sum(begin_balance_cr) begin_balance_cr' from dual union select '6', 'Base Columns' , 'sum(period_net_dr) period_net_dr, sum(period_net_cr) period_net_cr,sum(quarter_to_date_dr) quarter_to_date_dr, sum(quarter_to_date_cr) quarter_to_date_cr, sum(begin_balance_dr) begin_balance_dr, sum(begin_balance_cr) begin_balance_cr' from dual ) order by seq sq~sq~(uq~(srInfoPurple.ColumnPropertyValues ඳcٸL colPropValuesq~L drillValuesq~L parentQlettLInfoPurple/Qlet;xpsq~uq~tPERIOD_SET_NAMEt114sq~pppsq~pppsq~pppt1q~sq~A@ ptArialxtNAtNt999999t DD-MON-YYYYtYsq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t TABLE_NAMEt279q~q~q~ t1q~q~"tNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tDEBITt112q~q~q~ t1q~q~"tNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ srInfoPurple.DrillSettings ඳcL drillColumnsq~L drillNameq~ L drillQletIDq~ xpsq~uq~ t No ParameterspppppppppxtJournal tq5pppppppppxq~sq~sq~uq~tCREDITt108q~q~q~ t1q~q~"tNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t ACC_DEBITt97q~q~q~ t1q~q~"tNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t ACC_CREDITt93q~q~q~ t1q~q~"tNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t CURRENCY_CODEt42q~q~q~ t1q~q~"tNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tCOMPANYt162q~q~q~ t1q~q~"tNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tACCOUNTt65q~q~q~ t1q~q~"tNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t PERIOD_NAMEt48q~q~q~ t1q~q~"tNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tCURRt41sq~pppq~sq~pppt0q~q~"tNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxtCurr tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tPERIODt50sq~֟pppq~sq~֟pppt1q~q~"tNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxtPeriod tDEFAULTtYpppxsq~uq~ sq~Rsq~uq~ t SEGMENT_VALUEpppppppppxtGet Balance by Code Combinationtq77pppppppppxq~sq~sq~uq~tCREDIT_ACTIVITYt123q~q~q~ t1q~q~"tNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxtCredit Activity tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t DEBIT_BALt102sq~pppq~q~ t1q~q~"tNAtNt ##########t dd-MMM-yyyyq~(sq~A@ ptArialxt Debit Bal tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tDEBIT_ACTIVITYt103q~q~q~ t1q~q~"tNAtNt ##########t dd-MMM-yyyyq~(sq~A@ ptArialxtDebit Activity tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tPRODUCTt96q~q~q~ t1q~q~"tNAtNt ##########t dd-MMM-yyyyq~(sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t CREDIT_BALt101q~q~q~ t1q~q~"tNAtNt ##########t dd-MMM-yyyyq~(sq~A@ ptArialxt Credit Bal tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t DEPARTMENTt242q~q~q~ t1q~q~"tNAtNt ##########t dd-MMM-yyyyq~(sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t Sub-Accountt204q~q~q~ t1q~q~"tNAtNt ##########t dd-MMM-yyyyq~(sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t Departmentt261q~q~q~ t1q~q~"tNAtNt ##########t dd-MMM-yyyytYsq~A@ ptArialxt Department tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tProductt262q~q~q~ t1q~q~"tNAtNt ##########t dd-MMM-yyyyq~(sq~A@ ptArialxtProduct tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tAccountt263q~q~q~ t1q~q~"tNAtNt ##########t dd-MMM-yyyyq~(sq~A@ ptArialxtAccount tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tCompanyt262q~q~q~ t1q~q~"tNAtNt ##########t dd-MMM-yyyyq~(sq~A@ ptArialxtCompany tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tDepartment_codet75q~q~q~ t1q~q~"tNAtNt ##########t dd-MMM-yyyyq~(sq~A@ ptArialxtDepartment Code tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t Company_codet75q~q~q~ t1q~q~"tNAtNt ##########t dd-MMM-yyyyq~(sq~A@ ptArialxt Company Code tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tSub-Account_codet75sq~pppq~sq~pppt1q~q~"tNAtNt ##########t dd-MMM-yyyyq~(sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tInfoCaptor Messaget734q~q~q~t1q~q~"tNAtNt ##########t dd-MMM-yyyyq~(sq~A@ ptArialxtInfocaptor Message tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t Country_codet75q~q~q~t1q~q~"tNAtNt ##########t dd-MMM-yyyyq~(sq~A@ ptArialxt Country Code tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tCountryt75q~q~q~t1q~q~"tNAtNt ##########t dd-MMM-yyyyq~(sq~A@ ptArialxtCountry tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t Cost Centert75q~q~q~t1q~q~"tNAtNt ##########t dd-MMM-yyyyq~(sq~A@ ptArialxt Cost CentertDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t6SUM(PERIOD_NET_DR-PERIOD_NET_CR)PTD/*BALANCE_COLUMNS*/t322q~q~q~t1q~q~"tNAtNt ##########t dd-MMM-yyyyq~(sq~A@ ptArialxt7Sum(period Net Dr-period Net Cr)ptd/*balance Columns*/ tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tPTDt65q~q~q~t1q~q~"tNAtNt ##########t dd-MMM-yyyyq~(sq~A@ ptArialxtPtd tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tQTDt86q~q~q~t1q~q~"tNAtNt ##########t dd-MMM-yyyyq~(sq~A@ ptArialxtQtd tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tYTDt80q~q~q~t1q~q~"tNAtNt ##########t dd-MMM-yyyyq~(sq~A@ ptArialxtYtd tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tSUM(PERIOD_NET_DR)t86q~q~q~t1q~q~"tNAtNt ##########t dd-MMM-yyyyq~(sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tQUARTER_TO_DATE_DRt75q~q~q~t1q~q~"tNAtNt ##########t dd-MMM-yyyyq~(sq~A@ ptArialxtQuarter To Date Dr tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t Account_codet75q~q~q~t1q~q~"tNAtNt ##########t dd-MMM-yyyyq~(sq~A@ ptArialxt Account Code tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t PERIOD_NET_DRt75q~q~#q~t1q~#q~!tNAtNt ##########t dd-MMM-yyyyq~(sq~A@ ptArialxtPeriod Net Dr tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t Product_codet75q~q~#q~t1q~#q~!tNAtNt ##########t dd-MMM-yyyytNsq~A@ ptArialxt Product Code tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tProjectt75q~q~#q~t1q~#q~!tNAtNt ##########t dd-MMM-yyyytNq~-tProjecttDEFAULTtYpppxsq~uq~ sq~Rsq~uq~ t7txyzppppppppxtDrill0tg105sq~Rsq~uq~ t No ParameterspppppppppxtDrill0q~Xppppppppxq~xsq~.dsq~0(sq~(uq~(tBalance by Single Dimensionq~5t1000tManualt1440t 1-JAN-1990q~q~q~q~q~q~!q~#q~$q~%q~&q~'q~)q~*q~+q~Xq~#q~-tYtappst No_PatterntQLETsq~pppq~tXXDBNAMEt tAuthor,Description etctNt1tDEFAULTtYtYtNsq~;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~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{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~pq~wxuq~%sq~'q~-q~wxq~wxpq~sq~uq~ ppppppppppxpppxtYxtzSELECT bal.period_name Period ,value_desc.description "G_PARAM" ,cck.G_PARAM "G_PARAM_code" /*segment_name*/ ,bal.currency_code Curr , G_PARAM /*balance_columns*/ ,cck.G_PARAM segment_value FROM gl_balances bal, gl_code_combinations_kfv cck, ( select flex_value, flex_value_id,description from fnd_flex_values_vl where flex_value_set_id= G_PARAM/*flex_value_set_id*/ ) value_desc WHERE bal.code_combination_id = cck.code_combination_id AND bal.actual_flag = 'G_PARAM' /*lookup_code*/ AND bal.set_of_books_id = G_PARAM/*gsob.set_of_books_id*/ AND bal.period_name = 'G_PARAM' /*period_name*/ AND bal.template_id IS NULL AND NVL(bal.translated_flag, 'R') = 'R' AND bal.currency_code = 'G_PARAM'/*distinctcurrency_code*/ and cck.G_PARAM like 'G_PARAM'/*flex_value*/ and cck.gl_account_type = 'G_PARAM'/*glkp.lookup_code*/ and cck.G_PARAM = value_desc.flex_value group by value_desc.description,cck.G_PARAM , bal.currency_code ,bal.period_name q~sq~sq~uq~ sq~sq~uq~tTRX_NUMBER_DISPLAYEDt75sq~pppsq~pppsq~pppt1q~=sq~A@ ptArialxtNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxtTrx Number Displayed tDEFAULTtYpppxsq~uq~ ppppppppppxq~4sq~sq~uq~t JE_HEADER_IDt75q~t1q~=q~@tNAtNt ##########t dd-MMM-yyyyq~(sq~A@ ptArialxt Je Header Id tDEFAULTtYpppxsq~uq~ ppppppppppxq~4sq~sq~uq~tSET_OF_BOOKS_IDt75q~t1q~=q~@tNAtNt ##########t dd-MMM-yyyyq~(sq~A@ ptArialxtSet Of Books Id tDEFAULTtYpppxsq~uq~ ppppppppppxq~4sq~sq~uq~t REFERENCE_2t75q~t1q~=q~@tNAtNt ##########t dd-MMM-yyyyq~(sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~4ppppppxsq~.*_sq~0sq~(uq~(tSubledger Detailsq~5t100tManualt1440t 1-JAN-1990q~q~q~q~q~q~!q~#q~$q~%q~&q~'q~)q~*q~+tq10q~#q~-tNtappst No_PatterntQLETsq~pppq~=tXXDBNAMEt tAuthor,Description etcq~t1tDEFAULTtYtYtNsq~;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~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{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~pq~wxuq~%sq~'q~q~wxq~wxpq~sq~uq~ ppppppppppxpppxtYxtselect * from param where je_header_id= param and je_line_num = param tYsq~sq~uq~(sq~sq~uq~tAPPLICATION_COLUMN_NAMEt103sq~pppsq~pppsq~pppt1q~sq~A@ ptArialxtNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t SEGMENT_NAMEt112q~q~q~t1q~q~tNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tAPPLICATION_COLUMN_INDEX_FLAGt112q~q~q~t1q~q~tNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tFLEX_VALUE_SET_IDt119q~q~q~t1q~q~tNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t SEGMENT_NUMt123q~q~q~t1q~q~tNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tPERIOD_SET_NAMEt115q~q~q~t1q~q~tNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t PERIOD_NAMEt86q~q~q~t1q~q~tNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxt Period Name tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t QUARTER_NUMt95q~q~q~t1q~q~tNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tCONTEXTt25q~q~q~t1q~q~tNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tYEAR_START_DATEt88q~q~q~t1q~q~tNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t PERIOD_NET_DRt112q~q~q~t1q~q~tNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t PERIOD_NET_CRt99q~q~q~t1q~q~tNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t DESCRIPTIONt131q~q~q~t1q~q~tNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxt Description tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t LOOKUP_TYPEt166q~q~q~t1q~q~tNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t JE_CATEGORYt73q~q~q~t1q~q~tNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxt Je Category tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tInfoCaptor Messaget489q~q~q~t1q~q~tNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxtInfocaptor Message tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t JE_LINE_NUMt75q~q~q~t1q~q~tNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxt Je Line Num tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tACCOUNTt86q~q~q~t1q~q~tNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxtAccount tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tSL_VIEWt20q~q~q~t1q~q~tNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxtSl View tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tJOURNAL_HEADERt156q~q~q~t1q~q~tNAtNt999999t DD-MON-YYYYq~(sq~A@ ptArialxtJournal Header tDEFAULTtYpppxsq~uq~ sq~Rsq~uq~ q~ t JE_HEADER_IDt JE_LINE_NUMpppppppxtSubledger Transactionsq~pppppppppxq~sq~sq~uq~t JE_HEADER_IDt75q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~(sq~A@ ptArialxt Je Header Id tDEFAULTtYpppxsq~uq~ ppppppppppxq~pppppppppppppppppppxsq~.sq~0sq~(uq~(tJournal Details (Posted)q~5t100tManualt1440t 1-JAN-1990q~q~q~q~q~q~!q~#q~$q~%q~&q~'q~)q~*q~+tq1q~#q~-tNtappst No_PatterntQLETsq~pppq~tXXDBNAMEt tAuthor,Description etcq~t1tDEFAULTtYtYtNsq~;8pq~\sq~]pq~ Wpxsq~`t Text Cursorpuq~csq~esq~iw ?@q~mxsq~esq~iw ?@q~pxppq~rq~tsq~uq~wq~xq~yppppppq~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~q~ aq~q~ bq~q~ cq~q~ dq~q~ eq~q~ fq~q~ gq~q~ hq~q~ iq~q~ jq~q~ kq~q~ lpsq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~ twtdefaultsq~sq~pxq~ twq~q~ wxxxsq~  uq~ psq~?@wq~sq~ti18nsq~ttabSizesq~xsq~pxsq~uq~ ppppppppppxsq~pq~ swxuq~%sq~'q~ q~ swxq~ swxpq~ ssq~uq~ ppppppppppxpppxtYxt select jeh.name journal_header , jeh.description , jeh.je_header_id , jel.je_line_num , jel.entered_dr , jel.entered_cr , jel.accounted_dr , jel.accounted_cr , jeh.je_source , jeh.je_category , jel.description line_desc , jel.period_name , jeh.currency_code currency , gcc.concatenated_segments account , (case when jeh.je_category in ('Sales Invoices', 'Credit Memos', 'Credit Memo Applications', 'Debit Memos', 'Chargebacks') then 'AR_AEL_GL_INV_V' when jeh.je_category in ('Misc Receipts', 'Trade Receipts', 'Rate Adjustments', 'Cross Currency') then 'AR_AEL_GL_REC_ALL_V' when jeh.je_category = 'Adjustment' then 'AR_AEL_GL_ADJ_V' when jeh.je_category in ('Remittance', 'Write-off', 'Conformation', 'Rejection', 'Bank Receipts', 'Banks Charges') then 'JL_BR_AR_BT_AEL_GL_V' when jeh.je_category in ('Purchase Invoices') then 'AP_AEL_GL_INV_V' when jeh.je_category in ('Payments', 'Cross Currency', 'Reconciled Payments' ) then 'AP_AEL_GL_PAY_V' when jeh.je_category in ('Labor Cost', 'Miscellaneous Transaction', 'Total Burdened Cost', 'Usage Cost' ) then 'PA_AEL_GL_EI_V' when jeh.je_category ='Revenue' then 'PA_AEL_GL_DR_V' when jeh.je_Category = 'MTL' then 'CST_AEL_GL_INV_V' when jeh.je_Category = 'WIP' then 'CST_AEL_GL_WIP_V' when jeh.je_Category in ('Purchasing', 'Periodic Inventory' ) then 'RCV_AEL_GL_V' when jeh.je_Category = 'Requisitions' then 'REQ_ENC_AEL_GL_V' when jeh.je_Category = 'Purchases' then 'PO_ENV_AEL_GL_V' when jeh.je_source = 'Periodic Inventory' and jeh.je_source in ('Receiving', 'Accrual') then 'CST_PAC_AEL_GL_INV_V' when jeh.je_source ='Assets' and jeh.je_Category = 'Globalization' then 'JL_CO_FA_AEL_GL_V' when jeh.je_source='Assets' and jeh.je_category <> 'Globalization' then 'FA_AEL_GL_V' when jeh.je_Category in ('Settlement', 'Claims', 'Deductions') then 'OZF_AEL_GL_CLA_V' when jeh.je_Category in ('Fixed Budgets', 'Accrual Budgets') then 'OZF_AEL_GL_UTL_V' when jeh.je_Category = 'Expense' then 'PN_AEL_PAY_GL_V' when jeh.je_Category = 'Revenue' then 'PN_AEL_BILL_GL_V' when jeh.je_Category = 'Termination' then 'OKL_AEL_GL_QTE_V' when jeh.je_Category = 'Asset Deposition' then 'OKL_AEL_GL_AST_V' when jeh.je_Category in ('Booking', 'Rebook', 'Renewal', 'Release', 'Reverse', 'Syndication') then 'OKL_AEL_GL_CTR_V' when jeh.je_Category in ('Loss Provision', 'Adjustment', 'Lease Accrual', 'Miscellaneous') then 'OKL_AEL_GL_TRX_V' when jeh.je_category in ('Oracle Loans') then 'LNS_AEL_GL_V' else 'gl_import_references' end) sl_view from gl_je_headers jeh , gl_je_lines jel , gl_code_combinations_kfv gcc where jeh.je_header_id=jel.je_header_id and jel.code_combination_id= gcc.code_combination_id and jel.code_combination_id = param and jel.status='P' and jel.set_of_books_id= G_PARAM/*gsob.set_of_books_id*/ and jel.period_name = 'G_PARAM' /*period_name*/ q~sq~sq~uq~ sq~sq~uq~tACCOUNT_COMBINATIONt144sq~pppsq~pppsq~pppt1q~ sq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyyq~(sq~A@ ptArialxtAccount Combination tDEFAULTtYpppxsq~uq~ sq~Rsq~uq~ tCODE_COMBINATION_IDpppppppppxtGet Journal Detailsq~ Ipppppppppxq~ sq~sq~uq~tPTDt38q~q~#q~t1q~#q~!tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxtPtd tDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~sq~uq~tCURRt39q~q~#q~t1q~#q~!tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxtCurr tDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~sq~uq~tPERIODt45q~q~#q~t1q~#q~!tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxtPeriod tDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~sq~uq~tQTDt39q~q~#q~t1q~#q~!tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxtQtd tDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~sq~uq~tYTDt40q~q~#q~t1q~#q~!tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxtYtd tDEFAULTtYpppxsq~uq~ ppppppppppxq~ ppppxsq~.dsq~0,sq~(uq~(tBalance by Code Combinationq~5t100tManualt1440t 1-JAN-1990tYq~q~q~q~q~!q~#q~$q~%q~&q~'q~)q~*q~+q~q~#q~-q~tappst No_PatterntQLETsq~pppq~ tXXDBNAMEt tAuthor,Description etcq~t1tDEFAULTtYtYtNsq~;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~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{q~zsq~{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~ 2wtdefaultsq~sq~pxq~ 2wq~q~ 5xxxsq~  uq~ psq~?@wq~sq~ti18nsq~ttabSizesq~xsq~pxsq~uq~ ppppppppppxsq~pq~ 1wxuq~%sq~'q~ Cq~ 1wxq~ 1wxpq~ 1sq~uq~ ppppppppppxpppxtYxtSELECT cck.concatenated_segments Account_Combination ,bal.currency_code Curr , G_PARAM /*balance_columns*/ ,cck.code_combination_id FROM gl_balances bal, gl_code_combinations_kfv cck, ( select flex_value, flex_value_id,description from fnd_flex_values_vl where flex_value_set_id= G_PARAM/*flex_value_set_id*/ ) value_desc WHERE bal.code_combination_id = cck.code_combination_id AND bal.actual_flag = 'G_PARAM' /*lookup_code*/ AND bal.set_of_books_id = G_PARAM/*gsob.set_of_books_id*/ AND bal.period_name = 'G_PARAM' /*period_name*/ AND bal.template_id IS NULL AND NVL(bal.translated_flag, 'R') = 'R' AND bal.currency_code = 'G_PARAM'/*distinctcurrency_code*/ and cck.G_PARAM = 'param< Value, xyz>' and cck.gl_account_type = 'G_PARAM'/*glkp.lookup_code*/ and cck.G_PARAM = value_desc.flex_value group by cck.concatenated_segments , bal.currency_code ,bal.period_name ,cck.code_combination_id q~esq~sq~uq~ ppppppppppxsq~.sq~0sq~(uq~(tUnbalanced GL linesq~5t100tManualt300t 1-JAN-1990tYq~q~q~q~q~!q~#q~$q~ Vq~&q~'q~)t dd-MMM-yyyyt #########tq117q~#q~-tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etctNt1tDEFAULTq~ Vq~ cq~ csq~;8pq~\sq~]pq~ fpxsq~`t Text Cursorpuq~csq~esq~iw ?@q~mxsq~esq~iw ?@q~pxppq~rq~tsq~uq~wq~xq~yppppppq~zsq~{q~zsq~{q~zsq~{q~zsq~{q~q~ pq~q~ qq~q~ rq~q~ spsq~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~ zwxuq~%sq~'q~ q~ zwxq~ zwxpq~ zsq~uq~ ppppppppppxpppxq~ cxt select b.code_combination_id ccid, b.period_name period, b.currency_code currency, nvl(b.period_net_cr, 0) balances_cr, nvl(b.period_net_dr, 0) balances_dr, sum(nvl(l.accounted_cr, 0)) lines_cr, sum(nvl(l.accounted_dr, 0)) lines_dr from gl.gl_je_headers h , gl.gl_je_lines l , gl.gl_balances b where b.set_of_books_id = 'G_PARAM' /*gsob.set_of_books_id*/ and b.period_name = 'G_PARAM' /*period_name*/ and b.actual_flag = 'A' and b.currency_code != 'STAT' and b.currency_code = 'G_PARAM' /*currency_code*/ and l.set_of_books_id = b.set_of_books_id and l.period_name = b.period_name and l.code_combination_id = b.code_combination_id and (b.translated_flag <> 'Y' or b.translated_flag is null) and h.je_header_id = l.je_header_id and h.actual_flag = b.actual_flag and h.currency_code != 'STAT' and h.status = 'P' group by b.code_combination_id, b.period_name, b.currency_code, nvl(b.period_net_cr, 0), nvl(b.period_net_dr, 0) having nvl(b.period_net_cr,0) <> sum(nvl(accounted_cr,0)) or nvl(b.period_net_dr,0) <> sum(nvl(accounted_dr,0)) union --part for foreign currencies select b.code_combination_id ccid, b.period_name period, b.currency_code currency, nvl(b.period_net_cr, 0) balances_cr, nvl(b.period_net_dr, 0) balances_dr, sum(nvl(l.entered_cr, 0)) lines_cr, sum(nvl(l.entered_dr, 0)) lines_dr from gl.gl_je_headers h , gl.gl_je_lines l , gl.gl_balances b where b.set_of_books_id = 'G_PARAM' /*gsob.set_of_books_id*/ and b.period_name = 'G_PARAM' /*period_name*/ and b.actual_flag = 'A' and b.currency_code != 'STAT' and b.currency_code != 'G_PARAM' /*currency_code*/ and l.set_of_books_id = b.set_of_books_id and l.period_name = b.period_name and l.code_combination_id = b.code_combination_id and (b.translated_flag <> 'Y' or b.translated_flag is null) and h.je_header_id = l.je_header_id and h.actual_flag = b.actual_flag and h.currency_code = b.currency_code and h.currency_code != 'STAT' and h.status = 'P' group by b.code_combination_id, b.period_name, b.currency_code, nvl(b.period_net_cr, 0), nvl(b.period_net_dr, 0) having nvl(b.period_net_cr,0) <> sum(nvl(entered_cr,0)) or nvl(b.period_net_dr,0) <> sum(nvl(entered_dr,0))tNsq~sq~uq~ ppppppppppxsq~.sq~0sq~(uq~(tFind Overlapping Segmentsq~5t100tManualt300t 1-JAN-1990tYq~q~q~q~q~!q~#q~$q~ q~&q~'q~)t dd-MMM-yyyyt #########tq115q~#q~-q~ tappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~tAuthor,Description etctNt1tDEFAULTq~ q~ q~ sq~;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~zsq~{q~zsq~{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~pq~ wxuq~%sq~'q~ q~ wxq~ wxpq~ sq~uq~ ppppppppppxpppxq~ xtSELECT DISTINCT flexset.segment_name, flexset.segment_num, fvh1.parent_flex_value "Segment w/Overlapping Children", SUBSTR(fvh1.child_flex_value_low,1,30) "Overlapping Child Low Value", SUBSTR(fvh1.child_flex_value_high,1,30) "Overlapping Child High Value", SUBSTR(fvh2.child_flex_value_low,1,30) "Overlapped By Child Low Value", SUBSTR(fvh2.child_flex_value_high,1,30) "Overlapped By Child High Value" FROM fnd_flex_value_hierarchies fvh1, fnd_flex_value_hierarchies fvh2, (SELECT idfs.segment_num, idfs.flex_value_set_id, idfs.application_column_name, idfs.segment_name FROM gl_sets_of_books glsob, fnd_id_flex_segments idfs, fnd_flex_value_sets fvs WHERE glsob.chart_of_accounts_id = idfs.id_flex_num AND fvs.flex_value_set_id = idfs.flex_value_set_id AND glsob.set_of_books_id = 'G_PARAM' /*gsob.set_of_books_id*/ AND idfs.application_id = 101 AND idfs.id_flex_code = 'GL#') flexset WHERE fvh1.parent_flex_value = fvh2.parent_flex_value AND fvh1.flex_value_set_id = flexset.flex_value_set_id AND fvh1.rowid != fvh2.rowid AND fvh1.flex_value_set_id = fvh2.flex_value_set_id AND NVL(fvh2.CHILD_FLEX_VALUE_LOW,'X') <= NVL(fvh1.CHILD_FLEX_VALUE_HIGH,'X') AND NVL(fvh2.CHILD_FLEX_VALUE_HIGH,'X') >= NVL(fvh1.CHILD_FLEX_VALUE_LOW,'X') ORDER BY flexset.segment_numq~pppppppppppppppppppppppppx