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_00540_AAD_S_000014_PKG dependencies on ALL_OBJECTS

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

15398: , null source_meaning
15399: FROM xla_events_gt xet
15400: , OKL_CMN_EXTRACT_HDR_V h1
15401: , OKL_SHR_EXTRACT_HDR_V h3
15402: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
15403: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
15404: AND xet.event_class_code = C_EVENT_CLASS_CODE
15405: AND h1.event_id = xet.event_id
15406: AND h3.tcn_id (+) = h1.tcn_id

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

15521: END source_meaning
15522: FROM xla_events_gt xet
15523: , OKL_CMN_EXTRACT_LINE_V l2
15524: , fnd_lookup_values fvl6
15525: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
15526: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
15527: AND xet.event_class_code = C_EVENT_CLASS_CODE
15528: AND l2.event_id = xet.event_id
15529: AND fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'

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

16645: END source_value
16646: , null source_meaning
16647: FROM xla_events_gt xet
16648: , OKL_CMN_EXTRACT_HDR_V h1
16649: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
16650: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
16651: AND xet.event_class_code = C_EVENT_CLASS_CODE
16652: AND h1.event_id = xet.event_id
16653:

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

16768: END source_meaning
16769: FROM xla_events_gt xet
16770: , OKL_CMN_EXTRACT_LINE_V l2
16771: , fnd_lookup_values fvl6
16772: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
16773: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
16774: AND xet.event_class_code = C_EVENT_CLASS_CODE
16775: AND l2.event_id = xet.event_id
16776: AND fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'

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

17830: END source_value
17831: , null source_meaning
17832: FROM xla_events_gt xet
17833: , OKL_CMN_EXTRACT_HDR_V h1
17834: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
17835: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
17836: AND xet.event_class_code = C_EVENT_CLASS_CODE
17837: AND h1.event_id = xet.event_id
17838:

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

17953: END source_meaning
17954: FROM xla_events_gt xet
17955: , OKL_CMN_EXTRACT_LINE_V l2
17956: , fnd_lookup_values fvl6
17957: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
17958: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
17959: AND xet.event_class_code = C_EVENT_CLASS_CODE
17960: AND l2.event_id = xet.event_id
17961: AND fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'

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

19015: END source_value
19016: , null source_meaning
19017: FROM xla_events_gt xet
19018: , OKL_CMN_EXTRACT_HDR_V h1
19019: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
19020: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
19021: AND xet.event_class_code = C_EVENT_CLASS_CODE
19022: AND h1.event_id = xet.event_id
19023:

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

19138: END source_meaning
19139: FROM xla_events_gt xet
19140: , OKL_CMN_EXTRACT_LINE_V l2
19141: , fnd_lookup_values fvl6
19142: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
19143: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
19144: AND xet.event_class_code = C_EVENT_CLASS_CODE
19145: AND l2.event_id = xet.event_id
19146: AND fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'

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

20200: END source_value
20201: , null source_meaning
20202: FROM xla_events_gt xet
20203: , OKL_CMN_EXTRACT_HDR_V h1
20204: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
20205: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
20206: AND xet.event_class_code = C_EVENT_CLASS_CODE
20207: AND h1.event_id = xet.event_id
20208:

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

20323: END source_meaning
20324: FROM xla_events_gt xet
20325: , OKL_CMN_EXTRACT_LINE_V l2
20326: , fnd_lookup_values fvl6
20327: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
20328: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
20329: AND xet.event_class_code = C_EVENT_CLASS_CODE
20330: AND l2.event_id = xet.event_id
20331: AND fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'

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

21385: END source_value
21386: , null source_meaning
21387: FROM xla_events_gt xet
21388: , OKL_IA_EXTRACT_HDR_V h2
21389: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
21390: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
21391: AND xet.event_class_code = C_EVENT_CLASS_CODE
21392: AND h2.event_id = xet.event_id
21393:

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

21508: END source_meaning
21509: FROM xla_events_gt xet
21510: , OKL_CMN_EXTRACT_LINE_V l1
21511: , fnd_lookup_values fvl6
21512: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
21513: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
21514: AND xet.event_class_code = C_EVENT_CLASS_CODE
21515: AND l1.event_id = xet.event_id
21516: AND fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'

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

22570: END source_value
22571: , null source_meaning
22572: FROM xla_events_gt xet
22573: , OKL_CMN_EXTRACT_HDR_V h1
22574: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
22575: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
22576: AND xet.event_class_code = C_EVENT_CLASS_CODE
22577: AND h1.event_id = xet.event_id
22578:

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

22693: END source_meaning
22694: FROM xla_events_gt xet
22695: , OKL_CMN_EXTRACT_LINE_V l2
22696: , fnd_lookup_values fvl6
22697: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
22698: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
22699: AND xet.event_class_code = C_EVENT_CLASS_CODE
22700: AND l2.event_id = xet.event_id
22701: AND fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'

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

23755: END source_value
23756: , null source_meaning
23757: FROM xla_events_gt xet
23758: , OKL_CMN_EXTRACT_HDR_V h1
23759: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
23760: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
23761: AND xet.event_class_code = C_EVENT_CLASS_CODE
23762: AND h1.event_id = xet.event_id
23763:

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

23878: END source_meaning
23879: FROM xla_events_gt xet
23880: , OKL_CMN_EXTRACT_LINE_V l2
23881: , fnd_lookup_values fvl6
23882: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
23883: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
23884: AND xet.event_class_code = C_EVENT_CLASS_CODE
23885: AND l2.event_id = xet.event_id
23886: AND fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'

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

24940: END source_value
24941: , null source_meaning
24942: FROM xla_events_gt xet
24943: , OKL_CMN_EXTRACT_HDR_V h1
24944: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
24945: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
24946: AND xet.event_class_code = C_EVENT_CLASS_CODE
24947: AND h1.event_id = xet.event_id
24948:

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

25063: END source_meaning
25064: FROM xla_events_gt xet
25065: , OKL_CMN_EXTRACT_LINE_V l2
25066: , fnd_lookup_values fvl6
25067: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
25068: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
25069: AND xet.event_class_code = C_EVENT_CLASS_CODE
25070: AND l2.event_id = xet.event_id
25071: AND fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'

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

26125: END source_value
26126: , null source_meaning
26127: FROM xla_events_gt xet
26128: , OKL_CMN_EXTRACT_HDR_V h1
26129: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
26130: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
26131: AND xet.event_class_code = C_EVENT_CLASS_CODE
26132: AND h1.event_id = xet.event_id
26133:

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

26248: END source_meaning
26249: FROM xla_events_gt xet
26250: , OKL_CMN_EXTRACT_LINE_V l2
26251: , fnd_lookup_values fvl6
26252: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
26253: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
26254: AND xet.event_class_code = C_EVENT_CLASS_CODE
26255: AND l2.event_id = xet.event_id
26256: AND fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'

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

27310: END source_value
27311: , null source_meaning
27312: FROM xla_events_gt xet
27313: , OKL_CMN_EXTRACT_HDR_V h1
27314: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
27315: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
27316: AND xet.event_class_code = C_EVENT_CLASS_CODE
27317: AND h1.event_id = xet.event_id
27318:

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

27433: END source_meaning
27434: FROM xla_events_gt xet
27435: , OKL_CMN_EXTRACT_LINE_V l2
27436: , fnd_lookup_values fvl6
27437: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
27438: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
27439: AND xet.event_class_code = C_EVENT_CLASS_CODE
27440: AND l2.event_id = xet.event_id
27441: AND fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'

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

28490: END source_value
28491: , null source_meaning
28492: FROM xla_events_gt xet
28493: , OKL_CMN_EXTRACT_HDR_V h1
28494: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
28495: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
28496: AND xet.event_class_code = C_EVENT_CLASS_CODE
28497: AND h1.event_id = xet.event_id
28498:

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

28613: END source_meaning
28614: FROM xla_events_gt xet
28615: , OKL_CMN_EXTRACT_LINE_V l2
28616: , fnd_lookup_values fvl6
28617: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
28618: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
28619: AND xet.event_class_code = C_EVENT_CLASS_CODE
28620: AND l2.event_id = xet.event_id
28621: AND fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'

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

29658: END source_value
29659: , null source_meaning
29660: FROM xla_events_gt xet
29661: , OKL_CMN_EXTRACT_HDR_V h1
29662: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
29663: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
29664: AND xet.event_class_code = C_EVENT_CLASS_CODE
29665: AND h1.event_id = xet.event_id
29666:

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

29781: END source_meaning
29782: FROM xla_events_gt xet
29783: , OKL_CMN_EXTRACT_LINE_V l2
29784: , fnd_lookup_values fvl6
29785: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
29786: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
29787: AND xet.event_class_code = C_EVENT_CLASS_CODE
29788: AND l2.event_id = xet.event_id
29789: AND fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'

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

30843: END source_value
30844: , null source_meaning
30845: FROM xla_events_gt xet
30846: , OKL_CMN_EXTRACT_HDR_V h1
30847: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
30848: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
30849: AND xet.event_class_code = C_EVENT_CLASS_CODE
30850: AND h1.event_id = xet.event_id
30851:

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

30966: END source_meaning
30967: FROM xla_events_gt xet
30968: , OKL_CMN_EXTRACT_LINE_V l2
30969: , fnd_lookup_values fvl6
30970: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
30971: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
30972: AND xet.event_class_code = C_EVENT_CLASS_CODE
30973: AND l2.event_id = xet.event_id
30974: AND fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'