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_000002_PKG dependencies on XLA_EVENTS_GT

Line 179265: FROM xla_events_gt xet

179261:
179262: ELSE null
179263: END source_value
179264: , null source_meaning
179265: FROM xla_events_gt xet
179266: , FA_XLA_EXT_HEADERS_B_GT h1
179267: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
179268: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
179269: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 179433: FROM xla_events_gt xet

179429:
179430: ELSE null
179431: END source_value
179432: , null source_meaning
179433: FROM xla_events_gt xet
179434: , FA_XLA_EXT_LINES_B_GT l2
179435: , (select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
179436: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
179437: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 179648: FROM xla_events_gt xet

179644: , h1.PERIOD_CLOSE_DATE source_1
179645: , h1.DEFAULT_CCID source_30
179646: , h1.ACCOUNTING_DATE source_51
179647: , h1.TRANSFER_TO_GL_FLAG source_52
179648: FROM xla_events_gt xet
179649: , FA_XLA_EXT_HEADERS_B_GT h1
179650: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
179651: and xet.event_class_code = C_EVENT_CLASS_CODE
179652: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 179703: FROM xla_events_gt xet

179699: , l2.ADJUSTMENT_LINE_ID source_37
179700: , l2.DISTRIBUTION_TYPE_CODE source_38
179701: , l2.ENTERED_AMOUNT source_39
179702: , l2.CURRENCY_CODE source_40
179703: FROM xla_events_gt xet
179704: , FA_XLA_EXT_LINES_B_GT l2
179705: WHERE xet.event_id between x_first_event_id and x_last_event_id
179706: and xet.event_date between p_pad_start_date and p_pad_end_date
179707: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 180702: FROM xla_events_gt xet

180698:
180699: ELSE null
180700: END source_value
180701: , null source_meaning
180702: FROM xla_events_gt xet
180703: , FA_XLA_EXT_HEADERS_B_GT h1
180704: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
180705: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
180706: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 180870: FROM xla_events_gt xet

180866:
180867: ELSE null
180868: END source_value
180869: , null source_meaning
180870: FROM xla_events_gt xet
180871: , FA_XLA_EXT_LINES_B_GT l2
180872: , (select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
180873: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
180874: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 181091: FROM xla_events_gt xet

181087: , h1.AR_INTERCOMPANY_ACCT source_20
181088: , h1.DEFAULT_CCID source_30
181089: , h1.ACCOUNTING_DATE source_51
181090: , h1.TRANSFER_TO_GL_FLAG source_52
181091: FROM xla_events_gt xet
181092: , FA_XLA_EXT_HEADERS_B_GT h1
181093: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
181094: and xet.event_class_code = C_EVENT_CLASS_CODE
181095: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 181146: FROM xla_events_gt xet

181142: , l2.ADJUSTMENT_LINE_ID source_37
181143: , l2.DISTRIBUTION_TYPE_CODE source_38
181144: , l2.ENTERED_AMOUNT source_39
181145: , l2.CURRENCY_CODE source_40
181146: FROM xla_events_gt xet
181147: , FA_XLA_EXT_LINES_B_GT l2
181148: WHERE xet.event_id between x_first_event_id and x_last_event_id
181149: and xet.event_date between p_pad_start_date and p_pad_end_date
181150: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 182188: FROM xla_events_gt xet

182184:
182185: ELSE null
182186: END source_value
182187: , null source_meaning
182188: FROM xla_events_gt xet
182189: , FA_XLA_EXT_HEADERS_B_GT h1
182190: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
182191: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
182192: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 182350: FROM xla_events_gt xet

182346:
182347: ELSE null
182348: END source_value
182349: , null source_meaning
182350: FROM xla_events_gt xet
182351: , FA_XLA_EXT_LINES_B_GT l2
182352: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
182353: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
182354: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 182564: FROM xla_events_gt xet

182560: , h1.PERIOD_CLOSE_DATE source_1
182561: , h1.DEFAULT_CCID source_30
182562: , h1.ACCOUNTING_DATE source_51
182563: , h1.TRANSFER_TO_GL_FLAG source_52
182564: FROM xla_events_gt xet
182565: , FA_XLA_EXT_HEADERS_B_GT h1
182566: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
182567: and xet.event_type_code = C_EVENT_TYPE_CODE
182568: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 182618: FROM xla_events_gt xet

182614: , l2.ADJUSTMENT_LINE_ID source_37
182615: , l2.DISTRIBUTION_TYPE_CODE source_38
182616: , l2.ENTERED_AMOUNT source_39
182617: , l2.CURRENCY_CODE source_40
182618: FROM xla_events_gt xet
182619: , FA_XLA_EXT_LINES_B_GT l2
182620: WHERE xet.event_id between x_first_event_id and x_last_event_id
182621: and xet.event_date between p_pad_start_date and p_pad_end_date
182622: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 183605: FROM xla_events_gt xet

183601:
183602: ELSE null
183603: END source_value
183604: , null source_meaning
183605: FROM xla_events_gt xet
183606: , FA_XLA_EXT_HEADERS_B_GT h1
183607: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
183608: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
183609: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 183773: FROM xla_events_gt xet

183769:
183770: ELSE null
183771: END source_value
183772: , null source_meaning
183773: FROM xla_events_gt xet
183774: , FA_XLA_EXT_LINES_B_GT l2
183775: , (select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
183776: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
183777: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 183988: FROM xla_events_gt xet

183984: , h1.PERIOD_CLOSE_DATE source_1
183985: , h1.DEFAULT_CCID source_30
183986: , h1.ACCOUNTING_DATE source_51
183987: , h1.TRANSFER_TO_GL_FLAG source_52
183988: FROM xla_events_gt xet
183989: , FA_XLA_EXT_HEADERS_B_GT h1
183990: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
183991: and xet.event_class_code = C_EVENT_CLASS_CODE
183992: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 184043: FROM xla_events_gt xet

184039: , l2.DISTRIBUTION_TYPE_CODE source_38
184040: , l2.ENTERED_AMOUNT source_39
184041: , l2.CURRENCY_CODE source_40
184042: , l2.SOURCE_DEST_CODE source_42
184043: FROM xla_events_gt xet
184044: , FA_XLA_EXT_LINES_B_GT l2
184045: WHERE xet.event_id between x_first_event_id and x_last_event_id
184046: and xet.event_date between p_pad_start_date and p_pad_end_date
184047: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 185159: FROM xla_events_gt xet

185155:
185156: ELSE null
185157: END source_value
185158: , null source_meaning
185159: FROM xla_events_gt xet
185160: , FA_XLA_EXT_HEADERS_B_GT h1
185161: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
185162: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
185163: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 185307: FROM xla_events_gt xet

185303:
185304: ELSE null
185305: END source_value
185306: , null source_meaning
185307: FROM xla_events_gt xet
185308: , FA_XLA_EXT_LINES_B_GT l2
185309: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
185310: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
185311: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 185514: FROM xla_events_gt xet

185510: , h1.PERIOD_CLOSE_DATE source_1
185511: , h1.DEFAULT_CCID source_30
185512: , h1.ACCOUNTING_DATE source_51
185513: , h1.TRANSFER_TO_GL_FLAG source_52
185514: FROM xla_events_gt xet
185515: , FA_XLA_EXT_HEADERS_B_GT h1
185516: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
185517: and xet.event_class_code = C_EVENT_CLASS_CODE
185518: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 185565: FROM xla_events_gt xet

185561: , l2.ADJUSTMENT_LINE_ID source_37
185562: , l2.DISTRIBUTION_TYPE_CODE source_38
185563: , l2.ENTERED_AMOUNT source_39
185564: , l2.CURRENCY_CODE source_40
185565: FROM xla_events_gt xet
185566: , FA_XLA_EXT_LINES_B_GT l2
185567: WHERE xet.event_id between x_first_event_id and x_last_event_id
185568: and xet.event_date between p_pad_start_date and p_pad_end_date
185569: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 186378: FROM xla_events_gt xet

186374:
186375: ELSE null
186376: END source_value
186377: , null source_meaning
186378: FROM xla_events_gt xet
186379: , FA_XLA_EXT_HEADERS_B_GT h1
186380: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
186381: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
186382: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 186526: FROM xla_events_gt xet

186522:
186523: ELSE null
186524: END source_value
186525: , null source_meaning
186526: FROM xla_events_gt xet
186527: , FA_XLA_EXT_LINES_B_GT l2
186528: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
186529: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
186530: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 186733: FROM xla_events_gt xet

186729: , h1.PERIOD_CLOSE_DATE source_1
186730: , h1.DEFAULT_CCID source_30
186731: , h1.ACCOUNTING_DATE source_51
186732: , h1.TRANSFER_TO_GL_FLAG source_52
186733: FROM xla_events_gt xet
186734: , FA_XLA_EXT_HEADERS_B_GT h1
186735: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
186736: and xet.event_class_code = C_EVENT_CLASS_CODE
186737: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 186784: FROM xla_events_gt xet

186780: , l2.ADJUSTMENT_LINE_ID source_37
186781: , l2.DISTRIBUTION_TYPE_CODE source_38
186782: , l2.ENTERED_AMOUNT source_39
186783: , l2.CURRENCY_CODE source_40
186784: FROM xla_events_gt xet
186785: , FA_XLA_EXT_LINES_B_GT l2
186786: WHERE xet.event_id between x_first_event_id and x_last_event_id
186787: and xet.event_date between p_pad_start_date and p_pad_end_date
186788: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 187597: FROM xla_events_gt xet

187593:
187594: ELSE null
187595: END source_value
187596: , null source_meaning
187597: FROM xla_events_gt xet
187598: , FA_XLA_EXT_HEADERS_B_GT h1
187599: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
187600: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
187601: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 187745: FROM xla_events_gt xet

187741:
187742: ELSE null
187743: END source_value
187744: , null source_meaning
187745: FROM xla_events_gt xet
187746: , FA_XLA_EXT_LINES_B_GT l2
187747: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
187748: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
187749: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 187952: FROM xla_events_gt xet

187948: , h1.PERIOD_CLOSE_DATE source_1
187949: , h1.DEFAULT_CCID source_30
187950: , h1.ACCOUNTING_DATE source_51
187951: , h1.TRANSFER_TO_GL_FLAG source_52
187952: FROM xla_events_gt xet
187953: , FA_XLA_EXT_HEADERS_B_GT h1
187954: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
187955: and xet.event_class_code = C_EVENT_CLASS_CODE
187956: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 188003: FROM xla_events_gt xet

187999: , l2.DISTRIBUTION_TYPE_CODE source_38
188000: , l2.ENTERED_AMOUNT source_39
188001: , l2.CURRENCY_CODE source_40
188002: , l2.SOURCE_DEST_CODE source_42
188003: FROM xla_events_gt xet
188004: , FA_XLA_EXT_LINES_B_GT l2
188005: WHERE xet.event_id between x_first_event_id and x_last_event_id
188006: and xet.event_date between p_pad_start_date and p_pad_end_date
188007: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 188922: FROM xla_events_gt xet

188918:
188919: ELSE null
188920: END source_value
188921: , null source_meaning
188922: FROM xla_events_gt xet
188923: , FA_XLA_EXT_HEADERS_B_GT h1
188924: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
188925: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
188926: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 189074: FROM xla_events_gt xet

189070:
189071: ELSE null
189072: END source_value
189073: , null source_meaning
189074: FROM xla_events_gt xet
189075: , FA_XLA_EXT_LINES_B_GT l2
189076: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
189077: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
189078: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 189311: FROM xla_events_gt xet

189307: , h1.REVAL_RSV_RETIRED_LOSS_ACCT source_28
189308: , h1.DEFAULT_CCID source_30
189309: , h1.ACCOUNTING_DATE source_51
189310: , h1.TRANSFER_TO_GL_FLAG source_52
189311: FROM xla_events_gt xet
189312: , FA_XLA_EXT_HEADERS_B_GT h1
189313: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
189314: and xet.event_type_code = C_EVENT_TYPE_CODE
189315: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 189363: FROM xla_events_gt xet

189359: , l2.DISTRIBUTION_TYPE_CODE source_38
189360: , l2.ENTERED_AMOUNT source_39
189361: , l2.CURRENCY_CODE source_40
189362: , l2.GAIN_LOSS_AMOUNT source_41
189363: FROM xla_events_gt xet
189364: , FA_XLA_EXT_LINES_B_GT l2
189365: WHERE xet.event_id between x_first_event_id and x_last_event_id
189366: and xet.event_date between p_pad_start_date and p_pad_end_date
189367: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 190543: FROM xla_events_gt xet

190539:
190540: ELSE null
190541: END source_value
190542: , null source_meaning
190543: FROM xla_events_gt xet
190544: , FA_XLA_EXT_HEADERS_B_GT h1
190545: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
190546: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
190547: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 190695: FROM xla_events_gt xet

190691:
190692: ELSE null
190693: END source_value
190694: , null source_meaning
190695: FROM xla_events_gt xet
190696: , FA_XLA_EXT_LINES_B_GT l2
190697: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
190698: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
190699: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 190935: FROM xla_events_gt xet

190931: , h1.REVAL_RSV_RETIRED_LOSS_ACCT source_28
190932: , h1.DEFAULT_CCID source_30
190933: , h1.ACCOUNTING_DATE source_51
190934: , h1.TRANSFER_TO_GL_FLAG source_52
190935: FROM xla_events_gt xet
190936: , FA_XLA_EXT_HEADERS_B_GT h1
190937: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
190938: and xet.event_type_code = C_EVENT_TYPE_CODE
190939: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 190987: FROM xla_events_gt xet

190983: , l2.DISTRIBUTION_TYPE_CODE source_38
190984: , l2.ENTERED_AMOUNT source_39
190985: , l2.CURRENCY_CODE source_40
190986: , l2.GAIN_LOSS_AMOUNT source_41
190987: FROM xla_events_gt xet
190988: , FA_XLA_EXT_LINES_B_GT l2
190989: WHERE xet.event_id between x_first_event_id and x_last_event_id
190990: and xet.event_date between p_pad_start_date and p_pad_end_date
190991: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 192119: FROM xla_events_gt xet

192115:
192116: ELSE null
192117: END source_value
192118: , null source_meaning
192119: FROM xla_events_gt xet
192120: , FA_XLA_EXT_HEADERS_B_GT h1
192121: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
192122: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
192123: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 192267: FROM xla_events_gt xet

192263:
192264: ELSE null
192265: END source_value
192266: , null source_meaning
192267: FROM xla_events_gt xet
192268: , FA_XLA_EXT_LINES_B_GT l2
192269: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
192270: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
192271: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 192474: FROM xla_events_gt xet

192470: , h1.PERIOD_CLOSE_DATE source_1
192471: , h1.DEFAULT_CCID source_30
192472: , h1.ACCOUNTING_DATE source_51
192473: , h1.TRANSFER_TO_GL_FLAG source_52
192474: FROM xla_events_gt xet
192475: , FA_XLA_EXT_HEADERS_B_GT h1
192476: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
192477: and xet.event_class_code = C_EVENT_CLASS_CODE
192478: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 192525: FROM xla_events_gt xet

192521: , l2.ADJUSTMENT_LINE_ID source_37
192522: , l2.DISTRIBUTION_TYPE_CODE source_38
192523: , l2.ENTERED_AMOUNT source_39
192524: , l2.CURRENCY_CODE source_40
192525: FROM xla_events_gt xet
192526: , FA_XLA_EXT_LINES_B_GT l2
192527: WHERE xet.event_id between x_first_event_id and x_last_event_id
192528: and xet.event_date between p_pad_start_date and p_pad_end_date
192529: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 193348: FROM xla_events_gt xet

193344:
193345: ELSE null
193346: END source_value
193347: , null source_meaning
193348: FROM xla_events_gt xet
193349: , FA_XLA_EXT_HEADERS_B_GT h1
193350: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
193351: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
193352: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 193511: FROM xla_events_gt xet

193507:
193508: ELSE null
193509: END source_value
193510: , null source_meaning
193511: FROM xla_events_gt xet
193512: , FA_XLA_EXT_LINES_B_GT l2
193513: , (select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
193514: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
193515: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 193730: FROM xla_events_gt xet

193726: , h1.AR_INTERCOMPANY_ACCT source_20
193727: , h1.DEFAULT_CCID source_30
193728: , h1.ACCOUNTING_DATE source_51
193729: , h1.TRANSFER_TO_GL_FLAG source_52
193730: FROM xla_events_gt xet
193731: , FA_XLA_EXT_HEADERS_B_GT h1
193732: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
193733: and xet.event_class_code = C_EVENT_CLASS_CODE
193734: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 193784: FROM xla_events_gt xet

193780: , l2.DISTRIBUTION_TYPE_CODE source_38
193781: , l2.ENTERED_AMOUNT source_39
193782: , l2.CURRENCY_CODE source_40
193783: , l2.SOURCE_DEST_CODE source_42
193784: FROM xla_events_gt xet
193785: , FA_XLA_EXT_LINES_B_GT l2
193786: WHERE xet.event_id between x_first_event_id and x_last_event_id
193787: and xet.event_date between p_pad_start_date and p_pad_end_date
193788: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 194797: FROM xla_events_gt xet

194793:
194794: ELSE null
194795: END source_value
194796: , null source_meaning
194797: FROM xla_events_gt xet
194798: , FA_XLA_EXT_HEADERS_B_GT h1
194799: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
194800: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
194801: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 194950: FROM xla_events_gt xet

194946:
194947: ELSE null
194948: END source_value
194949: , null source_meaning
194950: FROM xla_events_gt xet
194951: , FA_XLA_EXT_LINES_B_GT l2
194952: , (select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
194953: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
194954: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 195165: FROM xla_events_gt xet

195161: , h1.AR_INTERCOMPANY_ACCT source_20
195162: , h1.DEFAULT_CCID source_30
195163: , h1.ACCOUNTING_DATE source_51
195164: , h1.TRANSFER_TO_GL_FLAG source_52
195165: FROM xla_events_gt xet
195166: , FA_XLA_EXT_HEADERS_B_GT h1
195167: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
195168: and xet.event_class_code = C_EVENT_CLASS_CODE
195169: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 195217: FROM xla_events_gt xet

195213: , l2.DISTRIBUTION_TYPE_CODE source_38
195214: , l2.ENTERED_AMOUNT source_39
195215: , l2.CURRENCY_CODE source_40
195216: , l2.SOURCE_DEST_CODE source_42
195217: FROM xla_events_gt xet
195218: , FA_XLA_EXT_LINES_B_GT l2
195219: WHERE xet.event_id between x_first_event_id and x_last_event_id
195220: and xet.event_date between p_pad_start_date and p_pad_end_date
195221: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 196165: FROM xla_events_gt xet

196161:
196162: ELSE null
196163: END source_value
196164: , null source_meaning
196165: FROM xla_events_gt xet
196166: , FA_XLA_EXT_HEADERS_B_GT h1
196167: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
196168: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
196169: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 196318: FROM xla_events_gt xet

196314:
196315: ELSE null
196316: END source_value
196317: , null source_meaning
196318: FROM xla_events_gt xet
196319: , FA_XLA_EXT_LINES_B_GT l2
196320: , (select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
196321: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
196322: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 196533: FROM xla_events_gt xet

196529: , h1.AR_INTERCOMPANY_ACCT source_20
196530: , h1.DEFAULT_CCID source_30
196531: , h1.ACCOUNTING_DATE source_51
196532: , h1.TRANSFER_TO_GL_FLAG source_52
196533: FROM xla_events_gt xet
196534: , FA_XLA_EXT_HEADERS_B_GT h1
196535: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
196536: and xet.event_class_code = C_EVENT_CLASS_CODE
196537: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 196585: FROM xla_events_gt xet

196581: , l2.DISTRIBUTION_TYPE_CODE source_38
196582: , l2.ENTERED_AMOUNT source_39
196583: , l2.CURRENCY_CODE source_40
196584: , l2.SOURCE_DEST_CODE source_42
196585: FROM xla_events_gt xet
196586: , FA_XLA_EXT_LINES_B_GT l2
196587: WHERE xet.event_id between x_first_event_id and x_last_event_id
196588: and xet.event_date between p_pad_start_date and p_pad_end_date
196589: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 197539: FROM xla_events_gt xet

197535:
197536: ELSE null
197537: END source_value
197538: , null source_meaning
197539: FROM xla_events_gt xet
197540: , FA_XLA_EXT_HEADERS_B_GT h1
197541: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
197542: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
197543: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 197677: FROM xla_events_gt xet

197673:
197674: ELSE null
197675: END source_value
197676: , null source_meaning
197677: FROM xla_events_gt xet
197678: , FA_XLA_EXT_LINES_B_GT l2
197679: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
197680: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
197681: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 197889: FROM xla_events_gt xet

197885: , h1.DEFAULT_CCID source_30
197886: , h1.PERIOD_COUNTER source_44
197887: , h1.BOOK_TYPE_CODE source_46
197888: , h1.ACCOUNTING_DATE source_51
197889: FROM xla_events_gt xet
197890: , FA_XLA_EXT_HEADERS_B_GT h1
197891: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
197892: and xet.event_class_code = C_EVENT_CLASS_CODE
197893: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 197938: FROM xla_events_gt xet

197934: , l2.CURRENCY_CODE source_40
197935: , l2.ASSET_ID source_43
197936: , l2.DISTRIBUTION_ID source_45
197937: , l2.TAX_BOOK_TYPE_CODE source_47
197938: FROM xla_events_gt xet
197939: , FA_XLA_EXT_LINES_B_GT l2
197940: WHERE xet.event_id between x_first_event_id and x_last_event_id
197941: and xet.event_date between p_pad_start_date and p_pad_end_date
197942: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 198762: FROM xla_events_gt xet

198758:
198759: ELSE null
198760: END source_value
198761: , null source_meaning
198762: FROM xla_events_gt xet
198763: , FA_XLA_EXT_HEADERS_B_GT h1
198764: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
198765: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
198766: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 198905: FROM xla_events_gt xet

198901:
198902: ELSE null
198903: END source_value
198904: , null source_meaning
198905: FROM xla_events_gt xet
198906: , FA_XLA_EXT_LINES_B_GT l2
198907: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
198908: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
198909: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 199113: FROM xla_events_gt xet

199109: , h1.DEPRN_ADJUSTMENT_ACCT source_18
199110: , h1.DEFAULT_CCID source_30
199111: , h1.ACCOUNTING_DATE source_51
199112: , h1.TRANSFER_TO_GL_FLAG source_52
199113: FROM xla_events_gt xet
199114: , FA_XLA_EXT_HEADERS_B_GT h1
199115: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
199116: and xet.event_class_code = C_EVENT_CLASS_CODE
199117: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 199163: FROM xla_events_gt xet

199159: , l2.ADJUSTMENT_LINE_ID source_37
199160: , l2.DISTRIBUTION_TYPE_CODE source_38
199161: , l2.ENTERED_AMOUNT source_39
199162: , l2.CURRENCY_CODE source_40
199163: FROM xla_events_gt xet
199164: , FA_XLA_EXT_LINES_B_GT l2
199165: WHERE xet.event_id between x_first_event_id and x_last_event_id
199166: and xet.event_date between p_pad_start_date and p_pad_end_date
199167: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 199992: FROM xla_events_gt xet

199988:
199989: ELSE null
199990: END source_value
199991: , null source_meaning
199992: FROM xla_events_gt xet
199993: , FA_XLA_EXT_HEADERS_B_GT h1
199994: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
199995: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
199996: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 200185: FROM xla_events_gt xet

200181:
200182: ELSE null
200183: END source_value
200184: , null source_meaning
200185: FROM xla_events_gt xet
200186: , FA_XLA_EXT_LINES_B_GT l2
200187: , (select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
200188: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
200189: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 200419: FROM xla_events_gt xet

200415: , h1.BOOK_TYPE_CODE source_46
200416: , h1.ACCOUNTING_DATE source_51
200417: , h1.TRANSFER_TO_GL_FLAG source_52
200418: , h1.REVERSAL_FLAG source_53
200419: FROM xla_events_gt xet
200420: , FA_XLA_EXT_HEADERS_B_GT h1
200421: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
200422: and xet.event_class_code = C_EVENT_CLASS_CODE
200423: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 200479: FROM xla_events_gt xet

200475: , l2.DISTRIBUTION_ID source_45
200476: , l2.BONUS_ENTERED_AMOUNT source_48
200477: , l2.DEPRN_RUN_ID source_49
200478: , l2.REVAL_ENTERED_AMOUNT source_50
200479: FROM xla_events_gt xet
200480: , FA_XLA_EXT_LINES_B_GT l2
200481: WHERE xet.event_id between x_first_event_id and x_last_event_id
200482: and xet.event_date between p_pad_start_date and p_pad_end_date
200483: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 201549: FROM xla_events_gt xet

201545:
201546: ELSE null
201547: END source_value
201548: , null source_meaning
201549: FROM xla_events_gt xet
201550: , FA_XLA_EXT_HEADERS_B_GT h1
201551: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
201552: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
201553: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 201716: FROM xla_events_gt xet

201712:
201713: ELSE null
201714: END source_value
201715: , null source_meaning
201716: FROM xla_events_gt xet
201717: , FA_XLA_EXT_LINES_B_GT l2
201718: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
201719: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
201720: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 201962: FROM xla_events_gt xet

201958: , h1.REVAL_RSV_RETIRED_LOSS_ACCT source_28
201959: , h1.DEFAULT_CCID source_30
201960: , h1.ACCOUNTING_DATE source_51
201961: , h1.TRANSFER_TO_GL_FLAG source_52
201962: FROM xla_events_gt xet
201963: , FA_XLA_EXT_HEADERS_B_GT h1
201964: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
201965: and xet.event_type_code = C_EVENT_TYPE_CODE
201966: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 202017: FROM xla_events_gt xet

202013: , l2.DISTRIBUTION_TYPE_CODE source_38
202014: , l2.ENTERED_AMOUNT source_39
202015: , l2.CURRENCY_CODE source_40
202016: , l2.GAIN_LOSS_AMOUNT source_41
202017: FROM xla_events_gt xet
202018: , FA_XLA_EXT_LINES_B_GT l2
202019: WHERE xet.event_id between x_first_event_id and x_last_event_id
202020: and xet.event_date between p_pad_start_date and p_pad_end_date
202021: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 203364: FROM xla_events_gt xet

203360:
203361: ELSE null
203362: END source_value
203363: , null source_meaning
203364: FROM xla_events_gt xet
203365: , FA_XLA_EXT_HEADERS_B_GT h1
203366: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
203367: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
203368: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 203512: FROM xla_events_gt xet

203508:
203509: ELSE null
203510: END source_value
203511: , null source_meaning
203512: FROM xla_events_gt xet
203513: , FA_XLA_EXT_LINES_B_GT l2
203514: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
203515: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
203516: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 203725: FROM xla_events_gt xet

203721: , h1.AR_INTERCOMPANY_ACCT source_20
203722: , h1.DEFAULT_CCID source_30
203723: , h1.ACCOUNTING_DATE source_51
203724: , h1.TRANSFER_TO_GL_FLAG source_52
203725: FROM xla_events_gt xet
203726: , FA_XLA_EXT_HEADERS_B_GT h1
203727: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
203728: and xet.event_class_code = C_EVENT_CLASS_CODE
203729: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 203776: FROM xla_events_gt xet

203772: , l2.DISTRIBUTION_TYPE_CODE source_38
203773: , l2.ENTERED_AMOUNT source_39
203774: , l2.CURRENCY_CODE source_40
203775: , l2.SOURCE_DEST_CODE source_42
203776: FROM xla_events_gt xet
203777: , FA_XLA_EXT_LINES_B_GT l2
203778: WHERE xet.event_id between x_first_event_id and x_last_event_id
203779: and xet.event_date between p_pad_start_date and p_pad_end_date
203780: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 204704: FROM xla_events_gt xet

204700:
204701: ELSE null
204702: END source_value
204703: , null source_meaning
204704: FROM xla_events_gt xet
204705: , FA_XLA_EXT_HEADERS_B_GT h1
204706: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
204707: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
204708: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 204871: FROM xla_events_gt xet

204867:
204868: ELSE null
204869: END source_value
204870: , null source_meaning
204871: FROM xla_events_gt xet
204872: , FA_XLA_EXT_LINES_B_GT l2
204873: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
204874: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
204875: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 205117: FROM xla_events_gt xet

205113: , h1.REVAL_RSV_RETIRED_LOSS_ACCT source_28
205114: , h1.DEFAULT_CCID source_30
205115: , h1.ACCOUNTING_DATE source_51
205116: , h1.TRANSFER_TO_GL_FLAG source_52
205117: FROM xla_events_gt xet
205118: , FA_XLA_EXT_HEADERS_B_GT h1
205119: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
205120: and xet.event_type_code = C_EVENT_TYPE_CODE
205121: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 205172: FROM xla_events_gt xet

205168: , l2.DISTRIBUTION_TYPE_CODE source_38
205169: , l2.ENTERED_AMOUNT source_39
205170: , l2.CURRENCY_CODE source_40
205171: , l2.GAIN_LOSS_AMOUNT source_41
205172: FROM xla_events_gt xet
205173: , FA_XLA_EXT_LINES_B_GT l2
205174: WHERE xet.event_id between x_first_event_id and x_last_event_id
205175: and xet.event_date between p_pad_start_date and p_pad_end_date
205176: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 206462: FROM xla_events_gt xet

206458:
206459: ELSE null
206460: END source_value
206461: , null source_meaning
206462: FROM xla_events_gt xet
206463: , FA_XLA_EXT_HEADERS_B_GT h1
206464: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
206465: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
206466: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 206605: FROM xla_events_gt xet

206601:
206602: ELSE null
206603: END source_value
206604: , null source_meaning
206605: FROM xla_events_gt xet
206606: , FA_XLA_EXT_LINES_B_GT l2
206607: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
206608: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
206609: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 206816: FROM xla_events_gt xet

206812: , h1.PROCEEDS_OF_SALE_CLEARING_ACCT source_23
206813: , h1.DEFAULT_CCID source_30
206814: , h1.ACCOUNTING_DATE source_51
206815: , h1.TRANSFER_TO_GL_FLAG source_52
206816: FROM xla_events_gt xet
206817: , FA_XLA_EXT_HEADERS_B_GT h1
206818: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
206819: and xet.event_class_code = C_EVENT_CLASS_CODE
206820: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 206866: FROM xla_events_gt xet

206862: , l2.ADJUSTMENT_LINE_ID source_37
206863: , l2.DISTRIBUTION_TYPE_CODE source_38
206864: , l2.ENTERED_AMOUNT source_39
206865: , l2.CURRENCY_CODE source_40
206866: FROM xla_events_gt xet
206867: , FA_XLA_EXT_LINES_B_GT l2
206868: WHERE xet.event_id between x_first_event_id and x_last_event_id
206869: and xet.event_date between p_pad_start_date and p_pad_end_date
206870: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 207711: FROM xla_events_gt xet

207707:
207708: ELSE null
207709: END source_value
207710: , null source_meaning
207711: FROM xla_events_gt xet
207712: , FA_XLA_EXT_HEADERS_B_GT h1
207713: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
207714: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
207715: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 207874: FROM xla_events_gt xet

207870:
207871: ELSE null
207872: END source_value
207873: , null source_meaning
207874: FROM xla_events_gt xet
207875: , FA_XLA_EXT_LINES_B_GT l2
207876: , (select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
207877: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
207878: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 208087: FROM xla_events_gt xet

208083: , h1.PERIOD_CLOSE_DATE source_1
208084: , h1.DEFAULT_CCID source_30
208085: , h1.ACCOUNTING_DATE source_51
208086: , h1.TRANSFER_TO_GL_FLAG source_52
208087: FROM xla_events_gt xet
208088: , FA_XLA_EXT_HEADERS_B_GT h1
208089: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
208090: and xet.event_class_code = C_EVENT_CLASS_CODE
208091: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 208141: FROM xla_events_gt xet

208137: , l2.ADJUSTMENT_LINE_ID source_37
208138: , l2.DISTRIBUTION_TYPE_CODE source_38
208139: , l2.ENTERED_AMOUNT source_39
208140: , l2.CURRENCY_CODE source_40
208141: FROM xla_events_gt xet
208142: , FA_XLA_EXT_LINES_B_GT l2
208143: WHERE xet.event_id between x_first_event_id and x_last_event_id
208144: and xet.event_date between p_pad_start_date and p_pad_end_date
208145: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 209129: FROM xla_events_gt xet

209125:
209126: ELSE null
209127: END source_value
209128: , null source_meaning
209129: FROM xla_events_gt xet
209130: , FA_XLA_EXT_HEADERS_B_GT h1
209131: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
209132: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
209133: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 209291: FROM xla_events_gt xet

209287:
209288: ELSE null
209289: END source_value
209290: , null source_meaning
209291: FROM xla_events_gt xet
209292: , FA_XLA_EXT_LINES_B_GT l2
209293: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
209294: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
209295: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 209505: FROM xla_events_gt xet

209501: , h1.PERIOD_CLOSE_DATE source_1
209502: , h1.DEFAULT_CCID source_30
209503: , h1.ACCOUNTING_DATE source_51
209504: , h1.TRANSFER_TO_GL_FLAG source_52
209505: FROM xla_events_gt xet
209506: , FA_XLA_EXT_HEADERS_B_GT h1
209507: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
209508: and xet.event_type_code = C_EVENT_TYPE_CODE
209509: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 209559: FROM xla_events_gt xet

209555: , l2.ADJUSTMENT_LINE_ID source_37
209556: , l2.DISTRIBUTION_TYPE_CODE source_38
209557: , l2.ENTERED_AMOUNT source_39
209558: , l2.CURRENCY_CODE source_40
209559: FROM xla_events_gt xet
209560: , FA_XLA_EXT_LINES_B_GT l2
209561: WHERE xet.event_id between x_first_event_id and x_last_event_id
209562: and xet.event_date between p_pad_start_date and p_pad_end_date
209563: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 210556: FROM xla_events_gt xet

210552:
210553: ELSE null
210554: END source_value
210555: , null source_meaning
210556: FROM xla_events_gt xet
210557: , FA_XLA_EXT_HEADERS_B_GT h1
210558: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
210559: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
210560: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 210739: FROM xla_events_gt xet

210735:
210736: ELSE null
210737: END source_value
210738: , null source_meaning
210739: FROM xla_events_gt xet
210740: , FA_XLA_EXT_LINES_B_GT l2
210741: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
210742: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
210743: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 210966: FROM xla_events_gt xet

210962: , h1.AR_INTERCOMPANY_ACCT source_20
210963: , h1.DEFAULT_CCID source_30
210964: , h1.ACCOUNTING_DATE source_51
210965: , h1.TRANSFER_TO_GL_FLAG source_52
210966: FROM xla_events_gt xet
210967: , FA_XLA_EXT_HEADERS_B_GT h1
210968: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
210969: and xet.event_class_code = C_EVENT_CLASS_CODE
210970: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 211024: FROM xla_events_gt xet

211020: , l2.DISTRIBUTION_TYPE_CODE source_38
211021: , l2.ENTERED_AMOUNT source_39
211022: , l2.CURRENCY_CODE source_40
211023: , l2.SOURCE_DEST_CODE source_42
211024: FROM xla_events_gt xet
211025: , FA_XLA_EXT_LINES_B_GT l2
211026: WHERE xet.event_id between x_first_event_id and x_last_event_id
211027: and xet.event_date between p_pad_start_date and p_pad_end_date
211028: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 212457: FROM xla_events_gt xet

212453:
212454: ELSE null
212455: END source_value
212456: , null source_meaning
212457: FROM xla_events_gt xet
212458: , FA_XLA_EXT_HEADERS_B_GT h1
212459: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
212460: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
212461: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 212600: FROM xla_events_gt xet

212596:
212597: ELSE null
212598: END source_value
212599: , null source_meaning
212600: FROM xla_events_gt xet
212601: , FA_XLA_EXT_LINES_B_GT l2
212602: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
212603: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
212604: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 212811: FROM xla_events_gt xet

212807: , h1.NBV_RETIRED_LOSS_ACCT source_22
212808: , h1.DEFAULT_CCID source_30
212809: , h1.ACCOUNTING_DATE source_51
212810: , h1.TRANSFER_TO_GL_FLAG source_52
212811: FROM xla_events_gt xet
212812: , FA_XLA_EXT_HEADERS_B_GT h1
212813: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
212814: and xet.event_class_code = C_EVENT_CLASS_CODE
212815: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 212861: FROM xla_events_gt xet

212857: , l2.ADJUSTMENT_LINE_ID source_37
212858: , l2.DISTRIBUTION_TYPE_CODE source_38
212859: , l2.ENTERED_AMOUNT source_39
212860: , l2.CURRENCY_CODE source_40
212861: FROM xla_events_gt xet
212862: , FA_XLA_EXT_LINES_B_GT l2
212863: WHERE xet.event_id between x_first_event_id and x_last_event_id
212864: and xet.event_date between p_pad_start_date and p_pad_end_date
212865: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 213716: FROM xla_events_gt xet

213712:
213713: ELSE null
213714: END source_value
213715: , null source_meaning
213716: FROM xla_events_gt xet
213717: , FA_XLA_EXT_HEADERS_B_GT h1
213718: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
213719: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
213720: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 213884: FROM xla_events_gt xet

213880:
213881: ELSE null
213882: END source_value
213883: , null source_meaning
213884: FROM xla_events_gt xet
213885: , FA_XLA_EXT_LINES_B_GT l2
213886: , (select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
213887: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
213888: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 214105: FROM xla_events_gt xet

214101: , h1.AR_INTERCOMPANY_ACCT source_20
214102: , h1.DEFAULT_CCID source_30
214103: , h1.ACCOUNTING_DATE source_51
214104: , h1.TRANSFER_TO_GL_FLAG source_52
214105: FROM xla_events_gt xet
214106: , FA_XLA_EXT_HEADERS_B_GT h1
214107: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
214108: and xet.event_class_code = C_EVENT_CLASS_CODE
214109: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 214160: FROM xla_events_gt xet

214156: , l2.DISTRIBUTION_TYPE_CODE source_38
214157: , l2.ENTERED_AMOUNT source_39
214158: , l2.CURRENCY_CODE source_40
214159: , l2.SOURCE_DEST_CODE source_42
214160: FROM xla_events_gt xet
214161: , FA_XLA_EXT_LINES_B_GT l2
214162: WHERE xet.event_id between x_first_event_id and x_last_event_id
214163: and xet.event_date between p_pad_start_date and p_pad_end_date
214164: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 215468: FROM xla_events_gt xet

215464:
215465: ELSE null
215466: END source_value
215467: , null source_meaning
215468: FROM xla_events_gt xet
215469: , FA_XLA_EXT_HEADERS_B_GT h1
215470: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
215471: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
215472: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 215636: FROM xla_events_gt xet

215632:
215633: ELSE null
215634: END source_value
215635: , null source_meaning
215636: FROM xla_events_gt xet
215637: , FA_XLA_EXT_LINES_B_GT l2
215638: , (select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
215639: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
215640: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 215857: FROM xla_events_gt xet

215853: , h1.AR_INTERCOMPANY_ACCT source_20
215854: , h1.DEFAULT_CCID source_30
215855: , h1.ACCOUNTING_DATE source_51
215856: , h1.TRANSFER_TO_GL_FLAG source_52
215857: FROM xla_events_gt xet
215858: , FA_XLA_EXT_HEADERS_B_GT h1
215859: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
215860: and xet.event_class_code = C_EVENT_CLASS_CODE
215861: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 215912: FROM xla_events_gt xet

215908: , l2.DISTRIBUTION_TYPE_CODE source_38
215909: , l2.ENTERED_AMOUNT source_39
215910: , l2.CURRENCY_CODE source_40
215911: , l2.SOURCE_DEST_CODE source_42
215912: FROM xla_events_gt xet
215913: , FA_XLA_EXT_LINES_B_GT l2
215914: WHERE xet.event_id between x_first_event_id and x_last_event_id
215915: and xet.event_date between p_pad_start_date and p_pad_end_date
215916: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 217210: FROM xla_events_gt xet

217206:
217207: ELSE null
217208: END source_value
217209: , null source_meaning
217210: FROM xla_events_gt xet
217211: , FA_XLA_EXT_HEADERS_B_GT h1
217212: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
217213: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
217214: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 217353: FROM xla_events_gt xet

217349:
217350: ELSE null
217351: END source_value
217352: , null source_meaning
217353: FROM xla_events_gt xet
217354: , FA_XLA_EXT_LINES_B_GT l2
217355: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
217356: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
217357: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 217558: FROM xla_events_gt xet

217554: , h1.PERIOD_CLOSE_DATE source_1
217555: , h1.DEFAULT_CCID source_30
217556: , h1.ACCOUNTING_DATE source_51
217557: , h1.TRANSFER_TO_GL_FLAG source_52
217558: FROM xla_events_gt xet
217559: , FA_XLA_EXT_HEADERS_B_GT h1
217560: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
217561: and xet.event_class_code = C_EVENT_CLASS_CODE
217562: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 217608: FROM xla_events_gt xet

217604: , l2.ADJUSTMENT_LINE_ID source_37
217605: , l2.DISTRIBUTION_TYPE_CODE source_38
217606: , l2.ENTERED_AMOUNT source_39
217607: , l2.CURRENCY_CODE source_40
217608: FROM xla_events_gt xet
217609: , FA_XLA_EXT_LINES_B_GT l2
217610: WHERE xet.event_id between x_first_event_id and x_last_event_id
217611: and xet.event_date between p_pad_start_date and p_pad_end_date
217612: and xet.event_class_code = C_EVENT_CLASS_CODE

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

219264: ,p_level => C_LEVEL_STATEMENT
219265: ,p_module => l_log_module);
219266:
219267: trace
219268: (p_msg => '# of events in xla_events_gt: '
219269: ||xla_context_pkg.get_event_count_context
219270: ,p_level => C_LEVEL_STATEMENT
219271: ,p_module => l_log_module);
219272: