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 FND_GLOBAL

Line 42: last_updated_by = FND_GLOBAL.user_id

38: UPDATE ra_cust_trx_line_gl_dist_all
39: SET gl_date = g_sweep_to_date,
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

Line 57: last_updated_by = FND_GLOBAL.user_id

53: UPDATE ar_receivable_applications_all
54: SET gl_date = g_sweep_to_date,
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'

Line 73: last_updated_by = FND_GLOBAL.user_id

69: UPDATE ar_cash_receipt_history_all
70: SET gl_date = g_sweep_to_date,
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'

Line 89: last_updated_by = FND_GLOBAL.user_id

85: UPDATE ar_receivable_applications_all
86: SET gl_date = g_sweep_to_date,
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'

Line 105: last_updated_by = FND_GLOBAL.user_id

101: UPDATE ar_misc_cash_distributions_all
102: SET gl_date = g_sweep_to_date,
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'

Line 121: last_updated_by = FND_GLOBAL.user_id

117: UPDATE ar_adjustments_all
118: SET gl_date = g_sweep_to_date,
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'

Line 137: last_updated_by = FND_GLOBAL.user_id

133: UPDATE ar_transaction_history_all
134: SET gl_date = g_sweep_to_date,
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'

Line 482: last_updated_by = FND_GLOBAL.user_id

478: UPDATE xla_ae_headers aeh
479: SET aeh.accounting_date = g_sweep_to_date,
480: aeh.period_name = g_sweep_period_name,
481: last_update_date = SYSDATE,
482: last_updated_by = FND_GLOBAL.user_id
483: WHERE aeh.event_id = l_event_ids(i)
484: AND application_id = 200
485: AND gl_transfer_status_code <> 'Y'
486: AND accounting_entry_status_code <> 'F';

Line 492: last_updated_by = FND_GLOBAL.user_id

488: forall i in l_event_ids.first..l_event_ids.last
489: UPDATE xla_ae_lines ael
490: SET ael.accounting_date = g_sweep_to_date,
491: last_update_date = sysdate,
492: last_updated_by = FND_GLOBAL.user_id
493: WHERE ael.ae_header_id in (
494: SELECT aeh.ae_header_id
495: FROM xla_ae_headers aeh
496: WHERE aeh.event_id = l_event_ids(i)