eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_CMGT_DATA_POINTS_PKG dependencies on FND_NUMBER

Line 383: p_data_point_value => fnd_number.number_to_canonical(l_deduction_amount),

379: -- Now call build case folder to insert into case folder details
380: build_case_folder_details(
381: p_case_folder_id => p_case_folder_id,
382: p_data_point_id => 211, -- deduction amount
383: p_data_point_value => fnd_number.number_to_canonical(l_deduction_amount),
384: p_mode => p_mode,
385: p_error_msg => p_error_msg,
386: p_resultout => p_resultout);
387: IF p_resultout <> 0

Line 851: p_data_point_value => fnd_number.number_to_canonical(l_final_inv_amount),

847:
848: build_case_folder_details(
849: p_case_folder_id => p_case_folder_id,
850: p_data_point_id => 19,
851: p_data_point_value => fnd_number.number_to_canonical(l_final_inv_amount),
852: p_mode => p_mode,
853: p_error_msg => p_errormsg ,
854: p_resultout => p_resultout);
855: build_case_folder_details(

Line 865: p_data_point_value => fnd_number.number_to_canonical(l_final_high_watermark),

861: p_resultout => p_resultout);
862: build_case_folder_details(
863: p_case_folder_id => p_case_folder_id,
864: p_data_point_id => 6,
865: p_data_point_value => fnd_number.number_to_canonical(l_final_high_watermark),
866: p_mode => p_mode,
867: p_error_msg => p_errormsg ,
868: p_resultout => p_resultout);
869: build_case_folder_details(

Line 1026: p_data_point_value => fnd_number.number_to_canonical(l_last_payment_amount_conv),

1022: END IF;
1023: build_case_folder_details(
1024: p_case_folder_id => p_case_folder_id,
1025: p_data_point_id => 11,
1026: p_data_point_value => fnd_number.number_to_canonical(l_last_payment_amount_conv),
1027: p_mode => p_mode,
1028: p_error_msg => p_errormsg ,
1029: p_resultout => p_resultout);
1030: build_case_folder_details(

Line 1033: p_data_point_value => fnd_number.number_to_canonical(l_last_payment_amount),

1029: p_resultout => p_resultout);
1030: build_case_folder_details(
1031: p_case_folder_id => p_case_folder_id,
1032: p_data_point_id => 207,
1033: p_data_point_value => fnd_number.number_to_canonical(l_last_payment_amount),
1034: p_mode => p_mode,
1035: p_error_msg => p_errormsg ,
1036: p_resultout => p_resultout);
1037: build_case_folder_details(

Line 1449: p_data_point_value => fnd_number.number_to_canonical((l_total_exposure - l_ar_cmount)),

1445:
1446: build_case_folder_details(
1447: p_case_folder_id => p_case_folder_id,
1448: p_data_point_id => 15,
1449: p_data_point_value => fnd_number.number_to_canonical((l_total_exposure - l_ar_cmount)),
1450: p_mode => p_mode,
1451: p_error_msg => l_errmsg,
1452: p_resultout => l_resultout);
1453:

Line 1457: p_data_point_value => fnd_number.number_to_canonical(l_order_hold_amount),

1453:
1454: build_case_folder_details(
1455: p_case_folder_id => p_case_folder_id,
1456: p_data_point_id => 26,
1457: p_data_point_value => fnd_number.number_to_canonical(l_order_hold_amount),
1458: p_mode => p_mode,
1459: p_error_msg => l_errmsg,
1460: p_resultout => l_resultout);
1461:

Line 1467: NVL(fnd_number.canonical_to_number(RecBalRec.data_point_value),0);

1463: /* 9560367 - Added value back into itself.. the loop didnt make sense before! */
1464: FOR RecBalRec IN RecBalC
1465: LOOP
1466: l_rec_bal := l_rec_bal +
1467: NVL(fnd_number.canonical_to_number(RecBalRec.data_point_value),0);
1468: END LOOP;
1469:
1470: l_credit_exposure :=
1471: nvl(l_rec_bal,0) + (nvl(l_total_exposure,0) - nvl(l_ar_cmount,0)) +

Line 1477: p_data_point_value => fnd_number.number_to_canonical(l_credit_exposure),

1473:
1474: build_case_folder_details(
1475: p_case_folder_id => p_case_folder_id,
1476: p_data_point_id => 213,
1477: p_data_point_value => fnd_number.number_to_canonical(l_credit_exposure),
1478: p_mode => p_mode,
1479: p_error_msg => l_errmsg,
1480: p_resultout => l_resultout);
1481: ELSE

Line 1750: p_data_point_value => fnd_number.number_to_canonical(l_cash),

1746: p_resultout => p_resultout);
1747: build_case_folder_details(
1748: p_case_folder_id => p_case_folder_id,
1749: p_data_point_id => 113,
1750: p_data_point_value => fnd_number.number_to_canonical(l_cash),
1751: p_mode => p_mode,
1752: p_error_msg => p_errmsg,
1753: p_resultout => p_resultout);
1754: build_case_folder_details(

Line 1757: p_data_point_value => fnd_number.number_to_canonical(l_net_receivables),

1753: p_resultout => p_resultout);
1754: build_case_folder_details(
1755: p_case_folder_id => p_case_folder_id,
1756: p_data_point_id => 114,
1757: p_data_point_value => fnd_number.number_to_canonical(l_net_receivables),
1758: p_mode => p_mode,
1759: p_error_msg => p_errmsg,
1760: p_resultout => p_resultout);
1761: build_case_folder_details(

Line 1764: p_data_point_value => fnd_number.number_to_canonical(l_inventories),

1760: p_resultout => p_resultout);
1761: build_case_folder_details(
1762: p_case_folder_id => p_case_folder_id,
1763: p_data_point_id => 115,
1764: p_data_point_value => fnd_number.number_to_canonical(l_inventories),
1765: p_mode => p_mode,
1766: p_error_msg => p_errmsg,
1767: p_resultout => p_resultout);
1768: build_case_folder_details(

Line 1771: p_data_point_value => fnd_number.number_to_canonical(l_other_cur_assets),

1767: p_resultout => p_resultout);
1768: build_case_folder_details(
1769: p_case_folder_id => p_case_folder_id,
1770: p_data_point_id => 116,
1771: p_data_point_value => fnd_number.number_to_canonical(l_other_cur_assets),
1772: p_mode => p_mode,
1773: p_error_msg => p_errmsg,
1774: p_resultout => p_resultout);
1775: build_case_folder_details(

Line 1778: p_data_point_value => fnd_number.number_to_canonical(l_total_cur_assets),

1774: p_resultout => p_resultout);
1775: build_case_folder_details(
1776: p_case_folder_id => p_case_folder_id,
1777: p_data_point_id => 117,
1778: p_data_point_value => fnd_number.number_to_canonical(l_total_cur_assets),
1779: p_mode => p_mode,
1780: p_error_msg => p_errmsg,
1781: p_resultout => p_resultout);
1782: build_case_folder_details(

Line 1785: p_data_point_value => fnd_number.number_to_canonical(l_net_fixed_assets),

1781: p_resultout => p_resultout);
1782: build_case_folder_details(
1783: p_case_folder_id => p_case_folder_id,
1784: p_data_point_id => 118,
1785: p_data_point_value => fnd_number.number_to_canonical(l_net_fixed_assets),
1786: p_mode => p_mode,
1787: p_error_msg => p_errmsg,
1788: p_resultout => p_resultout);
1789: build_case_folder_details(

Line 1792: p_data_point_value => fnd_number.number_to_canonical(l_other_non_cur_assets),

1788: p_resultout => p_resultout);
1789: build_case_folder_details(
1790: p_case_folder_id => p_case_folder_id,
1791: p_data_point_id => 119,
1792: p_data_point_value => fnd_number.number_to_canonical(l_other_non_cur_assets),
1793: p_mode => p_mode,
1794: p_error_msg => p_errmsg,
1795: p_resultout => p_resultout);
1796: build_case_folder_details(

Line 1799: p_data_point_value => fnd_number.number_to_canonical(l_total_assets),

1795: p_resultout => p_resultout);
1796: build_case_folder_details(
1797: p_case_folder_id => p_case_folder_id,
1798: p_data_point_id => 120,
1799: p_data_point_value => fnd_number.number_to_canonical(l_total_assets),
1800: p_mode => p_mode,
1801: p_error_msg => p_errmsg,
1802: p_resultout => p_resultout);
1803: build_case_folder_details(

Line 1806: p_data_point_value => fnd_number.number_to_canonical(l_accounts_payable),

1802: p_resultout => p_resultout);
1803: build_case_folder_details(
1804: p_case_folder_id => p_case_folder_id,
1805: p_data_point_id => 121,
1806: p_data_point_value => fnd_number.number_to_canonical(l_accounts_payable),
1807: p_mode => p_mode,
1808: p_error_msg => p_errmsg,
1809: p_resultout => p_resultout);
1810: build_case_folder_details(

Line 1813: p_data_point_value => fnd_number.number_to_canonical(l_short_term_debt),

1809: p_resultout => p_resultout);
1810: build_case_folder_details(
1811: p_case_folder_id => p_case_folder_id,
1812: p_data_point_id => 122,
1813: p_data_point_value => fnd_number.number_to_canonical(l_short_term_debt),
1814: p_mode => p_mode,
1815: p_error_msg => p_errmsg,
1816: p_resultout => p_resultout);
1817: build_case_folder_details(

Line 1820: p_data_point_value => fnd_number.number_to_canonical(l_other_cur_liabilities),

1816: p_resultout => p_resultout);
1817: build_case_folder_details(
1818: p_case_folder_id => p_case_folder_id,
1819: p_data_point_id => 123,
1820: p_data_point_value => fnd_number.number_to_canonical(l_other_cur_liabilities),
1821: p_mode => p_mode,
1822: p_error_msg => p_errmsg,
1823: p_resultout => p_resultout);
1824: build_case_folder_details(

Line 1827: p_data_point_value => fnd_number.number_to_canonical(l_total_cur_liabilities),

1823: p_resultout => p_resultout);
1824: build_case_folder_details(
1825: p_case_folder_id => p_case_folder_id,
1826: p_data_point_id => 124,
1827: p_data_point_value => fnd_number.number_to_canonical(l_total_cur_liabilities),
1828: p_mode => p_mode,
1829: p_error_msg => p_errmsg,
1830: p_resultout => p_resultout);
1831: build_case_folder_details(

Line 1834: p_data_point_value => fnd_number.number_to_canonical(l_long_term_debt),

1830: p_resultout => p_resultout);
1831: build_case_folder_details(
1832: p_case_folder_id => p_case_folder_id,
1833: p_data_point_id => 125,
1834: p_data_point_value => fnd_number.number_to_canonical(l_long_term_debt),
1835: p_mode => p_mode,
1836: p_error_msg => p_errmsg,
1837: p_resultout => p_resultout);
1838: build_case_folder_details(

Line 1841: p_data_point_value => fnd_number.number_to_canonical(l_other_non_cur_liabilities),

1837: p_resultout => p_resultout);
1838: build_case_folder_details(
1839: p_case_folder_id => p_case_folder_id,
1840: p_data_point_id => 126,
1841: p_data_point_value => fnd_number.number_to_canonical(l_other_non_cur_liabilities),
1842: p_mode => p_mode,
1843: p_error_msg => p_errmsg,
1844: p_resultout => p_resultout);
1845: build_case_folder_details(

Line 1848: p_data_point_value => fnd_number.number_to_canonical(l_total_liabilities),

1844: p_resultout => p_resultout);
1845: build_case_folder_details(
1846: p_case_folder_id => p_case_folder_id,
1847: p_data_point_id => 127,
1848: p_data_point_value => fnd_number.number_to_canonical(l_total_liabilities),
1849: p_mode => p_mode,
1850: p_error_msg => p_errmsg,
1851: p_resultout => p_resultout);
1852: build_case_folder_details(

Line 1855: p_data_point_value => fnd_number.number_to_canonical(l_stockholder_equity),

1851: p_resultout => p_resultout);
1852: build_case_folder_details(
1853: p_case_folder_id => p_case_folder_id,
1854: p_data_point_id => 128,
1855: p_data_point_value => fnd_number.number_to_canonical(l_stockholder_equity),
1856: p_mode => p_mode,
1857: p_error_msg => p_errmsg,
1858: p_resultout => p_resultout);
1859: build_case_folder_details(

Line 1862: p_data_point_value => fnd_number.number_to_canonical(l_total_liabilities_equity),

1858: p_resultout => p_resultout);
1859: build_case_folder_details(
1860: p_case_folder_id => p_case_folder_id,
1861: p_data_point_id => 129,
1862: p_data_point_value => fnd_number.number_to_canonical(l_total_liabilities_equity),
1863: p_mode => p_mode,
1864: p_error_msg => p_errmsg,
1865: p_resultout => p_resultout);
1866: build_case_folder_details(

Line 1869: p_data_point_value => fnd_number.number_to_canonical(l_revenue),

1865: p_resultout => p_resultout);
1866: build_case_folder_details(
1867: p_case_folder_id => p_case_folder_id,
1868: p_data_point_id => 130,
1869: p_data_point_value => fnd_number.number_to_canonical(l_revenue),
1870: p_mode => p_mode,
1871: p_error_msg => p_errmsg,
1872: p_resultout => p_resultout);
1873: build_case_folder_details(

Line 1876: p_data_point_value => fnd_number.number_to_canonical(l_cost_of_goods_sold),

1872: p_resultout => p_resultout);
1873: build_case_folder_details(
1874: p_case_folder_id => p_case_folder_id,
1875: p_data_point_id => 131,
1876: p_data_point_value => fnd_number.number_to_canonical(l_cost_of_goods_sold),
1877: p_mode => p_mode,
1878: p_error_msg => p_errmsg,
1879: p_resultout => p_resultout);
1880: build_case_folder_details(

Line 1883: p_data_point_value => fnd_number.number_to_canonical(l_sga_expenses),

1879: p_resultout => p_resultout);
1880: build_case_folder_details(
1881: p_case_folder_id => p_case_folder_id,
1882: p_data_point_id => 132,
1883: p_data_point_value => fnd_number.number_to_canonical(l_sga_expenses),
1884: p_mode => p_mode,
1885: p_error_msg => p_errmsg,
1886: p_resultout => p_resultout);
1887: build_case_folder_details(

Line 1890: p_data_point_value => fnd_number.number_to_canonical(l_operating_income),

1886: p_resultout => p_resultout);
1887: build_case_folder_details(
1888: p_case_folder_id => p_case_folder_id,
1889: p_data_point_id => 133,
1890: p_data_point_value => fnd_number.number_to_canonical(l_operating_income),
1891: p_mode => p_mode,
1892: p_error_msg => p_errmsg,
1893: p_resultout => p_resultout);
1894: build_case_folder_details(

Line 1897: p_data_point_value => fnd_number.number_to_canonical(l_operating_margin),

1893: p_resultout => p_resultout);
1894: build_case_folder_details(
1895: p_case_folder_id => p_case_folder_id,
1896: p_data_point_id => 134,
1897: p_data_point_value => fnd_number.number_to_canonical(l_operating_margin),
1898: p_mode => p_mode,
1899: p_error_msg => p_errmsg,
1900: p_resultout => p_resultout);
1901: build_case_folder_details(

Line 1904: p_data_point_value => fnd_number.number_to_canonical(l_non_operating_income),

1900: p_resultout => p_resultout);
1901: build_case_folder_details(
1902: p_case_folder_id => p_case_folder_id,
1903: p_data_point_id => 135,
1904: p_data_point_value => fnd_number.number_to_canonical(l_non_operating_income),
1905: p_mode => p_mode,
1906: p_error_msg => p_errmsg,
1907: p_resultout => p_resultout);
1908: build_case_folder_details(

Line 1911: p_data_point_value => fnd_number.number_to_canonical(l_non_operating_expenses),

1907: p_resultout => p_resultout);
1908: build_case_folder_details(
1909: p_case_folder_id => p_case_folder_id,
1910: p_data_point_id => 136,
1911: p_data_point_value => fnd_number.number_to_canonical(l_non_operating_expenses),
1912: p_mode => p_mode,
1913: p_error_msg => p_errmsg,
1914: p_resultout => p_resultout);
1915: build_case_folder_details(

Line 1918: p_data_point_value => fnd_number.number_to_canonical(l_pre_tax_net_income),

1914: p_resultout => p_resultout);
1915: build_case_folder_details(
1916: p_case_folder_id => p_case_folder_id,
1917: p_data_point_id => 137,
1918: p_data_point_value => fnd_number.number_to_canonical(l_pre_tax_net_income),
1919: p_mode => p_mode,
1920: p_error_msg => p_errmsg,
1921: p_resultout => p_resultout);
1922: build_case_folder_details(

Line 1925: p_data_point_value => fnd_number.number_to_canonical(l_income_taxes),

1921: p_resultout => p_resultout);
1922: build_case_folder_details(
1923: p_case_folder_id => p_case_folder_id,
1924: p_data_point_id => 138,
1925: p_data_point_value => fnd_number.number_to_canonical(l_income_taxes),
1926: p_mode => p_mode,
1927: p_error_msg => p_errmsg,
1928: p_resultout => p_resultout);
1929: build_case_folder_details(

Line 1932: p_data_point_value => fnd_number.number_to_canonical(l_net_income),

1928: p_resultout => p_resultout);
1929: build_case_folder_details(
1930: p_case_folder_id => p_case_folder_id,
1931: p_data_point_id => 139,
1932: p_data_point_value => fnd_number.number_to_canonical(l_net_income),
1933: p_mode => p_mode,
1934: p_error_msg => p_errmsg,
1935: p_resultout => p_resultout);
1936: build_case_folder_details(

Line 1939: p_data_point_value => fnd_number.number_to_canonical(l_earnings_per_share),

1935: p_resultout => p_resultout);
1936: build_case_folder_details(
1937: p_case_folder_id => p_case_folder_id,
1938: p_data_point_id => 140,
1939: p_data_point_value => fnd_number.number_to_canonical(l_earnings_per_share),
1940: p_mode => p_mode,
1941: p_error_msg => p_errmsg,
1942: p_resultout => p_resultout);
1943: IF pg_wf_debug = 'Y'

Line 2028: p_data_point_value => fnd_number.number_to_canonical(c_hz_cust_prof_amts_rec.trx_credit_limit),

2024: LOOP
2025: build_case_folder_details(
2026: p_case_folder_id => p_case_folder_id,
2027: p_data_point_id => 95,
2028: p_data_point_value => fnd_number.number_to_canonical(c_hz_cust_prof_amts_rec.trx_credit_limit),
2029: p_mode => p_mode,
2030: p_error_msg => l_errmsg,
2031: p_resultout => l_resultout);
2032:

Line 2036: p_data_point_value => fnd_number.number_to_canonical(c_hz_cust_prof_amts_rec.overall_credit_limit),

2032:
2033: build_case_folder_details(
2034: p_case_folder_id => p_case_folder_id,
2035: p_data_point_id => 96,
2036: p_data_point_value => fnd_number.number_to_canonical(c_hz_cust_prof_amts_rec.overall_credit_limit),
2037: p_mode => p_mode,
2038: p_error_msg => l_errmsg,
2039: p_resultout => l_resultout);
2040: exit;

Line 2125: p_data_point_value => fnd_number.number_to_canonical(c_credit_requests_rec.current_stock_price),

2121: p_resultout => l_resultout);
2122: build_case_folder_details(
2123: p_case_folder_id => p_case_folder_id,
2124: p_data_point_id => 98,
2125: p_data_point_value => fnd_number.number_to_canonical(c_credit_requests_rec.current_stock_price),
2126: p_mode => p_mode,
2127: p_error_msg => l_errmsg,
2128: p_resultout => l_resultout);
2129: build_case_folder_details(

Line 2132: p_data_point_value => fnd_number.number_to_canonical(c_credit_requests_rec.market_capitalization),

2128: p_resultout => l_resultout);
2129: build_case_folder_details(
2130: p_case_folder_id => p_case_folder_id,
2131: p_data_point_id => 99,
2132: p_data_point_value => fnd_number.number_to_canonical(c_credit_requests_rec.market_capitalization),
2133: p_mode => p_mode,
2134: p_error_msg => l_errmsg,
2135: p_resultout => l_resultout);
2136: build_case_folder_details(

Line 2139: p_data_point_value => fnd_number.number_to_canonical(c_credit_requests_rec.requested_amount),

2135: p_resultout => l_resultout);
2136: build_case_folder_details(
2137: p_case_folder_id => p_case_folder_id,
2138: p_data_point_id => 108,
2139: p_data_point_value => fnd_number.number_to_canonical(c_credit_requests_rec.requested_amount),
2140: p_mode => p_mode,
2141: p_error_msg => l_errmsg,
2142: p_resultout => l_resultout);
2143: build_case_folder_details(

Line 2184: p_data_point_value => fnd_number.number_to_canonical(c_case_folder_score_rec.score),

2180: LOOP
2181: build_case_folder_details(
2182: p_case_folder_id => p_case_folder_id,
2183: p_data_point_id => 30, -- last calculated credit score
2184: p_data_point_value => fnd_number.number_to_canonical(c_case_folder_score_rec.score),
2185: p_mode => p_mode,
2186: p_error_msg => l_errmsg,
2187: p_resultout => l_resultout);
2188: exit;

Line 4759: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,

4755: -- bug fixes 2824382.
4756: ********************************************************************/
4757: CURSOR c_party_summary IS
4758: SELECT
4759: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
4760: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4761: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4762: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4763: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,

Line 4760: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,

4756: ********************************************************************/
4757: CURSOR c_party_summary IS
4758: SELECT
4759: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
4760: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4761: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4762: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4763: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4764: '21'||'^'||fnd_number.number_to_canonical(

Line 4761: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,

4757: CURSOR c_party_summary IS
4758: SELECT
4759: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
4760: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4761: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4762: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4763: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4764: '21'||'^'||fnd_number.number_to_canonical(
4765: ROUND((SUM(x_tot_inv_inst_paid)-

Line 4762: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,

4758: SELECT
4759: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
4760: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4761: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4762: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4763: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4764: '21'||'^'||fnd_number.number_to_canonical(
4765: ROUND((SUM(x_tot_inv_inst_paid)-
4766: SUM(x_tot_inv_inst_paid_late)) * 100 /

Line 4763: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,

4759: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
4760: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4761: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4762: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4763: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4764: '21'||'^'||fnd_number.number_to_canonical(
4765: ROUND((SUM(x_tot_inv_inst_paid)-
4766: SUM(x_tot_inv_inst_paid_late)) * 100 /
4767: DECODE(SUM(x_tot_inv_inst_paid),0,1,SUM(x_tot_inv_inst_paid)),2)

Line 4764: '21'||'^'||fnd_number.number_to_canonical(

4760: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4761: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4762: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4763: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4764: '21'||'^'||fnd_number.number_to_canonical(
4765: ROUND((SUM(x_tot_inv_inst_paid)-
4766: SUM(x_tot_inv_inst_paid_late)) * 100 /
4767: DECODE(SUM(x_tot_inv_inst_paid),0,1,SUM(x_tot_inv_inst_paid)),2)
4768: ) per_inv_paid_promptly,

Line 4769: '22'||'^'||fnd_number.number_to_canonical(

4765: ROUND((SUM(x_tot_inv_inst_paid)-
4766: SUM(x_tot_inv_inst_paid_late)) * 100 /
4767: DECODE(SUM(x_tot_inv_inst_paid),0,1,SUM(x_tot_inv_inst_paid)),2)
4768: ) per_inv_paid_promptly,
4769: '22'||'^'||fnd_number.number_to_canonical(
4770: ROUND((SUM(x_tot_inv_inst_paid_late)) * 100 /
4771: DECODE(SUM(x_tot_inv_inst_paid),0,1,SUM(x_tot_inv_inst_paid)),2)
4772: ) per_inv_paid_late,
4773: '23'||'^'||fnd_number.number_to_canonical(

Line 4773: '23'||'^'||fnd_number.number_to_canonical(

4769: '22'||'^'||fnd_number.number_to_canonical(
4770: ROUND((SUM(x_tot_inv_inst_paid_late)) * 100 /
4771: DECODE(SUM(x_tot_inv_inst_paid),0,1,SUM(x_tot_inv_inst_paid)),2)
4772: ) per_inv_paid_late,
4773: '23'||'^'||fnd_number.number_to_canonical(
4774: ROUND((SUM(x_tot_disc_inv_inst)) * 100 /
4775: DECODE(SUM(x_tot_inv_inst_paid),0,1,SUM(x_tot_inv_inst_paid)),2)
4776: ) per_inv_with_discount,
4777: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,

Line 4777: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,

4773: '23'||'^'||fnd_number.number_to_canonical(
4774: ROUND((SUM(x_tot_disc_inv_inst)) * 100 /
4775: DECODE(SUM(x_tot_inv_inst_paid),0,1,SUM(x_tot_inv_inst_paid)),2)
4776: ) per_inv_with_discount,
4777: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4778: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4779: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4780: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4781: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,

Line 4778: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,

4774: ROUND((SUM(x_tot_disc_inv_inst)) * 100 /
4775: DECODE(SUM(x_tot_inv_inst_paid),0,1,SUM(x_tot_inv_inst_paid)),2)
4776: ) per_inv_with_discount,
4777: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4778: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4779: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4780: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4781: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4782: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,

Line 4779: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,

4775: DECODE(SUM(x_tot_inv_inst_paid),0,1,SUM(x_tot_inv_inst_paid)),2)
4776: ) per_inv_with_discount,
4777: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4778: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4779: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4780: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4781: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4782: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4783: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,

Line 4780: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,

4776: ) per_inv_with_discount,
4777: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4778: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4779: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4780: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4781: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4782: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4783: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4784: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,

Line 4781: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,

4777: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4778: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4779: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4780: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4781: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4782: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4783: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4784: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4785: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,

Line 4782: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,

4778: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4779: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4780: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4781: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4782: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4783: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4784: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4785: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4786: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,

Line 4783: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,

4779: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4780: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4781: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4782: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4783: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4784: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4785: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4786: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4787: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,

Line 4784: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,

4780: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4781: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4782: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4783: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4784: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4785: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4786: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4787: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4788: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,

Line 4785: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,

4781: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4782: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4783: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4784: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4785: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4786: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4787: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4788: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4789: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,

Line 4786: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,

4782: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4783: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4784: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4785: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4786: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4787: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4788: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4789: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4790: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,

Line 4787: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,

4783: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4784: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4785: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4786: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4787: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4788: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4789: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4790: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4791: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,

Line 4788: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,

4784: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4785: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4786: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4787: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4788: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4789: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4790: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4791: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4792: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,

Line 4789: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,

4785: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4786: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4787: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4788: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4789: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4790: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4791: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4792: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4793: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,

Line 4790: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,

4786: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4787: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4788: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4789: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4790: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4791: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4792: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4793: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4794: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,

Line 4791: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,

4787: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4788: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4789: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4790: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4791: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4792: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4793: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4794: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
4795: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,

Line 4792: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,

4788: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4789: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4790: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4791: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4792: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4793: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4794: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
4795: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,
4796: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count

Line 4793: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,

4789: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4790: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4791: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4792: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4793: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4794: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
4795: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,
4796: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count
4797: FROM ( SELECT

Line 4794: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,

4790: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4791: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4792: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4793: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4794: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
4795: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,
4796: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count
4797: FROM ( SELECT
4798: round(SUM(NVL(DAYS_CREDIT_GRANTED_SUM,0))/

Line 4795: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,

4791: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4792: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4793: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4794: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
4795: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,
4796: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count
4797: FROM ( SELECT
4798: round(SUM(NVL(DAYS_CREDIT_GRANTED_SUM,0))/
4799: decode(SUM(NVL(TOTAL_INVOICES_VALUE,0)),0,1,

Line 4796: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count

4792: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4793: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4794: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
4795: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,
4796: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count
4797: FROM ( SELECT
4798: round(SUM(NVL(DAYS_CREDIT_GRANTED_SUM,0))/
4799: decode(SUM(NVL(TOTAL_INVOICES_VALUE,0)),0,1,
4800: SUM(NVL(TOTAL_INVOICES_VALUE,0))),2) days_credit_granted, -- days credit granted

Line 4903: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,

4899:
4900:
4901: CURSOR c_account_summary IS
4902: SELECT
4903: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
4904: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4905: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4906: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4907: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,

Line 4904: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,

4900:
4901: CURSOR c_account_summary IS
4902: SELECT
4903: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
4904: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4905: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4906: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4907: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4908: '21'||'^'||fnd_number.number_to_canonical(

Line 4905: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,

4901: CURSOR c_account_summary IS
4902: SELECT
4903: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
4904: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4905: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4906: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4907: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4908: '21'||'^'||fnd_number.number_to_canonical(
4909: ROUND((SUM(x_tot_inv_inst_paid)-

Line 4906: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,

4902: SELECT
4903: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
4904: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4905: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4906: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4907: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4908: '21'||'^'||fnd_number.number_to_canonical(
4909: ROUND((SUM(x_tot_inv_inst_paid)-
4910: SUM(x_tot_inv_inst_paid_late)) * 100 /

Line 4907: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,

4903: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
4904: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4905: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4906: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4907: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4908: '21'||'^'||fnd_number.number_to_canonical(
4909: ROUND((SUM(x_tot_inv_inst_paid)-
4910: SUM(x_tot_inv_inst_paid_late)) * 100 /
4911: DECODE(SUM(x_tot_inv_inst_paid),0,1,SUM(x_tot_inv_inst_paid)),2)

Line 4908: '21'||'^'||fnd_number.number_to_canonical(

4904: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4905: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4906: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4907: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4908: '21'||'^'||fnd_number.number_to_canonical(
4909: ROUND((SUM(x_tot_inv_inst_paid)-
4910: SUM(x_tot_inv_inst_paid_late)) * 100 /
4911: DECODE(SUM(x_tot_inv_inst_paid),0,1,SUM(x_tot_inv_inst_paid)),2)
4912: ) per_inv_paid_promptly,

Line 4913: '22'||'^'||fnd_number.number_to_canonical(

4909: ROUND((SUM(x_tot_inv_inst_paid)-
4910: SUM(x_tot_inv_inst_paid_late)) * 100 /
4911: DECODE(SUM(x_tot_inv_inst_paid),0,1,SUM(x_tot_inv_inst_paid)),2)
4912: ) per_inv_paid_promptly,
4913: '22'||'^'||fnd_number.number_to_canonical(
4914: ROUND((SUM(x_tot_inv_inst_paid_late)) * 100 /
4915: DECODE(SUM(x_tot_inv_inst_paid),0,1,SUM(x_tot_inv_inst_paid)),2)
4916: ) per_inv_paid_late,
4917: '23'||'^'||fnd_number.number_to_canonical(

Line 4917: '23'||'^'||fnd_number.number_to_canonical(

4913: '22'||'^'||fnd_number.number_to_canonical(
4914: ROUND((SUM(x_tot_inv_inst_paid_late)) * 100 /
4915: DECODE(SUM(x_tot_inv_inst_paid),0,1,SUM(x_tot_inv_inst_paid)),2)
4916: ) per_inv_paid_late,
4917: '23'||'^'||fnd_number.number_to_canonical(
4918: ROUND((SUM(x_tot_disc_inv_inst)) * 100 /
4919: DECODE(SUM(x_tot_inv_inst_paid),0,1,SUM(x_tot_inv_inst_paid)),2)
4920: ) per_inv_with_discount,
4921: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,

Line 4921: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,

4917: '23'||'^'||fnd_number.number_to_canonical(
4918: ROUND((SUM(x_tot_disc_inv_inst)) * 100 /
4919: DECODE(SUM(x_tot_inv_inst_paid),0,1,SUM(x_tot_inv_inst_paid)),2)
4920: ) per_inv_with_discount,
4921: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4922: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4923: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4924: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4925: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,

Line 4922: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,

4918: ROUND((SUM(x_tot_disc_inv_inst)) * 100 /
4919: DECODE(SUM(x_tot_inv_inst_paid),0,1,SUM(x_tot_inv_inst_paid)),2)
4920: ) per_inv_with_discount,
4921: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4922: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4923: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4924: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4925: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4926: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,

Line 4923: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,

4919: DECODE(SUM(x_tot_inv_inst_paid),0,1,SUM(x_tot_inv_inst_paid)),2)
4920: ) per_inv_with_discount,
4921: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4922: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4923: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4924: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4925: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4926: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4927: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,

Line 4924: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,

4920: ) per_inv_with_discount,
4921: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4922: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4923: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4924: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4925: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4926: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4927: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4928: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,

Line 4925: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,

4921: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4922: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4923: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4924: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4925: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4926: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4927: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4928: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4929: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,

Line 4926: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,

4922: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4923: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4924: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4925: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4926: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4927: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4928: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4929: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4930: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,

Line 4927: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,

4923: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4924: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4925: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4926: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4927: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4928: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4929: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4930: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4931: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,

Line 4928: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,

4924: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4925: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4926: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4927: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4928: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4929: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4930: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4931: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4932: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,

Line 4929: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,

4925: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4926: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4927: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4928: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4929: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4930: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4931: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4932: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4933: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,

Line 4930: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,

4926: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4927: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4928: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4929: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4930: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4931: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4932: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4933: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4934: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,

Line 4931: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,

4927: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4928: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4929: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4930: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4931: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4932: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4933: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4934: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4935: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,

Line 4932: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,

4928: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4929: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4930: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4931: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4932: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4933: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4934: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4935: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4936: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,

Line 4933: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,

4929: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4930: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4931: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4932: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4933: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4934: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4935: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4936: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4937: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,

Line 4934: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,

4930: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4931: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4932: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4933: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4934: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4935: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4936: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4937: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4938: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,

Line 4935: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,

4931: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4932: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4933: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4934: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4935: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4936: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4937: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4938: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
4939: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,

Line 4936: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,

4932: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4933: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4934: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4935: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4936: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4937: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4938: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
4939: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,
4940: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count

Line 4937: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,

4933: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4934: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4935: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4936: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4937: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4938: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
4939: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,
4940: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count
4941: FROM ( SELECT

Line 4938: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,

4934: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4935: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4936: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4937: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4938: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
4939: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,
4940: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count
4941: FROM ( SELECT
4942: round(SUM(NVL(DAYS_CREDIT_GRANTED_SUM,0))/

Line 4939: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,

4935: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4936: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4937: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4938: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
4939: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,
4940: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count
4941: FROM ( SELECT
4942: round(SUM(NVL(DAYS_CREDIT_GRANTED_SUM,0))/
4943: decode(SUM(NVL(TOTAL_INVOICES_VALUE,0)),0,1,

Line 4940: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count

4936: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4937: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4938: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
4939: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,
4940: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count
4941: FROM ( SELECT
4942: round(SUM(NVL(DAYS_CREDIT_GRANTED_SUM,0))/
4943: decode(SUM(NVL(TOTAL_INVOICES_VALUE,0)),0,1,
4944: SUM(NVL(TOTAL_INVOICES_VALUE,0))),2) days_credit_granted, -- days credit granted

Line 5024: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,

5020: group by currency );
5021:
5022: CURSOR c_site_summary IS
5023: SELECT
5024: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
5025: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
5026: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
5027: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
5028: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,

Line 5025: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,

5021:
5022: CURSOR c_site_summary IS
5023: SELECT
5024: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
5025: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
5026: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
5027: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
5028: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
5029: '21'||'^'||fnd_number.number_to_canonical(

Line 5026: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,

5022: CURSOR c_site_summary IS
5023: SELECT
5024: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
5025: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
5026: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
5027: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
5028: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
5029: '21'||'^'||fnd_number.number_to_canonical(
5030: ROUND((SUM(x_tot_inv_inst_paid)-

Line 5027: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,

5023: SELECT
5024: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
5025: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
5026: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
5027: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
5028: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
5029: '21'||'^'||fnd_number.number_to_canonical(
5030: ROUND((SUM(x_tot_inv_inst_paid)-
5031: SUM(x_tot_inv_inst_paid_late)) * 100 /

Line 5028: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,

5024: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
5025: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
5026: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
5027: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
5028: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
5029: '21'||'^'||fnd_number.number_to_canonical(
5030: ROUND((SUM(x_tot_inv_inst_paid)-
5031: SUM(x_tot_inv_inst_paid_late)) * 100 /
5032: DECODE(SUM(x_tot_inv_inst_paid),0,1,SUM(x_tot_inv_inst_paid)),2)

Line 5029: '21'||'^'||fnd_number.number_to_canonical(

5025: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
5026: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
5027: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
5028: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
5029: '21'||'^'||fnd_number.number_to_canonical(
5030: ROUND((SUM(x_tot_inv_inst_paid)-
5031: SUM(x_tot_inv_inst_paid_late)) * 100 /
5032: DECODE(SUM(x_tot_inv_inst_paid),0,1,SUM(x_tot_inv_inst_paid)),2)
5033: ) per_inv_paid_promptly,

Line 5034: '22'||'^'||fnd_number.number_to_canonical(

5030: ROUND((SUM(x_tot_inv_inst_paid)-
5031: SUM(x_tot_inv_inst_paid_late)) * 100 /
5032: DECODE(SUM(x_tot_inv_inst_paid),0,1,SUM(x_tot_inv_inst_paid)),2)
5033: ) per_inv_paid_promptly,
5034: '22'||'^'||fnd_number.number_to_canonical(
5035: ROUND((SUM(x_tot_inv_inst_paid_late)) * 100 /
5036: DECODE(SUM(x_tot_inv_inst_paid),0,1,SUM(x_tot_inv_inst_paid)),2)
5037: ) per_inv_paid_late,
5038: '23'||'^'||fnd_number.number_to_canonical(

Line 5038: '23'||'^'||fnd_number.number_to_canonical(

5034: '22'||'^'||fnd_number.number_to_canonical(
5035: ROUND((SUM(x_tot_inv_inst_paid_late)) * 100 /
5036: DECODE(SUM(x_tot_inv_inst_paid),0,1,SUM(x_tot_inv_inst_paid)),2)
5037: ) per_inv_paid_late,
5038: '23'||'^'||fnd_number.number_to_canonical(
5039: ROUND((SUM(x_tot_disc_inv_inst)) * 100 /
5040: DECODE(SUM(x_tot_inv_inst_paid),0,1,SUM(x_tot_inv_inst_paid)),2)
5041: ) per_inv_with_discount,
5042: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,

Line 5042: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,

5038: '23'||'^'||fnd_number.number_to_canonical(
5039: ROUND((SUM(x_tot_disc_inv_inst)) * 100 /
5040: DECODE(SUM(x_tot_inv_inst_paid),0,1,SUM(x_tot_inv_inst_paid)),2)
5041: ) per_inv_with_discount,
5042: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
5043: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
5044: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
5045: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
5046: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,

Line 5043: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,

5039: ROUND((SUM(x_tot_disc_inv_inst)) * 100 /
5040: DECODE(SUM(x_tot_inv_inst_paid),0,1,SUM(x_tot_inv_inst_paid)),2)
5041: ) per_inv_with_discount,
5042: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
5043: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
5044: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
5045: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
5046: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
5047: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,

Line 5044: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,

5040: DECODE(SUM(x_tot_inv_inst_paid),0,1,SUM(x_tot_inv_inst_paid)),2)
5041: ) per_inv_with_discount,
5042: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
5043: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
5044: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
5045: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
5046: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
5047: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
5048: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,

Line 5045: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,

5041: ) per_inv_with_discount,
5042: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
5043: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
5044: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
5045: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
5046: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
5047: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
5048: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
5049: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,

Line 5046: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,

5042: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
5043: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
5044: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
5045: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
5046: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
5047: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
5048: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
5049: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
5050: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,

Line 5047: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,

5043: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
5044: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
5045: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
5046: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
5047: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
5048: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
5049: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
5050: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
5051: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,

Line 5048: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,

5044: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
5045: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
5046: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
5047: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
5048: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
5049: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
5050: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
5051: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
5052: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,

Line 5049: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,

5045: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
5046: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
5047: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
5048: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
5049: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
5050: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
5051: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
5052: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
5053: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,

Line 5050: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,

5046: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
5047: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
5048: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
5049: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
5050: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
5051: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
5052: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
5053: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
5054: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,

Line 5051: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,

5047: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
5048: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
5049: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
5050: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
5051: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
5052: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
5053: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
5054: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
5055: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,

Line 5052: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,

5048: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
5049: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
5050: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
5051: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
5052: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
5053: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
5054: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
5055: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
5056: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,

Line 5053: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,

5049: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
5050: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
5051: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
5052: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
5053: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
5054: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
5055: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
5056: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
5057: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,

Line 5054: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,

5050: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
5051: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
5052: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
5053: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
5054: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
5055: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
5056: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
5057: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
5058: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,

Line 5055: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,

5051: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
5052: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
5053: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
5054: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
5055: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
5056: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
5057: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
5058: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
5059: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,

Line 5056: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,

5052: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
5053: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
5054: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
5055: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
5056: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
5057: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
5058: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
5059: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
5060: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,

Line 5057: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,

5053: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
5054: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
5055: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
5056: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
5057: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
5058: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
5059: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
5060: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,
5061: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count

Line 5058: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,

5054: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
5055: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
5056: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
5057: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
5058: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
5059: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
5060: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,
5061: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count
5062: FROM ( SELECT

Line 5059: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,

5055: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
5056: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
5057: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
5058: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
5059: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
5060: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,
5061: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count
5062: FROM ( SELECT
5063: round(SUM(NVL(DAYS_CREDIT_GRANTED_SUM,0))/

Line 5060: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,

5056: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
5057: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
5058: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
5059: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
5060: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,
5061: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count
5062: FROM ( SELECT
5063: round(SUM(NVL(DAYS_CREDIT_GRANTED_SUM,0))/
5064: decode(SUM(NVL(TOTAL_INVOICES_VALUE,0)),0,1,

Line 5061: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count

5057: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
5058: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
5059: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
5060: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,
5061: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count
5062: FROM ( SELECT
5063: round(SUM(NVL(DAYS_CREDIT_GRANTED_SUM,0))/
5064: decode(SUM(NVL(TOTAL_INVOICES_VALUE,0)),0,1,
5065: SUM(NVL(TOTAL_INVOICES_VALUE,0))),2) days_credit_granted, -- days credit granted

Line 5149: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,

5145: -- if you are adding/removing an column in this cursor please
5146: -- update the bal_summary_rec_col_count varibale with proper number.
5147: ********************************************************************/
5148: CURSOR c_party_bal_summary IS
5149: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,
5150: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5151: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5152: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5153: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,

Line 5150: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount

5146: -- update the bal_summary_rec_col_count varibale with proper number.
5147: ********************************************************************/
5148: CURSOR c_party_bal_summary IS
5149: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,
5150: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5151: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5152: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5153: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5154: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,

Line 5151: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count

5147: ********************************************************************/
5148: CURSOR c_party_bal_summary IS
5149: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,
5150: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5151: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5152: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5153: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5154: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5155: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,

Line 5152: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,

5148: CURSOR c_party_bal_summary IS
5149: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,
5150: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5151: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5152: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5153: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5154: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5155: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5156: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,

Line 5153: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,

5149: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,
5150: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5151: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5152: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5153: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5154: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5155: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5156: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5157: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,

Line 5154: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,

5150: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5151: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5152: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5153: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5154: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5155: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5156: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5157: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5158: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,

Line 5155: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,

5151: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5152: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5153: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5154: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5155: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5156: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5157: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5158: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5159: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,

Line 5156: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,

5152: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5153: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5154: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5155: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5156: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5157: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5158: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5159: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5160: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,

Line 5157: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,

5153: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5154: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5155: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5156: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5157: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5158: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5159: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5160: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5161: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,

Line 5158: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,

5154: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5155: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5156: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5157: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5158: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5159: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5160: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5161: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5162: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,

Line 5159: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,

5155: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5156: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5157: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5158: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5159: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5160: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5161: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5162: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5163: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,

Line 5160: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,

5156: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5157: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5158: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5159: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5160: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5161: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5162: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5163: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5164: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,

Line 5161: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,

5157: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5158: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5159: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5160: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5161: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5162: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5163: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5164: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5165: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,

Line 5162: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,

5158: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5159: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5160: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5161: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5162: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5163: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5164: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5165: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5166: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,

Line 5163: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,

5159: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5160: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5161: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5162: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5163: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5164: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5165: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5166: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5167: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,

Line 5164: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,

5160: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5161: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5162: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5163: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5164: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5165: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5166: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5167: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5168: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,

Line 5165: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,

5161: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5162: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5163: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5164: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5165: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5166: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5167: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5168: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5169: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,

Line 5166: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,

5162: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5163: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5164: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5165: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5166: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5167: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5168: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5169: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5170: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,

Line 5167: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,

5163: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5164: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5165: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5166: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5167: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5168: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5169: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5170: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,
5171: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count

Line 5168: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,

5164: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5165: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5166: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5167: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5168: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5169: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5170: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,
5171: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count
5172: FROM (

Line 5169: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,

5165: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5166: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5167: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5168: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5169: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5170: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,
5171: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count
5172: FROM (
5173: SELECT

Line 5170: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,

5166: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5167: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5168: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5169: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5170: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,
5171: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count
5172: FROM (
5173: SELECT
5174: gl_currency_api.convert_amount(currency,

Line 5171: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count

5167: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5168: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5169: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5170: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,
5171: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count
5172: FROM (
5173: SELECT
5174: gl_currency_api.convert_amount(currency,
5175: l_limit_currency,sysdate,

Line 5271: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,

5267: group by currency);
5268:
5269:
5270: CURSOR c_account_bal_summary IS
5271: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,
5272: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5273: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5274: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5275: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,

Line 5272: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount

5268:
5269:
5270: CURSOR c_account_bal_summary IS
5271: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,
5272: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5273: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5274: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5275: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5276: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,

Line 5273: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count

5269:
5270: CURSOR c_account_bal_summary IS
5271: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,
5272: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5273: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5274: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5275: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5276: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5277: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,

Line 5274: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,

5270: CURSOR c_account_bal_summary IS
5271: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,
5272: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5273: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5274: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5275: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5276: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5277: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5278: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,

Line 5275: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,

5271: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,
5272: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5273: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5274: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5275: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5276: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5277: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5278: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5279: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,

Line 5276: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,

5272: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5273: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5274: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5275: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5276: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5277: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5278: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5279: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5280: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,

Line 5277: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,

5273: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5274: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5275: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5276: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5277: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5278: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5279: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5280: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5281: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,

Line 5278: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,

5274: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5275: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5276: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5277: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5278: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5279: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5280: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5281: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5282: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,

Line 5279: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,

5275: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5276: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5277: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5278: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5279: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5280: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5281: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5282: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5283: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,

Line 5280: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,

5276: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5277: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5278: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5279: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5280: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5281: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5282: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5283: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5284: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,

Line 5281: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,

5277: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5278: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5279: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5280: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5281: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5282: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5283: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5284: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5285: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,

Line 5282: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,

5278: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5279: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5280: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5281: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5282: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5283: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5284: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5285: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5286: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,

Line 5283: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,

5279: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5280: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5281: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5282: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5283: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5284: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5285: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5286: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5287: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,

Line 5284: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,

5280: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5281: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5282: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5283: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5284: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5285: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5286: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5287: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5288: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,

Line 5285: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,

5281: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5282: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5283: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5284: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5285: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5286: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5287: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5288: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5289: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,

Line 5286: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,

5282: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5283: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5284: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5285: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5286: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5287: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5288: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5289: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5290: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,

Line 5287: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,

5283: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5284: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5285: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5286: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5287: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5288: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5289: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5290: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5291: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,

Line 5288: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,

5284: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5285: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5286: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5287: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5288: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5289: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5290: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5291: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5292: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,

Line 5289: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,

5285: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5286: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5287: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5288: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5289: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5290: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5291: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5292: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,
5293: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count

Line 5290: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,

5286: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5287: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5288: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5289: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5290: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5291: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5292: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,
5293: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count
5294: FROM (

Line 5291: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,

5287: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5288: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5289: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5290: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5291: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5292: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,
5293: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count
5294: FROM (
5295: SELECT

Line 5292: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,

5288: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5289: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5290: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5291: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5292: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,
5293: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count
5294: FROM (
5295: SELECT
5296: gl_currency_api.convert_amount(currency,

Line 5293: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count

5289: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5290: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5291: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5292: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,
5293: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count
5294: FROM (
5295: SELECT
5296: gl_currency_api.convert_amount(currency,
5297: l_limit_currency,sysdate,

Line 5375: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,

5371: --and site_use_id = decode(l_analysis_level,'S',p_cust_acct_site_id,site_use_id)
5372: group by currency);
5373:
5374: CURSOR c_site_bal_summary IS
5375: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,
5376: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5377: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5378: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5379: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,

Line 5376: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount

5372: group by currency);
5373:
5374: CURSOR c_site_bal_summary IS
5375: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,
5376: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5377: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5378: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5379: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5380: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,

Line 5377: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count

5373:
5374: CURSOR c_site_bal_summary IS
5375: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,
5376: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5377: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5378: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5379: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5380: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5381: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,

Line 5378: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,

5374: CURSOR c_site_bal_summary IS
5375: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,
5376: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5377: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5378: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5379: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5380: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5381: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5382: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,

Line 5379: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,

5375: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,
5376: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5377: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5378: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5379: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5380: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5381: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5382: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5383: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,

Line 5380: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,

5376: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5377: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5378: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5379: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5380: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5381: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5382: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5383: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5384: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,

Line 5381: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,

5377: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5378: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5379: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5380: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5381: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5382: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5383: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5384: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5385: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,

Line 5382: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,

5378: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5379: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5380: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5381: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5382: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5383: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5384: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5385: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5386: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,

Line 5383: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,

5379: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5380: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5381: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5382: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5383: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5384: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5385: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5386: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5387: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,

Line 5384: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,

5380: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5381: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5382: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5383: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5384: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5385: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5386: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5387: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5388: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,

Line 5385: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,

5381: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5382: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5383: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5384: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5385: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5386: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5387: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5388: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5389: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,

Line 5386: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,

5382: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5383: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5384: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5385: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5386: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5387: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5388: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5389: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5390: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,

Line 5387: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,

5383: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5384: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5385: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5386: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5387: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5388: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5389: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5390: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5391: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,

Line 5388: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,

5384: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5385: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5386: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5387: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5388: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5389: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5390: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5391: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5392: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,

Line 5389: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,

5385: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5386: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5387: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5388: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5389: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5390: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5391: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5392: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5393: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,

Line 5390: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,

5386: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5387: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5388: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5389: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5390: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5391: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5392: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5393: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5394: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,

Line 5391: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,

5387: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5388: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5389: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5390: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5391: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5392: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5393: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5394: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5395: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,

Line 5392: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,

5388: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5389: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5390: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5391: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5392: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5393: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5394: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5395: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5396: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,

Line 5393: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,

5389: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5390: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5391: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5392: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5393: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5394: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5395: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5396: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,
5397: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count

Line 5394: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,

5390: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5391: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5392: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5393: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5394: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5395: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5396: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,
5397: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count
5398: FROM (

Line 5395: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,

5391: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5392: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5393: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5394: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5395: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5396: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,
5397: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count
5398: FROM (
5399: SELECT

Line 5396: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,

5392: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5393: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5394: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5395: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5396: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,
5397: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count
5398: FROM (
5399: SELECT
5400: gl_currency_api.convert_amount(currency,

Line 5397: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count

5393: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5394: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5395: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5396: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,
5397: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count
5398: FROM (
5399: SELECT
5400: gl_currency_api.convert_amount(currency,
5401: l_limit_currency,sysdate,

Line 6458: fnd_number.number_to_canonical(l_dso),

6454:
6455: build_case_folder_details(
6456: p_case_folder_id,
6457: 2, --dso
6458: fnd_number.number_to_canonical(l_dso),
6459: p_mode,
6460: p_error_msg,
6461: p_resultout);
6462:

Line 6471: fnd_number.number_to_canonical(l_ddso),

6467:
6468: build_case_folder_details(
6469: p_case_folder_id,
6470: 3, -- deliquent dso
6471: fnd_number.number_to_canonical(l_ddso),
6472: p_mode,
6473: p_error_msg,
6474: p_resultout);
6475:

Line 6484: fnd_number.number_to_canonical(l_apd),

6480:
6481: build_case_folder_details(
6482: p_case_folder_id,
6483: 4,
6484: fnd_number.number_to_canonical(l_apd),
6485: p_mode,
6486: p_error_msg,
6487: p_resultout);
6488:

Line 6497: fnd_number.number_to_canonical(l_wadpl),

6493:
6494: build_case_folder_details(
6495: p_case_folder_id,
6496: 5,
6497: fnd_number.number_to_canonical(l_wadpl),
6498: p_mode,
6499: p_error_msg,
6500: p_resultout);
6501: