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~(tPAtSelectt100tManualt1440t 1-JAN-1990tYsrjava.awt.Color3uFfalphaIvalueLcstLjava/awt/color/ColorSpace;[ frgbvaluet[F[fvalueq~xpfpppsq~pppsq~pppt1sr java.awt.Fontš5VsIfontSerializedDataVersionF pointSizeIsizeIstyleLfRequestedAttributestLjava/util/Hashtable;Lnameq~ xpA@ ptArialxsq~pppt18q~sq~3pppsq~A@ ptArialxsq~pppt dd-MMM-yyyyt #########tq0q~sq~A@ pq~xtNtappst No_PatterntVLETsq~pppsq~ppptXXPAsrInfoPurple.DashboardSettings ඳc۬I currPletIdxI currQletIdxxp'TtAuthor,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~FL 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~DL 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~VLpopupsq~LprefSizeq~xp8psr javax.swing.plaf.ColorUIResourcekSxq~pppsr java.beans.PropertyChangeSupportXdWH`I*propertyChangeSupportSerializedDataVersionLchildrenq~LsourcetLjava/lang/Object;xppq~Xpxsrjava.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~csq~gw ?@sq~i xppsrjavax.swing.plaf.FontUIResourceBć"Gxq~A0 ptTahomaxsq~Ypppsrjava.util.Locale~`0IhashcodeLcountryq~ Llanguageq~ Lvariantq~ xptUStentpppppptfocusLsr1javax.swing.text.JTextComponent$MutableCaretEventGY|IdotZ dragActiveImarkxrjavax.swing.event.CaretEvent [rVPxrjava.util.EventObjectL Nm}xpq~xsq~ytmouseLq~|q~~q~}psrjava.awt.ComponentOrientationEcI orientationxpppxur[Ljava.awt.Component; uxppppppxA(psrjavax.swing.ActionMapzLparentq~Exppwxppsrjavax.swing.InputMapf!ٟLparentq~Fxpsr#javax.swing.plaf.InputMapUIResourceHMכxq~sq~pw7sq~i&At selection-upsq~i'tcaret-next-wordsq~i%tselection-previous-wordsq~iAq~sq~i(t caret-downsq~iTtprevious-link-actionsq~i%tcaret-previous-wordsq~itcut-to-clipboardsq~i#tcaret-end-linesq~i!Atselection-page-upsq~itcaret-upsq~it delete-nextsq~i$t caret-beginsq~i%Atselection-backwardsq~i#t caret-endsq~itdelete-previoussq~i'tselection-next-wordsq~i%tcaret-backwardsq~iq~sq~iAtselection-forwardsq~i tactivate-link-actionsq~iHq~sq~i\tunselectsq~i t insert-breaksq~i$Atselection-begin-linesq~i't caret-forwardsq~i!tselection-page-leftsq~i(Atselection-downsq~i"t page-downsq~iAq~sq~iOttoggle-componentOrientationsq~iXq~sq~i"tselection-page-rightsq~iCtcopy-to-clipboardsq~iq~sq~i#Atselection-end-linesq~iq~sq~i$tcaret-begin-linesq~iVtpaste-from-clipboardsq~iq~sq~iAt select-allsq~i'Aq~sq~i#t selection-endsq~iq~sq~iq~sq~iTtnext-link-actionsq~iAq~sq~i t insert-tabsq~i&q~sq~i$tselection-beginsq~i"Atselection-page-downsq~iq~sq~iq~sq~i!tpage-upsq~iq~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~Ixpsrjavax.swing.text.StyleContexto~{xI unusedSetsLstylestLjavax/swing/text/Style;xpsr(javax.swing.text.StyleContext$NamedStyle NL listenerListq~ILthis$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~(tCurrencysrdbUtil.dbInstance ඳcLdbDriverq~ L dbPasswordq~ LdbURLq~ LdbUserq~ xpt* Oracle - oracle.jdbc.driver.OracleDrivertapps_devtlink-obyone:1525:DEVtappstALLt currency_codet'ID1't'ID2't'ID3't'ID4't'ID5'srInfoPurple.PletValue ඳcHL descriptionq~ L displayValueq~ Lid1q~ Lid2q~ Lid3q~ Lid4q~ Lid5q~ L internalValueq~ xpptUSDtID1tID2tID3tID4tID5psq~pppsq~pppsq~A@ ptArialxtappstNONEtPLETtp39tNq~FtAuthor,Description etctYt1tNsq~98pq~Zsq~[pq~Kpxsq~^t Text Cursorpuq~asq~csq~gw ?@q~kxsq~csq~gw ?@q~nxppq~pq~rsq~sq~uq~vq~wppppppq~xsq~yq~xsq~yq~~q~Uq~~q~Vpsq~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~pq~]wxuq~sq~q~oq~]wxq~]wxpq~]sq~uq~ ppppppppppxpppxppppppppppppppppxt)from gl_currencies where enabled_flag='Y'sq~ sq~"-sq~$2sq~uq~(tq~*tALLtSet User Contexttr.responsibility_idtr.application_idt'ID3't'ID4't'ID5'psq~ffpppsq~pppsq~A@ ptArialxtappstNONEtBLETtp33tNq~tAuthor,Description etctYt1tNsq~98pq~Zsq~[pq~pxsq~^t Text Cursorpuq~asq~csq~gw ?@q~kxsq~csq~gw ?@q~nxppq~pq~rsq~sq~uq~vq~wppppppq~xsq~yq~xsq~yq~~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{call fnd_global.APPS_INITIALIZE ( 'G_PARAM' /*user_id*/ , 'G_PARAM' /*r.responsibility_id*/ , 'G_PARAM' /*r.application_id*/ ) }sq~ sq~"Jsq~$2sq~uq~(tResponsibilityq~*tALLtr.responsibility_nametr.responsibility_idtr.application_idt'ID3't'ID4't'ID5'sq~6ptLinksys EMEA iExpense Usert51009t20003tID3tID4tID5psq~pppsq~pppsq~A@ ptArialxtappstNONEtPLETtp32tNq~tAuthor,Description etctYt1tNsq~98pq~Zsq~[pq~pxsq~^t Text Cursorpuq~asq~csq~gw ?@q~kxsq~csq~gw ?@q~nxppq~pq~rsq~sq~uq~vq~wppppppq~xsq~yq~xsq~yq~~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~ ppppppppppxpppxppppppppppppppppxtfrom fnd_user_resp_groups_direct ur , fnd_responsibility_vl r where ur.responsibility_id = r.responsibility_id and sysdate between ur.start_date and nvl(ur.end_date,sysdate) and ur.user_id = 'G_PARAM' /*user_id*/ sq~ sq~"s2sq~$2sq~uq~(t Project Typeq~*tALLt project_typetproject_type_idt'ID2't'ID3't'ID4't'ID5'sq~6tq~q~q~q~q~q~q~sq~pppsq~pppsq~A@ ptArialxtappstNONEtPLETtp38tNtYtAuthor,Description etctYt1tNsq~98pq~Zsq~[pq~!pxsq~^t Text Cursorpuq~asq~csq~gw ?@q~kxsq~csq~gw ?@q~nxppq~pq~rsq~sq~uq~vq~wppppppq~xsq~yq~xsq~yq~~q~+q~~q~,psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~4wtdefaultsq~sq~pxq~4wq~q~7xxxsq~ uq~ psq~?@wq~sq~ti18nsq~ttabSizesq~ xsq~pxsq~uq~ ppppppppppxsq~pq~3wxuq~sq~q~Eq~3wxq~3wxpq~3sq~uq~ ppppppppppxpppxppppppppppppppppxtfrom pa_project_types_allsq~ sq~"a2sq~$2ssq~uq~(tProject Statusq~*tALLtmeaningt lookup_codet'ID2't'ID3't'ID4't'ID5'sq~6pt ALL Valuest%q~Zq~Zq~ZtALLpsq~pppsq~pppsq~A@ ptArialxtappstNONEtPLETtp35q~tNtAuthor,Description etctYt1tNsq~98pq~Zsq~[pq~ipxsq~^t Text Cursorpuq~asq~csq~gw ?@q~kxsq~csq~gw ?@q~nxppq~pq~rsq~sq~uq~vq~wppppppq~xsq~yq~xsq~yq~~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~pq~{wxuq~sq~q~q~{wxq~{wxpq~{sq~uq~ ppppppppppxpppxppppppppppppppppxtNfrom pa_lookups where lookup_type='PROJECT_SYSTEM_STATUS' and enabled_flag='Y'sq~ sq~"1sq~$2sq~uq~(t Period Rangesq~*tALLt period_desct period_codet'ID2't'ID3't'ID4't'ID5'sq~6ptInception to datetITDtID2tID3tID4tID5psq~pppsq~pppsq~A@ ptArialxtappstNONEtPLETtp34tNq~tAuthor,Description etctYt1tNsq~98pq~Zsq~[pq~pxsq~^t Text Cursorpuq~asq~csq~gw ?@q~kxsq~csq~gw ?@q~nxppq~pq~rsq~sq~uq~vq~wppppppq~xsq~yq~xsq~yq~~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~ ppppppppppxpppxppppppppppppppppxt2from ( select 'Inception to date' period_desc, 'ITD' period_code from dual union all select 'Year to date' period_desc, 'YTD' period_code from dual union all select 'Prior GL or PA period' period_desc, 'PP' period_code from dual union all select 'Period to date' period_desc, 'PTD' period_code from dual ) sq~ sq~"2sq~$2dsq~uq~(t From Dateq~*tALLt to_char(sysdate-7,'DD-MON-YYYY')t'ID1't'ID2't'ID3't'ID4't'ID5'sq~6pt 20-JUL-2007tID1tID2tID3tID4tID5psq~pppsq~pppsq~A@ ptArialxtappstNONEtPLETtp36tNq~tAuthor,Description etctYt1tNsq~98pq~Zsq~[pq~pxsq~^t Text Cursorpuq~asq~csq~gw ?@q~kxsq~csq~gw ?@q~nxppq~pq~rsq~sq~uq~vq~wppppppq~xsq~yq~xsq~yq~~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 dualsq~ sq~";2sq~$2dsq~uq~(tTo Dateq~*tALLtto_char(sysdate,'DD-MON-YYYY')t'ID1't'ID2't'ID3't'ID4't'ID5'sq~6pt 27-JUL-2007tID1tID2tID3tID4tID5psq~pppsq~pppsq~A@ ptArialxtappstNONEtPLETtp37tNq~tAuthor,Description etctYt1tNsq~98pq~Zsq~[pq~Jpxsq~^t Text Cursorpuq~asq~csq~gw ?@q~kxsq~csq~gw ?@q~nxppq~pq~rsq~sq~uq~vq~wppppppq~xsq~yq~xsq~yq~~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~ ppppppppppxpppxppppppppppppppppxt from dualsq~ sq~"sq~$2sq~uq~(tUserq~*tALLt user_nametuser_idt'ID2't'ID3't'ID4't'ID5'sq~6ptZHAKLAYt4077tID2tID3tID4tID5pq~sq~pppsq~A@ ptArialxtappstNONEtPLETtp31tNq~tAuthor,Description etctYt1tNsq~98pq~Zsq~[pq~pxsq~^t Text Cursorpuq~asq~csq~gw ?@q~kxsq~csq~gw ?@q~nxppq~pq~rsq~sq~uq~vq~wppppppq~xsq~yq~xsq~yq~~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_user where sysdate between start_date and nvl(end_Date,sysdate) order by user_name descsrInfoPurple.Glet ඳcL GletLocationq~LGletSizeq~L colDetailsq~LgpValuesq~LqueryStrq~ xpsq~" sq~$fpsq~uq~(t$Project Actuals, Revenue, Cost Chartq~*t100tBartXtYtManualt1440sq~pppsq~A@ ptArialxsq~pppq~tg84q~tappst No_PatterntGlett tYtYtVerticalt0tYsq~AptArialxt##.#tYtAUTOtAUTOtNsq~98pq~Zsq~[pq~pxsq~^t Text Cursorpuq~asq~csq~gw ?@q~kxsq~csq~gw ?@q~nxppq~pq~rsq~sq~uq~vq~wppppppq~xsq~yq~xsq~yq~~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~ ppppppppppxpppxt1pppppppppxtselect p.name project ,sum(v.RAW_COST_G_PARAM) RAW_COST ,sum(v.BILLABLE_RAW_COST_G_PARAM ) BILLABLE_RAW_COST ,sum(v.BURDENED_COST_G_PARAM ) BURDENED_COST ,sum(v.BILLABLE_BURDENED_COST_G_PARAM ) BILLABLE_BURDENED_COST ,sum(v.ACTUALS_QUANTITY_G_PARAM ) ACTUALS_QUANTITY ,sum(v.BILLABLE_QUANTITY_G_PARAM ) BILLABLE_QUANTITY ,sum(v.ACTUALS_LABOR_HOURS_G_PARAM ) ACTUALS_LABOR_HOURS ,sum(v.BILLABLE_LABOR_HOURS_G_PARAM ) BILLABLE_LABOR_HOURS ,sum(v.REVENUE_G_PARAM ) REVENUE , p.project_id from PA_ACCUM_RSRC_ACT_V v , pa_projects_all p where p.project_id= v.project_id and v.task_id=0 and p.project_currency_code = 'G_PARAM' /*currency_code*/ --and p.start_date between to_date('G_PARAM','DD-MON-YYYY') and to_date('G_PARAM','DD-MON-YYYY') --and p.project_status_code like 'G_PARAM' /*lookup_code*/ and p.project_type like 'G_PARAM' /*project_type*/ and p.project_id = param group by p.name,p.project_idsq~sq~uq~ srInfoPurple.ColumnPropertyValues ඳcٸL colPropValuesq~L drillValuesq~L parentQlettLInfoPurple/Qlet;xpsq~uq~tInfoCaptor Messaget450sq~pppsq~pppsq~pppt1q~sq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyytYsq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~ pppppppppxsq~"sq~$sq~(uq~(t More Detailsq~*t100tManualt1440t 1-JAN-1990tYq~q~q~t1q~q~t18q~0q~!q~"q~$t dd-MMM-yyyyt #########tq67q~sq~A@ pq~xq~)tappst No_PatterntQLETsq~pppq~tXXDBNAMEt tAuthor,Description etctNt1tDEFAULTtYtNtNsq~98pq~Zsq~[pq~Dpxsq~^t Text Cursorpuq~asq~csq~gw ?@q~kxsq~csq~gw ?@q~nxppq~pq~rsq~sq~uq~vq~wppppppq~xsq~yq~xsq~yq~~q~Nq~~q~Opsq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~Wwtdefaultsq~sq~pxq~Wwq~q~Zxxxsq~ uq~ psq~?@wq~sq~ti18nsq~ttabSizesq~ xsq~pxsq~uq~ ppppppppppxsq~pq~Vwxuq~sq~q~hq~Vwxq~Vwxpq~Vsq~uq~ ppppppppppxpppxtNxtSselect * from param where project_id = paramq~sq~sq~uq~ sq~sq~uq~tInfoCaptor Messaget450sq~pppsq~pppsq~pppt1q~xsq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxtInfocaptor MessagetDEFAULTtYpppxsq~uq~ ppppppppppxq~opppppppppxsq~"Fsq~$sq~(uq~(tCross Charge Exceptionsq~*t100tManualt1440t 1-JAN-1990tYq~q~wq~yt1q~{q~xt18q~sq~pppsq~A@ pq~|xq~$t dd-MMM-yyyyt #########tq79q~xsq~A@ pq~|xq~)tappst No_PatterntQLETsq~pppq~xtXXDBNAMEq~tAuthor,Description etctNt1tDEFAULTtYtNtNsq~98pq~Zsq~[pq~pxsq~^t Text Cursorpuq~asq~csq~gw ?@q~kxsq~csq~gw ?@q~nxppq~pq~rsq~sq~uq~vq~wppppppq~xsq~yq~xsq~yq~~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~ ppppppppppxpppxtNxt$select * from PA_CC_EXCEPTIONS_DET_Vq~)sq~sq~uq~ sq~sq~uq~tPROJECT_NUMBERt94sq~pppsq~pppsq~pppt1q~sq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxtProject Number tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tEXCEPTION_REASONt223q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxtException Reason tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tCORRECTIVE_ACTIONt418q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxtCorrective Action tDEFAULTtYpppxsq~uq~ ppppppppppxq~pppppppxsq~"usq~$sq~(uq~(tInvoice Exceptionsq~*t100tManualt1440t 1-JAN-1990tYq~q~q~t1q~q~t18q~sq~pppsq~A@ pq~xq~$t dd-MMM-yyyyt #########tq78q~sq~A@ pq~xq~)tappst No_PatterntQLETsq~pppq~tXXDBNAMEq~tAuthor,Description etctNt1tDEFAULTtYtNtNsq~98pq~Zsq~[pq~*pxsq~^t Text Cursorpuq~asq~csq~gw ?@q~kxsq~csq~gw ?@q~nxppq~pq~rsq~sq~uq~vq~wppppppq~xsq~yq~xsq~yq~~q~4q~~q~5psq~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~) RAW_COST ,sum(v.BILLABLE_RAW_COST_G_PARAM ) BILLABLE_RAW_COST ,sum(v.BURDENED_COST_G_PARAM ) BURDENED_COST ,sum(v.BILLABLE_BURDENED_COST_G_PARAM ) BILLABLE_BURDENED_COST ,sum(v.ACTUALS_QUANTITY_G_PARAM ) ACTUALS_QUANTITY ,sum(v.BILLABLE_QUANTITY_G_PARAM ) BILLABLE_QUANTITY ,sum(v.ACTUALS_LABOR_HOURS_G_PARAM ) ACTUALS_LABOR_HOURS ,sum(v.BILLABLE_LABOR_HOURS_G_PARAM ) BILLABLE_LABOR_HOURS ,sum(v.REVENUE_G_PARAM ) REVENUE , p.project_id from PA_ACCUM_RSRC_ACT_V v , pa_projects_all p where p.project_id= v.project_id and v.task_id=0 and p.project_currency_code = 'G_PARAM' /*currency_code*/ --and p.start_date between to_date('G_PARAM','DD-MON-YYYY') and to_date('G_PARAM','DD-MON-YYYY') --and p.project_status_code like 'G_PARAM' /*lookup_code*/ and p.project_type like 'G_PARAM' /*project_type*/ group by p.name,p.project_idq~)sq~sq~uq~sq~sq~uq~tNAMEt232sq~pppsq~pppsq~pppt1q~[sq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Rsq~sq~uq~tCARRYING_OUT_ORGANIZATION_IDt137q~Zq~[q~\t1q~[q~^tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Rsq~sq~uq~tPROJECT_STATUS_CODEt137q~Zq~[q~\t1q~[q~^tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Rsq~sq~uq~tDISTRIBUTION_RULEt118q~Zq~[q~\t1q~[q~^tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Rsq~sq~uq~tUNBILLED_RECEIVABLE_DRt123q~Zq~[q~\t1q~[q~^tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Rsq~sq~uq~tRESPONSIBILITY_APPLICATION_IDt167q~Zq~[q~\t1q~[q~^tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Rsq~sq~uq~tRESPONSIBILITY_IDt150q~Zq~[q~\t1q~[q~^tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Rsq~sq~uq~q~t450q~Zq~[q~\t1q~[q~^tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxtInfocaptor Message tDEFAULTtYpppxsq~uq~ ppppppppppxq~Rsq~sq~uq~t PROJECT_TYPEt168q~Zq~[q~\t1q~[q~^tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Rsq~sq~uq~tCOMPLETION_DATEt109q~Zq~[q~\t1q~[q~^tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Rsq~sq~uq~tSCHEDULED_START_DATEt141q~Zq~[q~\t1q~[q~^tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Rsq~sq~uq~tSPLIT_COST_FROM_WORKPLAN_FLAGt196q~Zq~[q~\t1q~[q~^tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Rsq~sq~uq~t LONG_NAMEt113q~Zq~[q~\t1q~[q~^tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Rsq~sq~uq~tSEGMENT1t166q~Zq~[q~\t1q~[q~^tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Rsq~sq~uq~tLABOR_INVOICE_FORMAT_IDt175q~Zq~[q~\t1q~[q~^tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Rsq~sq~uq~tPROJECT_CURRENCY_CODEt156q~Zq~[q~\t1q~[q~^tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Rsq~sq~uq~tORGANIZATION_NAMEt137q~Zq~[q~\t1q~[q~^tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Rsq~sq~uq~t MANAGER_NAMEt127q~Zq~[q~\t1q~[q~^tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Rsq~sq~uq~t PROJECT_ROLEt119q~Zq~[q~\t1q~[q~^tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Rsq~sq~uq~t PROJECT_NAMEt216q~Zq~[q~\t1q~[q~^tNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ sq~sq~uq~ tPA_PROJ_WBS_VIEW t PROJECT_IDppppppppxtBreakdown Structureq~5sq~sq~uq~ tPA_GL_COST_XFER_AUDIT_Vq~ppppppppxtCost Trx Journal Detailsq~5sq~sq~uq~ tPA_GL_REV_XFER_AUDIT_Vq~ppppppppxtRevenue Trx Journal Detailsq~5sq~sq~uq~ tPA_PROJECT_INVOICE_VIEWq~ppppppppxtReleased Invoicesq~5sq~sq~uq~ tPA_PROJ_ADJUSTMENTS_VIEWq~ppppppppxtExpenditure Item Adjustmentsq~5sq~sq~uq~ tPA_PROJ_BILLING_STATUS_VIEWq~ppppppppxtProject Billing Statusq~5sq~sq~uq~ tPA_PROJ_EVENTS_VIEWq~ppppppppxtProject Event Detailsq~5sq~sq~uq~ tPA_PROJ_MEMBERS_VIEWq~ppppppppxtProject Membersq~5ppxq~Rxsq~"sq~$sq~(uq~(tProject Detailsq~*t100tManualt1440t 1-JAN-1990tYq~q~q~t1q~^q~[t18q~q~!q~"q~$t dd-MMM-yyyyq~&tq31q~[sq~A@ pq~_xq~)tappst No_PatterntQLETq~:q~[tXXDBNAMEq~tAuthor,Description etctNt1tDEFAULTtYtNtNsq~98pq~Zsq~[pq~pxsq~^t Text Cursorpuq~asq~csq~gw ?@q~kxsq~csq~gw ?@q~nxppq~pq~rsq~sq~uq~vq~wppppppq~xsq~yq~xsq~yq~~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 PA_PROJ_INFO_VIEWq~)ppppppppppppppppppppppppx