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_SYSTEM_PARAMETERS

Line 47: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_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;
49:
50: arp_standard.debug ('update_ar_acct_date: total records updated in ra_cust_trx_line_gl_dist_all: '||sql%rowcount);
51:

Line 63: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_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))
64: AND posting_control_id = -3;
65:
66: arp_standard.debug ('update_ar_acct_date: total records updated in ar_receivable_applications_all: '||sql%rowcount);
67:

Line 79: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_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))
80: AND posting_control_id = -3;
81:
82: arp_standard.debug ('update_ar_acct_date: total records updated in ar_cash_receipt_history_all: '||sql%rowcount);
83:

Line 95: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_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))
96: AND posting_control_id = -3;
97:
98: arp_standard.debug ('update_ar_acct_date: total records updated in ar_receivable_applications_all: '||sql%rowcount);
99:

Line 111: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_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))
112: AND posting_control_id = -3;
113:
114: arp_standard.debug ('update_ar_acct_date: total records updated in ar_misc_cash_distributions_all: '||sql%rowcount);
115:

Line 127: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_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))
128: AND posting_control_id = -3;
129:
130: arp_standard.debug ('update_ar_acct_date: total records updated in ar_adjustments_all: '||sql%rowcount);
131:

Line 143: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_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))
144: AND posting_control_id = -3;
145:
146: arp_standard.debug ('update_ar_acct_date: total records updated in ar_transaction_history_all: '||sql%rowcount);
147:

Line 187: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id))

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)
190: from ra_cust_trx_line_gl_dist_all
191: where customer_trx_id = ps.customer_trx_id

Line 209: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id)

205: and rai.applied_payment_schedule_id > 0
206: and gt.document_type = G_SRC_TYP_UNACCT_RCT
207: and gt.dist_source_table = 'RA'
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

Line 218: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id)

214: and rai.application_type = 'CASH'
215: and gt.document_type = G_SRC_TYP_UNACCT_RCT
216: and gt.dist_source_table = 'RA'
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

Line 228: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id)

224: and rai.payment_schedule_id is not null
225: and gt.document_type = G_SRC_TYP_UNACCT_TRX
226: and gt.dist_source_table = 'RA'
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

Line 238: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id)

234: and rai.payment_schedule_id is not null
235: and gt.document_type = G_SRC_TYP_UNACCT_TRX
236: and gt.dist_source_table = 'RA'
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

Line 247: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_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'
246: AND EXISTS
247: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id))
248: and ps.status = 'CL'
249: and ps.gl_date_closed < g_sweep_to_date
250: ;
251:

Line 276: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id))

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)
279: from ar_cash_receipt_history_all
280: where cash_receipt_id = ps.cash_receipt_id

Line 321: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id))

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)
324: from ar_transaction_history_all
325: where customer_trx_id = ps.customer_trx_id

Line 406: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id);

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);
407:
408: begin
409:
410: arp_standard.debug ('begin update_xla_events: Bulk fetch cursor c_events');

Line 1427: FROM ar_system_parameters_all

1423: ELSIF (p_reporting_level = '3000') THEN
1424:
1425: SELECT set_of_books_id
1426: INTO g_ledger_id
1427: FROM ar_system_parameters_all
1428: WHERE org_id = p_reporting_entity_id;
1429:
1430: g_org_id := p_reporting_entity_id;
1431: