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 AR Analysispt100tManualt1440t 1-JAN-1990tYsrjava.awt.Color3uFfalphaIvalueLcstLjava/awt/color/ColorSpace;[ frgbvaluet[F[fvalueq~xppppsq~pppsq~pppt1sr java.awt.Fontš5VsIfontSerializedDataVersionF pointSizeIsizeIstyleLfRequestedAttributestLjava/util/Hashtable;Lnameq~ xpA@ ptArialxsq~pppt18q~sq~Ӭpppsq~A@ ptArialxsq~33pppt dd-MMM-yyyyt#,###,###,##0.00tq0q~sq~A@ pq~xtNtappst No_PatterntVLETsq~pppq~t XXGL_FINANCEsrInfoPurple.DashboardSettings ඳc۬I currPletIdxI currQletIdxxp(tAuthor,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~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~wtmouseLq~zq~|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~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~&IxIyxpsrjava.awt.DimensionA׬_DIheightIwidthxp2dsq~uq~(tCurrencysrdbUtil.dbInstance ඳcLdbDriverq~ L dbPasswordq~ LdbURLq~ LdbUserq~ xpt* Oracle - oracle.jdbc.driver.OracleDrivertapps_devtlink-obyone:1525:DEVtappstALLtdistinct currency_codet'ID1't'ID1't'ID1't'ID1't'ID1'srInfoPurple.PletValue ඳcHL descriptionq~ L displayValueq~ Lid1q~ Lid2q~ Lid3q~ Lid4q~ Lid5q~ L internalValueq~ xpptUSDtID1tID1tID1tID1tID1psq~pppsq~pppsq~A@ ptArialxtappstNONEtPLETtp40tNq~DtAuthor,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~|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~mq~[wxq~[wxpq~[sq~uq~ ppppppppppxpppxppppppppppppppppxt*from gl_currencies where enabled_flag='Y' sq~sq~ Osq~"2sq~uq~(t Set of Booksq~(tALLtname t gsob.set_of_books_id tgsob.chart_of_accounts_id t%fav2.application_column_name Company t(fav3.application_column_name department t,fav1.application_column_name account_segmentsq~4pt Linksys USt1t50214tSEGMENT4tSEGMENT3tSEGMENT1psq~pppsq~pppsq~A@ ptArialxtappstNONEtPLETtp39tNq~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~|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~ ppppppppppxpppxppppppppppppppppxtQfrom 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~"2dsq~uq~(tBucketsq~(t100t bucket_namet bucket_daystb1tb2tb3tb4sq~4pt15 Dayst15t0 -- 15t15 -- 30t30 -- 45t45 -- 60psq~ffpppsq~pppsq~A@ ptArialxtappstNONEtPLETtp35tNtNtAuthor,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~|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~ ppppppppppxpppxppppppppppppppppxtNfrom ( select 'Week' bucket_name, 7 bucket_days, '0 -- 7' b1, '7 -- 14' b2 , '14 -- 21' b3, '21 -- 28' b4 from dual union select '15 Days' bucket_name, 15 bucket_days, '0 -- 15' b1, '15 -- 30' b2 , '30 -- 45' b3, '45 -- 60' b4 from dual union select 'Month' bucket_name, 30 bucket_days, '0 -- 30' b1, '30 -- 60' b2 , '60 -- 90' b3, '90 -- 120' b4 from dual union select '45 Days' bucket_name, 45 bucket_days, '0 -- 45' b1, '45 -- 90' b2 , '90 -- 135' b3, '135 -- 180' b4 from dual union select 'Quarter' bucket_name, 90 bucket_days, '0 -- 90' b1, '90 -- 180' b2 , '180 -- 270' b3, '270 -- 360' b4 from dual union select '180 Days' bucket_name, 180 bucket_days, '0 -- 180' b1, '180 -- 360' b2 , '360 -- 540' b3, '540 -- 720' b4 from dual union select 'Year' bucket_name, 365 bucket_days, 'Year1' b1, 'Year2' b2 , 'Year3' b3, 'Year4' b4 from dual )sq~sq~ msq~"2sq~uq~(tTransaction Typesq~(tALLtmeaningt lookup_codet'ID2't'ID3't'ID4't'ID5'sq~4pt ALL Valuest%q~q~q~tALLpq~q~sq~A@ pq~xtappstNONEtPLETtp36tYtNtAuthor,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~|q~0q~|q~1psq~}ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~9wtdefaultsq~sq~pxq~9wq~q~ 45 -- 60t75q~q~q~t1q~q~^tNAtNt ##########t dd-MMM-yyyytNsq~A@ pq~_xt > 45 -- 60tDEFAULTtYpppxsq~uq~ ppppppppppxq~Ppppppxsq~ sq~"Hsq~(uq~(t Outstanding Balance by Customersq~(t100tManualt1440t 1-JAN-1990tYq~q~q~t1q~^q~t18q~q~ q~!q~#q~$q~%tq98q~q~q~(tappst No_PatterntQLETq~,q~tXXDBNAMEt tAuthor,Description etctNt1tDEFAULTtYtNtNsq~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~|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 /*translate(initcap(customer_name),'abcdefghijklmnopqrstuvwxyz','efgabpcdefrgabcsdeftgaobcd') */ customer_name ,sum(amount_due_remaining) Overall_balance , sum(case when trunc( ( (sysdate-due_date)/ G_PARAM ) ) = 0 then amount_due_remaining end) "G_PARAM" ,sum(case when trunc( ( (sysdate-due_date)/ G_PARAM ) ) = 1 then amount_due_remaining end) "G_PARAM" ,sum(case when trunc( ( (sysdate-due_date)/ G_PARAM ) ) = 2 then amount_due_remaining end) "G_PARAM" ,sum(case when trunc( ( (sysdate-due_date)/ G_PARAM ) ) = 3 then amount_due_remaining end) "G_PARAM" ,sum(case when trunc( ( (sysdate-due_date)/ G_PARAM ) ) > 3 then amount_due_remaining end) "> G_PARAM" , customer_id from ( select aps.amount_due_remaining, aps.invoice_currency_code,aps.class,aps.customer_id,aps.cust_trx_type_id,aps.customer_trx_id ,aps.gl_date_closed,aps.amount_line_items_original,aps.amount_line_items_remaining,aps.amount_applied,aps.amount_adjusted, aps.amount_in_dispute, aps.amount_credited, aps.receivables_charges_charged ,aps.discount_taken_earned, aps.discount_taken_unearned, aps.dispute_date , al.meaning trx_type_desc ,aps.due_date , rc.customer_name from ar_payment_schedules_all aps , ra_customer_trx_all rct , ar_lookups al , ra_customers rc where aps.customer_trx_id= rct.customer_trx_id and rct.set_of_books_id = 'G_PARAM' /*gsob.set_of_books_id*/ and aps.invoice_currency_code= 'G_PARAM' /*distinctcurrency_code*/ and aps.class=al.lookup_code and aps.class like 'G_PARAM' /*lookup_code*/ and al.lookup_type='INV/CM/ADJ' and aps.status='OP' and aps.customer_id= rc.customer_id ) group by customer_name,customer_id order by 2 descq~srInfoPurple.Glet ඳcL GletLocationq~LGletSizeq~L colDetailsq~LgpValuesq~LqueryStrq~ xpsq~ sq~" psq~uq~(t-Top 10 Outstanding Balances by Customer Chartq~(t100tBartXtYtManualt1440sq~pppsq~A@ ptArialxsq~pppq~ tg113tNtappst No_PatterntGlett tYtYtVerticalt0tYsq~AptArialxt##.#tYtAUTOtAUTOtNsq~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~|q~-q~|q~.psq~}ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~6wtdefaultsq~sq~pxq~6wq~q~9xxxsq~ uq~ psq~?@wq~sq~ti18nsq~ttabSizesq~ xsq~pxsq~uq~ ppppppppppxsq~pq~5wxuq~sq~q~Gq~5wxq~5wxpq~5sq~uq~ ppppppppppxpppxt1pppppppppxtzselect * from ( select customer_name, sum( amount_due_remaining ) Balance_Due , customer_id from ( select aps.amount_due_remaining, aps.invoice_currency_code,aps.class,aps.customer_id,aps.cust_trx_type_id,aps.customer_trx_id ,aps.gl_date_closed,aps.amount_line_items_original,aps.amount_line_items_remaining,aps.amount_applied,aps.amount_adjusted, aps.amount_in_dispute, aps.amount_credited, aps.receivables_charges_charged ,aps.discount_taken_earned, aps.discount_taken_unearned, aps.dispute_date , al.meaning trx_type_desc ,aps.due_date , rc.customer_name from ar_payment_schedules_all aps , ra_customer_trx_all rct , ar_lookups al , ra_customers rc where aps.customer_trx_id= rct.customer_trx_id and rct.set_of_books_id = 'G_PARAM' /*gsob.set_of_books_id*/ and aps.invoice_currency_code= 'G_PARAM' /*distinctcurrency_code*/ and aps.class=al.lookup_code and aps.class like 'G_PARAM' /*lookup_code*/ and al.lookup_type='INV/CM/ADJ' and aps.status='OP' and aps.customer_id= rc.customer_id ) group by customer_name,customer_id order by 2 desc ) where rownum < 11sq~sq~ sq~"Bpsq~uq~(tSummary By Trx Type Chartq~(t100tPietXtYtManualt1440sq~pppsq~A@ ptArialxsq~pppq~Wq~q~tappst No_PatterntGlett tYtYtVerticalt0tYsq~AptArialxt##.#tYtAUTOtAUTOtNsq~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~|q~xq~|q~ypsq~}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 aps.class "Type",sum(aps.amount_due_remaining) Balance_by_Type from ar_payment_schedules_all aps , ra_customer_trx_all rct , ar_lookups al , ra_customers rc where aps.customer_trx_id= rct.customer_trx_id and rct.set_of_books_id = 'G_PARAM' /*gsob.set_of_books_id*/ and aps.invoice_currency_code= 'G_PARAM' /*distinctcurrency_code*/ and aps.class=al.lookup_code and aps.class like 'G_PARAM' /*lookup_code*/ and al.lookup_type='INV/CM/ADJ' and aps.status='OP' and aps.customer_id= rc.customer_id and aps.customer_id = param group by aps.classsq~sq~  dsq~"psq~uq~(tOpen Transactions Chartq~(t100tPietXtYtManualt1440sq~̙pppsq~A@ ptArialxsq~pppq~tg117q~tappst No_PatterntGlett tYtYtVerticalt0tYsq~AptArialxt##.#tYtAUTOtAUTOtNsq~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~|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 trx_type_desc Type, count(*) Open_Transactions from ( select aps.amount_due_remaining, aps.invoice_currency_code,aps.class,aps.customer_id,aps.cust_trx_type_id,aps.customer_trx_id ,aps.gl_date_closed,aps.amount_line_items_original,aps.amount_line_items_remaining,aps.amount_applied,aps.amount_adjusted, aps.amount_in_dispute, aps.amount_credited, aps.receivables_charges_charged ,aps.discount_taken_earned, aps.discount_taken_unearned, aps.dispute_date , al.meaning trx_type_desc ,aps.due_date from ar_payment_schedules_all aps , ra_customer_trx_all rct , ar_lookups al where aps.customer_trx_id= rct.customer_trx_id and rct.set_of_books_id = 'G_PARAM' /*gsob.set_of_books_id*/ and aps.invoice_currency_code= 'G_PARAM' /*distinctcurrency_code*/ and aps.class=al.lookup_code and aps.class like 'G_PARAM' /*lookup_code*/ and al.lookup_type='INV/CM/ADJ' and aps.status='OP' ) group by trx_type_descsq~sq~uq~ sq~Ssq~uq~tGL_DATE_CLOSEDt75q~sq~pppq~t1q~sq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyyq~dsq~A@ ptArialxtGL Date ClosedtDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~Ssq~uq~tCUSTOMER_TRX_IDt75q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~dsq~A@ ptArialxtCustomer Trx Id tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~Ssq~uq~tInfoCaptor Messaget450q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~dsq~A@ ptArialxtInfocaptor Message tDEFAULTtYpppxsq~uq~ ppppppppppxq~pppppppxsq~ sq~"sq~(uq~(tOutstanding Customer Detailsq~(t100tManualt1440t 1-JAN-1990tYq~q~q~t1q~q~t18q~'q~ q~!q~#q~$q~%q~q~sq~A@ pq~xtNtappst No_PatterntQLETq~,q~tXXDBNAMEt tAuthor,Description etctNt1tDEFAULTtYtNtNsq~78pq~Xsq~Ypq~8pxsq~\t Text Cursorpuq~_sq~asq~ew ?@q~ixsq~asq~ew ?@q~lxppq~nq~psq~qq~sq~tq~uppppppq~vsq~wq~vsq~wq~|q~Bq~|q~Cpsq~}ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~sq~pxq~Kwtdefaultsq~sq~pxq~Kwq~q~Nxxxsq~ uq~ psq~?@wq~sq~ti18nsq~ttabSizesq~ xsq~pxsq~uq~ ppppppppppxsq~pq~Jwxuq~sq~q~\q~Jwxq~Jwxpq~Jsq~uq~ ppppppppppxpppxtNxtsselect /*translate(initcap(rc.customer_name),'abcdefghijklmnopqrstuvwxyz','efgabpcdefrgabcsdeftgaobcd') */ customer_name ,aps.amount_due_remaining, aps.invoice_currency_code,aps.class,aps.customer_id,aps.cust_trx_type_id,aps.customer_trx_id ,aps.gl_date_closed,aps.amount_line_items_original,aps.amount_line_items_remaining,aps.amount_applied,aps.amount_adjusted, aps.amount_in_dispute, aps.amount_credited, aps.receivables_charges_charged ,aps.discount_taken_earned, aps.discount_taken_unearned, aps.dispute_date , al.meaning trx_type_desc ,aps.due_date from ar_payment_schedules_all aps , ra_customer_trx_all rct , ar_lookups al , ra_customers rc where aps.customer_trx_id= rct.customer_trx_id and rct.set_of_books_id = 'G_PARAM' /*gsob.set_of_books_id*/ and aps.invoice_currency_code= 'G_PARAM' /*distinctcurrency_code*/ and aps.class=al.lookup_code and aps.class like 'G_PARAM' /*lookup_code*/ and al.lookup_type='INV/CM/ADJ' and aps.status='OP' and aps.customer_id= rc.customer_id and aps.customer_id = param< Customer ID, 0> order by aps.due_date ascq~sq~sq~uq~ sq~Ssq~uq~tInfoCaptor Messaget251sq~pppsq~pppsq~pppt1q~lsq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyyq~dsq~A@ ptArialxtInfocaptor Message tDEFAULTtYpppxsq~uq~ ppppppppppxq~csq~Ssq~uq~tDUE_DATEt75q~kq~lq~mt1q~lq~otNAtNt ##########t dd-MMM-yyyyq~dsq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~csq~Ssq~uq~t 180 -- 360t75q~kq~lq~mt1q~lq~otNAtNt ##########t dd-MMM-yyyyq~dsq~A@ ptArialxt 180 -- 360 tDEFAULTtYpppxsq~uq~ ppppppppppxq~csq~Ssq~uq~t0 -- 180t75q~kq~lq~mt1q~lq~otNAtNt ##########t dd-MMM-yyyyq~dsq~A@ ptArialxt 0 -- 180 tDEFAULTtYpppxsq~uq~ ppppppppppxq~csq~Ssq~uq~t30 -- 60t75q~kq~lq~mt1q~lq~otNAtNt ##########t dd-MMM-yyyyq~dsq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~csq~Ssq~uq~tTYPEt75q~q~lq~t1q~lq~otNAtNt ##########t dd-MMM-yyyyq~dsq~A@ ptArialxtType tDEFAULTtYpppxsq~uq~ ppppppppppxq~cppppxsq~ 1sq~"Zsq~(uq~(tOpen Transaction Countq~(t10tManualt1440t 1-JAN-1990tYq~q~q~t1q~oq~t18q~q~ q~!q~#q~$q~%tq79q~sq~A@ pq~pxq~(tappst No_PatterntQLETq~,q~tXXDBNAMEq~tAuthor,Description etctNt1tDEFAULTtYtNtNsq~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~|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 trx_type_desc Type, sum(case when trunc( ( (sysdate-due_date)/ G_PARAM ) ) = 0 then 1 end) "G_PARAM" ,sum(case when trunc( ( (sysdate-due_date)/ G_PARAM ) ) = 1 then 1 end) "G_PARAM" ,sum(case when trunc( ( (sysdate-due_date)/ G_PARAM ) ) = 2 then 1 end) "G_PARAM" ,sum(case when trunc( ( (sysdate-due_date)/ G_PARAM ) ) = 3 then 1 end) "G_PARAM" ,sum(case when trunc( ( (sysdate-due_date)/ G_PARAM ) ) > 3 then 1 end) "> G_PARAM" from ( select aps.amount_due_remaining, aps.invoice_currency_code,aps.class,aps.customer_id,aps.cust_trx_type_id,aps.customer_trx_id ,aps.gl_date_closed,aps.amount_line_items_original,aps.amount_line_items_remaining,aps.amount_applied,aps.amount_adjusted, aps.amount_in_dispute, aps.amount_credited, aps.receivables_charges_charged ,aps.discount_taken_earned, aps.discount_taken_unearned, aps.dispute_date , al.meaning trx_type_desc ,aps.due_date from ar_payment_schedules_all aps , ra_customer_trx_all rct , ar_lookups al where aps.customer_trx_id= rct.customer_trx_id and rct.set_of_books_id = 'G_PARAM' /*gsob.set_of_books_id*/ and aps.invoice_currency_code= 'G_PARAM' /*distinctcurrency_code*/ and aps.class=al.lookup_code and aps.class like 'G_PARAM' /*lookup_code*/ and al.lookup_type='INV/CM/ADJ' and aps.status='OP' ) group by trx_type_descq~sq~sq~ uq~sq~Ssq~uq~tCUSTOMER_TRX_IDt73q~sq~pppq~t1q~sq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyyq~dsq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~Ssq~uq~t7 -- 14t75q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~dsq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~Ssq~uq~t 270 -- 360t86q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~dsq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~Ssq~uq~t0 -- 90t83q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~dsq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~Ssq~uq~t 90 -- 180t97q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~dsq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~Ssq~uq~t 180 -- 270t85q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~dsq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~Ssq~uq~t > 270 -- 360t75q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~dsq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~Ssq~uq~tYear1t105q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~dsq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~Ssq~uq~tYear2t88q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~dsq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~Ssq~uq~t 540 -- 720t75q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~dsq~A@ ptArialxt 540 -- 720 tDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~Ssq~uq~tInfoCaptor Messaget450q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~dsq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~Ssq~uq~t0 -- 180t75q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~dsq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~Ssq~uq~t0 -- 15t75q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~dsq~A@ ptArialxt0 -- 15tDEFAULTtYpppxsq~uq~ ppppppppppxq~pppppppxsq~ dsq~"sq~(uq~(t#Outstanding Balance by Transactionsq~(t100tManualt1440t 1-JAN-1990tYq~q~q~t1q~q~t18q~q~ q~!q~#q~$q~%tq62q~sq~A@ pq~ xq~(tappst No_PatterntQLETq~,q~tXXDBNAMEq~tAuthor,Description etctNt1tDEFAULTtYtNtNsq~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~|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~5q~#wxq~#wxpq~#sq~uq~ ppppppppppxpppxtNxtselect trx_type_desc Type, sum(case when trunc( ( (sysdate-due_date)/ G_PARAM ) ) = 0 then amount_due_remaining end) "G_PARAM" ,sum(case when trunc( ( (sysdate-due_date)/ G_PARAM ) ) = 1 then amount_due_remaining end) "G_PARAM" ,sum(case when trunc( ( (sysdate-due_date)/ G_PARAM ) ) = 2 then amount_due_remaining end) "G_PARAM" ,sum(case when trunc( ( (sysdate-due_date)/ G_PARAM ) ) = 3 then amount_due_remaining end) "G_PARAM" ,sum(case when trunc( ( (sysdate-due_date)/ G_PARAM ) ) > 3 then amount_due_remaining end) "> G_PARAM" from ( select aps.amount_due_remaining, aps.invoice_currency_code,aps.class,aps.customer_id,aps.cust_trx_type_id,aps.customer_trx_id ,aps.gl_date_closed,aps.amount_line_items_original,aps.amount_line_items_remaining,aps.amount_applied,aps.amount_adjusted, aps.amount_in_dispute, aps.amount_credited, aps.receivables_charges_charged ,aps.discount_taken_earned, aps.discount_taken_unearned, aps.dispute_date , al.meaning trx_type_desc ,aps.due_date from ar_payment_schedules_all aps , ra_customer_trx_all rct , ar_lookups al where aps.customer_trx_id= rct.customer_trx_id and rct.set_of_books_id = 'G_PARAM' /*gsob.set_of_books_id*/ and aps.invoice_currency_code= 'G_PARAM' /*distinctcurrency_code*/ and aps.class=al.lookup_code and aps.class like 'G_PARAM' /*lookup_code*/ and al.lookup_type='INV/CM/ADJ' and aps.status='OP' ) group by trx_type_descq~ppppppppppppppppppppppppppppx