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.CST_ACCRUAL_LOAD dependencies on XLA_EVENTS

Line 190: | xla_events table. |

186: | |
187: | Procedure Name : min_mre_date |
188: | |
189: | Purpose : This Procedure gets the minimum receipt date from |
190: | xla_events table. |
191: | |
192: | Called from : DetUpgDatesFromDate |
193: | |
194: | Parameters : |

Line 208: FROM xla_events ev

204: IS
205: CURSOR c_min_recp IS
206: SELECT Min(min_event_date) FROM (
207: SELECT min(ev.event_date) min_event_date
208: FROM xla_events ev
209: WHERE ev.application_id IN (707,555) /*Bug 8426283 - included application id 555 also*/
210: AND ev.event_type_code = 'RECEIVE'
211: AND ev.process_status_code = 'P'
212: AND ev.event_status_code = 'P'

Line 215: FROM xla_events ev

211: AND ev.process_status_code = 'P'
212: AND ev.event_status_code = 'P'
213: union
214: SELECT min(ev.event_date) min_event_date
215: FROM xla_events ev
216: WHERE ev.application_id IN (200)
217: /*Bug 8349881 in case of manual invoices,
218: an invoice can be raised ahead of PO*/
219: AND ev.process_status_code = 'P'