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_UNACCOUNTED_TRX_SWEEP dependencies on AR_PERIOD_CLOSE_EXCPS_GT

Line 44: FROM ar_period_close_excps_gt gt

40: program_id = ln_conc_program_id,
41: last_update_date = sysdate,
42: last_updated_by = FND_GLOBAL.user_id
43: WHERE cust_trx_line_gl_dist_id in (SELECT gt.cust_trx_line_gl_dist_id
44: FROM ar_period_close_excps_gt gt
45: WHERE gt.document_type = G_SRC_TYP_UNACCT_TRX
46: AND EXISTS
47: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id))
48: AND posting_control_id = -3;

Line 59: FROM ar_period_close_excps_gt gt

55: program_id = ln_conc_program_id,
56: last_update_date = sysdate,
57: last_updated_by = FND_GLOBAL.user_id
58: WHERE receivable_application_id in (SELECT gt.dist_source_id
59: FROM ar_period_close_excps_gt gt
60: WHERE gt.document_type = G_SRC_TYP_UNACCT_TRX
61: AND gt.dist_source_table = 'RA'
62: AND EXISTS
63: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id))

Line 75: FROM ar_period_close_excps_gt gt

71: program_id = ln_conc_program_id,
72: last_update_date = sysdate,
73: last_updated_by = FND_GLOBAL.user_id
74: WHERE cash_receipt_history_id in (SELECT gt.dist_source_id
75: FROM ar_period_close_excps_gt gt
76: WHERE gt.document_type = G_SRC_TYP_UNACCT_RCT
77: AND gt.dist_source_table = 'CRH'
78: AND EXISTS
79: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id))

Line 91: FROM ar_period_close_excps_gt gt

87: program_id = ln_conc_program_id,
88: last_update_date = sysdate,
89: last_updated_by = FND_GLOBAL.user_id
90: WHERE receivable_application_id in (SELECT gt.dist_source_id
91: FROM ar_period_close_excps_gt gt
92: WHERE gt.document_type = G_SRC_TYP_UNACCT_RCT
93: AND gt.dist_source_table = 'RA'
94: AND EXISTS
95: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id))

Line 107: FROM ar_period_close_excps_gt gt

103: program_id = ln_conc_program_id,
104: last_update_date = sysdate,
105: last_updated_by = FND_GLOBAL.user_id
106: WHERE misc_cash_distribution_id in (SELECT gt.dist_source_id
107: FROM ar_period_close_excps_gt gt
108: WHERE gt.document_type = G_SRC_TYP_UNACCT_RCT
109: AND gt.dist_source_table = 'MCD'
110: AND EXISTS
111: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id))

Line 123: FROM ar_period_close_excps_gt gt

119: program_id = ln_conc_program_id,
120: last_update_date = sysdate,
121: last_updated_by = FND_GLOBAL.user_id
122: WHERE adjustment_id in (SELECT gt.dist_source_id
123: FROM ar_period_close_excps_gt gt
124: WHERE gt.document_type = G_SRC_TYP_UNACCT_ADJ
125: AND gt.dist_source_table = 'ADJ'
126: AND EXISTS
127: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id))

Line 139: FROM ar_period_close_excps_gt gt

135: program_id = ln_conc_program_id,
136: last_update_date = sysdate,
137: last_updated_by = FND_GLOBAL.user_id
138: WHERE transaction_history_id in (SELECT gt.dist_source_id
139: FROM ar_period_close_excps_gt gt
140: WHERE gt.document_type = G_SRC_TYP_UNACCT_BR
141: AND gt.dist_source_table = 'TH'
142: AND EXISTS
143: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id))

Line 161: from ar_receivable_applications_all ra, ar_period_close_excps_gt psi

157: ps.gl_date_closed = decode(ps.status,
158: 'CL', (SELECT MAX(a.gl_date)
159: from (
160: select psi.payment_schedule_id payment_schedule_id, max(ra.gl_date) gl_date
161: from ar_receivable_applications_all ra, ar_period_close_excps_gt psi
162: where ra.status = 'APP'
163: and ra.payment_schedule_id = psi.payment_schedule_id
164: group by psi.payment_schedule_id
165: union all

Line 167: from ar_receivable_applications_all ra, ar_period_close_excps_gt psi

163: and ra.payment_schedule_id = psi.payment_schedule_id
164: group by psi.payment_schedule_id
165: union all
166: select psi.payment_schedule_id payment_schedule_id, max(ra.gl_date) gl_date
167: from ar_receivable_applications_all ra, ar_period_close_excps_gt psi
168: where ra.status = 'APP'
169: and ra.applied_payment_schedule_id = psi.payment_schedule_id
170: group by psi.payment_schedule_id
171: union all

Line 173: from ar_adjustments_all adj, ar_period_close_excps_gt psi

169: and ra.applied_payment_schedule_id = psi.payment_schedule_id
170: group by psi.payment_schedule_id
171: union all
172: select psi.payment_schedule_id payment_schedule_id, max(adj.gl_date) gl_date
173: from ar_adjustments_all adj, ar_period_close_excps_gt psi
174: where adj.status = 'A'
175: and adj.amount <> 0
176: and adj.payment_schedule_id = psi.payment_schedule_id
177: group by psi.payment_schedule_id

Line 185: where payment_schedule_id in (select payment_schedule_id from ar_period_close_excps_gt gt

181: group by a.payment_schedule_id
182: ),
183: ps.gl_date_closed),
184: last_update_date = sysdate
185: where payment_schedule_id in (select payment_schedule_id from ar_period_close_excps_gt gt
186: WHERE EXISTS
187: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id))
188: and class not in ('PMT', 'BR')
189: and trunc(ps.gl_date) <> ( select nvl(min(gl_date), ps.gl_date)

Line 201: from ar_receivable_applications_all rai, ar_period_close_excps_gt gt

197: update ar_payment_schedules_all ps
198: set ps.gl_date_closed = g_sweep_to_date,
199: last_update_date = sysdate
200: where payment_schedule_id in (select rai.applied_payment_schedule_id
201: from ar_receivable_applications_all rai, ar_period_close_excps_gt gt
202: where rai.payment_schedule_id = gt.payment_schedule_id
203: and rai.application_type = 'CASH'
204: and rai.applied_payment_schedule_id is not null
205: and rai.applied_payment_schedule_id > 0

Line 212: from ar_receivable_applications_all rai, ar_period_close_excps_gt gt

208: AND EXISTS
209: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id)
210: union
211: select rai.payment_schedule_id
212: from ar_receivable_applications_all rai, ar_period_close_excps_gt gt
213: where rai.payment_schedule_id = gt.payment_schedule_id
214: and rai.application_type = 'CASH'
215: and gt.document_type = G_SRC_TYP_UNACCT_RCT
216: and gt.dist_source_table = 'RA'

Line 221: from ar_receivable_applications_all rai, ar_period_close_excps_gt gt

217: AND EXISTS
218: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id)
219: union
220: select rai.payment_schedule_id
221: from ar_receivable_applications_all rai, ar_period_close_excps_gt gt
222: where rai.payment_schedule_id = gt.payment_schedule_id
223: and rai.application_type = 'CM'
224: and rai.payment_schedule_id is not null
225: and gt.document_type = G_SRC_TYP_UNACCT_TRX

Line 231: from ar_receivable_applications_all rai, ar_period_close_excps_gt gt

227: AND EXISTS
228: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id)
229: union
230: select rai.applied_payment_schedule_id
231: from ar_receivable_applications_all rai, ar_period_close_excps_gt gt
232: where rai.payment_schedule_id = gt.payment_schedule_id
233: and rai.application_type = 'CM'
234: and rai.payment_schedule_id is not null
235: and gt.document_type = G_SRC_TYP_UNACCT_TRX

Line 241: from ar_adjustments_all adji, ar_period_close_excps_gt gt

237: AND EXISTS
238: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id)
239: union
240: select adji.payment_schedule_id
241: from ar_adjustments_all adji, ar_period_close_excps_gt gt
242: where adji.payment_schedule_id = gt.payment_schedule_id
243: and adji.adjustment_id = gt.adjustment_id
244: and gt.document_type = G_SRC_TYP_UNACCT_ADJ
245: and gt.dist_source_table = 'ADJ'

Line 264: from ar_receivable_applications_all ra, ar_period_close_excps_gt psi

260: ps.gl_date_closed = decode(ps.status,
261: 'CL', (SELECT MAX(a.gl_date)
262: from (
263: select psi.payment_schedule_id payment_schedule_id, max(ra.gl_date) gl_date
264: from ar_receivable_applications_all ra, ar_period_close_excps_gt psi
265: where ra.payment_schedule_id = psi.payment_schedule_id
266: group by psi.payment_schedule_id
267: ) a, ar_payment_schedules_all ps2
268: where ps2.payment_schedule_id = a.payment_schedule_id

Line 274: where payment_schedule_id in (select payment_schedule_id from ar_period_close_excps_gt gt

270: group by a.payment_schedule_id
271: ),
272: ps.gl_date_closed),
273: last_update_date = sysdate
274: where payment_schedule_id in (select payment_schedule_id from ar_period_close_excps_gt gt
275: WHERE EXISTS
276: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id))
277: and class = 'PMT'
278: and trunc(ps.gl_date) <> ( select nvl(min(gl_date), ps.gl_date)

Line 295: from ar_receivable_applications_all ra, ar_period_close_excps_gt psi

291: ps.gl_date_closed = decode(ps.status,
292: 'CL', (SELECT MAX(a.gl_date)
293: from (
294: select psi.payment_schedule_id payment_schedule_id, max(ra.gl_date) gl_date
295: from ar_receivable_applications_all ra, ar_period_close_excps_gt psi
296: where ra.status = 'APP'
297: and ra.payment_schedule_id = psi.payment_schedule_id
298: group by psi.payment_schedule_id
299: union all

Line 301: from ar_receivable_applications_all ra, ar_period_close_excps_gt psi

297: and ra.payment_schedule_id = psi.payment_schedule_id
298: group by psi.payment_schedule_id
299: union all
300: select psi.payment_schedule_id payment_schedule_id, max(ra.gl_date) gl_date
301: from ar_receivable_applications_all ra, ar_period_close_excps_gt psi
302: where ra.status = 'APP'
303: and ra.applied_payment_schedule_id = psi.payment_schedule_id
304: group by psi.payment_schedule_id
305: union all

Line 307: from ar_adjustments_all adj, ar_period_close_excps_gt psi

303: and ra.applied_payment_schedule_id = psi.payment_schedule_id
304: group by psi.payment_schedule_id
305: union all
306: select psi.payment_schedule_id payment_schedule_id, max(adj.gl_date) gl_date
307: from ar_adjustments_all adj, ar_period_close_excps_gt psi
308: where adj.status = 'A'
309: and adj.amount <> 0
310: and adj.payment_schedule_id = psi.payment_schedule_id
311: group by psi.payment_schedule_id

Line 319: where payment_schedule_id in (select payment_schedule_id from ar_period_close_excps_gt gt

315: group by a.payment_schedule_id
316: ),
317: ps.gl_date_closed),
318: last_update_date = sysdate
319: where payment_schedule_id in (select payment_schedule_id from ar_period_close_excps_gt gt
320: WHERE EXISTS
321: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id))
322: and class = 'BR'
323: and trunc(ps.gl_date) <> ( select nvl(min(gl_date), ps.gl_date)

Line 402: FROM ar_period_close_excps_gt gt

398: ,G_SRC_TYP_UNACCT_RCT, 'RECEIPTS'
399: ,G_SRC_TYP_UNACCT_ADJ, 'ADJUSTMENTS'
400: ,G_SRC_TYP_UNACCT_BR, 'BILLS_RECEIVABLE'
401: ) entity_code
402: FROM ar_period_close_excps_gt gt
403: WHERE gt.event_id is NOT NULL
404: AND gt.document_type <> G_SRC_TYP_OTHER_EXCPS
405: AND EXISTS
406: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id);

Line 590: insert into ar_period_close_excps_gt

586: <>
587:
588: -- insert statement will populate all un-posted invoice distributions
589: --
590: insert into ar_period_close_excps_gt
591: ( document_type
592: , customer_trx_id
593: , trx_number
594: , cash_receipt_id

Line 671: arp_standard.debug ('Total records inserted in ar_period_close_excps_gt for source_type='||G_SRC_TYP_UNACCT_TRX||' is:'||l_rowcount);

667:
668:
669: l_rowcount := sql%rowcount;
670:
671: arp_standard.debug ('Total records inserted in ar_period_close_excps_gt for source_type='||G_SRC_TYP_UNACCT_TRX||' is:'||l_rowcount);
672:
673: l_rowcount := NULL;
674:
675: <>

Line 679: insert into ar_period_close_excps_gt

675: <>
676:
677: -- insert statement will populate all un-posted invoice distributions
678: --
679: insert into ar_period_close_excps_gt
680: ( document_type
681: , customer_trx_id
682: , trx_number
683: , cash_receipt_id

Line 754: arp_standard.debug ('Total records inserted in ar_period_close_excps_gt for source_type='||G_SRC_TYP_UNACCT_TRX||' is:'||l_rowcount);

750:
751:
752: l_rowcount := sql%rowcount;
753:
754: arp_standard.debug ('Total records inserted in ar_period_close_excps_gt for source_type='||G_SRC_TYP_UNACCT_TRX||' is:'||l_rowcount);
755:
756: l_rowcount := NULL;
757:
758: --------------

Line 764: insert into ar_period_close_excps_gt

760: --------------
761:
762: <>
763:
764: insert into ar_period_close_excps_gt
765: ( document_type
766: , customer_trx_id
767: , trx_number
768: , cash_receipt_id

Line 836: arp_standard.debug ('Total records inserted in ar_period_close_excps_gt for cash receipts source_type='||G_SRC_TYP_UNACCT_RCT||' for table= CRH is:'||l_rowcount);

832:
833:
834: l_rowcount := sql%rowcount;
835:
836: arp_standard.debug ('Total records inserted in ar_period_close_excps_gt for cash receipts source_type='||G_SRC_TYP_UNACCT_RCT||' for table= CRH is:'||l_rowcount);
837:
838: l_rowcount := NULL;
839:
840: <>

Line 842: insert into ar_period_close_excps_gt

838: l_rowcount := NULL;
839:
840: <>
841:
842: insert into ar_period_close_excps_gt
843: ( document_type
844: , customer_trx_id
845: , trx_number
846: , cash_receipt_id

Line 913: arp_standard.debug ('Total records inserted in ar_period_close_excps_gt for MCD receipts source_type='||G_SRC_TYP_UNACCT_RCT||' for table= CRH is:'||l_rowcount);

909:
910:
911: l_rowcount := sql%rowcount;
912:
913: arp_standard.debug ('Total records inserted in ar_period_close_excps_gt for MCD receipts source_type='||G_SRC_TYP_UNACCT_RCT||' for table= CRH is:'||l_rowcount);
914:
915: l_rowcount := NULL;
916:
917: <>

Line 919: insert into ar_period_close_excps_gt

915: l_rowcount := NULL;
916:
917: <>
918:
919: insert into ar_period_close_excps_gt
920: ( document_type
921: , customer_trx_id
922: , trx_number
923: , cash_receipt_id

Line 992: arp_standard.debug ('Total records inserted in ar_period_close_excps_gt for source_type='||G_SRC_TYP_UNACCT_RCT||' for table= RA is:'||l_rowcount);

988:
989:
990: l_rowcount := sql%rowcount;
991:
992: arp_standard.debug ('Total records inserted in ar_period_close_excps_gt for source_type='||G_SRC_TYP_UNACCT_RCT||' for table= RA is:'||l_rowcount);
993:
994: l_rowcount := NULL;
995:
996: <>

Line 998: insert into ar_period_close_excps_gt

994: l_rowcount := NULL;
995:
996: <>
997:
998: insert into ar_period_close_excps_gt
999: ( document_type
1000: , customer_trx_id
1001: , trx_number
1002: , cash_receipt_id

Line 1068: arp_standard.debug ('Total records inserted in ar_period_close_excps_gt for source_type='||G_SRC_TYP_UNACCT_RCT||' for table= MCD is:'||l_rowcount);

1064:
1065:
1066: l_rowcount := sql%rowcount;
1067:
1068: arp_standard.debug ('Total records inserted in ar_period_close_excps_gt for source_type='||G_SRC_TYP_UNACCT_RCT||' for table= MCD is:'||l_rowcount);
1069:
1070: l_rowcount := NULL;
1071:
1072: --------------

Line 1078: insert into ar_period_close_excps_gt

1074: --------------
1075:
1076: <>
1077:
1078: insert into ar_period_close_excps_gt
1079: ( document_type
1080: , customer_trx_id
1081: , trx_number
1082: , cash_receipt_id

Line 1151: arp_standard.debug ('Total records inserted in ar_period_close_excps_gt for source_type='||G_SRC_TYP_UNACCT_ADJ||' is:'||l_rowcount);

1147:
1148:
1149: l_rowcount := sql%rowcount;
1150:
1151: arp_standard.debug ('Total records inserted in ar_period_close_excps_gt for source_type='||G_SRC_TYP_UNACCT_ADJ||' is:'||l_rowcount);
1152:
1153: l_rowcount := NULL;
1154:
1155: --------------

Line 1161: insert into ar_period_close_excps_gt

1157: --------------
1158:
1159: <>
1160:
1161: insert into ar_period_close_excps_gt
1162: ( document_type
1163: , customer_trx_id
1164: , trx_number
1165: , cash_receipt_id

Line 1234: arp_standard.debug ('Total records inserted in ar_period_close_excps_gt for source_type='||G_SRC_TYP_UNACCT_BR||' is:'||l_rowcount);

1230:
1231:
1232: l_rowcount := sql%rowcount;
1233:
1234: arp_standard.debug ('Total records inserted in ar_period_close_excps_gt for source_type='||G_SRC_TYP_UNACCT_BR||' is:'||l_rowcount);
1235:
1236: l_rowcount := NULL;
1237:
1238:

Line 1242: UPDATE ar_period_close_excps_gt

1238:
1239: -- If an invoice / cm has posted applications against it with gl_date greater than REC gl_date and less than sweep_to_date
1240: -- then mark the invoice distributions as 'OTHER_EXCEPTIONS' as these cant be sweeped
1241: <>
1242: UPDATE ar_period_close_excps_gt
1243: SET document_type = G_SRC_TYP_OTHER_EXCPS
1244: WHERE customer_trx_id IN (SELECT pce.customer_trx_id
1245: FROM ar_period_close_excps_gt pce, ar_receivable_applications_all ra
1246: WHERE pce.document_type = G_SRC_TYP_UNACCT_TRX

Line 1245: FROM ar_period_close_excps_gt pce, ar_receivable_applications_all ra

1241: <>
1242: UPDATE ar_period_close_excps_gt
1243: SET document_type = G_SRC_TYP_OTHER_EXCPS
1244: WHERE customer_trx_id IN (SELECT pce.customer_trx_id
1245: FROM ar_period_close_excps_gt pce, ar_receivable_applications_all ra
1246: WHERE pce.document_type = G_SRC_TYP_UNACCT_TRX
1247: AND pce.account_class = 'REC'
1248: AND pce.customer_trx_id = ra.customer_trx_id
1249: AND ra.gl_date between pce.gl_date and g_period_end_date

Line 1253: FROM ar_period_close_excps_gt pce, ar_receivable_applications_all ra

1249: AND ra.gl_date between pce.gl_date and g_period_end_date
1250: AND ra.posting_control_id <> -3
1251: UNION
1252: SELECT pce.customer_trx_id
1253: FROM ar_period_close_excps_gt pce, ar_receivable_applications_all ra
1254: WHERE pce.document_type = G_SRC_TYP_UNACCT_TRX
1255: AND pce.account_class = 'REC'
1256: AND pce.customer_trx_id = ra.applied_customer_trx_id
1257: AND ra.gl_date between pce.gl_date and g_period_end_date

Line 1264: UPDATE ar_period_close_excps_gt

1260:
1261: -- If a RECEIPT has posted applications/CRH activities against it with gl_date greater than gl_date being sweeped and less than sweep_to_date
1262: -- then mark the CRH/RA records as 'OTHER_EXCEPTIONS' as these cant be sweeped
1263: <>
1264: UPDATE ar_period_close_excps_gt
1265: SET document_type = G_SRC_TYP_OTHER_EXCPS
1266: WHERE cash_receipt_id IN (SELECT pce.customer_trx_id
1267: FROM ar_period_close_excps_gt pce, ar_receivable_applications_all ra
1268: WHERE pce.document_type = G_SRC_TYP_UNACCT_RCT

Line 1267: FROM ar_period_close_excps_gt pce, ar_receivable_applications_all ra

1263: <>
1264: UPDATE ar_period_close_excps_gt
1265: SET document_type = G_SRC_TYP_OTHER_EXCPS
1266: WHERE cash_receipt_id IN (SELECT pce.customer_trx_id
1267: FROM ar_period_close_excps_gt pce, ar_receivable_applications_all ra
1268: WHERE pce.document_type = G_SRC_TYP_UNACCT_RCT
1269: AND ra.receivable_application_id = pce.dist_source_id
1270: AND pce.dist_source_table = 'RA'
1271: AND ra.gl_date between pce.gl_date and g_period_end_date

Line 1275: FROM ar_period_close_excps_gt pce, ar_cash_receipt_history_all crh

1271: AND ra.gl_date between pce.gl_date and g_period_end_date
1272: AND ra.posting_control_id <> -3
1273: UNION
1274: SELECT pce.customer_trx_id
1275: FROM ar_period_close_excps_gt pce, ar_cash_receipt_history_all crh
1276: WHERE pce.document_type = G_SRC_TYP_UNACCT_RCT
1277: AND crh.cash_receipt_history_id = pce.dist_source_id
1278: AND pce.dist_source_table = 'CRH'
1279: AND crh.gl_date between pce.gl_date and g_period_end_date