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 ALL_OBJECTS

Line 179267: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)

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
179270: AND h1.event_id = xet.event_id
179271:

Line 179435: , (select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)

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
179438: AND l2.event_id = xet.event_id
179439: AND l2.ledger_id (+) = p_sla_ledger_id

Line 180704: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)

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
180707: AND h1.event_id = xet.event_id
180708:

Line 180872: , (select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)

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
180875: AND l2.event_id = xet.event_id
180876: AND l2.ledger_id (+) = p_sla_ledger_id

Line 182190: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)

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
182193: AND h1.event_id = xet.event_id
182194:

Line 182352: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)

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
182355: AND l2.event_id = xet.event_id
182356: AND l2.ledger_id (+) = p_sla_ledger_id

Line 183607: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)

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
183610: AND h1.event_id = xet.event_id
183611:

Line 183775: , (select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)

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
183778: AND l2.event_id = xet.event_id
183779: AND l2.ledger_id (+) = p_sla_ledger_id

Line 185161: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)

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
185164: AND h1.event_id = xet.event_id
185165:

Line 185309: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

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
185312: AND l2.event_id = xet.event_id
185313: AND l2.ledger_id (+) = p_sla_ledger_id

Line 186380: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)

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
186383: AND h1.event_id = xet.event_id
186384:

Line 186528: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

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
186531: AND l2.event_id = xet.event_id
186532: AND l2.ledger_id (+) = p_sla_ledger_id

Line 187599: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)

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
187602: AND h1.event_id = xet.event_id
187603:

Line 187747: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

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
187750: AND l2.event_id = xet.event_id
187751: AND l2.ledger_id (+) = p_sla_ledger_id

Line 188924: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)

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
188927: AND h1.event_id = xet.event_id
188928:

Line 189076: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)

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
189079: AND l2.event_id = xet.event_id
189080: AND l2.ledger_id (+) = p_sla_ledger_id

Line 190545: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)

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
190548: AND h1.event_id = xet.event_id
190549:

Line 190697: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)

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
190700: AND l2.event_id = xet.event_id
190701: AND l2.ledger_id (+) = p_sla_ledger_id

Line 192121: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)

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
192124: AND h1.event_id = xet.event_id
192125:

Line 192269: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

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
192272: AND l2.event_id = xet.event_id
192273: AND l2.ledger_id (+) = p_sla_ledger_id

Line 193350: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)

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
193353: AND h1.event_id = xet.event_id
193354:

Line 193513: , (select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)

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
193516: AND l2.event_id = xet.event_id
193517: AND l2.ledger_id (+) = p_sla_ledger_id

Line 194799: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)

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
194802: AND h1.event_id = xet.event_id
194803:

Line 194952: , (select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)

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
194955: AND l2.event_id = xet.event_id
194956: AND l2.ledger_id (+) = p_sla_ledger_id

Line 196167: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)

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
196170: AND h1.event_id = xet.event_id
196171:

Line 196320: , (select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)

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
196323: AND l2.event_id = xet.event_id
196324: AND l2.ledger_id (+) = p_sla_ledger_id

Line 197541: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)

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
197544: AND h1.event_id = xet.event_id
197545:

Line 197679: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

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
197682: AND l2.event_id = xet.event_id
197683: AND l2.ledger_id (+) = p_sla_ledger_id

Line 198764: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)

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
198767: AND h1.event_id = xet.event_id
198768:

Line 198907: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)

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
198910: AND l2.event_id = xet.event_id
198911: AND l2.ledger_id (+) = p_sla_ledger_id

Line 199994: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)

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
199997: AND h1.event_id = xet.event_id
199998:

Line 200187: , (select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)

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
200190: AND l2.event_id = xet.event_id
200191: AND l2.ledger_id (+) = p_sla_ledger_id

Line 201551: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)

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
201554: AND h1.event_id = xet.event_id
201555:

Line 201718: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)

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
201721: AND l2.event_id = xet.event_id
201722: AND l2.ledger_id (+) = p_sla_ledger_id

Line 203366: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)

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
203369: AND h1.event_id = xet.event_id
203370:

Line 203514: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)

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
203517: AND l2.event_id = xet.event_id
203518: AND l2.ledger_id (+) = p_sla_ledger_id

Line 204706: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)

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
204709: AND h1.event_id = xet.event_id
204710:

Line 204873: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)

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
204876: AND l2.event_id = xet.event_id
204877: AND l2.ledger_id (+) = p_sla_ledger_id

Line 206464: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)

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
206467: AND h1.event_id = xet.event_id
206468:

Line 206607: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)

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
206610: AND l2.event_id = xet.event_id
206611: AND l2.ledger_id (+) = p_sla_ledger_id

Line 207713: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)

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
207716: AND h1.event_id = xet.event_id
207717:

Line 207876: , (select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)

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
207879: AND l2.event_id = xet.event_id
207880: AND l2.ledger_id (+) = p_sla_ledger_id

Line 209131: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)

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
209134: AND h1.event_id = xet.event_id
209135:

Line 209293: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)

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
209296: AND l2.event_id = xet.event_id
209297: AND l2.ledger_id (+) = p_sla_ledger_id

Line 210558: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)

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
210561: AND h1.event_id = xet.event_id
210562:

Line 210741: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)

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
210744: AND l2.event_id = xet.event_id
210745: AND l2.ledger_id (+) = p_sla_ledger_id

Line 212459: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)

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
212462: AND h1.event_id = xet.event_id
212463:

Line 212602: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)

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
212605: AND l2.event_id = xet.event_id
212606: AND l2.ledger_id (+) = p_sla_ledger_id

Line 213718: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)

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
213721: AND h1.event_id = xet.event_id
213722:

Line 213886: , (select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)

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
213889: AND l2.event_id = xet.event_id
213890: AND l2.ledger_id (+) = p_sla_ledger_id

Line 215470: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)

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
215473: AND h1.event_id = xet.event_id
215474:

Line 215638: , (select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)

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
215641: AND l2.event_id = xet.event_id
215642: AND l2.ledger_id (+) = p_sla_ledger_id

Line 217212: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)

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
217215: AND h1.event_id = xet.event_id
217216:

Line 217355: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)

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
217358: AND l2.event_id = xet.event_id
217359: AND l2.ledger_id (+) = p_sla_ledger_id