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.XLA_00140_AAD_S_000018_PKG dependencies on XLA_EVENTS_GT

Line 229918: FROM xla_events_gt xet

229914:
229915: ELSE null
229916: END source_value
229917: , null source_meaning
229918: FROM xla_events_gt xet
229919: , FA_XLA_EXT_HEADERS_B_GT h1
229920: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
229921: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
229922: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 230161: FROM xla_events_gt xet

230157:
230158: ELSE null
230159: END source_value
230160: , null source_meaning
230161: FROM xla_events_gt xet
230162: , FA_XLA_EXT_LINES_B_GT l2
230163: , IGI_IAC_XLA_LINES_GT l3
230164: , (select rownum r from all_objects where rownum <= 30 and owner = p_apps_owner)
230165: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 230407: FROM xla_events_gt xet

230403: , h1.PERIOD_CLOSE_DATE source_1
230404: , h1.ACCOUNTING_DATE source_3
230405: , h1.DEFAULT_CCID source_32
230406: , h1.TRANSFER_TO_GL_FLAG source_71
230407: FROM xla_events_gt xet
230408: , FA_XLA_EXT_HEADERS_B_GT h1
230409: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
230410: and xet.event_class_code = C_EVENT_CLASS_CODE
230411: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 230477: FROM xla_events_gt xet

230473: , l2.CURRENCY_CODE source_53
230474: , l3.IAC_ADJUSTMENT_TYPE source_64
230475: , l3.IAC_AMOUNT source_65
230476: , l3.IAC_CURRENCY_CODE source_66
230477: FROM xla_events_gt xet
230478: , FA_XLA_EXT_LINES_B_GT l2
230479: , IGI_IAC_XLA_LINES_GT l3
230480: WHERE xet.event_id between x_first_event_id and x_last_event_id
230481: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 231789: FROM xla_events_gt xet

231785:
231786: ELSE null
231787: END source_value
231788: , null source_meaning
231789: FROM xla_events_gt xet
231790: , FA_XLA_EXT_HEADERS_B_GT h1
231791: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
231792: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
231793: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 232032: FROM xla_events_gt xet

232028:
232029: ELSE null
232030: END source_value
232031: , null source_meaning
232032: FROM xla_events_gt xet
232033: , FA_XLA_EXT_LINES_B_GT l2
232034: , IGI_IAC_XLA_LINES_GT l3
232035: , (select rownum r from all_objects where rownum <= 30 and owner = p_apps_owner)
232036: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 232284: FROM xla_events_gt xet

232280: , h1.AP_INTERCOMPANY_ACCT source_21
232281: , h1.AR_INTERCOMPANY_ACCT source_22
232282: , h1.DEFAULT_CCID source_32
232283: , h1.TRANSFER_TO_GL_FLAG source_71
232284: FROM xla_events_gt xet
232285: , FA_XLA_EXT_HEADERS_B_GT h1
232286: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
232287: and xet.event_class_code = C_EVENT_CLASS_CODE
232288: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 232354: FROM xla_events_gt xet

232350: , l2.CURRENCY_CODE source_53
232351: , l3.IAC_ADJUSTMENT_TYPE source_64
232352: , l3.IAC_AMOUNT source_65
232353: , l3.IAC_CURRENCY_CODE source_66
232354: FROM xla_events_gt xet
232355: , FA_XLA_EXT_LINES_B_GT l2
232356: , IGI_IAC_XLA_LINES_GT l3
232357: WHERE xet.event_id between x_first_event_id and x_last_event_id
232358: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 233709: FROM xla_events_gt xet

233705:
233706: ELSE null
233707: END source_value
233708: , null source_meaning
233709: FROM xla_events_gt xet
233710: , FA_XLA_EXT_HEADERS_B_GT h1
233711: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
233712: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
233713: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 233871: FROM xla_events_gt xet

233867:
233868: ELSE null
233869: END source_value
233870: , null source_meaning
233871: FROM xla_events_gt xet
233872: , FA_XLA_EXT_LINES_B_GT l2
233873: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
233874: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
233875: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 234085: FROM xla_events_gt xet

234081: , h1.PERIOD_CLOSE_DATE source_1
234082: , h1.ACCOUNTING_DATE source_3
234083: , h1.DEFAULT_CCID source_32
234084: , h1.TRANSFER_TO_GL_FLAG source_71
234085: FROM xla_events_gt xet
234086: , FA_XLA_EXT_HEADERS_B_GT h1
234087: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
234088: and xet.event_type_code = C_EVENT_TYPE_CODE
234089: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 234139: FROM xla_events_gt xet

234135: , l2.ADJUSTMENT_LINE_ID source_50
234136: , l2.DISTRIBUTION_TYPE_CODE source_51
234137: , l2.ENTERED_AMOUNT source_52
234138: , l2.CURRENCY_CODE source_53
234139: FROM xla_events_gt xet
234140: , FA_XLA_EXT_LINES_B_GT l2
234141: WHERE xet.event_id between x_first_event_id and x_last_event_id
234142: and xet.event_date between p_pad_start_date and p_pad_end_date
234143: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 235126: FROM xla_events_gt xet

235122:
235123: ELSE null
235124: END source_value
235125: , null source_meaning
235126: FROM xla_events_gt xet
235127: , FA_XLA_EXT_HEADERS_B_GT h1
235128: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
235129: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
235130: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 235369: FROM xla_events_gt xet

235365:
235366: ELSE null
235367: END source_value
235368: , null source_meaning
235369: FROM xla_events_gt xet
235370: , FA_XLA_EXT_LINES_B_GT l2
235371: , IGI_IAC_XLA_LINES_GT l3
235372: , (select rownum r from all_objects where rownum <= 30 and owner = p_apps_owner)
235373: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 235615: FROM xla_events_gt xet

235611: , h1.PERIOD_CLOSE_DATE source_1
235612: , h1.ACCOUNTING_DATE source_3
235613: , h1.DEFAULT_CCID source_32
235614: , h1.TRANSFER_TO_GL_FLAG source_71
235615: FROM xla_events_gt xet
235616: , FA_XLA_EXT_HEADERS_B_GT h1
235617: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
235618: and xet.event_class_code = C_EVENT_CLASS_CODE
235619: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 235685: FROM xla_events_gt xet

235681: , l2.SOURCE_DEST_CODE source_55
235682: , l3.IAC_ADJUSTMENT_TYPE source_64
235683: , l3.IAC_AMOUNT source_65
235684: , l3.IAC_CURRENCY_CODE source_66
235685: FROM xla_events_gt xet
235686: , FA_XLA_EXT_LINES_B_GT l2
235687: , IGI_IAC_XLA_LINES_GT l3
235688: WHERE xet.event_id between x_first_event_id and x_last_event_id
235689: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 237114: FROM xla_events_gt xet

237110:
237111: ELSE null
237112: END source_value
237113: , null source_meaning
237114: FROM xla_events_gt xet
237115: , FA_XLA_EXT_HEADERS_B_GT h1
237116: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
237117: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
237118: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 237262: FROM xla_events_gt xet

237258:
237259: ELSE null
237260: END source_value
237261: , null source_meaning
237262: FROM xla_events_gt xet
237263: , FA_XLA_EXT_LINES_B_GT l2
237264: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
237265: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
237266: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 237469: FROM xla_events_gt xet

237465: , h1.PERIOD_CLOSE_DATE source_1
237466: , h1.ACCOUNTING_DATE source_3
237467: , h1.DEFAULT_CCID source_32
237468: , h1.TRANSFER_TO_GL_FLAG source_71
237469: FROM xla_events_gt xet
237470: , FA_XLA_EXT_HEADERS_B_GT h1
237471: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
237472: and xet.event_class_code = C_EVENT_CLASS_CODE
237473: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 237520: FROM xla_events_gt xet

237516: , l2.ADJUSTMENT_LINE_ID source_50
237517: , l2.DISTRIBUTION_TYPE_CODE source_51
237518: , l2.ENTERED_AMOUNT source_52
237519: , l2.CURRENCY_CODE source_53
237520: FROM xla_events_gt xet
237521: , FA_XLA_EXT_LINES_B_GT l2
237522: WHERE xet.event_id between x_first_event_id and x_last_event_id
237523: and xet.event_date between p_pad_start_date and p_pad_end_date
237524: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 238333: FROM xla_events_gt xet

238329:
238330: ELSE null
238331: END source_value
238332: , null source_meaning
238333: FROM xla_events_gt xet
238334: , FA_XLA_EXT_HEADERS_B_GT h1
238335: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
238336: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
238337: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 238481: FROM xla_events_gt xet

238477:
238478: ELSE null
238479: END source_value
238480: , null source_meaning
238481: FROM xla_events_gt xet
238482: , FA_XLA_EXT_LINES_B_GT l2
238483: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
238484: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
238485: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 238688: FROM xla_events_gt xet

238684: , h1.PERIOD_CLOSE_DATE source_1
238685: , h1.ACCOUNTING_DATE source_3
238686: , h1.DEFAULT_CCID source_32
238687: , h1.TRANSFER_TO_GL_FLAG source_71
238688: FROM xla_events_gt xet
238689: , FA_XLA_EXT_HEADERS_B_GT h1
238690: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
238691: and xet.event_class_code = C_EVENT_CLASS_CODE
238692: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 238739: FROM xla_events_gt xet

238735: , l2.ADJUSTMENT_LINE_ID source_50
238736: , l2.DISTRIBUTION_TYPE_CODE source_51
238737: , l2.ENTERED_AMOUNT source_52
238738: , l2.CURRENCY_CODE source_53
238739: FROM xla_events_gt xet
238740: , FA_XLA_EXT_LINES_B_GT l2
238741: WHERE xet.event_id between x_first_event_id and x_last_event_id
238742: and xet.event_date between p_pad_start_date and p_pad_end_date
238743: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 239552: FROM xla_events_gt xet

239548:
239549: ELSE null
239550: END source_value
239551: , null source_meaning
239552: FROM xla_events_gt xet
239553: , FA_XLA_EXT_HEADERS_B_GT h1
239554: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
239555: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
239556: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 239700: FROM xla_events_gt xet

239696:
239697: ELSE null
239698: END source_value
239699: , null source_meaning
239700: FROM xla_events_gt xet
239701: , FA_XLA_EXT_LINES_B_GT l2
239702: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
239703: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
239704: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 239907: FROM xla_events_gt xet

239903: , h1.PERIOD_CLOSE_DATE source_1
239904: , h1.ACCOUNTING_DATE source_3
239905: , h1.DEFAULT_CCID source_32
239906: , h1.TRANSFER_TO_GL_FLAG source_71
239907: FROM xla_events_gt xet
239908: , FA_XLA_EXT_HEADERS_B_GT h1
239909: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
239910: and xet.event_class_code = C_EVENT_CLASS_CODE
239911: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 239958: FROM xla_events_gt xet

239954: , l2.DISTRIBUTION_TYPE_CODE source_51
239955: , l2.ENTERED_AMOUNT source_52
239956: , l2.CURRENCY_CODE source_53
239957: , l2.SOURCE_DEST_CODE source_55
239958: FROM xla_events_gt xet
239959: , FA_XLA_EXT_LINES_B_GT l2
239960: WHERE xet.event_id between x_first_event_id and x_last_event_id
239961: and xet.event_date between p_pad_start_date and p_pad_end_date
239962: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 240877: FROM xla_events_gt xet

240873:
240874: ELSE null
240875: END source_value
240876: , null source_meaning
240877: FROM xla_events_gt xet
240878: , FA_XLA_EXT_HEADERS_B_GT h1
240879: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
240880: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
240881: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 241029: FROM xla_events_gt xet

241025:
241026: ELSE null
241027: END source_value
241028: , null source_meaning
241029: FROM xla_events_gt xet
241030: , FA_XLA_EXT_LINES_B_GT l2
241031: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
241032: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
241033: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 241266: FROM xla_events_gt xet

241262: , h1.PROCEEDS_OF_SALE_LOSS_ACCT source_27
241263: , h1.REVAL_RSV_RETIRED_LOSS_ACCT source_30
241264: , h1.DEFAULT_CCID source_32
241265: , h1.TRANSFER_TO_GL_FLAG source_71
241266: FROM xla_events_gt xet
241267: , FA_XLA_EXT_HEADERS_B_GT h1
241268: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
241269: and xet.event_type_code = C_EVENT_TYPE_CODE
241270: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 241318: FROM xla_events_gt xet

241314: , l2.DISTRIBUTION_TYPE_CODE source_51
241315: , l2.ENTERED_AMOUNT source_52
241316: , l2.CURRENCY_CODE source_53
241317: , l2.GAIN_LOSS_AMOUNT source_54
241318: FROM xla_events_gt xet
241319: , FA_XLA_EXT_LINES_B_GT l2
241320: WHERE xet.event_id between x_first_event_id and x_last_event_id
241321: and xet.event_date between p_pad_start_date and p_pad_end_date
241322: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 242498: FROM xla_events_gt xet

242494:
242495: ELSE null
242496: END source_value
242497: , null source_meaning
242498: FROM xla_events_gt xet
242499: , FA_XLA_EXT_HEADERS_B_GT h1
242500: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
242501: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
242502: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 242650: FROM xla_events_gt xet

242646:
242647: ELSE null
242648: END source_value
242649: , null source_meaning
242650: FROM xla_events_gt xet
242651: , FA_XLA_EXT_LINES_B_GT l2
242652: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
242653: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
242654: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 242890: FROM xla_events_gt xet

242886: , h1.REVAL_RSV_RETIRED_GAIN_ACCT source_29
242887: , h1.REVAL_RSV_RETIRED_LOSS_ACCT source_30
242888: , h1.DEFAULT_CCID source_32
242889: , h1.TRANSFER_TO_GL_FLAG source_71
242890: FROM xla_events_gt xet
242891: , FA_XLA_EXT_HEADERS_B_GT h1
242892: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
242893: and xet.event_type_code = C_EVENT_TYPE_CODE
242894: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 242942: FROM xla_events_gt xet

242938: , l2.DISTRIBUTION_TYPE_CODE source_51
242939: , l2.ENTERED_AMOUNT source_52
242940: , l2.CURRENCY_CODE source_53
242941: , l2.GAIN_LOSS_AMOUNT source_54
242942: FROM xla_events_gt xet
242943: , FA_XLA_EXT_LINES_B_GT l2
242944: WHERE xet.event_id between x_first_event_id and x_last_event_id
242945: and xet.event_date between p_pad_start_date and p_pad_end_date
242946: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 244074: FROM xla_events_gt xet

244070:
244071: ELSE null
244072: END source_value
244073: , null source_meaning
244074: FROM xla_events_gt xet
244075: , FA_XLA_EXT_HEADERS_B_GT h1
244076: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
244077: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
244078: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 244222: FROM xla_events_gt xet

244218:
244219: ELSE null
244220: END source_value
244221: , null source_meaning
244222: FROM xla_events_gt xet
244223: , FA_XLA_EXT_LINES_B_GT l2
244224: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
244225: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
244226: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 244429: FROM xla_events_gt xet

244425: , h1.PERIOD_CLOSE_DATE source_1
244426: , h1.ACCOUNTING_DATE source_3
244427: , h1.DEFAULT_CCID source_32
244428: , h1.TRANSFER_TO_GL_FLAG source_71
244429: FROM xla_events_gt xet
244430: , FA_XLA_EXT_HEADERS_B_GT h1
244431: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
244432: and xet.event_class_code = C_EVENT_CLASS_CODE
244433: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 244480: FROM xla_events_gt xet

244476: , l2.ADJUSTMENT_LINE_ID source_50
244477: , l2.DISTRIBUTION_TYPE_CODE source_51
244478: , l2.ENTERED_AMOUNT source_52
244479: , l2.CURRENCY_CODE source_53
244480: FROM xla_events_gt xet
244481: , FA_XLA_EXT_LINES_B_GT l2
244482: WHERE xet.event_id between x_first_event_id and x_last_event_id
244483: and xet.event_date between p_pad_start_date and p_pad_end_date
244484: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 245303: FROM xla_events_gt xet

245299:
245300: ELSE null
245301: END source_value
245302: , null source_meaning
245303: FROM xla_events_gt xet
245304: , FA_XLA_EXT_HEADERS_B_GT h1
245305: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
245306: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
245307: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 245466: FROM xla_events_gt xet

245462:
245463: ELSE null
245464: END source_value
245465: , null source_meaning
245466: FROM xla_events_gt xet
245467: , FA_XLA_EXT_LINES_B_GT l2
245468: , (select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
245469: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
245470: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 245685: FROM xla_events_gt xet

245681: , h1.AP_INTERCOMPANY_ACCT source_21
245682: , h1.AR_INTERCOMPANY_ACCT source_22
245683: , h1.DEFAULT_CCID source_32
245684: , h1.TRANSFER_TO_GL_FLAG source_71
245685: FROM xla_events_gt xet
245686: , FA_XLA_EXT_HEADERS_B_GT h1
245687: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
245688: and xet.event_class_code = C_EVENT_CLASS_CODE
245689: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 245739: FROM xla_events_gt xet

245735: , l2.DISTRIBUTION_TYPE_CODE source_51
245736: , l2.ENTERED_AMOUNT source_52
245737: , l2.CURRENCY_CODE source_53
245738: , l2.SOURCE_DEST_CODE source_55
245739: FROM xla_events_gt xet
245740: , FA_XLA_EXT_LINES_B_GT l2
245741: WHERE xet.event_id between x_first_event_id and x_last_event_id
245742: and xet.event_date between p_pad_start_date and p_pad_end_date
245743: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 246752: FROM xla_events_gt xet

246748:
246749: ELSE null
246750: END source_value
246751: , null source_meaning
246752: FROM xla_events_gt xet
246753: , FA_XLA_EXT_HEADERS_B_GT h1
246754: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
246755: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
246756: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 246905: FROM xla_events_gt xet

246901:
246902: ELSE null
246903: END source_value
246904: , null source_meaning
246905: FROM xla_events_gt xet
246906: , FA_XLA_EXT_LINES_B_GT l2
246907: , (select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
246908: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
246909: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 247120: FROM xla_events_gt xet

247116: , h1.AP_INTERCOMPANY_ACCT source_21
247117: , h1.AR_INTERCOMPANY_ACCT source_22
247118: , h1.DEFAULT_CCID source_32
247119: , h1.TRANSFER_TO_GL_FLAG source_71
247120: FROM xla_events_gt xet
247121: , FA_XLA_EXT_HEADERS_B_GT h1
247122: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
247123: and xet.event_class_code = C_EVENT_CLASS_CODE
247124: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 247172: FROM xla_events_gt xet

247168: , l2.DISTRIBUTION_TYPE_CODE source_51
247169: , l2.ENTERED_AMOUNT source_52
247170: , l2.CURRENCY_CODE source_53
247171: , l2.SOURCE_DEST_CODE source_55
247172: FROM xla_events_gt xet
247173: , FA_XLA_EXT_LINES_B_GT l2
247174: WHERE xet.event_id between x_first_event_id and x_last_event_id
247175: and xet.event_date between p_pad_start_date and p_pad_end_date
247176: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 248120: FROM xla_events_gt xet

248116:
248117: ELSE null
248118: END source_value
248119: , null source_meaning
248120: FROM xla_events_gt xet
248121: , FA_XLA_EXT_HEADERS_B_GT h1
248122: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
248123: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
248124: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 248273: FROM xla_events_gt xet

248269:
248270: ELSE null
248271: END source_value
248272: , null source_meaning
248273: FROM xla_events_gt xet
248274: , FA_XLA_EXT_LINES_B_GT l2
248275: , (select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
248276: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
248277: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 248488: FROM xla_events_gt xet

248484: , h1.AP_INTERCOMPANY_ACCT source_21
248485: , h1.AR_INTERCOMPANY_ACCT source_22
248486: , h1.DEFAULT_CCID source_32
248487: , h1.TRANSFER_TO_GL_FLAG source_71
248488: FROM xla_events_gt xet
248489: , FA_XLA_EXT_HEADERS_B_GT h1
248490: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
248491: and xet.event_class_code = C_EVENT_CLASS_CODE
248492: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 248540: FROM xla_events_gt xet

248536: , l2.DISTRIBUTION_TYPE_CODE source_51
248537: , l2.ENTERED_AMOUNT source_52
248538: , l2.CURRENCY_CODE source_53
248539: , l2.SOURCE_DEST_CODE source_55
248540: FROM xla_events_gt xet
248541: , FA_XLA_EXT_LINES_B_GT l2
248542: WHERE xet.event_id between x_first_event_id and x_last_event_id
248543: and xet.event_date between p_pad_start_date and p_pad_end_date
248544: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 249494: FROM xla_events_gt xet

249490:
249491: ELSE null
249492: END source_value
249493: , null source_meaning
249494: FROM xla_events_gt xet
249495: , FA_XLA_EXT_HEADERS_B_GT h1
249496: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
249497: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
249498: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 249632: FROM xla_events_gt xet

249628:
249629: ELSE null
249630: END source_value
249631: , null source_meaning
249632: FROM xla_events_gt xet
249633: , FA_XLA_EXT_LINES_B_GT l2
249634: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
249635: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
249636: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 249844: FROM xla_events_gt xet

249840: , h1.DEFERRED_DEPRN_RESERVE_ACCT source_18
249841: , h1.DEFAULT_CCID source_32
249842: , h1.PERIOD_COUNTER source_57
249843: , h1.BOOK_TYPE_CODE source_59
249844: FROM xla_events_gt xet
249845: , FA_XLA_EXT_HEADERS_B_GT h1
249846: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
249847: and xet.event_class_code = C_EVENT_CLASS_CODE
249848: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 249893: FROM xla_events_gt xet

249889: , l2.CURRENCY_CODE source_53
249890: , l2.ASSET_ID source_56
249891: , l2.DISTRIBUTION_ID source_58
249892: , l2.TAX_BOOK_TYPE_CODE source_60
249893: FROM xla_events_gt xet
249894: , FA_XLA_EXT_LINES_B_GT l2
249895: WHERE xet.event_id between x_first_event_id and x_last_event_id
249896: and xet.event_date between p_pad_start_date and p_pad_end_date
249897: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 250717: FROM xla_events_gt xet

250713:
250714: ELSE null
250715: END source_value
250716: , null source_meaning
250717: FROM xla_events_gt xet
250718: , FA_XLA_EXT_HEADERS_B_GT h1
250719: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
250720: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
250721: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 250860: FROM xla_events_gt xet

250856:
250857: ELSE null
250858: END source_value
250859: , null source_meaning
250860: FROM xla_events_gt xet
250861: , FA_XLA_EXT_LINES_B_GT l2
250862: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
250863: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
250864: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 251068: FROM xla_events_gt xet

251064: , h1.ACCOUNTING_DATE source_3
251065: , h1.DEPRN_ADJUSTMENT_ACCT source_20
251066: , h1.DEFAULT_CCID source_32
251067: , h1.TRANSFER_TO_GL_FLAG source_71
251068: FROM xla_events_gt xet
251069: , FA_XLA_EXT_HEADERS_B_GT h1
251070: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
251071: and xet.event_class_code = C_EVENT_CLASS_CODE
251072: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 251118: FROM xla_events_gt xet

251114: , l2.ADJUSTMENT_LINE_ID source_50
251115: , l2.DISTRIBUTION_TYPE_CODE source_51
251116: , l2.ENTERED_AMOUNT source_52
251117: , l2.CURRENCY_CODE source_53
251118: FROM xla_events_gt xet
251119: , FA_XLA_EXT_LINES_B_GT l2
251120: WHERE xet.event_id between x_first_event_id and x_last_event_id
251121: and xet.event_date between p_pad_start_date and p_pad_end_date
251122: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 251947: FROM xla_events_gt xet

251943:
251944: ELSE null
251945: END source_value
251946: , null source_meaning
251947: FROM xla_events_gt xet
251948: , FA_XLA_EXT_HEADERS_B_GT h1
251949: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
251950: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
251951: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 252215: FROM xla_events_gt xet

252211:
252212: ELSE null
252213: END source_value
252214: , null source_meaning
252215: FROM xla_events_gt xet
252216: , FA_XLA_EXT_LINES_B_GT l2
252217: , IGI_IAC_XLA_LINES_GT l3
252218: , (select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)
252219: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 252480: FROM xla_events_gt xet

252476: , h1.PERIOD_COUNTER source_57
252477: , h1.BOOK_TYPE_CODE source_59
252478: , h1.TRANSFER_TO_GL_FLAG source_71
252479: , h1.REVERSAL_FLAG source_72
252480: FROM xla_events_gt xet
252481: , FA_XLA_EXT_HEADERS_B_GT h1
252482: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
252483: and xet.event_class_code = C_EVENT_CLASS_CODE
252484: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 252555: FROM xla_events_gt xet

252551: , l2.REVAL_ENTERED_AMOUNT source_63
252552: , l3.IAC_ADJUSTMENT_TYPE source_64
252553: , l3.IAC_AMOUNT source_65
252554: , l3.IAC_CURRENCY_CODE source_66
252555: FROM xla_events_gt xet
252556: , FA_XLA_EXT_LINES_B_GT l2
252557: , IGI_IAC_XLA_LINES_GT l3
252558: WHERE xet.event_id between x_first_event_id and x_last_event_id
252559: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 253911: FROM xla_events_gt xet

253907:
253908: ELSE null
253909: END source_value
253910: , null source_meaning
253911: FROM xla_events_gt xet
253912: , FA_XLA_EXT_HEADERS_B_GT h1
253913: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
253914: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
253915: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 254104: FROM xla_events_gt xet

254100:
254101: ELSE null
254102: END source_value
254103: , null source_meaning
254104: FROM xla_events_gt xet
254105: , FA_XLA_EXT_LINES_B_GT l2
254106: , IGI_IAC_XLA_LINES_GT l3
254107: , (select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
254108: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 254324: FROM xla_events_gt xet

254320: ,xet.event_created_by
254321: ,xet.budgetary_control_flag
254322: , h1.ACCOUNTING_DATE source_3
254323: , h1.TRANSFER_TO_GL_FLAG source_71
254324: FROM xla_events_gt xet
254325: , FA_XLA_EXT_HEADERS_B_GT h1
254326: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
254327: and xet.event_class_code = C_EVENT_CLASS_CODE
254328: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 254384: FROM xla_events_gt xet

254380: , l3.IAC_ADJUSTMENT_ID source_67
254381: , l3.IAC_ASSET_ID source_68
254382: , l3.IAC_DISTRIBUTION_ID source_69
254383: , l3.IAC_ADJUSTMENT_LINE_ID source_70
254384: FROM xla_events_gt xet
254385: , FA_XLA_EXT_LINES_B_GT l2
254386: , IGI_IAC_XLA_LINES_GT l3
254387: WHERE xet.event_id between x_first_event_id and x_last_event_id
254388: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 255504: FROM xla_events_gt xet

255500:
255501: ELSE null
255502: END source_value
255503: , null source_meaning
255504: FROM xla_events_gt xet
255505: , FA_XLA_EXT_HEADERS_B_GT h1
255506: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
255507: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
255508: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 255746: FROM xla_events_gt xet

255742:
255743: ELSE null
255744: END source_value
255745: , null source_meaning
255746: FROM xla_events_gt xet
255747: , FA_XLA_EXT_LINES_B_GT l2
255748: , IGI_IAC_XLA_LINES_GT l3
255749: ,(select rownum r from all_objects where rownum <= 30 and owner = p_apps_owner)
255750: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 256023: FROM xla_events_gt xet

256019: , h1.REVAL_RSV_RETIRED_GAIN_ACCT source_29
256020: , h1.REVAL_RSV_RETIRED_LOSS_ACCT source_30
256021: , h1.DEFAULT_CCID source_32
256022: , h1.TRANSFER_TO_GL_FLAG source_71
256023: FROM xla_events_gt xet
256024: , FA_XLA_EXT_HEADERS_B_GT h1
256025: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
256026: and xet.event_type_code = C_EVENT_TYPE_CODE
256027: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 256093: FROM xla_events_gt xet

256089: , l2.GAIN_LOSS_AMOUNT source_54
256090: , l3.IAC_ADJUSTMENT_TYPE source_64
256091: , l3.IAC_AMOUNT source_65
256092: , l3.IAC_CURRENCY_CODE source_66
256093: FROM xla_events_gt xet
256094: , FA_XLA_EXT_LINES_B_GT l2
256095: , IGI_IAC_XLA_LINES_GT l3
256096: WHERE xet.event_id between x_first_event_id and x_last_event_id
256097: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 257753: FROM xla_events_gt xet

257749:
257750: ELSE null
257751: END source_value
257752: , null source_meaning
257753: FROM xla_events_gt xet
257754: , FA_XLA_EXT_HEADERS_B_GT h1
257755: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
257756: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
257757: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 257901: FROM xla_events_gt xet

257897:
257898: ELSE null
257899: END source_value
257900: , null source_meaning
257901: FROM xla_events_gt xet
257902: , FA_XLA_EXT_LINES_B_GT l2
257903: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
257904: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
257905: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 258114: FROM xla_events_gt xet

258110: , h1.AP_INTERCOMPANY_ACCT source_21
258111: , h1.AR_INTERCOMPANY_ACCT source_22
258112: , h1.DEFAULT_CCID source_32
258113: , h1.TRANSFER_TO_GL_FLAG source_71
258114: FROM xla_events_gt xet
258115: , FA_XLA_EXT_HEADERS_B_GT h1
258116: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
258117: and xet.event_class_code = C_EVENT_CLASS_CODE
258118: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 258165: FROM xla_events_gt xet

258161: , l2.DISTRIBUTION_TYPE_CODE source_51
258162: , l2.ENTERED_AMOUNT source_52
258163: , l2.CURRENCY_CODE source_53
258164: , l2.SOURCE_DEST_CODE source_55
258165: FROM xla_events_gt xet
258166: , FA_XLA_EXT_LINES_B_GT l2
258167: WHERE xet.event_id between x_first_event_id and x_last_event_id
258168: and xet.event_date between p_pad_start_date and p_pad_end_date
258169: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 259093: FROM xla_events_gt xet

259089:
259090: ELSE null
259091: END source_value
259092: , null source_meaning
259093: FROM xla_events_gt xet
259094: , FA_XLA_EXT_HEADERS_B_GT h1
259095: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
259096: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
259097: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 259335: FROM xla_events_gt xet

259331:
259332: ELSE null
259333: END source_value
259334: , null source_meaning
259335: FROM xla_events_gt xet
259336: , FA_XLA_EXT_LINES_B_GT l2
259337: , IGI_IAC_XLA_LINES_GT l3
259338: ,(select rownum r from all_objects where rownum <= 30 and owner = p_apps_owner)
259339: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 259612: FROM xla_events_gt xet

259608: , h1.REVAL_RSV_RETIRED_GAIN_ACCT source_29
259609: , h1.REVAL_RSV_RETIRED_LOSS_ACCT source_30
259610: , h1.DEFAULT_CCID source_32
259611: , h1.TRANSFER_TO_GL_FLAG source_71
259612: FROM xla_events_gt xet
259613: , FA_XLA_EXT_HEADERS_B_GT h1
259614: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
259615: and xet.event_type_code = C_EVENT_TYPE_CODE
259616: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 259682: FROM xla_events_gt xet

259678: , l2.GAIN_LOSS_AMOUNT source_54
259679: , l3.IAC_ADJUSTMENT_TYPE source_64
259680: , l3.IAC_AMOUNT source_65
259681: , l3.IAC_CURRENCY_CODE source_66
259682: FROM xla_events_gt xet
259683: , FA_XLA_EXT_LINES_B_GT l2
259684: , IGI_IAC_XLA_LINES_GT l3
259685: WHERE xet.event_id between x_first_event_id and x_last_event_id
259686: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 261285: FROM xla_events_gt xet

261281:
261282: ELSE null
261283: END source_value
261284: , null source_meaning
261285: FROM xla_events_gt xet
261286: , FA_XLA_EXT_HEADERS_B_GT h1
261287: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
261288: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
261289: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 261428: FROM xla_events_gt xet

261424:
261425: ELSE null
261426: END source_value
261427: , null source_meaning
261428: FROM xla_events_gt xet
261429: , FA_XLA_EXT_LINES_B_GT l2
261430: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
261431: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
261432: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 261639: FROM xla_events_gt xet

261635: , h1.COST_OF_REMOVAL_CLEARING_ACCT source_14
261636: , h1.PROCEEDS_OF_SALE_CLEARING_ACCT source_25
261637: , h1.DEFAULT_CCID source_32
261638: , h1.TRANSFER_TO_GL_FLAG source_71
261639: FROM xla_events_gt xet
261640: , FA_XLA_EXT_HEADERS_B_GT h1
261641: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
261642: and xet.event_class_code = C_EVENT_CLASS_CODE
261643: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 261689: FROM xla_events_gt xet

261685: , l2.ADJUSTMENT_LINE_ID source_50
261686: , l2.DISTRIBUTION_TYPE_CODE source_51
261687: , l2.ENTERED_AMOUNT source_52
261688: , l2.CURRENCY_CODE source_53
261689: FROM xla_events_gt xet
261690: , FA_XLA_EXT_LINES_B_GT l2
261691: WHERE xet.event_id between x_first_event_id and x_last_event_id
261692: and xet.event_date between p_pad_start_date and p_pad_end_date
261693: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 262534: FROM xla_events_gt xet

262530:
262531: ELSE null
262532: END source_value
262533: , null source_meaning
262534: FROM xla_events_gt xet
262535: , FA_XLA_EXT_HEADERS_B_GT h1
262536: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
262537: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
262538: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 262697: FROM xla_events_gt xet

262693:
262694: ELSE null
262695: END source_value
262696: , null source_meaning
262697: FROM xla_events_gt xet
262698: , FA_XLA_EXT_LINES_B_GT l2
262699: , (select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
262700: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
262701: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 262910: FROM xla_events_gt xet

262906: , h1.PERIOD_CLOSE_DATE source_1
262907: , h1.ACCOUNTING_DATE source_3
262908: , h1.DEFAULT_CCID source_32
262909: , h1.TRANSFER_TO_GL_FLAG source_71
262910: FROM xla_events_gt xet
262911: , FA_XLA_EXT_HEADERS_B_GT h1
262912: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
262913: and xet.event_class_code = C_EVENT_CLASS_CODE
262914: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 262964: FROM xla_events_gt xet

262960: , l2.ADJUSTMENT_LINE_ID source_50
262961: , l2.DISTRIBUTION_TYPE_CODE source_51
262962: , l2.ENTERED_AMOUNT source_52
262963: , l2.CURRENCY_CODE source_53
262964: FROM xla_events_gt xet
262965: , FA_XLA_EXT_LINES_B_GT l2
262966: WHERE xet.event_id between x_first_event_id and x_last_event_id
262967: and xet.event_date between p_pad_start_date and p_pad_end_date
262968: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 263952: FROM xla_events_gt xet

263948:
263949: ELSE null
263950: END source_value
263951: , null source_meaning
263952: FROM xla_events_gt xet
263953: , FA_XLA_EXT_HEADERS_B_GT h1
263954: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
263955: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
263956: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 264114: FROM xla_events_gt xet

264110:
264111: ELSE null
264112: END source_value
264113: , null source_meaning
264114: FROM xla_events_gt xet
264115: , FA_XLA_EXT_LINES_B_GT l2
264116: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
264117: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
264118: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 264328: FROM xla_events_gt xet

264324: , h1.PERIOD_CLOSE_DATE source_1
264325: , h1.ACCOUNTING_DATE source_3
264326: , h1.DEFAULT_CCID source_32
264327: , h1.TRANSFER_TO_GL_FLAG source_71
264328: FROM xla_events_gt xet
264329: , FA_XLA_EXT_HEADERS_B_GT h1
264330: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
264331: and xet.event_type_code = C_EVENT_TYPE_CODE
264332: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 264382: FROM xla_events_gt xet

264378: , l2.ADJUSTMENT_LINE_ID source_50
264379: , l2.DISTRIBUTION_TYPE_CODE source_51
264380: , l2.ENTERED_AMOUNT source_52
264381: , l2.CURRENCY_CODE source_53
264382: FROM xla_events_gt xet
264383: , FA_XLA_EXT_LINES_B_GT l2
264384: WHERE xet.event_id between x_first_event_id and x_last_event_id
264385: and xet.event_date between p_pad_start_date and p_pad_end_date
264386: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 265379: FROM xla_events_gt xet

265375:
265376: ELSE null
265377: END source_value
265378: , null source_meaning
265379: FROM xla_events_gt xet
265380: , FA_XLA_EXT_HEADERS_B_GT h1
265381: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
265382: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
265383: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 265562: FROM xla_events_gt xet

265558:
265559: ELSE null
265560: END source_value
265561: , null source_meaning
265562: FROM xla_events_gt xet
265563: , FA_XLA_EXT_LINES_B_GT l2
265564: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
265565: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
265566: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 265789: FROM xla_events_gt xet

265785: , h1.AP_INTERCOMPANY_ACCT source_21
265786: , h1.AR_INTERCOMPANY_ACCT source_22
265787: , h1.DEFAULT_CCID source_32
265788: , h1.TRANSFER_TO_GL_FLAG source_71
265789: FROM xla_events_gt xet
265790: , FA_XLA_EXT_HEADERS_B_GT h1
265791: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
265792: and xet.event_class_code = C_EVENT_CLASS_CODE
265793: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 265847: FROM xla_events_gt xet

265843: , l2.DISTRIBUTION_TYPE_CODE source_51
265844: , l2.ENTERED_AMOUNT source_52
265845: , l2.CURRENCY_CODE source_53
265846: , l2.SOURCE_DEST_CODE source_55
265847: FROM xla_events_gt xet
265848: , FA_XLA_EXT_LINES_B_GT l2
265849: WHERE xet.event_id between x_first_event_id and x_last_event_id
265850: and xet.event_date between p_pad_start_date and p_pad_end_date
265851: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 267280: FROM xla_events_gt xet

267276:
267277: ELSE null
267278: END source_value
267279: , null source_meaning
267280: FROM xla_events_gt xet
267281: , FA_XLA_EXT_HEADERS_B_GT h1
267282: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
267283: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
267284: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 267423: FROM xla_events_gt xet

267419:
267420: ELSE null
267421: END source_value
267422: , null source_meaning
267423: FROM xla_events_gt xet
267424: , FA_XLA_EXT_LINES_B_GT l2
267425: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
267426: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
267427: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 267634: FROM xla_events_gt xet

267630: , h1.NBV_RETIRED_GAIN_ACCT source_23
267631: , h1.NBV_RETIRED_LOSS_ACCT source_24
267632: , h1.DEFAULT_CCID source_32
267633: , h1.TRANSFER_TO_GL_FLAG source_71
267634: FROM xla_events_gt xet
267635: , FA_XLA_EXT_HEADERS_B_GT h1
267636: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
267637: and xet.event_class_code = C_EVENT_CLASS_CODE
267638: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 267684: FROM xla_events_gt xet

267680: , l2.ADJUSTMENT_LINE_ID source_50
267681: , l2.DISTRIBUTION_TYPE_CODE source_51
267682: , l2.ENTERED_AMOUNT source_52
267683: , l2.CURRENCY_CODE source_53
267684: FROM xla_events_gt xet
267685: , FA_XLA_EXT_LINES_B_GT l2
267686: WHERE xet.event_id between x_first_event_id and x_last_event_id
267687: and xet.event_date between p_pad_start_date and p_pad_end_date
267688: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 268539: FROM xla_events_gt xet

268535:
268536: ELSE null
268537: END source_value
268538: , null source_meaning
268539: FROM xla_events_gt xet
268540: , FA_XLA_EXT_HEADERS_B_GT h1
268541: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
268542: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
268543: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 268782: FROM xla_events_gt xet

268778:
268779: ELSE null
268780: END source_value
268781: , null source_meaning
268782: FROM xla_events_gt xet
268783: , FA_XLA_EXT_LINES_B_GT l2
268784: , IGI_IAC_XLA_LINES_GT l3
268785: , (select rownum r from all_objects where rownum <= 30 and owner = p_apps_owner)
268786: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 269034: FROM xla_events_gt xet

269030: , h1.AP_INTERCOMPANY_ACCT source_21
269031: , h1.AR_INTERCOMPANY_ACCT source_22
269032: , h1.DEFAULT_CCID source_32
269033: , h1.TRANSFER_TO_GL_FLAG source_71
269034: FROM xla_events_gt xet
269035: , FA_XLA_EXT_HEADERS_B_GT h1
269036: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
269037: and xet.event_class_code = C_EVENT_CLASS_CODE
269038: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 269104: FROM xla_events_gt xet

269100: , l2.SOURCE_DEST_CODE source_55
269101: , l3.IAC_ADJUSTMENT_TYPE source_64
269102: , l3.IAC_AMOUNT source_65
269103: , l3.IAC_CURRENCY_CODE source_66
269104: FROM xla_events_gt xet
269105: , FA_XLA_EXT_LINES_B_GT l2
269106: , IGI_IAC_XLA_LINES_GT l3
269107: WHERE xet.event_id between x_first_event_id and x_last_event_id
269108: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 270725: FROM xla_events_gt xet

270721:
270722: ELSE null
270723: END source_value
270724: , null source_meaning
270725: FROM xla_events_gt xet
270726: , FA_XLA_EXT_HEADERS_B_GT h1
270727: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
270728: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
270729: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 270893: FROM xla_events_gt xet

270889:
270890: ELSE null
270891: END source_value
270892: , null source_meaning
270893: FROM xla_events_gt xet
270894: , FA_XLA_EXT_LINES_B_GT l2
270895: , (select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
270896: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
270897: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 271114: FROM xla_events_gt xet

271110: , h1.AP_INTERCOMPANY_ACCT source_21
271111: , h1.AR_INTERCOMPANY_ACCT source_22
271112: , h1.DEFAULT_CCID source_32
271113: , h1.TRANSFER_TO_GL_FLAG source_71
271114: FROM xla_events_gt xet
271115: , FA_XLA_EXT_HEADERS_B_GT h1
271116: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
271117: and xet.event_class_code = C_EVENT_CLASS_CODE
271118: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 271169: FROM xla_events_gt xet

271165: , l2.DISTRIBUTION_TYPE_CODE source_51
271166: , l2.ENTERED_AMOUNT source_52
271167: , l2.CURRENCY_CODE source_53
271168: , l2.SOURCE_DEST_CODE source_55
271169: FROM xla_events_gt xet
271170: , FA_XLA_EXT_LINES_B_GT l2
271171: WHERE xet.event_id between x_first_event_id and x_last_event_id
271172: and xet.event_date between p_pad_start_date and p_pad_end_date
271173: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 272467: FROM xla_events_gt xet

272463:
272464: ELSE null
272465: END source_value
272466: , null source_meaning
272467: FROM xla_events_gt xet
272468: , FA_XLA_EXT_HEADERS_B_GT h1
272469: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
272470: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
272471: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 272610: FROM xla_events_gt xet

272606:
272607: ELSE null
272608: END source_value
272609: , null source_meaning
272610: FROM xla_events_gt xet
272611: , FA_XLA_EXT_LINES_B_GT l2
272612: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
272613: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
272614: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 272815: FROM xla_events_gt xet

272811: , h1.PERIOD_CLOSE_DATE source_1
272812: , h1.ACCOUNTING_DATE source_3
272813: , h1.DEFAULT_CCID source_32
272814: , h1.TRANSFER_TO_GL_FLAG source_71
272815: FROM xla_events_gt xet
272816: , FA_XLA_EXT_HEADERS_B_GT h1
272817: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
272818: and xet.event_class_code = C_EVENT_CLASS_CODE
272819: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 272865: FROM xla_events_gt xet

272861: , l2.ADJUSTMENT_LINE_ID source_50
272862: , l2.DISTRIBUTION_TYPE_CODE source_51
272863: , l2.ENTERED_AMOUNT source_52
272864: , l2.CURRENCY_CODE source_53
272865: FROM xla_events_gt xet
272866: , FA_XLA_EXT_LINES_B_GT l2
272867: WHERE xet.event_id between x_first_event_id and x_last_event_id
272868: and xet.event_date between p_pad_start_date and p_pad_end_date
272869: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 274559: (p_msg => '# of events in xla_events_gt: '

274555: ,p_level => C_LEVEL_STATEMENT
274556: ,p_module => l_log_module);
274557:
274558: trace
274559: (p_msg => '# of events in xla_events_gt: '
274560: ||xla_context_pkg.get_event_count_context
274561: ,p_level => C_LEVEL_STATEMENT
274562: ,p_module => l_log_module);
274563: