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

APPS.AR_BUS_EVENT_SUB_PVT dependencies on AR_TRX_SUMMARY

Line 13: FROM ar_trx_summary

9: p_site_use_id NUMBER,
10: p_currency VARCHAR2,
11: p_date DATE) IS
12: SELECT largest_inv_amount
13: FROM ar_trx_summary
14: WHERE cust_account_id = p_cust_acct_id
15: AND site_use_id = nvl(p_site_use_id,-99)
16: AND currency = p_currency
17: AND as_of_date = p_date

Line 143: UPDATE ar_trx_summary

139: and org_id = l_org_id;
140: END IF;
141:
142: IF l_app_type = 'CASH' THEN
143: UPDATE ar_trx_summary
144: set INV_PAID_AMOUNT = nvl(INV_PAID_AMOUNT,0)
145: + nvl(l_inv_paid_amt,0),
146: INV_INST_PMT_DAYS_SUM = nvl(INV_INST_PMT_DAYS_SUM,0)
147: + nvl(l_inv_inst_pmt_days_sum,0),

Line 235: ar_trx_summary trx_sum

231: ra_terms rt,
232: ra_terms_lines rtl,
233: ar_receivable_applications_all ra_cm,
234: ar_payment_schedules_all cm_app_ps,
235: ar_trx_summary trx_sum
236: where trx.customer_trx_id = ps.customer_trx_id
237: and trx.request_id = p_req_id
238: and trx.previous_customer_trx_id = prev_trx.customer_trx_id(+)
239: and prev_trx.cust_trx_type_id = ctt.cust_trx_type_id(+)

Line 424: UPDATE ar_trx_summary

420: );
421:
422: END IF;
423:
424: UPDATE ar_trx_summary
425: SET OP_BAL_HIGH_WATERMARK = nvl(OP_BAL_HIGH_WATERMARK,0) +
426: nvl(rec.amount_due_original,0),
427: TOTAL_INVOICES_VALUE
428: = DECODE(rec.class , 'INV',

Line 478: INSERT INTO ar_trx_summary

474: AND org_id = rec.org_id
475: AND as_of_date = rec.trx_date;
476:
477: IF SQL%NOTFOUND THEN
478: INSERT INTO ar_trx_summary
479: ( CUST_ACCOUNT_ID,
480: SITE_USE_ID,
481: ORG_ID,
482: CURRENCY,

Line 653: UPDATE ar_trx_summary

649: );
650:
651: END IF;
652:
653: UPDATE ar_trx_summary
654: set OP_BAL_HIGH_WATERMARK = nvl(OP_BAL_HIGH_WATERMARK,0)
655: + nvl(l_adj_amount,0),
656: TOTAL_ADJUSTMENTS_VALUE = nvl(TOTAL_ADJUSTMENTS_VALUE,0)
657: + DECODE(l_special_adj, 'Y',0, nvl(l_adj_amount,0)),

Line 671: INSERT INTO ar_trx_summary

667: and org_id = l_org_id;
668:
669: IF sql%NOTFOUND THEN
670:
671: INSERT INTO ar_trx_summary
672: (CUST_ACCOUNT_ID,
673: SITE_USE_ID,
674: ORG_ID,
675: CURRENCY,

Line 842: -- AR_TRX_SUMMARY

838: debug ('p_req_id ='||p_req_id);
839: END IF;
840: FOR i in create_recept_info(p_req_id)
841: LOOP
842: -- AR_TRX_SUMMARY
843: UPDATE ar_trx_summary
844: set total_cash_receipts_value = nvl(total_cash_receipts_value,0) +
845: i.receipt_amount,
846: total_cash_receipts_count = nvl(total_cash_receipts_count,0) + 1,

Line 843: UPDATE ar_trx_summary

839: END IF;
840: FOR i in create_recept_info(p_req_id)
841: LOOP
842: -- AR_TRX_SUMMARY
843: UPDATE ar_trx_summary
844: set total_cash_receipts_value = nvl(total_cash_receipts_value,0) +
845: i.receipt_amount,
846: total_cash_receipts_count = nvl(total_cash_receipts_count,0) + 1,
847: LAST_UPDATE_DATE = sysdate,

Line 857: INSERT INTO ar_trx_summary

853: and currency = i.rcpt_currency
854: and as_of_date = i.as_of_date;
855:
856: IF sql%notfound then
857: INSERT INTO ar_trx_summary
858: (CUST_ACCOUNT_ID,
859: SITE_USE_ID,
860: ORG_ID,
861: CURRENCY,

Line 940: UPDATE ar_trx_summary

936: END LOOP;
937:
938: FOR i IN application_info(p_req_id) LOOP
939:
940: UPDATE ar_trx_summary
941: SET inv_paid_amount = nvl(inv_paid_amount,0)
942: + nvl(i.amt_applied,0),
943: inv_inst_pmt_days_sum = nvl(inv_inst_pmt_days_sum,0)
944: + nvl(i.inv_inst_pmt_days_sum,0),

Line 1048: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

1044: )
1045: RETURN VARCHAR2 IS
1046:
1047: l_ps_tab ps_tab_type;
1048: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
1049: CURSOR get_trx_history(p_cust_trx_id IN NUMBER) IS
1050: SELECT *
1051: FROM AR_TRX_SUMMARY_HIST
1052: WHERE customer_trx_id = p_cust_trx_id

Line 1051: FROM AR_TRX_SUMMARY_HIST

1047: l_ps_tab ps_tab_type;
1048: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
1049: CURSOR get_trx_history(p_cust_trx_id IN NUMBER) IS
1050: SELECT *
1051: FROM AR_TRX_SUMMARY_HIST
1052: WHERE customer_trx_id = p_cust_trx_id
1053: and nvl(complete_flag,'N') = 'N'
1054: and amount_due_original is not null
1055: for update;

Line 1074: l_history_rec ar_trx_summary_hist%rowtype;

1070: l_security_gr_id NUMBER;
1071: l_counter NUMBER;
1072: l_history_exists_flag BOOLEAN;
1073: l_ps_exists BOOLEAN;
1074: l_history_rec ar_trx_summary_hist%rowtype;
1075: l_tot_inv_amt NUMBER;
1076: l_inv_inst_count NUMBER;
1077: BEGIN
1078:

Line 1134: UPDATE ar_trx_summary_hist

1130: --Update the transaction history table
1131: --set the complete_flag = 'Y'
1132: --if history records exist.
1133: --
1134: UPDATE ar_trx_summary_hist
1135: set complete_flag = 'Y',
1136: LAST_UPDATE_DATE = sysdate,
1137: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1138: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 1225: -- Update the AR_TRX_SUMMARY table

1221: decode(sign(l_ps_tab(j).due_date - trunc(sysdate)),-1,1,null));
1222:
1223: END IF;
1224: --
1225: -- Update the AR_TRX_SUMMARY table
1226: --
1227: l_tot_inv_amt := l_tot_inv_amt + l_ps_tab(j).amount_due_original;
1228:
1229: UPDATE ar_trx_summary

Line 1229: UPDATE ar_trx_summary

1225: -- Update the AR_TRX_SUMMARY table
1226: --
1227: l_tot_inv_amt := l_tot_inv_amt + l_ps_tab(j).amount_due_original;
1228:
1229: UPDATE ar_trx_summary
1230: set OP_BAL_HIGH_WATERMARK = nvl(OP_BAL_HIGH_WATERMARK,0) +
1231: l_ps_tab(j).amount_due_original+
1232: nvl(l_ps_tab(j).amount_adjusted,0),
1233: TOTAL_INVOICES_VALUE = nvl(TOTAL_INVOICES_VALUE,0) +

Line 1260: INSERT INTO ar_trx_summary

1256: and as_of_date = l_ps_tab(j).trx_date;
1257:
1258: IF SQL%NOTFOUND THEN
1259:
1260: INSERT INTO ar_trx_summary
1261: (CUST_ACCOUNT_ID,
1262: SITE_USE_ID,
1263: ORG_ID,
1264: CURRENCY,

Line 1336: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

1332: , p_event IN OUT NOCOPY WF_EVENT_T
1333: )
1334: RETURN VARCHAR2 IS
1335: l_ps_tab ps_tab_type;
1336: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
1337:
1338: CURSOR get_trx_history(p_hist_id IN NUMBER) IS
1339: SELECT *
1340: FROM AR_TRX_SUMMARY_HIST

Line 1340: FROM AR_TRX_SUMMARY_HIST

1336: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
1337:
1338: CURSOR get_trx_history(p_hist_id IN NUMBER) IS
1339: SELECT *
1340: FROM AR_TRX_SUMMARY_HIST
1341: WHERE history_id = p_hist_id;
1342: -- and nvl(complete_flag,'N') = 'N';
1343:
1344: CURSOR get_curr_larg_inv_info(p_cust_account_id IN NUMBER,

Line 1349: FROM ar_trx_summary

1345: p_site_use_id IN NUMBER,
1346: p_currency IN VARCHAR2,
1347: p_as_of_date IN DATE) IS
1348: SELECT LARGEST_INV_CUST_TRX_ID
1349: FROM ar_trx_summary
1350: WHERE cust_account_id = p_cust_account_id
1351: and site_use_id = p_site_use_id
1352: and currency = p_currency
1353: and as_of_date = p_as_of_date

Line 1368: l_history_rec ar_trx_summary_hist%rowtype;

1364: l_security_gr_id NUMBER;
1365: l_counter NUMBER;
1366: l_history_exists_flag BOOLEAN;
1367: l_ps_exists BOOLEAN;
1368: l_history_rec ar_trx_summary_hist%rowtype;
1369: l_tot_inv_amt NUMBER;
1370: l_inv_inst_count NUMBER;
1371: l_larg_inv_cust_trx_id NUMBER;
1372: l_text VARCHAR2(2000);

Line 1424: UPDATE ar_trx_summary_hist

1420: --
1421: -- Update the transaction history table set the complete_flag = 'Y'
1422: -- if history records exist.
1423: --
1424: UPDATE ar_trx_summary_hist
1425: set complete_flag = 'Y',
1426: LAST_UPDATE_DATE = sysdate,
1427: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1428: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 1481: -- Update the AR_TRX_SUMMARY table

1477: -- event would fire only after a complete event has fired.
1478:
1479:
1480: --
1481: -- Update the AR_TRX_SUMMARY table
1482: --
1483:
1484: --
1485: --Get the info about the largest invoice

Line 1538: UPDATE ar_trx_summary

1534: END IF;
1535: CLOSE get_curr_larg_inv_info;
1536: END IF;
1537:
1538: UPDATE ar_trx_summary
1539: set OP_BAL_HIGH_WATERMARK = nvl(OP_BAL_HIGH_WATERMARK,0) -
1540: (l_history_rec.amount_due_original+
1541: nvl(l_history_rec.amount_adjusted,0)),
1542: TOTAL_INVOICES_VALUE = nvl(TOTAL_INVOICES_VALUE,0) -

Line 1601: FROM AR_TRX_SUMMARY_HIST

1597: RETURN VARCHAR2 IS
1598:
1599: CURSOR get_trx_history(p_hist_id IN NUMBER) IS
1600: SELECT *
1601: FROM AR_TRX_SUMMARY_HIST
1602: WHERE history_id = p_hist_id;
1603: -- and nvl(complete_flag,'N') = 'N';
1604:
1605: CURSOR get_trx_history2 (p_history_id IN NUMBER) IS

Line 1607: from ar_trx_summary_hist

1603: -- and nvl(complete_flag,'N') = 'N';
1604:
1605: CURSOR get_trx_history2 (p_history_id IN NUMBER) IS
1606: select *
1607: from ar_trx_summary_hist
1608: where previous_history_id = p_history_id;
1609:
1610: CURSOR get_ps_info (p_ps_id IN NUMBER) IS
1611: select due_date, amount_in_dispute

Line 1624: l_history_rec ar_trx_summary_hist%rowtype;

1620: l_application_id NUMBER;
1621: l_security_gr_id NUMBER;
1622: l_history_exists_flag BOOLEAN;
1623: l_ps_exists BOOLEAN;
1624: l_history_rec ar_trx_summary_hist%rowtype;
1625: l_history_rec2 ar_trx_summary_hist%rowtype;
1626: l_tot_inv_amt NUMBER;
1627: l_history_id NUMBER(15);
1628:

Line 1625: l_history_rec2 ar_trx_summary_hist%rowtype;

1621: l_security_gr_id NUMBER;
1622: l_history_exists_flag BOOLEAN;
1623: l_ps_exists BOOLEAN;
1624: l_history_rec ar_trx_summary_hist%rowtype;
1625: l_history_rec2 ar_trx_summary_hist%rowtype;
1626: l_tot_inv_amt NUMBER;
1627: l_history_id NUMBER(15);
1628:
1629: l_due_date_change VARCHAR2(1);

Line 1674: UPDATE ar_trx_summary_hist

1670:
1671: BEGIN
1672:
1673: --Stamp the history record for the modification.
1674: UPDATE ar_trx_summary_hist
1675: set complete_flag = 'Y',
1676: LAST_UPDATE_DATE = sysdate,
1677: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1678: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 1762: UPDATE ar_trx_summary

1758: and site_use_id = nvl(l_history_rec.site_use_id,-99)
1759: and currency = l_history_rec.currency_code
1760: and org_id = l_org_id;
1761:
1762: UPDATE ar_trx_summary
1763: set DAYS_CREDIT_GRANTED_SUM = nvl(DAYS_CREDIT_GRANTED_SUM,0) +
1764: ((l_history_rec.amount_due_original
1765: + l_history_rec.amount_adjusted)
1766: * (l_history_rec2.due_date -l_history_rec.due_date)),

Line 1824: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

1820: , p_event IN OUT NOCOPY WF_EVENT_T
1821: )
1822: RETURN VARCHAR2 IS
1823: l_ps_rec AR_PAYMENT_SCHEDULES%rowtype;
1824: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
1825: CURSOR get_trx_history(p_cust_trx_id IN NUMBER) IS
1826: SELECT *
1827: FROM AR_TRX_SUMMARY_HIST
1828: WHERE customer_trx_id = p_cust_trx_id

Line 1827: FROM AR_TRX_SUMMARY_HIST

1823: l_ps_rec AR_PAYMENT_SCHEDULES%rowtype;
1824: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
1825: CURSOR get_trx_history(p_cust_trx_id IN NUMBER) IS
1826: SELECT *
1827: FROM AR_TRX_SUMMARY_HIST
1828: WHERE customer_trx_id = p_cust_trx_id
1829: and nvl(complete_flag,'N') = 'N'
1830: and amount_due_original is not null
1831: for update;

Line 1859: l_history_rec ar_trx_summary_hist%rowtype;

1855: l_security_gr_id NUMBER;
1856: l_counter NUMBER;
1857: l_history_exists_flag BOOLEAN;
1858: l_ps_exists BOOLEAN;
1859: l_history_rec ar_trx_summary_hist%rowtype;
1860: l_tot_inv_amt NUMBER;
1861: l_inv_inst_count NUMBER;
1862: l_prev_trx_op_count NUMBER;
1863: l_prev_trx_app_amt NUMBER;

Line 1933: UPDATE ar_trx_summary_hist

1929: --Update the transaction history table
1930: --set the complete_flag = 'Y'
1931: --if history records exist.
1932: --
1933: UPDATE ar_trx_summary_hist
1934: set complete_flag = 'Y',
1935: LAST_UPDATE_DATE = sysdate,
1936: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1937: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 2087: -- Update the AR_TRX_SUMMARY table

2083: );
2084:
2085: END IF;
2086: --
2087: -- Update the AR_TRX_SUMMARY table
2088: --
2089:
2090: UPDATE ar_trx_summary
2091: set OP_BAL_HIGH_WATERMARK = nvl(OP_BAL_HIGH_WATERMARK,0) +

Line 2090: UPDATE ar_trx_summary

2086: --
2087: -- Update the AR_TRX_SUMMARY table
2088: --
2089:
2090: UPDATE ar_trx_summary
2091: set OP_BAL_HIGH_WATERMARK = nvl(OP_BAL_HIGH_WATERMARK,0) +
2092: l_ps_rec.amount_due_original,
2093: TOTAL_CREDIT_MEMOS_VALUE = nvl(TOTAL_CREDIT_MEMOS_VALUE,0) +
2094: l_ps_rec.amount_due_original,

Line 2107: INSERT INTO ar_trx_summary

2103: and as_of_date = l_ps_rec.trx_date;
2104:
2105: IF SQL%NOTFOUND THEN
2106:
2107: INSERT INTO ar_trx_summary
2108: (CUST_ACCOUNT_ID,
2109: SITE_USE_ID,
2110: ORG_ID,
2111: CURRENCY,

Line 2174: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

2170: )
2171: RETURN VARCHAR2 IS
2172:
2173: l_ps_tab ps_tab_type;
2174: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
2175:
2176: CURSOR get_trx_history(p_hist_id IN NUMBER) IS
2177: SELECT *
2178: FROM AR_TRX_SUMMARY_HIST

Line 2178: FROM AR_TRX_SUMMARY_HIST

2174: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
2175:
2176: CURSOR get_trx_history(p_hist_id IN NUMBER) IS
2177: SELECT *
2178: FROM AR_TRX_SUMMARY_HIST
2179: WHERE history_id = p_hist_id;
2180:
2181: CURSOR get_prev_ctx_id (ctx_id IN NUMBER) IS
2182: select previous_customer_trx_id

Line 2198: l_history_rec ar_trx_summary_hist%rowtype;

2194: l_security_gr_id NUMBER;
2195: l_counter NUMBER;
2196: l_history_exists_flag BOOLEAN;
2197: l_ps_exists BOOLEAN;
2198: l_history_rec ar_trx_summary_hist%rowtype;
2199: l_tot_inv_amt NUMBER;
2200: l_inv_inst_count NUMBER;
2201: l_larg_inv_cust_trx_id NUMBER;
2202: l_text VARCHAR2(2000);

Line 2273: UPDATE ar_trx_summary_hist

2269: --
2270: -- Update the transaction history table set the complete_flag = 'Y'
2271: -- if history records exist.
2272: --
2273: UPDATE ar_trx_summary_hist
2274: set complete_flag = 'Y',
2275: LAST_UPDATE_DATE = sysdate,
2276: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2277: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 2358: -- Update the AR_TRX_SUMMARY table

2354: and currency = l_history_rec.currency_code
2355: and org_id = l_org_id;
2356:
2357: --
2358: -- Update the AR_TRX_SUMMARY table
2359: --
2360: UPDATE ar_trx_summary
2361: set OP_BAL_HIGH_WATERMARK = nvl(OP_BAL_HIGH_WATERMARK,0) -
2362: l_history_rec.amount_due_original,

Line 2360: UPDATE ar_trx_summary

2356:
2357: --
2358: -- Update the AR_TRX_SUMMARY table
2359: --
2360: UPDATE ar_trx_summary
2361: set OP_BAL_HIGH_WATERMARK = nvl(OP_BAL_HIGH_WATERMARK,0) -
2362: l_history_rec.amount_due_original,
2363: TOTAL_CREDIT_MEMOS_VALUE = nvl(TOTAL_CREDIT_MEMOS_VALUE,0) -
2364: l_history_rec.amount_due_original,

Line 2411: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

2407: ( p_subscription_guid In RAW
2408: , p_event IN OUT NOCOPY WF_EVENT_T
2409: ) RETURN VARCHAR2 IS
2410: l_ps_tab ps_tab_type;
2411: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
2412:
2413: CURSOR get_trx_history(p_cust_trx_id IN NUMBER) IS
2414: SELECT *
2415: FROM AR_TRX_SUMMARY_HIST

Line 2415: FROM AR_TRX_SUMMARY_HIST

2411: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
2412:
2413: CURSOR get_trx_history(p_cust_trx_id IN NUMBER) IS
2414: SELECT *
2415: FROM AR_TRX_SUMMARY_HIST
2416: WHERE customer_trx_id = p_cust_trx_id
2417: and nvl(complete_flag,'N') = 'N'
2418: and amount_due_original is not null
2419: for update;

Line 2438: l_history_rec ar_trx_summary_hist%rowtype;

2434: l_security_gr_id NUMBER;
2435: l_counter NUMBER;
2436: l_history_exists_flag BOOLEAN;
2437: l_ps_exists BOOLEAN;
2438: l_history_rec ar_trx_summary_hist%rowtype;
2439: BEGIN
2440:
2441: IF pg_debug = 'Y'
2442: THEN

Line 2497: UPDATE ar_trx_summary_hist

2493: --Update the transaction history table
2494: --set the complete_flag = 'Y'
2495: --if history records exist.
2496: --
2497: UPDATE ar_trx_summary_hist
2498: set complete_flag = 'Y',
2499: LAST_UPDATE_DATE = sysdate,
2500: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2501: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 2573: -- Update the AR_TRX_SUMMARY table

2569: );
2570:
2571: END IF;
2572: --
2573: -- Update the AR_TRX_SUMMARY table
2574: --
2575:
2576: UPDATE ar_trx_summary
2577: set OP_BAL_HIGH_WATERMARK = nvl(OP_BAL_HIGH_WATERMARK,0) +

Line 2576: UPDATE ar_trx_summary

2572: --
2573: -- Update the AR_TRX_SUMMARY table
2574: --
2575:
2576: UPDATE ar_trx_summary
2577: set OP_BAL_HIGH_WATERMARK = nvl(OP_BAL_HIGH_WATERMARK,0) +
2578: l_ps_tab(j).amount_due_original,
2579: TOTAL_DEBIT_MEMOS_VALUE = nvl(TOTAL_DEBIT_MEMOS_VALUE,0) +
2580: l_ps_tab(j).amount_due_original,

Line 2593: INSERT INTO ar_trx_summary

2589: and as_of_date = l_ps_tab(j).trx_date;
2590:
2591: IF SQL%NOTFOUND THEN
2592:
2593: INSERT INTO ar_trx_summary
2594: (CUST_ACCOUNT_ID,
2595: SITE_USE_ID,
2596: ORG_ID,
2597: CURRENCY,

Line 2660: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

2656: , p_event IN OUT NOCOPY WF_EVENT_T
2657: )
2658: RETURN VARCHAR2 IS
2659: l_ps_tab ps_tab_type;
2660: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
2661:
2662: CURSOR get_trx_history(p_hist_id IN NUMBER) IS
2663: SELECT *
2664: FROM AR_TRX_SUMMARY_HIST

Line 2664: FROM AR_TRX_SUMMARY_HIST

2660: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
2661:
2662: CURSOR get_trx_history(p_hist_id IN NUMBER) IS
2663: SELECT *
2664: FROM AR_TRX_SUMMARY_HIST
2665: WHERE history_id = p_hist_id;
2666: -- and nvl(complete_flag,'N') = 'N';
2667:
2668:

Line 2681: l_history_rec ar_trx_summary_hist%rowtype;

2677: l_security_gr_id NUMBER;
2678: l_counter NUMBER;
2679: l_history_exists_flag BOOLEAN;
2680: l_ps_exists BOOLEAN;
2681: l_history_rec ar_trx_summary_hist%rowtype;
2682: l_tot_inv_amt NUMBER;
2683: l_inv_inst_count NUMBER;
2684: l_larg_inv_cust_trx_id NUMBER;
2685: l_text VARCHAR2(2000);

Line 2733: UPDATE ar_trx_summary_hist

2729: --
2730: -- Update the transaction history table set the complete_flag = 'Y'
2731: -- if history records exist.
2732: --
2733: UPDATE ar_trx_summary_hist
2734: set complete_flag = 'Y',
2735: LAST_UPDATE_DATE = sysdate,
2736: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2737: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 2782: -- Update the AR_TRX_SUMMARY table

2778: -- event would fire only after a complete event has fired.
2779:
2780:
2781: --
2782: -- Update the AR_TRX_SUMMARY table
2783: --
2784:
2785: UPDATE ar_trx_summary
2786: set OP_BAL_HIGH_WATERMARK = nvl(OP_BAL_HIGH_WATERMARK,0) -

Line 2785: UPDATE ar_trx_summary

2781: --
2782: -- Update the AR_TRX_SUMMARY table
2783: --
2784:
2785: UPDATE ar_trx_summary
2786: set OP_BAL_HIGH_WATERMARK = nvl(OP_BAL_HIGH_WATERMARK,0) -
2787: l_history_rec.amount_due_original+
2788: nvl(l_history_rec.amount_adjusted,0),
2789: TOTAL_DEBIT_MEMOS_VALUE = nvl(TOTAL_DEBIT_MEMOS_VALUE,0) -

Line 2851: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

2847: )
2848: RETURN VARCHAR2 IS
2849:
2850: l_ps_tab ps_tab_type;
2851: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
2852:
2853: CURSOR get_trx_history(p_cust_trx_id IN NUMBER) IS
2854: SELECT *
2855: FROM AR_TRX_SUMMARY_HIST

Line 2855: FROM AR_TRX_SUMMARY_HIST

2851: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
2852:
2853: CURSOR get_trx_history(p_cust_trx_id IN NUMBER) IS
2854: SELECT *
2855: FROM AR_TRX_SUMMARY_HIST
2856: WHERE customer_trx_id = p_cust_trx_id
2857: and nvl(complete_flag,'N') = 'N'
2858: and amount_due_original is not null
2859: for update;

Line 2878: l_history_rec ar_trx_summary_hist%rowtype;

2874: l_security_gr_id NUMBER;
2875: l_counter NUMBER;
2876: l_history_exists_flag BOOLEAN;
2877: l_ps_exists BOOLEAN;
2878: l_history_rec ar_trx_summary_hist%rowtype;
2879: BEGIN
2880:
2881: IF pg_debug = 'Y'
2882: THEN

Line 2937: UPDATE ar_trx_summary_hist

2933: --Update the transaction history table
2934: --set the complete_flag = 'Y'
2935: --if history records exist.
2936: --
2937: UPDATE ar_trx_summary_hist
2938: set complete_flag = 'Y',
2939: LAST_UPDATE_DATE = sysdate,
2940: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2941: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 3014: -- Update the AR_TRX_SUMMARY table

3010: );
3011:
3012: END IF;
3013: --
3014: -- Update the AR_TRX_SUMMARY table
3015: --
3016:
3017: UPDATE ar_trx_summary
3018: set OP_BAL_HIGH_WATERMARK = nvl(OP_BAL_HIGH_WATERMARK,0) +

Line 3017: UPDATE ar_trx_summary

3013: --
3014: -- Update the AR_TRX_SUMMARY table
3015: --
3016:
3017: UPDATE ar_trx_summary
3018: set OP_BAL_HIGH_WATERMARK = nvl(OP_BAL_HIGH_WATERMARK,0) +
3019: l_ps_tab(j).amount_due_original+
3020: nvl(l_ps_tab(j).amount_adjusted,0),
3021: TOTAL_DEPOSITS_VALUE = nvl(TOTAL_DEPOSITS_VALUE,0) +

Line 3035: INSERT INTO ar_trx_summary

3031: and as_of_date = l_ps_tab(j).trx_date;
3032:
3033: IF SQL%NOTFOUND THEN
3034:
3035: INSERT INTO ar_trx_summary
3036: (CUST_ACCOUNT_ID,
3037: SITE_USE_ID,
3038: ORG_ID,
3039: CURRENCY,

Line 3101: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

3097: , p_event IN OUT NOCOPY WF_EVENT_T
3098: )
3099: RETURN VARCHAR2 IS
3100: l_ps_tab ps_tab_type;
3101: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
3102:
3103: CURSOR get_trx_history(p_hist_id IN NUMBER) IS
3104: SELECT *
3105: FROM AR_TRX_SUMMARY_HIST

Line 3105: FROM AR_TRX_SUMMARY_HIST

3101: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
3102:
3103: CURSOR get_trx_history(p_hist_id IN NUMBER) IS
3104: SELECT *
3105: FROM AR_TRX_SUMMARY_HIST
3106: WHERE history_id = p_hist_id;
3107: -- and nvl(complete_flag,'N') = 'N';
3108:
3109:

Line 3122: l_history_rec ar_trx_summary_hist%rowtype;

3118: l_security_gr_id NUMBER;
3119: l_counter NUMBER;
3120: l_history_exists_flag BOOLEAN;
3121: l_ps_exists BOOLEAN;
3122: l_history_rec ar_trx_summary_hist%rowtype;
3123: l_tot_inv_amt NUMBER;
3124: l_inv_inst_count NUMBER;
3125: l_larg_inv_cust_trx_id NUMBER;
3126: l_text VARCHAR2(2000);

Line 3176: UPDATE ar_trx_summary_hist

3172: --
3173: -- Update the transaction history table set the complete_flag = 'Y'
3174: -- if history records exist.
3175: --
3176: UPDATE ar_trx_summary_hist
3177: set complete_flag = 'Y',
3178: LAST_UPDATE_DATE = sysdate,
3179: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3180: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 3225: -- Update the AR_TRX_SUMMARY table

3221: -- event would fire only after a complete event has fired.
3222:
3223:
3224: --
3225: -- Update the AR_TRX_SUMMARY table
3226: --
3227:
3228: UPDATE ar_trx_summary
3229: set OP_BAL_HIGH_WATERMARK = nvl(OP_BAL_HIGH_WATERMARK,0) -

Line 3228: UPDATE ar_trx_summary

3224: --
3225: -- Update the AR_TRX_SUMMARY table
3226: --
3227:
3228: UPDATE ar_trx_summary
3229: set OP_BAL_HIGH_WATERMARK = nvl(OP_BAL_HIGH_WATERMARK,0) -
3230: l_history_rec.amount_due_original+
3231: nvl(l_history_rec.amount_adjusted,0),
3232: TOTAL_DEPOSITS_VALUE = nvl(TOTAL_DEPOSITS_VALUE,0) -

Line 3294: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

3290: )
3291: RETURN VARCHAR2 IS
3292:
3293: l_ps_rec AR_PAYMENT_SCHEDULES%rowtype;
3294: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
3295:
3296: CURSOR get_trx_history(p_cust_trx_id IN NUMBER) IS
3297: SELECT *
3298: FROM AR_TRX_SUMMARY_HIST

Line 3298: FROM AR_TRX_SUMMARY_HIST

3294: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
3295:
3296: CURSOR get_trx_history(p_cust_trx_id IN NUMBER) IS
3297: SELECT *
3298: FROM AR_TRX_SUMMARY_HIST
3299: WHERE customer_trx_id = p_cust_trx_id
3300: and nvl(complete_flag,'N') = 'N'
3301: and amount_due_original is not null
3302: for update;

Line 3322: l_history_rec ar_trx_summary_hist%rowtype;

3318: l_security_gr_id NUMBER;
3319: l_counter NUMBER;
3320: l_history_exists_flag BOOLEAN;
3321: l_ps_exists BOOLEAN;
3322: l_history_rec ar_trx_summary_hist%rowtype;
3323: l_tot_inv_amt NUMBER;
3324: l_inv_inst_count NUMBER;
3325: BEGIN
3326: IF pg_debug = 'Y'

Line 3381: UPDATE ar_trx_summary_hist

3377: --Update the transaction history table
3378: --set the complete_flag = 'Y'
3379: --if history records exist.
3380: --
3381: UPDATE ar_trx_summary_hist
3382: set complete_flag = 'Y',
3383: LAST_UPDATE_DATE = sysdate,
3384: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3385: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 3455: -- Update the AR_TRX_SUMMARY table

3451: );
3452:
3453: END IF;
3454: --
3455: -- Update the AR_TRX_SUMMARY table
3456: --
3457:
3458: UPDATE ar_trx_summary
3459: set OP_BAL_HIGH_WATERMARK = nvl(OP_BAL_HIGH_WATERMARK,0) +

Line 3458: UPDATE ar_trx_summary

3454: --
3455: -- Update the AR_TRX_SUMMARY table
3456: --
3457:
3458: UPDATE ar_trx_summary
3459: set OP_BAL_HIGH_WATERMARK = nvl(OP_BAL_HIGH_WATERMARK,0) +
3460: l_ps_rec.amount_due_original,
3461: TOTAL_CHARGEBACK_VALUE = nvl(TOTAL_CHARGEBACK_VALUE,0) +
3462: l_ps_rec.amount_due_original,

Line 3475: INSERT INTO ar_trx_summary

3471: and as_of_date = l_ps_rec.trx_date;
3472:
3473: IF SQL%NOTFOUND THEN
3474:
3475: INSERT INTO ar_trx_summary
3476: (CUST_ACCOUNT_ID,
3477: SITE_USE_ID,
3478: ORG_ID,
3479: CURRENCY,

Line 3685: --we would stamp the complete_flag on the ar_trx_summary_hist

3681: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
3682: mo_global.init('AR');
3683: mo_global.set_policy_context('S',l_org_id);
3684:
3685: --we would stamp the complete_flag on the ar_trx_summary_hist
3686: --for any records for this cash receipt. They could be due to
3687: -- receipt deletion or modification.
3688: UPDATE ar_trx_summary_hist
3689: set complete_flag = 'Y',

Line 3688: UPDATE ar_trx_summary_hist

3684:
3685: --we would stamp the complete_flag on the ar_trx_summary_hist
3686: --for any records for this cash receipt. They could be due to
3687: -- receipt deletion or modification.
3688: UPDATE ar_trx_summary_hist
3689: set complete_flag = 'Y',
3690: LAST_UPDATE_DATE = sysdate,
3691: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3692: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 3776: --Update ar_trx_summary

3772: l_receipt_number
3773: );
3774: END IF;
3775:
3776: --Update ar_trx_summary
3777: UPDATE ar_trx_summary
3778: set total_cash_receipts_value = nvl(total_cash_receipts_value,0) +
3779: l_receipt_amount,
3780: total_cash_receipts_count = nvl(total_cash_receipts_count,0) + 1,

Line 3777: UPDATE ar_trx_summary

3773: );
3774: END IF;
3775:
3776: --Update ar_trx_summary
3777: UPDATE ar_trx_summary
3778: set total_cash_receipts_value = nvl(total_cash_receipts_value,0) +
3779: l_receipt_amount,
3780: total_cash_receipts_count = nvl(total_cash_receipts_count,0) + 1,
3781: LAST_UPDATE_DATE = sysdate,

Line 3791: INSERT INTO ar_trx_summary

3787: and currency = l_currency_code
3788: and as_of_date = l_receipt_date;
3789:
3790: IF sql%notfound then
3791: INSERT INTO ar_trx_summary
3792: (CUST_ACCOUNT_ID,
3793: SITE_USE_ID,
3794: ORG_ID,
3795: CURRENCY,

Line 3960: UPDATE ar_trx_summary_hist

3956: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
3957: mo_global.init('AR');
3958: mo_global.set_policy_context('S',l_org_id);
3959:
3960: UPDATE ar_trx_summary_hist
3961: set complete_flag = 'Y',
3962: LAST_UPDATE_DATE = sysdate,
3963: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3964: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 4025: --Update ar_trx_summary

4021: and org_id = l_org_id
4022: and currency = l_currency_code;
4023:
4024:
4025: --Update ar_trx_summary
4026: UPDATE ar_trx_summary
4027: set total_cash_receipts_value = nvl(total_cash_receipts_value,0) -
4028: nvl(l_receipt_amount,0),
4029: total_cash_receipts_count = nvl(total_cash_receipts_count,0) - 1,

Line 4026: UPDATE ar_trx_summary

4022: and currency = l_currency_code;
4023:
4024:
4025: --Update ar_trx_summary
4026: UPDATE ar_trx_summary
4027: set total_cash_receipts_value = nvl(total_cash_receipts_value,0) -
4028: nvl(l_receipt_amount,0),
4029: total_cash_receipts_count = nvl(total_cash_receipts_count,0) - 1,
4030: nsf_stop_payment_amount = nvl(nsf_stop_payment_amount,0)

Line 4093: from ar_trx_summary_hist

4089: WHERE payment_schedule_id = p_ps_id;
4090:
4091: CURSOR get_receipt_hist (p_hist_id IN NUMBER) IS
4092: select *
4093: from ar_trx_summary_hist
4094: where history_id = p_hist_id
4095: and nvl(complete_flag ,'N') = 'N'
4096: for update;
4097:

Line 4102: from ar_trx_summary_hist hist,

4098: CURSOR get_receipt_hist2 (p_hist_id IN NUMBER) IS
4099: select ps.cash_receipt_id, ps.trx_date, hist.amount_due_original,
4100: ps.trx_number, hist.customer_id, hist.site_use_id,
4101: ps.invoice_currency_code
4102: from ar_trx_summary_hist hist,
4103: ar_payment_schedules ps
4104: where previous_history_id = p_hist_id
4105: and ps.payment_schedule_id = hist.payment_schedule_id;
4106:

Line 4107: l_hist_rec ar_trx_summary_hist%rowtype;

4103: ar_payment_schedules ps
4104: where previous_history_id = p_hist_id
4105: and ps.payment_schedule_id = hist.payment_schedule_id;
4106:
4107: l_hist_rec ar_trx_summary_hist%rowtype;
4108: l_hist_rec2 ar_trx_summary_hist%rowtype;
4109: l_receipt_status VARCHAR2(30);
4110: l_receipt_exists VARCHAR2(10);
4111: l_history_id NUMBER;

Line 4108: l_hist_rec2 ar_trx_summary_hist%rowtype;

4104: where previous_history_id = p_hist_id
4105: and ps.payment_schedule_id = hist.payment_schedule_id;
4106:
4107: l_hist_rec ar_trx_summary_hist%rowtype;
4108: l_hist_rec2 ar_trx_summary_hist%rowtype;
4109: l_receipt_status VARCHAR2(30);
4110: l_receipt_exists VARCHAR2(10);
4111: l_history_id NUMBER;
4112: l_history2_exists_flag VARCHAR2(1);

Line 4195: UPDATE ar_trx_summary_hist

4191:
4192: END IF;
4193: CLOSE get_receipt_hist;
4194:
4195: UPDATE ar_trx_summary_hist
4196: set complete_flag = 'Y',
4197: LAST_UPDATE_DATE = sysdate,
4198: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4199: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 4261: --Update ar_trx_summary

4257: END IF;
4258:
4259:
4260:
4261: --Update ar_trx_summary
4262: UPDATE ar_trx_summary
4263: set total_cash_receipts_value = nvl(total_cash_receipts_value,0) +
4264: (l_receipt_amount - nvl(l_hist_rec.amount_due_original,0)),
4265: total_cash_receipts_count = nvl(total_cash_receipts_count,0),

Line 4262: UPDATE ar_trx_summary

4258:
4259:
4260:
4261: --Update ar_trx_summary
4262: UPDATE ar_trx_summary
4263: set total_cash_receipts_value = nvl(total_cash_receipts_value,0) +
4264: (l_receipt_amount - nvl(l_hist_rec.amount_due_original,0)),
4265: total_cash_receipts_count = nvl(total_cash_receipts_count,0),
4266: LAST_UPDATE_DATE = sysdate,

Line 4277: INSERT INTO ar_trx_summary

4273: and as_of_date = l_receipt_date;
4274:
4275:
4276: IF sql%notfound then
4277: INSERT INTO ar_trx_summary
4278: (CUST_ACCOUNT_ID,
4279: SITE_USE_ID,
4280: ORG_ID,
4281: CURRENCY,

Line 4356: --Update ar_trx_summary

4352: l_receipt_number
4353: );
4354: END IF;
4355:
4356: --Update ar_trx_summary
4357: UPDATE ar_trx_summary
4358: set total_cash_receipts_value = nvl(total_cash_receipts_value,0)
4359: - nvl(l_hist_rec.amount_due_original,0) ,
4360: total_cash_receipts_count = nvl(total_cash_receipts_count,0) -1,

Line 4357: UPDATE ar_trx_summary

4353: );
4354: END IF;
4355:
4356: --Update ar_trx_summary
4357: UPDATE ar_trx_summary
4358: set total_cash_receipts_value = nvl(total_cash_receipts_value,0)
4359: - nvl(l_hist_rec.amount_due_original,0) ,
4360: total_cash_receipts_count = nvl(total_cash_receipts_count,0) -1,
4361: LAST_UPDATE_DATE = sysdate,

Line 4371: INSERT INTO ar_trx_summary

4367: and currency = l_currency_code
4368: and as_of_date = l_receipt_date;
4369:
4370: IF sql%notfound then
4371: INSERT INTO ar_trx_summary
4372: (CUST_ACCOUNT_ID,
4373: SITE_USE_ID,
4374: ORG_ID,
4375: CURRENCY,

Line 4449: --Update ar_trx_summary

4445: l_receipt_number
4446: );
4447: END IF;
4448:
4449: --Update ar_trx_summary
4450: UPDATE ar_trx_summary
4451: set total_cash_receipts_value = nvl(total_cash_receipts_value,0)
4452: + l_receipt_amount ,
4453: total_cash_receipts_count = nvl(total_cash_receipts_count,0)+1,

Line 4450: UPDATE ar_trx_summary

4446: );
4447: END IF;
4448:
4449: --Update ar_trx_summary
4450: UPDATE ar_trx_summary
4451: set total_cash_receipts_value = nvl(total_cash_receipts_value,0)
4452: + l_receipt_amount ,
4453: total_cash_receipts_count = nvl(total_cash_receipts_count,0)+1,
4454: LAST_UPDATE_DATE = sysdate,

Line 4464: INSERT INTO ar_trx_summary

4460: and currency = l_currency_code
4461: and as_of_date = l_receipt_date;
4462:
4463: IF sql%notfound then
4464: INSERT INTO ar_trx_summary
4465: (CUST_ACCOUNT_ID,
4466: SITE_USE_ID,
4467: ORG_ID,
4468: CURRENCY,

Line 4543: --Update ar_trx_summary

4539: l_receipt_number
4540: );
4541: END IF;
4542:
4543: --Update ar_trx_summary
4544: UPDATE ar_trx_summary
4545: set total_cash_receipts_value = nvl(total_cash_receipts_value,0)
4546: - nvl(l_hist_rec.amount_due_original,0) ,
4547: total_cash_receipts_count = nvl(total_cash_receipts_count,0),

Line 4544: UPDATE ar_trx_summary

4540: );
4541: END IF;
4542:
4543: --Update ar_trx_summary
4544: UPDATE ar_trx_summary
4545: set total_cash_receipts_value = nvl(total_cash_receipts_value,0)
4546: - nvl(l_hist_rec.amount_due_original,0) ,
4547: total_cash_receipts_count = nvl(total_cash_receipts_count,0),
4548: LAST_UPDATE_DATE = sysdate,

Line 4558: INSERT INTO ar_trx_summary

4554: and currency = l_currency_code
4555: and as_of_date = l_receipt_date;
4556:
4557: IF sql%notfound then
4558: INSERT INTO ar_trx_summary
4559: (CUST_ACCOUNT_ID,
4560: SITE_USE_ID,
4561: ORG_ID,
4562: CURRENCY,

Line 4637: --Update ar_trx_summary

4633: );
4634: END IF;
4635:
4636:
4637: --Update ar_trx_summary
4638: UPDATE ar_trx_summary
4639: set total_cash_receipts_value = nvl(total_cash_receipts_value,0)
4640: + l_receipt_amount ,
4641: total_cash_receipts_count = nvl(total_cash_receipts_count,0)+1,

Line 4638: UPDATE ar_trx_summary

4634: END IF;
4635:
4636:
4637: --Update ar_trx_summary
4638: UPDATE ar_trx_summary
4639: set total_cash_receipts_value = nvl(total_cash_receipts_value,0)
4640: + l_receipt_amount ,
4641: total_cash_receipts_count = nvl(total_cash_receipts_count,0)+1,
4642: LAST_UPDATE_DATE = sysdate,

Line 4652: INSERT INTO ar_trx_summary

4648: and currency = l_currency_code
4649: and as_of_date = l_receipt_date;
4650:
4651: IF sql%notfound then
4652: INSERT INTO ar_trx_summary
4653: (CUST_ACCOUNT_ID,
4654: SITE_USE_ID,
4655: ORG_ID,
4656: CURRENCY,

Line 4789: FROM ar_trx_summary_hist

4785: RETURN VARCHAR2
4786: IS
4787: CURSOR hist(ps_id in number) IS
4788: SELECT *
4789: FROM ar_trx_summary_hist
4790: WHERE payment_schedule_id = ps_id;
4791:
4792: CURSOR is_this_last_payment (p_customer_id IN NUMBER,
4793: p_site_use_id IN NUMBER,

Line 4882: UPDATE ar_trx_summary_hist

4878: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
4879: mo_global.init('AR');
4880: mo_global.set_policy_context('S',l_org_id);
4881:
4882: UPDATE ar_trx_summary_hist
4883: SET complete_flag = 'Y',
4884: LAST_UPDATE_DATE = sysdate,
4885: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4886: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 4933: --Update ar_trx_summary

4929: AND org_id = l_org_id
4930: AND currency = k.currency_code;
4931:
4932:
4933: --Update ar_trx_summary
4934: UPDATE ar_trx_summary
4935: SET total_cash_receipts_value = nvl(total_cash_receipts_value,0) -
4936: nvl(k.amount_due_original,0),
4937: total_cash_receipts_count = nvl(total_cash_receipts_count,0) - 1,

Line 4934: UPDATE ar_trx_summary

4930: AND currency = k.currency_code;
4931:
4932:
4933: --Update ar_trx_summary
4934: UPDATE ar_trx_summary
4935: SET total_cash_receipts_value = nvl(total_cash_receipts_value,0) -
4936: nvl(k.amount_due_original,0),
4937: total_cash_receipts_count = nvl(total_cash_receipts_count,0) - 1,
4938: LAST_UPDATE_DATE = sysdate,

Line 5099: AR_TRX_SUMMARY

5095:
5096: /*****************************************************************
5097: Columns that need to be updated in the summary tables due to a
5098: credit memo application
5099: AR_TRX_SUMMARY
5100: ==================
5101:
5102: AR_TRX_BAL_SUMMARY
5103: ==================

Line 5304: AR_TRX_SUMMARY

5300:
5301: /*****************************************************************
5302: Columns that need to be updated in the summary tables due to a
5303: credit memo application
5304: AR_TRX_SUMMARY
5305: ==================
5306:
5307: AR_TRX_BAL_SUMMARY
5308: ==================

Line 5566: AR_TRX_SUMMARY

5562:
5563: /*****************************************************************
5564: Columns that need to be updated in the summary tables due to a
5565: receipt application
5566: AR_TRX_SUMMARY
5567: ==================
5568: 1) INV_PAID_AMOUNT
5569: 2) INV_INST_PMT_DAYS_SUM
5570: 3) TOTAL_EARNED_DISC_VALUE

Line 5947: AR_TRX_SUMMARY

5943:
5944: /*****************************************************************
5945: Columns that need to be updated in the summary tables due to a
5946: receipt application
5947: AR_TRX_SUMMARY
5948: ==================
5949: 1) INV_PAID_AMOUNT
5950: 2) INV_INST_PMT_DAYS_SUM
5951: 3) TOTAL_EARNED_DISC_VALUE

Line 6113: ar_trx_summary trx_sum

6109: ra_terms rt,
6110: ra_terms_lines rtl,
6111: ar_receivable_applications_all ra_cm,
6112: ar_payment_schedules_all cm_app_ps,
6113: ar_trx_summary trx_sum
6114: where trx.customer_trx_id = ps.customer_trx_id
6115: and trx.request_id = p_req_id
6116: and trx.previous_customer_trx_id = prev_trx.customer_trx_id(+)
6117: and prev_trx.cust_trx_type_id = ctt.cust_trx_type_id(+)