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 XLA_EVENTS_GT

Line 15399: FROM xla_events_gt xet

15395:
15396: ELSE null
15397: END source_value
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

Line 15522: FROM xla_events_gt xet

15518: WHEN 2 THEN fvl6.meaning
15519:
15520: ELSE null
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

Line 15735: FROM xla_events_gt xet

15731: , h1.TCN_CURR_CONVERSION_TYPE source_13
15732: , h3.TCN_ACCRUAL_REVERSAL_DATE source_14
15733: , h1.GL_DATE source_15
15734: , h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
15735: FROM xla_events_gt xet
15736: , OKL_CMN_EXTRACT_HDR_V h1
15737: , OKL_SHR_EXTRACT_HDR_V h3
15738: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
15739: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 15782: FROM xla_events_gt xet

15778: , fvl6.meaning source_6_meaning
15779: , l2.DIST_ID source_7
15780: , l2.DIST_TYPE source_8
15781: , l2.DIST_ENTERED_AMOUNT source_9
15782: FROM xla_events_gt xet
15783: , OKL_CMN_EXTRACT_LINE_V l2
15784: , fnd_lookup_values fvl6
15785: WHERE xet.event_id between x_first_event_id and x_last_event_id
15786: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 16647: FROM xla_events_gt xet

16643:
16644: ELSE null
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

Line 16769: FROM xla_events_gt xet

16765: WHEN 2 THEN fvl6.meaning
16766:
16767: ELSE null
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

Line 16979: FROM xla_events_gt xet

16975: , h1.TCN_CURR_CONVERSION_RATE source_12
16976: , h1.TCN_CURR_CONVERSION_TYPE source_13
16977: , h1.GL_DATE source_15
16978: , h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
16979: FROM xla_events_gt xet
16980: , OKL_CMN_EXTRACT_HDR_V h1
16981: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
16982: and xet.event_class_code = C_EVENT_CLASS_CODE
16983: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 17025: FROM xla_events_gt xet

17021: , fvl6.meaning source_6_meaning
17022: , l2.DIST_ID source_7
17023: , l2.DIST_TYPE source_8
17024: , l2.DIST_ENTERED_AMOUNT source_9
17025: FROM xla_events_gt xet
17026: , OKL_CMN_EXTRACT_LINE_V l2
17027: , fnd_lookup_values fvl6
17028: WHERE xet.event_id between x_first_event_id and x_last_event_id
17029: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 17832: FROM xla_events_gt xet

17828:
17829: ELSE null
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

Line 17954: FROM xla_events_gt xet

17950: WHEN 2 THEN fvl6.meaning
17951:
17952: ELSE null
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

Line 18164: FROM xla_events_gt xet

18160: , h1.TCN_CURR_CONVERSION_RATE source_12
18161: , h1.TCN_CURR_CONVERSION_TYPE source_13
18162: , h1.GL_DATE source_15
18163: , h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
18164: FROM xla_events_gt xet
18165: , OKL_CMN_EXTRACT_HDR_V h1
18166: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
18167: and xet.event_class_code = C_EVENT_CLASS_CODE
18168: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 18210: FROM xla_events_gt xet

18206: , fvl6.meaning source_6_meaning
18207: , l2.DIST_ID source_7
18208: , l2.DIST_TYPE source_8
18209: , l2.DIST_ENTERED_AMOUNT source_9
18210: FROM xla_events_gt xet
18211: , OKL_CMN_EXTRACT_LINE_V l2
18212: , fnd_lookup_values fvl6
18213: WHERE xet.event_id between x_first_event_id and x_last_event_id
18214: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 19017: FROM xla_events_gt xet

19013:
19014: ELSE null
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

Line 19139: FROM xla_events_gt xet

19135: WHEN 2 THEN fvl6.meaning
19136:
19137: ELSE null
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

Line 19349: FROM xla_events_gt xet

19345: , h1.TCN_CURR_CONVERSION_RATE source_12
19346: , h1.TCN_CURR_CONVERSION_TYPE source_13
19347: , h1.GL_DATE source_15
19348: , h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
19349: FROM xla_events_gt xet
19350: , OKL_CMN_EXTRACT_HDR_V h1
19351: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
19352: and xet.event_class_code = C_EVENT_CLASS_CODE
19353: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 19395: FROM xla_events_gt xet

19391: , fvl6.meaning source_6_meaning
19392: , l2.DIST_ID source_7
19393: , l2.DIST_TYPE source_8
19394: , l2.DIST_ENTERED_AMOUNT source_9
19395: FROM xla_events_gt xet
19396: , OKL_CMN_EXTRACT_LINE_V l2
19397: , fnd_lookup_values fvl6
19398: WHERE xet.event_id between x_first_event_id and x_last_event_id
19399: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 20202: FROM xla_events_gt xet

20198:
20199: ELSE null
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

Line 20324: FROM xla_events_gt xet

20320: WHEN 2 THEN fvl6.meaning
20321:
20322: ELSE null
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

Line 20534: FROM xla_events_gt xet

20530: , h1.TCN_CURR_CONVERSION_RATE source_12
20531: , h1.TCN_CURR_CONVERSION_TYPE source_13
20532: , h1.GL_DATE source_15
20533: , h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
20534: FROM xla_events_gt xet
20535: , OKL_CMN_EXTRACT_HDR_V h1
20536: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
20537: and xet.event_class_code = C_EVENT_CLASS_CODE
20538: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 20580: FROM xla_events_gt xet

20576: , fvl6.meaning source_6_meaning
20577: , l2.DIST_ID source_7
20578: , l2.DIST_TYPE source_8
20579: , l2.DIST_ENTERED_AMOUNT source_9
20580: FROM xla_events_gt xet
20581: , OKL_CMN_EXTRACT_LINE_V l2
20582: , fnd_lookup_values fvl6
20583: WHERE xet.event_id between x_first_event_id and x_last_event_id
20584: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 21387: FROM xla_events_gt xet

21383:
21384: ELSE null
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

Line 21509: FROM xla_events_gt xet

21505: WHEN 2 THEN fvl6.meaning
21506:
21507: ELSE null
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

Line 21719: FROM xla_events_gt xet

21715: , h2.TCN_CURR_CONVERSION_RATE source_12
21716: , h2.TCN_CURR_CONVERSION_TYPE source_13
21717: , h2.GL_DATE source_15
21718: , h2.TCN_ACCOUNTING_REVERSAL_FLAG source_16
21719: FROM xla_events_gt xet
21720: , OKL_IA_EXTRACT_HDR_V h2
21721: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
21722: and xet.event_class_code = C_EVENT_CLASS_CODE
21723: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 21765: FROM xla_events_gt xet

21761: , fvl6.meaning source_6_meaning
21762: , l1.DIST_ID source_7
21763: , l1.DIST_TYPE source_8
21764: , l1.DIST_ENTERED_AMOUNT source_9
21765: FROM xla_events_gt xet
21766: , OKL_CMN_EXTRACT_LINE_V l1
21767: , fnd_lookup_values fvl6
21768: WHERE xet.event_id between x_first_event_id and x_last_event_id
21769: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 22572: FROM xla_events_gt xet

22568:
22569: ELSE null
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

Line 22694: FROM xla_events_gt xet

22690: WHEN 2 THEN fvl6.meaning
22691:
22692: ELSE null
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

Line 22904: FROM xla_events_gt xet

22900: , h1.TCN_CURR_CONVERSION_RATE source_12
22901: , h1.TCN_CURR_CONVERSION_TYPE source_13
22902: , h1.GL_DATE source_15
22903: , h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
22904: FROM xla_events_gt xet
22905: , OKL_CMN_EXTRACT_HDR_V h1
22906: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
22907: and xet.event_class_code = C_EVENT_CLASS_CODE
22908: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 22950: FROM xla_events_gt xet

22946: , fvl6.meaning source_6_meaning
22947: , l2.DIST_ID source_7
22948: , l2.DIST_TYPE source_8
22949: , l2.DIST_ENTERED_AMOUNT source_9
22950: FROM xla_events_gt xet
22951: , OKL_CMN_EXTRACT_LINE_V l2
22952: , fnd_lookup_values fvl6
22953: WHERE xet.event_id between x_first_event_id and x_last_event_id
22954: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 23757: FROM xla_events_gt xet

23753:
23754: ELSE null
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

Line 23879: FROM xla_events_gt xet

23875: WHEN 2 THEN fvl6.meaning
23876:
23877: ELSE null
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

Line 24089: FROM xla_events_gt xet

24085: , h1.TCN_CURR_CONVERSION_RATE source_12
24086: , h1.TCN_CURR_CONVERSION_TYPE source_13
24087: , h1.GL_DATE source_15
24088: , h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
24089: FROM xla_events_gt xet
24090: , OKL_CMN_EXTRACT_HDR_V h1
24091: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
24092: and xet.event_class_code = C_EVENT_CLASS_CODE
24093: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 24135: FROM xla_events_gt xet

24131: , fvl6.meaning source_6_meaning
24132: , l2.DIST_ID source_7
24133: , l2.DIST_TYPE source_8
24134: , l2.DIST_ENTERED_AMOUNT source_9
24135: FROM xla_events_gt xet
24136: , OKL_CMN_EXTRACT_LINE_V l2
24137: , fnd_lookup_values fvl6
24138: WHERE xet.event_id between x_first_event_id and x_last_event_id
24139: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 24942: FROM xla_events_gt xet

24938:
24939: ELSE null
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

Line 25064: FROM xla_events_gt xet

25060: WHEN 2 THEN fvl6.meaning
25061:
25062: ELSE null
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

Line 25274: FROM xla_events_gt xet

25270: , h1.TCN_CURR_CONVERSION_RATE source_12
25271: , h1.TCN_CURR_CONVERSION_TYPE source_13
25272: , h1.GL_DATE source_15
25273: , h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
25274: FROM xla_events_gt xet
25275: , OKL_CMN_EXTRACT_HDR_V h1
25276: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
25277: and xet.event_class_code = C_EVENT_CLASS_CODE
25278: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 25320: FROM xla_events_gt xet

25316: , fvl6.meaning source_6_meaning
25317: , l2.DIST_ID source_7
25318: , l2.DIST_TYPE source_8
25319: , l2.DIST_ENTERED_AMOUNT source_9
25320: FROM xla_events_gt xet
25321: , OKL_CMN_EXTRACT_LINE_V l2
25322: , fnd_lookup_values fvl6
25323: WHERE xet.event_id between x_first_event_id and x_last_event_id
25324: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 26127: FROM xla_events_gt xet

26123:
26124: ELSE null
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

Line 26249: FROM xla_events_gt xet

26245: WHEN 2 THEN fvl6.meaning
26246:
26247: ELSE null
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

Line 26459: FROM xla_events_gt xet

26455: , h1.TCN_CURR_CONVERSION_RATE source_12
26456: , h1.TCN_CURR_CONVERSION_TYPE source_13
26457: , h1.GL_DATE source_15
26458: , h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
26459: FROM xla_events_gt xet
26460: , OKL_CMN_EXTRACT_HDR_V h1
26461: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
26462: and xet.event_class_code = C_EVENT_CLASS_CODE
26463: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 26505: FROM xla_events_gt xet

26501: , fvl6.meaning source_6_meaning
26502: , l2.DIST_ID source_7
26503: , l2.DIST_TYPE source_8
26504: , l2.DIST_ENTERED_AMOUNT source_9
26505: FROM xla_events_gt xet
26506: , OKL_CMN_EXTRACT_LINE_V l2
26507: , fnd_lookup_values fvl6
26508: WHERE xet.event_id between x_first_event_id and x_last_event_id
26509: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 27312: FROM xla_events_gt xet

27308:
27309: ELSE null
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

Line 27434: FROM xla_events_gt xet

27430: WHEN 2 THEN fvl6.meaning
27431:
27432: ELSE null
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

Line 27644: FROM xla_events_gt xet

27640: , h1.TCN_CURR_CONVERSION_RATE source_12
27641: , h1.TCN_CURR_CONVERSION_TYPE source_13
27642: , h1.GL_DATE source_15
27643: , h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
27644: FROM xla_events_gt xet
27645: , OKL_CMN_EXTRACT_HDR_V h1
27646: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
27647: and xet.event_class_code = C_EVENT_CLASS_CODE
27648: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 27690: FROM xla_events_gt xet

27686: , fvl6.meaning source_6_meaning
27687: , l2.DIST_ID source_7
27688: , l2.DIST_TYPE source_8
27689: , l2.DIST_ENTERED_AMOUNT source_9
27690: FROM xla_events_gt xet
27691: , OKL_CMN_EXTRACT_LINE_V l2
27692: , fnd_lookup_values fvl6
27693: WHERE xet.event_id between x_first_event_id and x_last_event_id
27694: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 28492: FROM xla_events_gt xet

28488:
28489: ELSE null
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

Line 28614: FROM xla_events_gt xet

28610: WHEN 2 THEN fvl6.meaning
28611:
28612: ELSE null
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

Line 28821: FROM xla_events_gt xet

28817: , h1.TCN_CURR_CONVERSION_DATE source_11
28818: , h1.TCN_CURR_CONVERSION_RATE source_12
28819: , h1.TCN_CURR_CONVERSION_TYPE source_13
28820: , h1.GL_DATE source_15
28821: FROM xla_events_gt xet
28822: , OKL_CMN_EXTRACT_HDR_V h1
28823: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
28824: and xet.event_class_code = C_EVENT_CLASS_CODE
28825: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 28867: FROM xla_events_gt xet

28863: , fvl6.meaning source_6_meaning
28864: , l2.DIST_ID source_7
28865: , l2.DIST_TYPE source_8
28866: , l2.DIST_ENTERED_AMOUNT source_9
28867: FROM xla_events_gt xet
28868: , OKL_CMN_EXTRACT_LINE_V l2
28869: , fnd_lookup_values fvl6
28870: WHERE xet.event_id between x_first_event_id and x_last_event_id
28871: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 29660: FROM xla_events_gt xet

29656:
29657: ELSE null
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

Line 29782: FROM xla_events_gt xet

29778: WHEN 2 THEN fvl6.meaning
29779:
29780: ELSE null
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

Line 29992: FROM xla_events_gt xet

29988: , h1.TCN_CURR_CONVERSION_RATE source_12
29989: , h1.TCN_CURR_CONVERSION_TYPE source_13
29990: , h1.GL_DATE source_15
29991: , h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
29992: FROM xla_events_gt xet
29993: , OKL_CMN_EXTRACT_HDR_V h1
29994: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
29995: and xet.event_class_code = C_EVENT_CLASS_CODE
29996: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 30038: FROM xla_events_gt xet

30034: , fvl6.meaning source_6_meaning
30035: , l2.DIST_ID source_7
30036: , l2.DIST_TYPE source_8
30037: , l2.DIST_ENTERED_AMOUNT source_9
30038: FROM xla_events_gt xet
30039: , OKL_CMN_EXTRACT_LINE_V l2
30040: , fnd_lookup_values fvl6
30041: WHERE xet.event_id between x_first_event_id and x_last_event_id
30042: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 30845: FROM xla_events_gt xet

30841:
30842: ELSE null
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

Line 30967: FROM xla_events_gt xet

30963: WHEN 2 THEN fvl6.meaning
30964:
30965: ELSE null
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

Line 31177: FROM xla_events_gt xet

31173: , h1.TCN_CURR_CONVERSION_RATE source_12
31174: , h1.TCN_CURR_CONVERSION_TYPE source_13
31175: , h1.GL_DATE source_15
31176: , h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
31177: FROM xla_events_gt xet
31178: , OKL_CMN_EXTRACT_HDR_V h1
31179: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
31180: and xet.event_class_code = C_EVENT_CLASS_CODE
31181: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 31223: FROM xla_events_gt xet

31219: , fvl6.meaning source_6_meaning
31220: , l2.DIST_ID source_7
31221: , l2.DIST_TYPE source_8
31222: , l2.DIST_ENTERED_AMOUNT source_9
31223: FROM xla_events_gt xet
31224: , OKL_CMN_EXTRACT_LINE_V l2
31225: , fnd_lookup_values fvl6
31226: WHERE xet.event_id between x_first_event_id and x_last_event_id
31227: and xet.event_date between p_pad_start_date and p_pad_end_date

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

32415: ,p_level => C_LEVEL_STATEMENT
32416: ,p_module => l_log_module);
32417:
32418: trace
32419: (p_msg => '# of events in xla_events_gt: '
32420: ||xla_context_pkg.get_event_count_context
32421: ,p_level => C_LEVEL_STATEMENT
32422: ,p_module => l_log_module);
32423: