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 ALL_OBJECTS

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

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
229923: AND h1.event_id = xet.event_id
229924:

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

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
230166: AND xet.event_class_code = C_EVENT_CLASS_CODE
230167: AND l2.event_id = xet.event_id
230168: AND l2.ledger_id (+) = p_sla_ledger_id

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

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
231794: AND h1.event_id = xet.event_id
231795:

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

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
232037: AND xet.event_class_code = C_EVENT_CLASS_CODE
232038: AND l2.event_id = xet.event_id
232039: AND l2.ledger_id (+) = p_sla_ledger_id

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

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
233714: AND h1.event_id = xet.event_id
233715:

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

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

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

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
235131: AND h1.event_id = xet.event_id
235132:

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

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
235374: AND xet.event_class_code = C_EVENT_CLASS_CODE
235375: AND l2.event_id = xet.event_id
235376: AND l2.ledger_id (+) = p_sla_ledger_id

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

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
237119: AND h1.event_id = xet.event_id
237120:

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

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

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

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
238338: AND h1.event_id = xet.event_id
238339:

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

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

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

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
239557: AND h1.event_id = xet.event_id
239558:

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

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

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

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
240882: AND h1.event_id = xet.event_id
240883:

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

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

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

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
242503: AND h1.event_id = xet.event_id
242504:

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

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

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

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
244079: AND h1.event_id = xet.event_id
244080:

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

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

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

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
245308: AND h1.event_id = xet.event_id
245309:

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

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

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

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
246757: AND h1.event_id = xet.event_id
246758:

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

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

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

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
248125: AND h1.event_id = xet.event_id
248126:

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

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

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

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
249499: AND h1.event_id = xet.event_id
249500:

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

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

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

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
250722: AND h1.event_id = xet.event_id
250723:

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

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

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

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
251952: AND h1.event_id = xet.event_id
251953:

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

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
252220: AND xet.event_class_code = C_EVENT_CLASS_CODE
252221: AND l2.event_id = xet.event_id
252222: AND l2.ledger_id (+) = p_sla_ledger_id

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

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
253916: AND h1.event_id = xet.event_id
253917:

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

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
254109: AND xet.event_class_code = C_EVENT_CLASS_CODE
254110: AND l2.event_id = xet.event_id
254111: AND l2.ledger_id (+) = p_sla_ledger_id

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

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
255509: AND h1.event_id = xet.event_id
255510:

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

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
255751: AND xet.event_type_code = C_EVENT_TYPE_CODE
255752: AND l2.event_id = xet.event_id
255753: AND l2.ledger_id (+) = p_sla_ledger_id

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

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
257758: AND h1.event_id = xet.event_id
257759:

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

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

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

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
259098: AND h1.event_id = xet.event_id
259099:

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

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
259340: AND xet.event_type_code = C_EVENT_TYPE_CODE
259341: AND l2.event_id = xet.event_id
259342: AND l2.ledger_id (+) = p_sla_ledger_id

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

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
261290: AND h1.event_id = xet.event_id
261291:

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

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

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

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
262539: AND h1.event_id = xet.event_id
262540:

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

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

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

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
263957: AND h1.event_id = xet.event_id
263958:

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

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

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

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
265384: AND h1.event_id = xet.event_id
265385:

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

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

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

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
267285: AND h1.event_id = xet.event_id
267286:

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

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

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

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
268544: AND h1.event_id = xet.event_id
268545:

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

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
268787: AND xet.event_class_code = C_EVENT_CLASS_CODE
268788: AND l2.event_id = xet.event_id
268789: AND l2.ledger_id (+) = p_sla_ledger_id

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

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
270730: AND h1.event_id = xet.event_id
270731:

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

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

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

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
272472: AND h1.event_id = xet.event_id
272473:

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

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