APPS.AR_CMGT_DATA_POINTS_PKG dependencies on FND_NUMBER

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

320: -- Now call build case folder to insert into case folder details
321: build_case_folder_details(
322: p_case_folder_id => p_case_folder_id,
323: p_data_point_id => 211, -- deduction amount
324: p_data_point_value => fnd_number.number_to_canonical(l_deduction_amount),
325: p_mode => p_mode,
326: p_error_msg => p_error_msg,
327: p_resultout => p_resultout);
328: IF p_resultout <> 0

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

788:
789: build_case_folder_details(
790: p_case_folder_id => p_case_folder_id,
791: p_data_point_id => 19,
792: p_data_point_value => fnd_number.number_to_canonical(l_final_inv_amount),
793: p_mode => p_mode,
794: p_error_msg => p_errormsg ,
795: p_resultout => p_resultout);
796: build_case_folder_details(

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

802: p_resultout => p_resultout);
803: build_case_folder_details(
804: p_case_folder_id => p_case_folder_id,
805: p_data_point_id => 6,
806: p_data_point_value => fnd_number.number_to_canonical(l_final_high_watermark),
807: p_mode => p_mode,
808: p_error_msg => p_errormsg ,
809: p_resultout => p_resultout);
810: build_case_folder_details(

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

963: END IF;
964: build_case_folder_details(
965: p_case_folder_id => p_case_folder_id,
966: p_data_point_id => 11,
967: p_data_point_value => fnd_number.number_to_canonical(l_last_payment_amount_conv),
968: p_mode => p_mode,
969: p_error_msg => p_errormsg ,
970: p_resultout => p_resultout);
971: build_case_folder_details(

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

970: p_resultout => p_resultout);
971: build_case_folder_details(
972: p_case_folder_id => p_case_folder_id,
973: p_data_point_id => 207,
974: p_data_point_value => fnd_number.number_to_canonical(l_last_payment_amount),
975: p_mode => p_mode,
976: p_error_msg => p_errormsg ,
977: p_resultout => p_resultout);
978: build_case_folder_details(

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

1300: THEN
1301: build_case_folder_details(
1302: p_case_folder_id => p_case_folder_id,
1303: p_data_point_id => 15,
1304: p_data_point_value => fnd_number.number_to_canonical((l_total_exposure - l_ar_cmount)),
1305: p_mode => p_mode,
1306: p_error_msg => l_errmsg,
1307: p_resultout => l_resultout);
1308:

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

1308:
1309: build_case_folder_details(
1310: p_case_folder_id => p_case_folder_id,
1311: p_data_point_id => 26,
1312: p_data_point_value => fnd_number.number_to_canonical(l_order_hold_amount),
1313: p_mode => p_mode,
1314: p_error_msg => l_errmsg,
1315: p_resultout => l_resultout);
1316:

Line 1320: l_Rec_Bal := fnd_number.canonical_to_number(RecBalRec.data_point_value);

1316:
1317: -- Now Populate Credit exposure
1318: FOR RecBalRec IN RecBalC
1319: LOOP
1320: l_Rec_Bal := fnd_number.canonical_to_number(RecBalRec.data_point_value);
1321: END LOOP;
1322: l_credit_exposure :=
1323: nvl(l_Rec_bal,0) + (nvl(l_total_exposure,0) - nvl(l_ar_cmount,0)) +
1324: nvl(l_order_hold_amount,0);

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

1325:
1326: build_case_folder_details(
1327: p_case_folder_id => p_case_folder_id,
1328: p_data_point_id => 213,
1329: p_data_point_value => fnd_number.number_to_canonical(l_credit_exposure),
1330: p_mode => p_mode,
1331: p_error_msg => l_errmsg,
1332: p_resultout => l_resultout);
1333: ELSE

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

1598: p_resultout => p_resultout);
1599: build_case_folder_details(
1600: p_case_folder_id => p_case_folder_id,
1601: p_data_point_id => 113,
1602: p_data_point_value => fnd_number.number_to_canonical(l_cash),
1603: p_mode => p_mode,
1604: p_error_msg => p_errmsg,
1605: p_resultout => p_resultout);
1606: build_case_folder_details(

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

1605: p_resultout => p_resultout);
1606: build_case_folder_details(
1607: p_case_folder_id => p_case_folder_id,
1608: p_data_point_id => 114,
1609: p_data_point_value => fnd_number.number_to_canonical(l_net_receivables),
1610: p_mode => p_mode,
1611: p_error_msg => p_errmsg,
1612: p_resultout => p_resultout);
1613: build_case_folder_details(

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

1612: p_resultout => p_resultout);
1613: build_case_folder_details(
1614: p_case_folder_id => p_case_folder_id,
1615: p_data_point_id => 115,
1616: p_data_point_value => fnd_number.number_to_canonical(l_inventories),
1617: p_mode => p_mode,
1618: p_error_msg => p_errmsg,
1619: p_resultout => p_resultout);
1620: build_case_folder_details(

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

1619: p_resultout => p_resultout);
1620: build_case_folder_details(
1621: p_case_folder_id => p_case_folder_id,
1622: p_data_point_id => 116,
1623: p_data_point_value => fnd_number.number_to_canonical(l_other_cur_assets),
1624: p_mode => p_mode,
1625: p_error_msg => p_errmsg,
1626: p_resultout => p_resultout);
1627: build_case_folder_details(

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

1626: p_resultout => p_resultout);
1627: build_case_folder_details(
1628: p_case_folder_id => p_case_folder_id,
1629: p_data_point_id => 117,
1630: p_data_point_value => fnd_number.number_to_canonical(l_total_cur_assets),
1631: p_mode => p_mode,
1632: p_error_msg => p_errmsg,
1633: p_resultout => p_resultout);
1634: build_case_folder_details(

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

1633: p_resultout => p_resultout);
1634: build_case_folder_details(
1635: p_case_folder_id => p_case_folder_id,
1636: p_data_point_id => 118,
1637: p_data_point_value => fnd_number.number_to_canonical(l_net_fixed_assets),
1638: p_mode => p_mode,
1639: p_error_msg => p_errmsg,
1640: p_resultout => p_resultout);
1641: build_case_folder_details(

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

1640: p_resultout => p_resultout);
1641: build_case_folder_details(
1642: p_case_folder_id => p_case_folder_id,
1643: p_data_point_id => 119,
1644: p_data_point_value => fnd_number.number_to_canonical(l_other_non_cur_assets),
1645: p_mode => p_mode,
1646: p_error_msg => p_errmsg,
1647: p_resultout => p_resultout);
1648: build_case_folder_details(

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

1647: p_resultout => p_resultout);
1648: build_case_folder_details(
1649: p_case_folder_id => p_case_folder_id,
1650: p_data_point_id => 120,
1651: p_data_point_value => fnd_number.number_to_canonical(l_total_assets),
1652: p_mode => p_mode,
1653: p_error_msg => p_errmsg,
1654: p_resultout => p_resultout);
1655: build_case_folder_details(

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

1654: p_resultout => p_resultout);
1655: build_case_folder_details(
1656: p_case_folder_id => p_case_folder_id,
1657: p_data_point_id => 121,
1658: p_data_point_value => fnd_number.number_to_canonical(l_accounts_payable),
1659: p_mode => p_mode,
1660: p_error_msg => p_errmsg,
1661: p_resultout => p_resultout);
1662: build_case_folder_details(

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

1661: p_resultout => p_resultout);
1662: build_case_folder_details(
1663: p_case_folder_id => p_case_folder_id,
1664: p_data_point_id => 122,
1665: p_data_point_value => fnd_number.number_to_canonical(l_short_term_debt),
1666: p_mode => p_mode,
1667: p_error_msg => p_errmsg,
1668: p_resultout => p_resultout);
1669: build_case_folder_details(

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

1668: p_resultout => p_resultout);
1669: build_case_folder_details(
1670: p_case_folder_id => p_case_folder_id,
1671: p_data_point_id => 123,
1672: p_data_point_value => fnd_number.number_to_canonical(l_other_cur_liabilities),
1673: p_mode => p_mode,
1674: p_error_msg => p_errmsg,
1675: p_resultout => p_resultout);
1676: build_case_folder_details(

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

1675: p_resultout => p_resultout);
1676: build_case_folder_details(
1677: p_case_folder_id => p_case_folder_id,
1678: p_data_point_id => 124,
1679: p_data_point_value => fnd_number.number_to_canonical(l_total_cur_liabilities),
1680: p_mode => p_mode,
1681: p_error_msg => p_errmsg,
1682: p_resultout => p_resultout);
1683: build_case_folder_details(

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

1682: p_resultout => p_resultout);
1683: build_case_folder_details(
1684: p_case_folder_id => p_case_folder_id,
1685: p_data_point_id => 125,
1686: p_data_point_value => fnd_number.number_to_canonical(l_long_term_debt),
1687: p_mode => p_mode,
1688: p_error_msg => p_errmsg,
1689: p_resultout => p_resultout);
1690: build_case_folder_details(

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

1689: p_resultout => p_resultout);
1690: build_case_folder_details(
1691: p_case_folder_id => p_case_folder_id,
1692: p_data_point_id => 126,
1693: p_data_point_value => fnd_number.number_to_canonical(l_other_non_cur_liabilities),
1694: p_mode => p_mode,
1695: p_error_msg => p_errmsg,
1696: p_resultout => p_resultout);
1697: build_case_folder_details(

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

1696: p_resultout => p_resultout);
1697: build_case_folder_details(
1698: p_case_folder_id => p_case_folder_id,
1699: p_data_point_id => 127,
1700: p_data_point_value => fnd_number.number_to_canonical(l_total_liabilities),
1701: p_mode => p_mode,
1702: p_error_msg => p_errmsg,
1703: p_resultout => p_resultout);
1704: build_case_folder_details(

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

1703: p_resultout => p_resultout);
1704: build_case_folder_details(
1705: p_case_folder_id => p_case_folder_id,
1706: p_data_point_id => 128,
1707: p_data_point_value => fnd_number.number_to_canonical(l_stockholder_equity),
1708: p_mode => p_mode,
1709: p_error_msg => p_errmsg,
1710: p_resultout => p_resultout);
1711: build_case_folder_details(

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

1710: p_resultout => p_resultout);
1711: build_case_folder_details(
1712: p_case_folder_id => p_case_folder_id,
1713: p_data_point_id => 129,
1714: p_data_point_value => fnd_number.number_to_canonical(l_total_liabilities_equity),
1715: p_mode => p_mode,
1716: p_error_msg => p_errmsg,
1717: p_resultout => p_resultout);
1718: build_case_folder_details(

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

1717: p_resultout => p_resultout);
1718: build_case_folder_details(
1719: p_case_folder_id => p_case_folder_id,
1720: p_data_point_id => 130,
1721: p_data_point_value => fnd_number.number_to_canonical(l_revenue),
1722: p_mode => p_mode,
1723: p_error_msg => p_errmsg,
1724: p_resultout => p_resultout);
1725: build_case_folder_details(

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

1724: p_resultout => p_resultout);
1725: build_case_folder_details(
1726: p_case_folder_id => p_case_folder_id,
1727: p_data_point_id => 131,
1728: p_data_point_value => fnd_number.number_to_canonical(l_cost_of_goods_sold),
1729: p_mode => p_mode,
1730: p_error_msg => p_errmsg,
1731: p_resultout => p_resultout);
1732: build_case_folder_details(

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

1731: p_resultout => p_resultout);
1732: build_case_folder_details(
1733: p_case_folder_id => p_case_folder_id,
1734: p_data_point_id => 132,
1735: p_data_point_value => fnd_number.number_to_canonical(l_sga_expenses),
1736: p_mode => p_mode,
1737: p_error_msg => p_errmsg,
1738: p_resultout => p_resultout);
1739: build_case_folder_details(

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

1738: p_resultout => p_resultout);
1739: build_case_folder_details(
1740: p_case_folder_id => p_case_folder_id,
1741: p_data_point_id => 133,
1742: p_data_point_value => fnd_number.number_to_canonical(l_operating_income),
1743: p_mode => p_mode,
1744: p_error_msg => p_errmsg,
1745: p_resultout => p_resultout);
1746: build_case_folder_details(

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

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

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

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

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

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

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

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

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

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

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

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

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

1787: p_resultout => p_resultout);
1788: build_case_folder_details(
1789: p_case_folder_id => p_case_folder_id,
1790: p_data_point_id => 140,
1791: p_data_point_value => fnd_number.number_to_canonical(l_earnings_per_share),
1792: p_mode => p_mode,
1793: p_error_msg => p_errmsg,
1794: p_resultout => p_resultout);
1795: IF pg_wf_debug = 'Y'

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

1876: LOOP
1877: build_case_folder_details(
1878: p_case_folder_id => p_case_folder_id,
1879: p_data_point_id => 95,
1880: p_data_point_value => fnd_number.number_to_canonical(c_hz_cust_prof_amts_rec.trx_credit_limit),
1881: p_mode => p_mode,
1882: p_error_msg => l_errmsg,
1883: p_resultout => l_resultout);
1884:

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

1884:
1885: build_case_folder_details(
1886: p_case_folder_id => p_case_folder_id,
1887: p_data_point_id => 96,
1888: p_data_point_value => fnd_number.number_to_canonical(c_hz_cust_prof_amts_rec.overall_credit_limit),
1889: p_mode => p_mode,
1890: p_error_msg => l_errmsg,
1891: p_resultout => l_resultout);
1892: exit;

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

1973: p_resultout => l_resultout);
1974: build_case_folder_details(
1975: p_case_folder_id => p_case_folder_id,
1976: p_data_point_id => 98,
1977: p_data_point_value => fnd_number.number_to_canonical(c_credit_requests_rec.current_stock_price),
1978: p_mode => p_mode,
1979: p_error_msg => l_errmsg,
1980: p_resultout => l_resultout);
1981: build_case_folder_details(

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

1980: p_resultout => l_resultout);
1981: build_case_folder_details(
1982: p_case_folder_id => p_case_folder_id,
1983: p_data_point_id => 99,
1984: p_data_point_value => fnd_number.number_to_canonical(c_credit_requests_rec.market_capitalization),
1985: p_mode => p_mode,
1986: p_error_msg => l_errmsg,
1987: p_resultout => l_resultout);
1988: build_case_folder_details(

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

1987: p_resultout => l_resultout);
1988: build_case_folder_details(
1989: p_case_folder_id => p_case_folder_id,
1990: p_data_point_id => 108,
1991: p_data_point_value => fnd_number.number_to_canonical(c_credit_requests_rec.requested_amount),
1992: p_mode => p_mode,
1993: p_error_msg => l_errmsg,
1994: p_resultout => l_resultout);
1995: build_case_folder_details(

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

2032: LOOP
2033: build_case_folder_details(
2034: p_case_folder_id => p_case_folder_id,
2035: p_data_point_id => 30, -- last calculated credit score
2036: p_data_point_value => fnd_number.number_to_canonical(c_case_folder_score_rec.score),
2037: p_mode => p_mode,
2038: p_error_msg => l_errmsg,
2039: p_resultout => l_resultout);
2040: exit;

Line 4664: SELECT '4'||'^'||fnd_number.number_to_canonical(SUM(avg_pmt_days)) avg_pmt_days,

4660: -- So we are multiplying to -1 to show the opposite value as part of
4661: -- bug fixes 2824382.
4662: ********************************************************************/
4663: CURSOR c_party_summary IS
4664: SELECT '4'||'^'||fnd_number.number_to_canonical(SUM(avg_pmt_days)) avg_pmt_days,
4665: '5'||'^'||fnd_number.number_to_canonical(SUM(weight_avg_days_late)) weight_avg_days_late,
4666: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
4667: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4668: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,

Line 4665: '5'||'^'||fnd_number.number_to_canonical(SUM(weight_avg_days_late)) weight_avg_days_late,

4661: -- bug fixes 2824382.
4662: ********************************************************************/
4663: CURSOR c_party_summary IS
4664: SELECT '4'||'^'||fnd_number.number_to_canonical(SUM(avg_pmt_days)) avg_pmt_days,
4665: '5'||'^'||fnd_number.number_to_canonical(SUM(weight_avg_days_late)) weight_avg_days_late,
4666: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
4667: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4668: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4669: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,

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

4662: ********************************************************************/
4663: CURSOR c_party_summary IS
4664: SELECT '4'||'^'||fnd_number.number_to_canonical(SUM(avg_pmt_days)) avg_pmt_days,
4665: '5'||'^'||fnd_number.number_to_canonical(SUM(weight_avg_days_late)) weight_avg_days_late,
4666: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
4667: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4668: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4669: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4670: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,

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

4663: CURSOR c_party_summary IS
4664: SELECT '4'||'^'||fnd_number.number_to_canonical(SUM(avg_pmt_days)) avg_pmt_days,
4665: '5'||'^'||fnd_number.number_to_canonical(SUM(weight_avg_days_late)) weight_avg_days_late,
4666: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
4667: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4668: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4669: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4670: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4671: '21'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_promptly)) per_inv_paid_promptly,

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

4664: SELECT '4'||'^'||fnd_number.number_to_canonical(SUM(avg_pmt_days)) avg_pmt_days,
4665: '5'||'^'||fnd_number.number_to_canonical(SUM(weight_avg_days_late)) weight_avg_days_late,
4666: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
4667: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4668: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4669: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4670: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4671: '21'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_promptly)) per_inv_paid_promptly,
4672: '22'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_late)) per_inv_paid_late,

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

4665: '5'||'^'||fnd_number.number_to_canonical(SUM(weight_avg_days_late)) weight_avg_days_late,
4666: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
4667: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4668: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4669: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4670: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4671: '21'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_promptly)) per_inv_paid_promptly,
4672: '22'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_late)) per_inv_paid_late,
4673: '23'||'^'||fnd_number.number_to_canonical(SUM(per_inv_with_discount)) per_inv_with_discount,

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

4666: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
4667: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4668: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4669: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4670: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4671: '21'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_promptly)) per_inv_paid_promptly,
4672: '22'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_late)) per_inv_paid_late,
4673: '23'||'^'||fnd_number.number_to_canonical(SUM(per_inv_with_discount)) per_inv_with_discount,
4674: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,

Line 4671: '21'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_promptly)) per_inv_paid_promptly,

4667: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4668: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4669: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4670: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4671: '21'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_promptly)) per_inv_paid_promptly,
4672: '22'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_late)) per_inv_paid_late,
4673: '23'||'^'||fnd_number.number_to_canonical(SUM(per_inv_with_discount)) per_inv_with_discount,
4674: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4675: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,

Line 4672: '22'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_late)) per_inv_paid_late,

4668: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4669: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4670: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4671: '21'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_promptly)) per_inv_paid_promptly,
4672: '22'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_late)) per_inv_paid_late,
4673: '23'||'^'||fnd_number.number_to_canonical(SUM(per_inv_with_discount)) per_inv_with_discount,
4674: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4675: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4676: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,

Line 4673: '23'||'^'||fnd_number.number_to_canonical(SUM(per_inv_with_discount)) per_inv_with_discount,

4669: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4670: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4671: '21'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_promptly)) per_inv_paid_promptly,
4672: '22'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_late)) per_inv_paid_late,
4673: '23'||'^'||fnd_number.number_to_canonical(SUM(per_inv_with_discount)) per_inv_with_discount,
4674: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4675: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4676: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4677: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,

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

4670: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4671: '21'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_promptly)) per_inv_paid_promptly,
4672: '22'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_late)) per_inv_paid_late,
4673: '23'||'^'||fnd_number.number_to_canonical(SUM(per_inv_with_discount)) per_inv_with_discount,
4674: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4675: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4676: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4677: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4678: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,

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

4671: '21'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_promptly)) per_inv_paid_promptly,
4672: '22'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_late)) per_inv_paid_late,
4673: '23'||'^'||fnd_number.number_to_canonical(SUM(per_inv_with_discount)) per_inv_with_discount,
4674: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4675: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4676: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4677: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4678: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4679: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,

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

4672: '22'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_late)) per_inv_paid_late,
4673: '23'||'^'||fnd_number.number_to_canonical(SUM(per_inv_with_discount)) per_inv_with_discount,
4674: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4675: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4676: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4677: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4678: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4679: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4680: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,

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

4673: '23'||'^'||fnd_number.number_to_canonical(SUM(per_inv_with_discount)) per_inv_with_discount,
4674: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4675: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4676: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4677: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4678: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4679: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4680: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4681: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,

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

4674: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4675: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4676: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4677: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4678: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4679: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4680: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4681: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4682: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,

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

4675: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4676: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4677: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4678: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4679: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4680: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4681: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4682: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4683: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,

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

4676: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4677: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4678: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4679: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4680: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4681: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4682: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4683: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4684: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,

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

4677: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4678: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4679: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4680: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4681: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4682: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4683: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4684: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4685: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,

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

4678: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4679: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4680: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4681: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4682: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4683: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4684: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4685: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4686: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,

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

4679: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4680: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4681: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4682: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4683: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4684: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4685: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4686: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4687: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,

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

4680: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4681: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4682: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4683: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4684: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4685: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4686: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4687: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4688: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,

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

4681: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4682: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4683: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4684: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4685: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4686: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4687: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4688: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4689: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,

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

4682: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4683: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4684: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4685: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4686: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4687: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4688: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4689: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4690: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,

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

4683: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4684: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4685: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4686: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4687: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4688: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4689: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4690: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4691: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,

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

4684: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4685: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4686: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4687: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4688: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4689: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4690: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4691: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
4692: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,

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

4685: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4686: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4687: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4688: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4689: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4690: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4691: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
4692: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,
4693: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count

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

4686: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4687: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4688: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4689: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4690: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4691: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
4692: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,
4693: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count
4694: FROM ( SELECT

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

4687: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4688: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4689: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4690: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4691: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
4692: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,
4693: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count
4694: FROM ( SELECT
4695: round(gl_currency_api.convert_amount(CURRENCY,

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

4688: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4689: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4690: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4691: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
4692: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,
4693: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count
4694: FROM ( SELECT
4695: round(gl_currency_api.convert_amount(CURRENCY,
4696: l_limit_currency,sysdate,

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

4689: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4690: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4691: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
4692: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,
4693: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count
4694: FROM ( SELECT
4695: round(gl_currency_api.convert_amount(CURRENCY,
4696: l_limit_currency,sysdate,
4697: l_exchange_rate_type,

Line 4823: SELECT '4'||'^'||fnd_number.number_to_canonical(SUM(avg_pmt_days)) avg_pmt_days,

4819: group by currency );
4820:
4821:
4822: CURSOR c_account_summary IS
4823: SELECT '4'||'^'||fnd_number.number_to_canonical(SUM(avg_pmt_days)) avg_pmt_days,
4824: '5'||'^'||fnd_number.number_to_canonical(SUM(weight_avg_days_late)) weight_avg_days_late,
4825: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
4826: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4827: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,

Line 4824: '5'||'^'||fnd_number.number_to_canonical(SUM(weight_avg_days_late)) weight_avg_days_late,

4820:
4821:
4822: CURSOR c_account_summary IS
4823: SELECT '4'||'^'||fnd_number.number_to_canonical(SUM(avg_pmt_days)) avg_pmt_days,
4824: '5'||'^'||fnd_number.number_to_canonical(SUM(weight_avg_days_late)) weight_avg_days_late,
4825: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
4826: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4827: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4828: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,

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

4821:
4822: CURSOR c_account_summary IS
4823: SELECT '4'||'^'||fnd_number.number_to_canonical(SUM(avg_pmt_days)) avg_pmt_days,
4824: '5'||'^'||fnd_number.number_to_canonical(SUM(weight_avg_days_late)) weight_avg_days_late,
4825: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
4826: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4827: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4828: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4829: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,

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

4822: CURSOR c_account_summary IS
4823: SELECT '4'||'^'||fnd_number.number_to_canonical(SUM(avg_pmt_days)) avg_pmt_days,
4824: '5'||'^'||fnd_number.number_to_canonical(SUM(weight_avg_days_late)) weight_avg_days_late,
4825: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
4826: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4827: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4828: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4829: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4830: '21'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_promptly)) per_inv_paid_promptly,

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

4823: SELECT '4'||'^'||fnd_number.number_to_canonical(SUM(avg_pmt_days)) avg_pmt_days,
4824: '5'||'^'||fnd_number.number_to_canonical(SUM(weight_avg_days_late)) weight_avg_days_late,
4825: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
4826: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4827: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4828: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4829: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4830: '21'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_promptly)) per_inv_paid_promptly,
4831: '22'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_late)) per_inv_paid_late,

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

4824: '5'||'^'||fnd_number.number_to_canonical(SUM(weight_avg_days_late)) weight_avg_days_late,
4825: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
4826: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4827: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4828: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4829: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4830: '21'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_promptly)) per_inv_paid_promptly,
4831: '22'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_late)) per_inv_paid_late,
4832: '23'||'^'||fnd_number.number_to_canonical(SUM(per_inv_with_discount)) per_inv_with_discount,

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

4825: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
4826: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4827: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4828: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4829: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4830: '21'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_promptly)) per_inv_paid_promptly,
4831: '22'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_late)) per_inv_paid_late,
4832: '23'||'^'||fnd_number.number_to_canonical(SUM(per_inv_with_discount)) per_inv_with_discount,
4833: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,

Line 4830: '21'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_promptly)) per_inv_paid_promptly,

4826: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4827: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4828: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4829: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4830: '21'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_promptly)) per_inv_paid_promptly,
4831: '22'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_late)) per_inv_paid_late,
4832: '23'||'^'||fnd_number.number_to_canonical(SUM(per_inv_with_discount)) per_inv_with_discount,
4833: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4834: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,

Line 4831: '22'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_late)) per_inv_paid_late,

4827: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4828: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4829: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4830: '21'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_promptly)) per_inv_paid_promptly,
4831: '22'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_late)) per_inv_paid_late,
4832: '23'||'^'||fnd_number.number_to_canonical(SUM(per_inv_with_discount)) per_inv_with_discount,
4833: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4834: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4835: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,

Line 4832: '23'||'^'||fnd_number.number_to_canonical(SUM(per_inv_with_discount)) per_inv_with_discount,

4828: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4829: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4830: '21'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_promptly)) per_inv_paid_promptly,
4831: '22'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_late)) per_inv_paid_late,
4832: '23'||'^'||fnd_number.number_to_canonical(SUM(per_inv_with_discount)) per_inv_with_discount,
4833: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4834: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4835: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4836: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,

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

4829: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4830: '21'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_promptly)) per_inv_paid_promptly,
4831: '22'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_late)) per_inv_paid_late,
4832: '23'||'^'||fnd_number.number_to_canonical(SUM(per_inv_with_discount)) per_inv_with_discount,
4833: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4834: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4835: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4836: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4837: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,

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

4830: '21'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_promptly)) per_inv_paid_promptly,
4831: '22'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_late)) per_inv_paid_late,
4832: '23'||'^'||fnd_number.number_to_canonical(SUM(per_inv_with_discount)) per_inv_with_discount,
4833: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4834: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4835: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4836: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4837: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4838: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,

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

4831: '22'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_late)) per_inv_paid_late,
4832: '23'||'^'||fnd_number.number_to_canonical(SUM(per_inv_with_discount)) per_inv_with_discount,
4833: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4834: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4835: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4836: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4837: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4838: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4839: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,

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

4832: '23'||'^'||fnd_number.number_to_canonical(SUM(per_inv_with_discount)) per_inv_with_discount,
4833: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4834: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4835: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4836: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4837: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4838: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4839: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4840: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,

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

4833: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4834: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4835: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4836: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4837: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4838: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4839: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4840: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4841: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,

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

4834: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4835: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4836: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4837: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4838: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4839: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4840: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4841: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4842: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,

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

4835: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4836: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4837: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4838: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4839: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4840: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4841: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4842: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4843: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,

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

4836: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4837: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4838: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4839: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4840: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4841: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4842: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4843: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4844: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,

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

4837: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4838: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4839: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4840: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4841: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4842: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4843: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4844: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4845: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,

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

4838: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4839: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4840: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4841: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4842: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4843: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4844: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4845: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4846: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,

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

4839: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4840: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4841: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4842: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4843: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4844: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4845: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4846: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4847: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,

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

4840: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4841: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4842: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4843: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4844: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4845: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4846: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4847: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4848: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,

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

4841: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4842: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4843: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4844: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4845: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4846: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4847: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4848: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4849: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,

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

4842: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4843: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4844: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4845: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4846: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4847: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4848: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4849: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4850: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,

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

4843: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4844: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4845: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4846: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4847: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4848: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4849: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4850: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
4851: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,

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

4844: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4845: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4846: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4847: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4848: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4849: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4850: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
4851: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,
4852: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count

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

4845: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4846: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4847: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4848: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4849: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4850: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
4851: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,
4852: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count
4853: FROM ( SELECT

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

4846: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4847: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4848: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4849: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4850: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
4851: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,
4852: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count
4853: FROM ( SELECT
4854: round(gl_currency_api.convert_amount(currency,

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

4847: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4848: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4849: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4850: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
4851: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,
4852: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count
4853: FROM ( SELECT
4854: round(gl_currency_api.convert_amount(currency,
4855: l_limit_currency,sysdate,

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

4848: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4849: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4850: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
4851: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,
4852: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count
4853: FROM ( SELECT
4854: round(gl_currency_api.convert_amount(currency,
4855: l_limit_currency,sysdate,
4856: l_exchange_rate_type,

Line 4959: SELECT '4'||'^'||fnd_number.number_to_canonical(SUM(avg_pmt_days)) avg_pmt_days,

4955: and as_of_date >= ADD_MONTHS(sysdate,(-l_period))
4956: group by currency );
4957:
4958: CURSOR c_site_summary IS
4959: SELECT '4'||'^'||fnd_number.number_to_canonical(SUM(avg_pmt_days)) avg_pmt_days,
4960: '5'||'^'||fnd_number.number_to_canonical(SUM(weight_avg_days_late)) weight_avg_days_late,
4961: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
4962: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4963: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,

Line 4960: '5'||'^'||fnd_number.number_to_canonical(SUM(weight_avg_days_late)) weight_avg_days_late,

4956: group by currency );
4957:
4958: CURSOR c_site_summary IS
4959: SELECT '4'||'^'||fnd_number.number_to_canonical(SUM(avg_pmt_days)) avg_pmt_days,
4960: '5'||'^'||fnd_number.number_to_canonical(SUM(weight_avg_days_late)) weight_avg_days_late,
4961: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
4962: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4963: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4964: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,

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

4957:
4958: CURSOR c_site_summary IS
4959: SELECT '4'||'^'||fnd_number.number_to_canonical(SUM(avg_pmt_days)) avg_pmt_days,
4960: '5'||'^'||fnd_number.number_to_canonical(SUM(weight_avg_days_late)) weight_avg_days_late,
4961: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
4962: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4963: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4964: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4965: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,

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

4958: CURSOR c_site_summary IS
4959: SELECT '4'||'^'||fnd_number.number_to_canonical(SUM(avg_pmt_days)) avg_pmt_days,
4960: '5'||'^'||fnd_number.number_to_canonical(SUM(weight_avg_days_late)) weight_avg_days_late,
4961: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
4962: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4963: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4964: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4965: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4966: '21'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_promptly)) per_inv_paid_promptly,

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

4959: SELECT '4'||'^'||fnd_number.number_to_canonical(SUM(avg_pmt_days)) avg_pmt_days,
4960: '5'||'^'||fnd_number.number_to_canonical(SUM(weight_avg_days_late)) weight_avg_days_late,
4961: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
4962: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4963: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4964: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4965: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4966: '21'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_promptly)) per_inv_paid_promptly,
4967: '22'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_late)) per_inv_paid_late,

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

4960: '5'||'^'||fnd_number.number_to_canonical(SUM(weight_avg_days_late)) weight_avg_days_late,
4961: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
4962: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4963: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4964: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4965: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4966: '21'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_promptly)) per_inv_paid_promptly,
4967: '22'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_late)) per_inv_paid_late,
4968: '23'||'^'||fnd_number.number_to_canonical(SUM(per_inv_with_discount)) per_inv_with_discount,

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

4961: '8'||'^'||fnd_number.number_to_canonical(SUM(days_credit_granted)) days_credit_granted,
4962: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4963: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4964: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4965: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4966: '21'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_promptly)) per_inv_paid_promptly,
4967: '22'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_late)) per_inv_paid_late,
4968: '23'||'^'||fnd_number.number_to_canonical(SUM(per_inv_with_discount)) per_inv_with_discount,
4969: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,

Line 4966: '21'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_promptly)) per_inv_paid_promptly,

4962: '13'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_count)) nsf_payment_count,
4963: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4964: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4965: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4966: '21'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_promptly)) per_inv_paid_promptly,
4967: '22'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_late)) per_inv_paid_late,
4968: '23'||'^'||fnd_number.number_to_canonical(SUM(per_inv_with_discount)) per_inv_with_discount,
4969: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4970: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,

Line 4967: '22'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_late)) per_inv_paid_late,

4963: '14'||'^'||fnd_number.number_to_canonical(SUM(nsf_payment_amount)) nsf_payment_amount,
4964: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4965: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4966: '21'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_promptly)) per_inv_paid_promptly,
4967: '22'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_late)) per_inv_paid_late,
4968: '23'||'^'||fnd_number.number_to_canonical(SUM(per_inv_with_discount)) per_inv_with_discount,
4969: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4970: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4971: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,

Line 4968: '23'||'^'||fnd_number.number_to_canonical(SUM(per_inv_with_discount)) per_inv_with_discount,

4964: '17'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_value)) credit_memo_value,
4965: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4966: '21'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_promptly)) per_inv_paid_promptly,
4967: '22'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_late)) per_inv_paid_late,
4968: '23'||'^'||fnd_number.number_to_canonical(SUM(per_inv_with_discount)) per_inv_with_discount,
4969: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4970: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4971: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4972: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,

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

4965: '18'||'^'||fnd_number.number_to_canonical(SUM(credit_memo_count)) credit_memo_count,
4966: '21'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_promptly)) per_inv_paid_promptly,
4967: '22'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_late)) per_inv_paid_late,
4968: '23'||'^'||fnd_number.number_to_canonical(SUM(per_inv_with_discount)) per_inv_with_discount,
4969: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4970: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4971: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4972: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4973: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,

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

4966: '21'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_promptly)) per_inv_paid_promptly,
4967: '22'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_late)) per_inv_paid_late,
4968: '23'||'^'||fnd_number.number_to_canonical(SUM(per_inv_with_discount)) per_inv_with_discount,
4969: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4970: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4971: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4972: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4973: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4974: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,

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

4967: '22'||'^'||fnd_number.number_to_canonical(SUM(per_inv_paid_late)) per_inv_paid_late,
4968: '23'||'^'||fnd_number.number_to_canonical(SUM(per_inv_with_discount)) per_inv_with_discount,
4969: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4970: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4971: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4972: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4973: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4974: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4975: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,

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

4968: '23'||'^'||fnd_number.number_to_canonical(SUM(per_inv_with_discount)) per_inv_with_discount,
4969: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4970: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4971: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4972: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4973: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4974: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4975: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4976: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,

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

4969: '41'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_amount)) inv_paid_amount,
4970: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4971: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4972: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4973: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4974: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4975: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4976: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4977: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,

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

4970: '42'||'^'||fnd_number.number_to_canonical(SUM(inv_paid_count)) inv_paid_count,
4971: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4972: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4973: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4974: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4975: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4976: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4977: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4978: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,

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

4971: '43'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_value)) earned_disc_value,
4972: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4973: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4974: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4975: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4976: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4977: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4978: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4979: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,

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

4972: '44'||'^'||fnd_number.number_to_canonical(SUM(earned_disc_count)) earned_disc_count,
4973: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4974: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4975: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4976: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4977: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4978: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4979: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4980: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,

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

4973: '45'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_value)) unearned_disc_value,
4974: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4975: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4976: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4977: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4978: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4979: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4980: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4981: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,

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

4974: '46'||'^'||fnd_number.number_to_canonical(SUM(unearned_disc_count)) unearned_disc_count,
4975: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4976: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4977: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4978: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4979: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4980: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4981: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4982: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,

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

4975: '156'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_value)) total_cash_receipts_value,
4976: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4977: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4978: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4979: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4980: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4981: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4982: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4983: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,

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

4976: '157'||'^'||fnd_number.number_to_canonical(SUM(total_cash_receipts_count)) total_cash_receipts_count,
4977: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4978: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4979: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4980: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4981: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4982: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4983: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4984: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,

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

4977: '158'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_value)) total_invoices_value,
4978: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4979: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4980: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4981: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4982: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4983: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4984: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4985: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,

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

4978: '159'||'^'||fnd_number.number_to_canonical(SUM(total_invoices_count)) total_invoices_count,
4979: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4980: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4981: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4982: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4983: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4984: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4985: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4986: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,

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

4979: '160'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_value)) total_bills_receivables_value,
4980: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4981: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4982: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4983: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4984: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4985: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4986: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
4987: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,

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

4980: '161'||'^'||fnd_number.number_to_canonical(SUM(total_bills_receivables_count)) total_bills_receivables_count,
4981: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4982: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4983: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4984: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4985: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4986: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
4987: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,
4988: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count

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

4981: '162'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_value)) total_debit_memos_value,
4982: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4983: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4984: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4985: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4986: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
4987: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,
4988: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count
4989: FROM ( SELECT

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

4982: '163'||'^'||fnd_number.number_to_canonical(SUM(total_debit_memos_count)) total_debit_memos_count,
4983: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4984: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4985: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4986: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
4987: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,
4988: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count
4989: FROM ( SELECT
4990: round(gl_currency_api.convert_amount(currency,

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

4983: '164'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_value)) total_chargeback_value,
4984: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4985: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4986: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
4987: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,
4988: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count
4989: FROM ( SELECT
4990: round(gl_currency_api.convert_amount(currency,
4991: l_limit_currency,sysdate,

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

4984: '165'||'^'||fnd_number.number_to_canonical(SUM(total_chargeback_count)) total_chargeback_count,
4985: '166'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_value)) total_adjustments_value,
4986: '167'||'^'||fnd_number.number_to_canonical(SUM(total_adjustments_count)) total_adjustments_count,
4987: '168'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_value)) total_deposits_value,
4988: '169'||'^'||fnd_number.number_to_canonical(SUM(total_deposits_count)) total_deposits_count
4989: FROM ( SELECT
4990: round(gl_currency_api.convert_amount(currency,
4991: l_limit_currency,sysdate,
4992: l_exchange_rate_type,

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

5096: -- if you are adding/removing an column in this cursor please
5097: -- update the bal_summary_rec_col_count varibale with proper number.
5098: ********************************************************************/
5099: CURSOR c_party_bal_summary IS
5100: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,
5101: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5102: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5103: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5104: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,

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

5097: -- update the bal_summary_rec_col_count varibale with proper number.
5098: ********************************************************************/
5099: CURSOR c_party_bal_summary IS
5100: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,
5101: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5102: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5103: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5104: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5105: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,

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

5098: ********************************************************************/
5099: CURSOR c_party_bal_summary IS
5100: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,
5101: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5102: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5103: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5104: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5105: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5106: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,

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

5099: CURSOR c_party_bal_summary IS
5100: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,
5101: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5102: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5103: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5104: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5105: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5106: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5107: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,

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

5100: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,
5101: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5102: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5103: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5104: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5105: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5106: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5107: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5108: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,

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

5101: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5102: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5103: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5104: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5105: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5106: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5107: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5108: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5109: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,

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

5102: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5103: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5104: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5105: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5106: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5107: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5108: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5109: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5110: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,

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

5103: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5104: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5105: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5106: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5107: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5108: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5109: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5110: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5111: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,

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

5104: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5105: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5106: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5107: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5108: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5109: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5110: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5111: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5112: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,

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

5105: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5106: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5107: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5108: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5109: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5110: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5111: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5112: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5113: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,

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

5106: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5107: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5108: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5109: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5110: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5111: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5112: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5113: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5114: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,

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

5107: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5108: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5109: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5110: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5111: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5112: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5113: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5114: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5115: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,

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

5108: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5109: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5110: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5111: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5112: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5113: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5114: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5115: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5116: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,

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

5109: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5110: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5111: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5112: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5113: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5114: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5115: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5116: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5117: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,

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

5110: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5111: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5112: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5113: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5114: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5115: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5116: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5117: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5118: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,

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

5111: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5112: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5113: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5114: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5115: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5116: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5117: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5118: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5119: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,

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

5112: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5113: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5114: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5115: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5116: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5117: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5118: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5119: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5120: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,

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

5113: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5114: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5115: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5116: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5117: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5118: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5119: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5120: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5121: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,

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

5114: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5115: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5116: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5117: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5118: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5119: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5120: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5121: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,
5122: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count

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

5115: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5116: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5117: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5118: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5119: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5120: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5121: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,
5122: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count
5123: FROM (

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

5116: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5117: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5118: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5119: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5120: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5121: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,
5122: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count
5123: FROM (
5124: SELECT

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

5117: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5118: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5119: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5120: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5121: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,
5122: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count
5123: FROM (
5124: SELECT
5125: gl_currency_api.convert_amount(currency,

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

5118: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5119: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5120: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5121: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,
5122: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count
5123: FROM (
5124: SELECT
5125: gl_currency_api.convert_amount(currency,
5126: l_limit_currency,sysdate,

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

5218: group by currency);
5219:
5220:
5221: CURSOR c_account_bal_summary IS
5222: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,
5223: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5224: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5225: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5226: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,

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

5219:
5220:
5221: CURSOR c_account_bal_summary IS
5222: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,
5223: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5224: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5225: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5226: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5227: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,

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

5220:
5221: CURSOR c_account_bal_summary IS
5222: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,
5223: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5224: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5225: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5226: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5227: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5228: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,

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

5221: CURSOR c_account_bal_summary IS
5222: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,
5223: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5224: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5225: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5226: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5227: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5228: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5229: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,

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

5222: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,
5223: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5224: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5225: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5226: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5227: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5228: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5229: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5230: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,

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

5223: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5224: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5225: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5226: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5227: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5228: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5229: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5230: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5231: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,

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

5224: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5225: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5226: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5227: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5228: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5229: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5230: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5231: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5232: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,

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

5225: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5226: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5227: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5228: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5229: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5230: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5231: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5232: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5233: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,

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

5226: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5227: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5228: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5229: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5230: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5231: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5232: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5233: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5234: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,

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

5227: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5228: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5229: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5230: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5231: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5232: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5233: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5234: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5235: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,

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

5228: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5229: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5230: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5231: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5232: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5233: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5234: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5235: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5236: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,

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

5229: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5230: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5231: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5232: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5233: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5234: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5235: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5236: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5237: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,

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

5230: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5231: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5232: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5233: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5234: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5235: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5236: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5237: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5238: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,

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

5231: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5232: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5233: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5234: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5235: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5236: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5237: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5238: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5239: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,

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

5232: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5233: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5234: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5235: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5236: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5237: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5238: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5239: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5240: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,

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

5233: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5234: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5235: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5236: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5237: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5238: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5239: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5240: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5241: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,

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

5234: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5235: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5236: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5237: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5238: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5239: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5240: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5241: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5242: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,

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

5235: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5236: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5237: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5238: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5239: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5240: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5241: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5242: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5243: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,

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

5236: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5237: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5238: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5239: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5240: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5241: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5242: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5243: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,
5244: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count

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

5237: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5238: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5239: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5240: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5241: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5242: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5243: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,
5244: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count
5245: FROM (

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

5238: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5239: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5240: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5241: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5242: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5243: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,
5244: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count
5245: FROM (
5246: SELECT

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

5239: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5240: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5241: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5242: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5243: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,
5244: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count
5245: FROM (
5246: SELECT
5247: gl_currency_api.convert_amount(currency,

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

5240: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5241: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5242: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5243: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,
5244: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count
5245: FROM (
5246: SELECT
5247: gl_currency_api.convert_amount(currency,
5248: l_limit_currency,sysdate,

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

5322: --and site_use_id = decode(l_analysis_level,'S',p_cust_acct_site_id,site_use_id)
5323: group by currency);
5324:
5325: CURSOR c_site_bal_summary IS
5326: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,
5327: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5328: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5329: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5330: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,

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

5323: group by currency);
5324:
5325: CURSOR c_site_bal_summary IS
5326: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,
5327: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5328: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5329: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5330: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5331: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,

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

5324:
5325: CURSOR c_site_bal_summary IS
5326: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,
5327: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5328: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5329: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5330: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5331: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5332: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,

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

5325: CURSOR c_site_bal_summary IS
5326: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,
5327: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5328: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5329: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5330: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5331: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5332: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5333: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,

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

5326: SELECT '34'||'^'||fnd_number.number_to_canonical(SUM(current_receivable_balance)) current_receivable_balance,
5327: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5328: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5329: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5330: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5331: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5332: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5333: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5334: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,

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

5327: '9'||'^'|| fnd_number.number_to_canonical(SUM(unapplied_cash_amount)) unapplied_cash_amount, -- unapplied case amount
5328: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5329: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5330: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5331: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5332: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5333: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5334: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5335: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,

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

5328: '10'||'^'||fnd_number.number_to_canonical(SUM(unapplied_cash_count)) unapplied_cash_count, -- unapplied cash count
5329: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5330: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5331: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5332: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5333: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5334: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5335: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5336: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,

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

5329: '48'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_value)) past_due_inv_value,
5330: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5331: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5332: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5333: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5334: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5335: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5336: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5337: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,

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

5330: '49'||'^'||fnd_number.number_to_canonical(SUM(past_due_inv_inst_count)) past_due_inv_inst_count,
5331: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5332: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5333: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5334: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5335: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5336: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5337: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5338: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,

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

5331: '50'||'^'||fnd_number.number_to_canonical(SUM(inv_amt_in_dispute)) inv_amt_in_dispute,
5332: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5333: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5334: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5335: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5336: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5337: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5338: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5339: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,

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

5332: '51'||'^'||fnd_number.number_to_canonical(SUM(disputed_inv_count)) disputed_inv_count,
5333: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5334: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5335: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5336: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5337: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5338: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5339: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5340: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,

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

5333: '56'||'^'||fnd_number.number_to_canonical(SUM(pending_adj_value)) pending_adj_value,
5334: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5335: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5336: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5337: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5338: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5339: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5340: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5341: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,

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

5334: '58'||'^'||fnd_number.number_to_canonical(SUM(total_receipts_at_risk_value)) total_receipts_at_risk_value,
5335: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5336: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5337: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5338: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5339: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5340: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5341: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5342: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,

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

5335: '170'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_value)) op_invoices_value,
5336: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5337: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5338: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5339: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5340: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5341: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5342: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5343: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,

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

5336: '171'||'^'||fnd_number.number_to_canonical(SUM(op_invoices_count)) op_invoices_count,
5337: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5338: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5339: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5340: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5341: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5342: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5343: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5344: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,

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

5337: '172'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_value)) op_debit_memos_value,
5338: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5339: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5340: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5341: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5342: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5343: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5344: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5345: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,

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

5338: '173'||'^'||fnd_number.number_to_canonical(SUM(op_debit_memos_count)) op_debit_memos_count,
5339: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5340: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5341: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5342: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5343: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5344: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5345: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5346: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,

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

5339: '174'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_value)) op_deposits_value,
5340: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5341: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5342: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5343: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5344: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5345: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5346: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5347: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,

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

5340: '175'||'^'||fnd_number.number_to_canonical(SUM(op_deposits_count)) op_deposits_count,
5341: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5342: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5343: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5344: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5345: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5346: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5347: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,
5348: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count

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

5341: '176'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_value)) op_bills_receivables_value,
5342: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5343: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5344: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5345: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5346: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5347: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,
5348: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count
5349: FROM (

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

5342: '177'||'^'||fnd_number.number_to_canonical(SUM(op_bills_receivables_count)) op_bills_receivables_count,
5343: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5344: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5345: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5346: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5347: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,
5348: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count
5349: FROM (
5350: SELECT

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

5343: '178'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_value)) op_chargeback_value,
5344: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5345: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5346: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5347: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,
5348: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count
5349: FROM (
5350: SELECT
5351: gl_currency_api.convert_amount(currency,

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

5344: '179'||'^'||fnd_number.number_to_canonical(SUM(op_chargeback_count)) op_chargeback_count,
5345: '180'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_value)) op_credit_memos_value,
5346: '181'||'^'||fnd_number.number_to_canonical(SUM(op_credit_memos_count)) op_credit_memos_count,
5347: '209'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_value)) current_invoice_value,
5348: '210'||'^'||fnd_number.number_to_canonical(SUM(current_invoice_count)) current_invoice_count
5349: FROM (
5350: SELECT
5351: gl_currency_api.convert_amount(currency,
5352: l_limit_currency,sysdate,

Line 6218: fnd_number.number_to_canonical(l_dso),

6214:
6215: build_case_folder_details(
6216: p_case_folder_id,
6217: 2, --dso
6218: fnd_number.number_to_canonical(l_dso),
6219: p_mode,
6220: p_error_msg,
6221: p_resultout);
6222: IF p_resultout <> 0

Line 6229: fnd_number.number_to_canonical(l_ddso),

6225: END IF;
6226: build_case_folder_details(
6227: p_case_folder_id,
6228: 3, -- deliquent dso
6229: fnd_number.number_to_canonical(l_ddso),
6230: p_mode,
6231: p_error_msg,
6232: p_resultout);
6233: IF p_resultout <> 0