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 NVL(org_id,'-99') = NVL(l_org_id,-99);
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 425: UPDATE ar_trx_summary

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

Line 479: INSERT INTO ar_trx_summary

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

Line 654: UPDATE ar_trx_summary

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

Line 672: INSERT INTO ar_trx_summary

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

Line 843: -- AR_TRX_SUMMARY

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

Line 844: UPDATE ar_trx_summary

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

Line 858: INSERT INTO ar_trx_summary

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

Line 941: UPDATE ar_trx_summary

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

Line 1049: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

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

Line 1052: FROM AR_TRX_SUMMARY_HIST

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

Line 1075: l_history_rec ar_trx_summary_hist%rowtype;

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

Line 1136: UPDATE ar_trx_summary_hist

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

Line 1227: -- Update the AR_TRX_SUMMARY table

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

Line 1231: UPDATE ar_trx_summary

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

Line 1262: INSERT INTO ar_trx_summary

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

Line 1338: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

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

Line 1342: FROM AR_TRX_SUMMARY_HIST

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

Line 1351: FROM ar_trx_summary

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

Line 1370: l_history_rec ar_trx_summary_hist%rowtype;

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

Line 1426: UPDATE ar_trx_summary_hist

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

Line 1483: -- Update the AR_TRX_SUMMARY table

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

Line 1540: UPDATE ar_trx_summary

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

Line 1603: FROM AR_TRX_SUMMARY_HIST

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

Line 1609: from ar_trx_summary_hist

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

Line 1626: l_history_rec ar_trx_summary_hist%rowtype;

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

Line 1627: l_history_rec2 ar_trx_summary_hist%rowtype;

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

Line 1676: UPDATE ar_trx_summary_hist

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

Line 1764: UPDATE ar_trx_summary

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

Line 1826: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

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

Line 1829: FROM AR_TRX_SUMMARY_HIST

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

Line 1861: l_history_rec ar_trx_summary_hist%rowtype;

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

Line 1935: UPDATE ar_trx_summary_hist

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

Line 2089: -- Update the AR_TRX_SUMMARY table

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

Line 2092: UPDATE ar_trx_summary

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

Line 2109: INSERT INTO ar_trx_summary

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

Line 2176: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

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

Line 2180: FROM AR_TRX_SUMMARY_HIST

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

Line 2200: l_history_rec ar_trx_summary_hist%rowtype;

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

Line 2275: UPDATE ar_trx_summary_hist

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

Line 2360: -- Update the AR_TRX_SUMMARY table

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

Line 2362: UPDATE ar_trx_summary

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

Line 2413: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

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

Line 2417: FROM AR_TRX_SUMMARY_HIST

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

Line 2440: l_history_rec ar_trx_summary_hist%rowtype;

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

Line 2500: UPDATE ar_trx_summary_hist

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

Line 2576: -- Update the AR_TRX_SUMMARY table

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

Line 2579: UPDATE ar_trx_summary

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

Line 2596: INSERT INTO ar_trx_summary

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

Line 2663: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

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

Line 2667: FROM AR_TRX_SUMMARY_HIST

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

Line 2684: l_history_rec ar_trx_summary_hist%rowtype;

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

Line 2736: UPDATE ar_trx_summary_hist

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

Line 2785: -- Update the AR_TRX_SUMMARY table

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

Line 2788: UPDATE ar_trx_summary

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

Line 2854: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

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

Line 2858: FROM AR_TRX_SUMMARY_HIST

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

Line 2881: l_history_rec ar_trx_summary_hist%rowtype;

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

Line 2941: UPDATE ar_trx_summary_hist

2937: --Update the transaction history table
2938: --set the complete_flag = 'Y'
2939: --if history records exist.
2940: --
2941: UPDATE ar_trx_summary_hist
2942: set complete_flag = 'Y',
2943: LAST_UPDATE_DATE = sysdate,
2944: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2945: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 3018: -- Update the AR_TRX_SUMMARY table

3014: );
3015:
3016: END IF;
3017: --
3018: -- Update the AR_TRX_SUMMARY table
3019: --
3020:
3021: UPDATE ar_trx_summary
3022: set OP_BAL_HIGH_WATERMARK = nvl(OP_BAL_HIGH_WATERMARK,0) +

Line 3021: UPDATE ar_trx_summary

3017: --
3018: -- Update the AR_TRX_SUMMARY table
3019: --
3020:
3021: UPDATE ar_trx_summary
3022: set OP_BAL_HIGH_WATERMARK = nvl(OP_BAL_HIGH_WATERMARK,0) +
3023: l_ps_tab(j).amount_due_original+
3024: nvl(l_ps_tab(j).amount_adjusted,0),
3025: TOTAL_DEPOSITS_VALUE = nvl(TOTAL_DEPOSITS_VALUE,0) +

Line 3039: INSERT INTO ar_trx_summary

3035: and as_of_date = l_ps_tab(j).trx_date;
3036:
3037: IF SQL%NOTFOUND THEN
3038:
3039: INSERT INTO ar_trx_summary
3040: (CUST_ACCOUNT_ID,
3041: SITE_USE_ID,
3042: ORG_ID,
3043: CURRENCY,

Line 3105: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

3101: , p_event IN OUT NOCOPY WF_EVENT_T
3102: )
3103: RETURN VARCHAR2 IS
3104: l_ps_tab ps_tab_type;
3105: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
3106:
3107: CURSOR get_trx_history(p_hist_id IN NUMBER) IS
3108: SELECT *
3109: FROM AR_TRX_SUMMARY_HIST

Line 3109: FROM AR_TRX_SUMMARY_HIST

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

Line 3126: l_history_rec ar_trx_summary_hist%rowtype;

3122: l_security_gr_id NUMBER;
3123: l_counter NUMBER;
3124: l_history_exists_flag BOOLEAN;
3125: l_ps_exists BOOLEAN;
3126: l_history_rec ar_trx_summary_hist%rowtype;
3127: l_tot_inv_amt NUMBER;
3128: l_inv_inst_count NUMBER;
3129: l_larg_inv_cust_trx_id NUMBER;
3130: l_text VARCHAR2(2000);

Line 3180: UPDATE ar_trx_summary_hist

3176: --
3177: -- Update the transaction history table set the complete_flag = 'Y'
3178: -- if history records exist.
3179: --
3180: UPDATE ar_trx_summary_hist
3181: set complete_flag = 'Y',
3182: LAST_UPDATE_DATE = sysdate,
3183: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3184: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 3229: -- Update the AR_TRX_SUMMARY table

3225: -- event would fire only after a complete event has fired.
3226:
3227:
3228: --
3229: -- Update the AR_TRX_SUMMARY table
3230: --
3231:
3232: UPDATE ar_trx_summary
3233: set OP_BAL_HIGH_WATERMARK = nvl(OP_BAL_HIGH_WATERMARK,0) -

Line 3232: UPDATE ar_trx_summary

3228: --
3229: -- Update the AR_TRX_SUMMARY table
3230: --
3231:
3232: UPDATE ar_trx_summary
3233: set OP_BAL_HIGH_WATERMARK = nvl(OP_BAL_HIGH_WATERMARK,0) -
3234: l_history_rec.amount_due_original+
3235: nvl(l_history_rec.amount_adjusted,0),
3236: TOTAL_DEPOSITS_VALUE = nvl(TOTAL_DEPOSITS_VALUE,0) -

Line 3298: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

3294: )
3295: RETURN VARCHAR2 IS
3296:
3297: l_ps_rec AR_PAYMENT_SCHEDULES%rowtype;
3298: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
3299:
3300: CURSOR get_trx_history(p_cust_trx_id IN NUMBER) IS
3301: SELECT *
3302: FROM AR_TRX_SUMMARY_HIST

Line 3302: FROM AR_TRX_SUMMARY_HIST

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

Line 3326: l_history_rec ar_trx_summary_hist%rowtype;

3322: l_security_gr_id NUMBER;
3323: l_counter NUMBER;
3324: l_history_exists_flag BOOLEAN;
3325: l_ps_exists BOOLEAN;
3326: l_history_rec ar_trx_summary_hist%rowtype;
3327: l_tot_inv_amt NUMBER;
3328: l_inv_inst_count NUMBER;
3329: BEGIN
3330: IF pg_debug = 'Y'

Line 3386: UPDATE ar_trx_summary_hist

3382: --Update the transaction history table
3383: --set the complete_flag = 'Y'
3384: --if history records exist.
3385: --
3386: UPDATE ar_trx_summary_hist
3387: set complete_flag = 'Y',
3388: LAST_UPDATE_DATE = sysdate,
3389: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3390: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 3460: -- Update the AR_TRX_SUMMARY table

3456: );
3457:
3458: END IF;
3459: --
3460: -- Update the AR_TRX_SUMMARY table
3461: --
3462:
3463: UPDATE ar_trx_summary
3464: set OP_BAL_HIGH_WATERMARK = nvl(OP_BAL_HIGH_WATERMARK,0) +

Line 3463: UPDATE ar_trx_summary

3459: --
3460: -- Update the AR_TRX_SUMMARY table
3461: --
3462:
3463: UPDATE ar_trx_summary
3464: set OP_BAL_HIGH_WATERMARK = nvl(OP_BAL_HIGH_WATERMARK,0) +
3465: l_ps_rec.amount_due_original,
3466: TOTAL_CHARGEBACK_VALUE = nvl(TOTAL_CHARGEBACK_VALUE,0) +
3467: l_ps_rec.amount_due_original,

Line 3480: INSERT INTO ar_trx_summary

3476: and as_of_date = l_ps_rec.trx_date;
3477:
3478: IF SQL%NOTFOUND THEN
3479:
3480: INSERT INTO ar_trx_summary
3481: (CUST_ACCOUNT_ID,
3482: SITE_USE_ID,
3483: ORG_ID,
3484: CURRENCY,

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

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

Line 3691: UPDATE ar_trx_summary_hist

3687:
3688: --we would stamp the complete_flag on the ar_trx_summary_hist
3689: --for any records for this cash receipt. They could be due to
3690: -- receipt deletion or modification.
3691: UPDATE ar_trx_summary_hist
3692: set complete_flag = 'Y',
3693: LAST_UPDATE_DATE = sysdate,
3694: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3695: 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 3971: UPDATE ar_trx_summary_hist

3967: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
3968: mo_global.init('AR');
3969: mo_global.set_policy_context('S',l_org_id);
3970:
3971: UPDATE ar_trx_summary_hist
3972: set complete_flag = 'Y',
3973: LAST_UPDATE_DATE = sysdate,
3974: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3975: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 4036: --Update ar_trx_summary

4032: and NVL(org_id,'-99') = NVL(l_org_id,-99)
4033: and currency = l_currency_code;
4034:
4035:
4036: --Update ar_trx_summary
4037: UPDATE ar_trx_summary
4038: set total_cash_receipts_value = nvl(total_cash_receipts_value,0) -
4039: nvl(l_receipt_amount,0),
4040: total_cash_receipts_count = nvl(total_cash_receipts_count,0) - 1,

Line 4037: UPDATE ar_trx_summary

4033: and currency = l_currency_code;
4034:
4035:
4036: --Update ar_trx_summary
4037: UPDATE ar_trx_summary
4038: set total_cash_receipts_value = nvl(total_cash_receipts_value,0) -
4039: nvl(l_receipt_amount,0),
4040: total_cash_receipts_count = nvl(total_cash_receipts_count,0) - 1,
4041: nsf_stop_payment_amount = nvl(nsf_stop_payment_amount,0)

Line 4104: from ar_trx_summary_hist

4100: WHERE payment_schedule_id = p_ps_id;
4101:
4102: CURSOR get_receipt_hist (p_hist_id IN NUMBER) IS
4103: select *
4104: from ar_trx_summary_hist
4105: where history_id = p_hist_id
4106: and nvl(complete_flag ,'N') = 'N'
4107: for update;
4108:

Line 4113: from ar_trx_summary_hist hist,

4109: CURSOR get_receipt_hist2 (p_hist_id IN NUMBER) IS
4110: select ps.cash_receipt_id, ps.trx_date, hist.amount_due_original * -1,
4111: ps.trx_number, hist.customer_id, hist.site_use_id,
4112: ps.invoice_currency_code
4113: from ar_trx_summary_hist hist,
4114: ar_payment_schedules ps
4115: where previous_history_id = p_hist_id
4116: and ps.payment_schedule_id = hist.payment_schedule_id;
4117:

Line 4118: l_hist_rec ar_trx_summary_hist%rowtype;

4114: ar_payment_schedules ps
4115: where previous_history_id = p_hist_id
4116: and ps.payment_schedule_id = hist.payment_schedule_id;
4117:
4118: l_hist_rec ar_trx_summary_hist%rowtype;
4119: l_hist_rec2 ar_trx_summary_hist%rowtype;
4120: l_receipt_exists VARCHAR2(10);
4121: l_history_id NUMBER;
4122: l_history2_exists_flag VARCHAR2(1);

Line 4119: l_hist_rec2 ar_trx_summary_hist%rowtype;

4115: where previous_history_id = p_hist_id
4116: and ps.payment_schedule_id = hist.payment_schedule_id;
4117:
4118: l_hist_rec ar_trx_summary_hist%rowtype;
4119: l_hist_rec2 ar_trx_summary_hist%rowtype;
4120: l_receipt_exists VARCHAR2(10);
4121: l_history_id NUMBER;
4122: l_history2_exists_flag VARCHAR2(1);
4123: l_history_exists_flag VARCHAR2(1);

Line 4205: UPDATE ar_trx_summary_hist

4201:
4202: END IF;
4203: CLOSE get_receipt_hist;
4204:
4205: UPDATE ar_trx_summary_hist
4206: set complete_flag = 'Y',
4207: LAST_UPDATE_DATE = sysdate,
4208: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4209: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 4272: --Update ar_trx_summary

4268: END IF;
4269:
4270:
4271:
4272: --Update ar_trx_summary
4273: UPDATE ar_trx_summary
4274: set total_cash_receipts_value = nvl(total_cash_receipts_value,0) +
4275: (l_receipt_amount - nvl(l_hist_rec.amount_due_original,0)),
4276: total_cash_receipts_count = nvl(total_cash_receipts_count,0),

Line 4273: UPDATE ar_trx_summary

4269:
4270:
4271:
4272: --Update ar_trx_summary
4273: UPDATE ar_trx_summary
4274: set total_cash_receipts_value = nvl(total_cash_receipts_value,0) +
4275: (l_receipt_amount - nvl(l_hist_rec.amount_due_original,0)),
4276: total_cash_receipts_count = nvl(total_cash_receipts_count,0),
4277: LAST_UPDATE_DATE = sysdate,

Line 4288: INSERT INTO ar_trx_summary

4284: and as_of_date = l_receipt_date;
4285:
4286:
4287: IF sql%notfound then
4288: INSERT INTO ar_trx_summary
4289: (CUST_ACCOUNT_ID,
4290: SITE_USE_ID,
4291: ORG_ID,
4292: CURRENCY,

Line 4367: --Update ar_trx_summary

4363: l_receipt_number
4364: );
4365: END IF;
4366:
4367: --Update ar_trx_summary
4368: UPDATE ar_trx_summary
4369: set total_cash_receipts_value = nvl(total_cash_receipts_value,0)
4370: - nvl(l_hist_rec.amount_due_original,0) ,
4371: total_cash_receipts_count = nvl(total_cash_receipts_count,0) -1,

Line 4368: UPDATE ar_trx_summary

4364: );
4365: END IF;
4366:
4367: --Update ar_trx_summary
4368: UPDATE ar_trx_summary
4369: set total_cash_receipts_value = nvl(total_cash_receipts_value,0)
4370: - nvl(l_hist_rec.amount_due_original,0) ,
4371: total_cash_receipts_count = nvl(total_cash_receipts_count,0) -1,
4372: LAST_UPDATE_DATE = sysdate,

Line 4382: INSERT INTO ar_trx_summary

4378: and currency = l_currency_code
4379: and as_of_date = l_receipt_date;
4380:
4381: IF sql%notfound then
4382: INSERT INTO ar_trx_summary
4383: (CUST_ACCOUNT_ID,
4384: SITE_USE_ID,
4385: ORG_ID,
4386: CURRENCY,

Line 4460: --Update ar_trx_summary

4456: l_receipt_number
4457: );
4458: END IF;
4459:
4460: --Update ar_trx_summary
4461: UPDATE ar_trx_summary
4462: set total_cash_receipts_value = nvl(total_cash_receipts_value,0)
4463: + l_receipt_amount ,
4464: total_cash_receipts_count = nvl(total_cash_receipts_count,0)+1,

Line 4461: UPDATE ar_trx_summary

4457: );
4458: END IF;
4459:
4460: --Update ar_trx_summary
4461: UPDATE ar_trx_summary
4462: set total_cash_receipts_value = nvl(total_cash_receipts_value,0)
4463: + l_receipt_amount ,
4464: total_cash_receipts_count = nvl(total_cash_receipts_count,0)+1,
4465: LAST_UPDATE_DATE = sysdate,

Line 4475: INSERT INTO ar_trx_summary

4471: and currency = l_currency_code
4472: and as_of_date = l_receipt_date;
4473:
4474: IF sql%notfound then
4475: INSERT INTO ar_trx_summary
4476: (CUST_ACCOUNT_ID,
4477: SITE_USE_ID,
4478: ORG_ID,
4479: CURRENCY,

Line 4554: --Update ar_trx_summary

4550: l_receipt_number
4551: );
4552: END IF;
4553:
4554: --Update ar_trx_summary
4555: UPDATE ar_trx_summary
4556: set total_cash_receipts_value = nvl(total_cash_receipts_value,0)
4557: - nvl(l_hist_rec.amount_due_original,0) ,
4558: total_cash_receipts_count = nvl(total_cash_receipts_count,0),

Line 4555: UPDATE ar_trx_summary

4551: );
4552: END IF;
4553:
4554: --Update ar_trx_summary
4555: UPDATE ar_trx_summary
4556: set total_cash_receipts_value = nvl(total_cash_receipts_value,0)
4557: - nvl(l_hist_rec.amount_due_original,0) ,
4558: total_cash_receipts_count = nvl(total_cash_receipts_count,0),
4559: LAST_UPDATE_DATE = sysdate,

Line 4569: INSERT INTO ar_trx_summary

4565: and currency = l_currency_code
4566: and as_of_date = l_receipt_date;
4567:
4568: IF sql%notfound then
4569: INSERT INTO ar_trx_summary
4570: (CUST_ACCOUNT_ID,
4571: SITE_USE_ID,
4572: ORG_ID,
4573: CURRENCY,

Line 4648: --Update ar_trx_summary

4644: );
4645: END IF;
4646:
4647:
4648: --Update ar_trx_summary
4649: UPDATE ar_trx_summary
4650: set total_cash_receipts_value = nvl(total_cash_receipts_value,0)
4651: + l_receipt_amount ,
4652: total_cash_receipts_count = nvl(total_cash_receipts_count,0)+1,

Line 4649: UPDATE ar_trx_summary

4645: END IF;
4646:
4647:
4648: --Update ar_trx_summary
4649: UPDATE ar_trx_summary
4650: set total_cash_receipts_value = nvl(total_cash_receipts_value,0)
4651: + l_receipt_amount ,
4652: total_cash_receipts_count = nvl(total_cash_receipts_count,0)+1,
4653: LAST_UPDATE_DATE = sysdate,

Line 4663: INSERT INTO ar_trx_summary

4659: and currency = l_currency_code
4660: and as_of_date = l_receipt_date;
4661:
4662: IF sql%notfound then
4663: INSERT INTO ar_trx_summary
4664: (CUST_ACCOUNT_ID,
4665: SITE_USE_ID,
4666: ORG_ID,
4667: CURRENCY,

Line 4800: FROM ar_trx_summary_hist

4796: RETURN VARCHAR2
4797: IS
4798: CURSOR hist(ps_id in number) IS
4799: SELECT *
4800: FROM ar_trx_summary_hist
4801: WHERE payment_schedule_id = ps_id;
4802:
4803: CURSOR is_this_last_payment (p_customer_id IN NUMBER,
4804: p_site_use_id IN NUMBER,

Line 4893: UPDATE ar_trx_summary_hist

4889: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
4890: mo_global.init('AR');
4891: mo_global.set_policy_context('S',l_org_id);
4892:
4893: UPDATE ar_trx_summary_hist
4894: SET complete_flag = 'Y',
4895: LAST_UPDATE_DATE = sysdate,
4896: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4897: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 4944: --Update ar_trx_summary

4940: AND NVL(org_id,'-99') = NVL(l_org_id,-99)
4941: AND currency = k.currency_code;
4942:
4943:
4944: --Update ar_trx_summary
4945: UPDATE ar_trx_summary
4946: SET total_cash_receipts_value = nvl(total_cash_receipts_value,0) -
4947: nvl(k.amount_due_original * -1, 0),
4948: total_cash_receipts_count = nvl(total_cash_receipts_count,0) - 1,

Line 4945: UPDATE ar_trx_summary

4941: AND currency = k.currency_code;
4942:
4943:
4944: --Update ar_trx_summary
4945: UPDATE ar_trx_summary
4946: SET total_cash_receipts_value = nvl(total_cash_receipts_value,0) -
4947: nvl(k.amount_due_original * -1, 0),
4948: total_cash_receipts_count = nvl(total_cash_receipts_count,0) - 1,
4949: LAST_UPDATE_DATE = sysdate,

Line 5114: AR_TRX_SUMMARY

5110:
5111: /*****************************************************************
5112: Columns that need to be updated in the summary tables due to a
5113: credit memo application
5114: AR_TRX_SUMMARY
5115: ==================
5116:
5117: AR_TRX_BAL_SUMMARY
5118: ==================

Line 5322: AR_TRX_SUMMARY

5318:
5319: /*****************************************************************
5320: Columns that need to be updated in the summary tables due to a
5321: credit memo application
5322: AR_TRX_SUMMARY
5323: ==================
5324:
5325: AR_TRX_BAL_SUMMARY
5326: ==================

Line 5589: AR_TRX_SUMMARY

5585:
5586: /*****************************************************************
5587: Columns that need to be updated in the summary tables due to a
5588: receipt application
5589: AR_TRX_SUMMARY
5590: ==================
5591: 1) INV_PAID_AMOUNT
5592: 2) INV_INST_PMT_DAYS_SUM
5593: 3) TOTAL_EARNED_DISC_VALUE

Line 5975: AR_TRX_SUMMARY

5971:
5972: /*****************************************************************
5973: Columns that need to be updated in the summary tables due to a
5974: receipt application
5975: AR_TRX_SUMMARY
5976: ==================
5977: 1) INV_PAID_AMOUNT
5978: 2) INV_INST_PMT_DAYS_SUM
5979: 3) TOTAL_EARNED_DISC_VALUE

Line 6141: ar_trx_summary trx_sum

6137: ra_terms rt,
6138: ra_terms_lines rtl,
6139: ar_receivable_applications_all ra_cm,
6140: ar_payment_schedules_all cm_app_ps,
6141: ar_trx_summary trx_sum
6142: where trx.customer_trx_id = ps.customer_trx_id
6143: and trx.request_id = p_req_id
6144: and trx.previous_customer_trx_id = prev_trx.customer_trx_id(+)
6145: and prev_trx.cust_trx_type_id = ctt.cust_trx_type_id(+)