[Home] [Help]
119625: ,555)
119626:
119627: ELSE null
119628: END source_meaning
119629: FROM xla_events_gt xet
119630: , GMF_XLA_EXTRACT_HEADERS h1
119631: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
119632: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
119633: AND xet.event_type_code = C_EVENT_TYPE_CODE
119742:
119743: ELSE null
119744: END source_value
119745: , null source_meaning
119746: FROM xla_events_gt xet
119747: , GMF_XLA_EXTRACT_LINES l2
119748: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
119749: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
119750: AND xet.event_type_code = C_EVENT_TYPE_CODE
119943: , h1.CURRENCY_CONVERSION_DATE source_8
119944: , h1.CURRENCY_CONVERSION_RATE source_9
119945: , h1.CURRENCY_CONVERSION_TYPE source_10
119946: , h1.TRANSACTION_DATE source_12
119947: FROM xla_events_gt xet
119948: , GMF_XLA_EXTRACT_HEADERS h1
119949: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
119950: and xet.event_type_code = C_EVENT_TYPE_CODE
119951: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
119988: , l2.JOURNAL_LINE_TYPE source_2
119989: , l2.ENTERED_AMOUNT source_3
119990: , l2.LINE_ID source_5
119991: , l2.ACCOUNTED_AMOUNT source_11
119992: FROM xla_events_gt xet
119993: , GMF_XLA_EXTRACT_LINES l2
119994: WHERE xet.event_id between x_first_event_id and x_last_event_id
119995: and xet.event_date between p_pad_start_date and p_pad_end_date
119996: and xet.event_type_code = C_EVENT_TYPE_CODE
120803: ,555)
120804:
120805: ELSE null
120806: END source_meaning
120807: FROM xla_events_gt xet
120808: , GMF_XLA_EXTRACT_HEADERS h1
120809: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
120810: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
120811: AND xet.event_type_code = C_EVENT_TYPE_CODE
120920:
120921: ELSE null
120922: END source_value
120923: , null source_meaning
120924: FROM xla_events_gt xet
120925: , GMF_XLA_EXTRACT_LINES l2
120926: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
120927: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
120928: AND xet.event_type_code = C_EVENT_TYPE_CODE
121121: , h1.CURRENCY_CONVERSION_DATE source_8
121122: , h1.CURRENCY_CONVERSION_RATE source_9
121123: , h1.CURRENCY_CONVERSION_TYPE source_10
121124: , h1.TRANSACTION_DATE source_12
121125: FROM xla_events_gt xet
121126: , GMF_XLA_EXTRACT_HEADERS h1
121127: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
121128: and xet.event_type_code = C_EVENT_TYPE_CODE
121129: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
121166: , l2.JOURNAL_LINE_TYPE source_2
121167: , l2.ENTERED_AMOUNT source_3
121168: , l2.LINE_ID source_5
121169: , l2.ACCOUNTED_AMOUNT source_11
121170: FROM xla_events_gt xet
121171: , GMF_XLA_EXTRACT_LINES l2
121172: WHERE xet.event_id between x_first_event_id and x_last_event_id
121173: and xet.event_date between p_pad_start_date and p_pad_end_date
121174: and xet.event_type_code = C_EVENT_TYPE_CODE
121981: ,555)
121982:
121983: ELSE null
121984: END source_meaning
121985: FROM xla_events_gt xet
121986: , GMF_XLA_EXTRACT_HEADERS h1
121987: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
121988: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
121989: AND xet.event_type_code = C_EVENT_TYPE_CODE
122098:
122099: ELSE null
122100: END source_value
122101: , null source_meaning
122102: FROM xla_events_gt xet
122103: , GMF_XLA_EXTRACT_LINES l2
122104: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
122105: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
122106: AND xet.event_type_code = C_EVENT_TYPE_CODE
122299: , h1.CURRENCY_CONVERSION_DATE source_8
122300: , h1.CURRENCY_CONVERSION_RATE source_9
122301: , h1.CURRENCY_CONVERSION_TYPE source_10
122302: , h1.TRANSACTION_DATE source_12
122303: FROM xla_events_gt xet
122304: , GMF_XLA_EXTRACT_HEADERS h1
122305: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
122306: and xet.event_type_code = C_EVENT_TYPE_CODE
122307: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
122344: , l2.JOURNAL_LINE_TYPE source_2
122345: , l2.ENTERED_AMOUNT source_3
122346: , l2.LINE_ID source_5
122347: , l2.ACCOUNTED_AMOUNT source_11
122348: FROM xla_events_gt xet
122349: , GMF_XLA_EXTRACT_LINES l2
122350: WHERE xet.event_id between x_first_event_id and x_last_event_id
122351: and xet.event_date between p_pad_start_date and p_pad_end_date
122352: and xet.event_type_code = C_EVENT_TYPE_CODE
123187: ,555)
123188:
123189: ELSE null
123190: END source_meaning
123191: FROM xla_events_gt xet
123192: , GMF_XLA_EXTRACT_HEADERS h1
123193: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
123194: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
123195: AND xet.event_type_code = C_EVENT_TYPE_CODE
123304:
123305: ELSE null
123306: END source_value
123307: , null source_meaning
123308: FROM xla_events_gt xet
123309: , GMF_XLA_EXTRACT_LINES l2
123310: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
123311: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
123312: AND xet.event_type_code = C_EVENT_TYPE_CODE
123505: , h1.CURRENCY_CONVERSION_DATE source_8
123506: , h1.CURRENCY_CONVERSION_RATE source_9
123507: , h1.CURRENCY_CONVERSION_TYPE source_10
123508: , h1.TRANSACTION_DATE source_12
123509: FROM xla_events_gt xet
123510: , GMF_XLA_EXTRACT_HEADERS h1
123511: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
123512: and xet.event_type_code = C_EVENT_TYPE_CODE
123513: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
123550: , l2.JOURNAL_LINE_TYPE source_2
123551: , l2.ENTERED_AMOUNT source_3
123552: , l2.LINE_ID source_5
123553: , l2.ACCOUNTED_AMOUNT source_11
123554: FROM xla_events_gt xet
123555: , GMF_XLA_EXTRACT_LINES l2
123556: WHERE xet.event_id between x_first_event_id and x_last_event_id
123557: and xet.event_date between p_pad_start_date and p_pad_end_date
123558: and xet.event_type_code = C_EVENT_TYPE_CODE
124449: ,555)
124450:
124451: ELSE null
124452: END source_meaning
124453: FROM xla_events_gt xet
124454: , GMF_XLA_EXTRACT_HEADERS h1
124455: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
124456: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
124457: AND xet.event_type_code = C_EVENT_TYPE_CODE
124566:
124567: ELSE null
124568: END source_value
124569: , null source_meaning
124570: FROM xla_events_gt xet
124571: , GMF_XLA_EXTRACT_LINES l2
124572: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
124573: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
124574: AND xet.event_type_code = C_EVENT_TYPE_CODE
124767: , h1.CURRENCY_CONVERSION_DATE source_8
124768: , h1.CURRENCY_CONVERSION_RATE source_9
124769: , h1.CURRENCY_CONVERSION_TYPE source_10
124770: , h1.TRANSACTION_DATE source_12
124771: FROM xla_events_gt xet
124772: , GMF_XLA_EXTRACT_HEADERS h1
124773: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
124774: and xet.event_type_code = C_EVENT_TYPE_CODE
124775: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
124812: , l2.JOURNAL_LINE_TYPE source_2
124813: , l2.ENTERED_AMOUNT source_3
124814: , l2.LINE_ID source_5
124815: , l2.ACCOUNTED_AMOUNT source_11
124816: FROM xla_events_gt xet
124817: , GMF_XLA_EXTRACT_LINES l2
124818: WHERE xet.event_id between x_first_event_id and x_last_event_id
124819: and xet.event_date between p_pad_start_date and p_pad_end_date
124820: and xet.event_type_code = C_EVENT_TYPE_CODE
125851: ,555)
125852:
125853: ELSE null
125854: END source_meaning
125855: FROM xla_events_gt xet
125856: , GMF_XLA_EXTRACT_HEADERS h1
125857: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
125858: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
125859: AND xet.event_type_code = C_EVENT_TYPE_CODE
125968:
125969: ELSE null
125970: END source_value
125971: , null source_meaning
125972: FROM xla_events_gt xet
125973: , GMF_XLA_EXTRACT_LINES l2
125974: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
125975: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
125976: AND xet.event_type_code = C_EVENT_TYPE_CODE
126169: , h1.CURRENCY_CONVERSION_DATE source_8
126170: , h1.CURRENCY_CONVERSION_RATE source_9
126171: , h1.CURRENCY_CONVERSION_TYPE source_10
126172: , h1.TRANSACTION_DATE source_12
126173: FROM xla_events_gt xet
126174: , GMF_XLA_EXTRACT_HEADERS h1
126175: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
126176: and xet.event_type_code = C_EVENT_TYPE_CODE
126177: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
126214: , l2.JOURNAL_LINE_TYPE source_2
126215: , l2.ENTERED_AMOUNT source_3
126216: , l2.LINE_ID source_5
126217: , l2.ACCOUNTED_AMOUNT source_11
126218: FROM xla_events_gt xet
126219: , GMF_XLA_EXTRACT_LINES l2
126220: WHERE xet.event_id between x_first_event_id and x_last_event_id
126221: and xet.event_date between p_pad_start_date and p_pad_end_date
126222: and xet.event_type_code = C_EVENT_TYPE_CODE
127029: ,555)
127030:
127031: ELSE null
127032: END source_meaning
127033: FROM xla_events_gt xet
127034: , GMF_XLA_EXTRACT_HEADERS h1
127035: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
127036: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
127037: AND xet.event_type_code = C_EVENT_TYPE_CODE
127146:
127147: ELSE null
127148: END source_value
127149: , null source_meaning
127150: FROM xla_events_gt xet
127151: , GMF_XLA_EXTRACT_LINES l2
127152: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
127153: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
127154: AND xet.event_type_code = C_EVENT_TYPE_CODE
127347: , h1.CURRENCY_CONVERSION_DATE source_8
127348: , h1.CURRENCY_CONVERSION_RATE source_9
127349: , h1.CURRENCY_CONVERSION_TYPE source_10
127350: , h1.TRANSACTION_DATE source_12
127351: FROM xla_events_gt xet
127352: , GMF_XLA_EXTRACT_HEADERS h1
127353: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
127354: and xet.event_type_code = C_EVENT_TYPE_CODE
127355: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
127392: , l2.JOURNAL_LINE_TYPE source_2
127393: , l2.ENTERED_AMOUNT source_3
127394: , l2.LINE_ID source_5
127395: , l2.ACCOUNTED_AMOUNT source_11
127396: FROM xla_events_gt xet
127397: , GMF_XLA_EXTRACT_LINES l2
127398: WHERE xet.event_id between x_first_event_id and x_last_event_id
127399: and xet.event_date between p_pad_start_date and p_pad_end_date
127400: and xet.event_type_code = C_EVENT_TYPE_CODE
128235: ,555)
128236:
128237: ELSE null
128238: END source_meaning
128239: FROM xla_events_gt xet
128240: , GMF_XLA_EXTRACT_HEADERS h1
128241: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
128242: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
128243: AND xet.event_type_code = C_EVENT_TYPE_CODE
128352:
128353: ELSE null
128354: END source_value
128355: , null source_meaning
128356: FROM xla_events_gt xet
128357: , GMF_XLA_EXTRACT_LINES l2
128358: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
128359: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
128360: AND xet.event_type_code = C_EVENT_TYPE_CODE
128553: , h1.CURRENCY_CONVERSION_DATE source_8
128554: , h1.CURRENCY_CONVERSION_RATE source_9
128555: , h1.CURRENCY_CONVERSION_TYPE source_10
128556: , h1.TRANSACTION_DATE source_12
128557: FROM xla_events_gt xet
128558: , GMF_XLA_EXTRACT_HEADERS h1
128559: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
128560: and xet.event_type_code = C_EVENT_TYPE_CODE
128561: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
128598: , l2.JOURNAL_LINE_TYPE source_2
128599: , l2.ENTERED_AMOUNT source_3
128600: , l2.LINE_ID source_5
128601: , l2.ACCOUNTED_AMOUNT source_11
128602: FROM xla_events_gt xet
128603: , GMF_XLA_EXTRACT_LINES l2
128604: WHERE xet.event_id between x_first_event_id and x_last_event_id
128605: and xet.event_date between p_pad_start_date and p_pad_end_date
128606: and xet.event_type_code = C_EVENT_TYPE_CODE
129441: ,555)
129442:
129443: ELSE null
129444: END source_meaning
129445: FROM xla_events_gt xet
129446: , GMF_XLA_EXTRACT_HEADERS h1
129447: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
129448: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
129449: AND xet.event_type_code = C_EVENT_TYPE_CODE
129558:
129559: ELSE null
129560: END source_value
129561: , null source_meaning
129562: FROM xla_events_gt xet
129563: , GMF_XLA_EXTRACT_LINES l2
129564: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
129565: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
129566: AND xet.event_type_code = C_EVENT_TYPE_CODE
129759: , h1.CURRENCY_CONVERSION_DATE source_8
129760: , h1.CURRENCY_CONVERSION_RATE source_9
129761: , h1.CURRENCY_CONVERSION_TYPE source_10
129762: , h1.TRANSACTION_DATE source_12
129763: FROM xla_events_gt xet
129764: , GMF_XLA_EXTRACT_HEADERS h1
129765: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
129766: and xet.event_type_code = C_EVENT_TYPE_CODE
129767: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
129804: , l2.JOURNAL_LINE_TYPE source_2
129805: , l2.ENTERED_AMOUNT source_3
129806: , l2.LINE_ID source_5
129807: , l2.ACCOUNTED_AMOUNT source_11
129808: FROM xla_events_gt xet
129809: , GMF_XLA_EXTRACT_LINES l2
129810: WHERE xet.event_id between x_first_event_id and x_last_event_id
129811: and xet.event_date between p_pad_start_date and p_pad_end_date
129812: and xet.event_type_code = C_EVENT_TYPE_CODE
130619: ,555)
130620:
130621: ELSE null
130622: END source_meaning
130623: FROM xla_events_gt xet
130624: , GMF_XLA_EXTRACT_HEADERS h1
130625: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
130626: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
130627: AND xet.event_type_code = C_EVENT_TYPE_CODE
130736:
130737: ELSE null
130738: END source_value
130739: , null source_meaning
130740: FROM xla_events_gt xet
130741: , GMF_XLA_EXTRACT_LINES l2
130742: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
130743: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
130744: AND xet.event_type_code = C_EVENT_TYPE_CODE
130937: , h1.CURRENCY_CONVERSION_DATE source_8
130938: , h1.CURRENCY_CONVERSION_RATE source_9
130939: , h1.CURRENCY_CONVERSION_TYPE source_10
130940: , h1.TRANSACTION_DATE source_12
130941: FROM xla_events_gt xet
130942: , GMF_XLA_EXTRACT_HEADERS h1
130943: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
130944: and xet.event_type_code = C_EVENT_TYPE_CODE
130945: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
130982: , l2.JOURNAL_LINE_TYPE source_2
130983: , l2.ENTERED_AMOUNT source_3
130984: , l2.LINE_ID source_5
130985: , l2.ACCOUNTED_AMOUNT source_11
130986: FROM xla_events_gt xet
130987: , GMF_XLA_EXTRACT_LINES l2
130988: WHERE xet.event_id between x_first_event_id and x_last_event_id
130989: and xet.event_date between p_pad_start_date and p_pad_end_date
130990: and xet.event_type_code = C_EVENT_TYPE_CODE
131797: ,555)
131798:
131799: ELSE null
131800: END source_meaning
131801: FROM xla_events_gt xet
131802: , GMF_XLA_EXTRACT_HEADERS h1
131803: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
131804: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
131805: AND xet.event_type_code = C_EVENT_TYPE_CODE
131914:
131915: ELSE null
131916: END source_value
131917: , null source_meaning
131918: FROM xla_events_gt xet
131919: , GMF_XLA_EXTRACT_LINES l2
131920: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
131921: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
131922: AND xet.event_type_code = C_EVENT_TYPE_CODE
132115: , h1.CURRENCY_CONVERSION_DATE source_8
132116: , h1.CURRENCY_CONVERSION_RATE source_9
132117: , h1.CURRENCY_CONVERSION_TYPE source_10
132118: , h1.TRANSACTION_DATE source_12
132119: FROM xla_events_gt xet
132120: , GMF_XLA_EXTRACT_HEADERS h1
132121: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
132122: and xet.event_type_code = C_EVENT_TYPE_CODE
132123: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
132160: , l2.JOURNAL_LINE_TYPE source_2
132161: , l2.ENTERED_AMOUNT source_3
132162: , l2.LINE_ID source_5
132163: , l2.ACCOUNTED_AMOUNT source_11
132164: FROM xla_events_gt xet
132165: , GMF_XLA_EXTRACT_LINES l2
132166: WHERE xet.event_id between x_first_event_id and x_last_event_id
132167: and xet.event_date between p_pad_start_date and p_pad_end_date
132168: and xet.event_type_code = C_EVENT_TYPE_CODE
133031: ,555)
133032:
133033: ELSE null
133034: END source_meaning
133035: FROM xla_events_gt xet
133036: , GMF_XLA_EXTRACT_HEADERS h1
133037: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
133038: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
133039: AND xet.event_type_code = C_EVENT_TYPE_CODE
133148:
133149: ELSE null
133150: END source_value
133151: , null source_meaning
133152: FROM xla_events_gt xet
133153: , GMF_XLA_EXTRACT_LINES l2
133154: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
133155: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
133156: AND xet.event_type_code = C_EVENT_TYPE_CODE
133349: , h1.CURRENCY_CONVERSION_DATE source_8
133350: , h1.CURRENCY_CONVERSION_RATE source_9
133351: , h1.CURRENCY_CONVERSION_TYPE source_10
133352: , h1.TRANSACTION_DATE source_12
133353: FROM xla_events_gt xet
133354: , GMF_XLA_EXTRACT_HEADERS h1
133355: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
133356: and xet.event_type_code = C_EVENT_TYPE_CODE
133357: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
133394: , l2.JOURNAL_LINE_TYPE source_2
133395: , l2.ENTERED_AMOUNT source_3
133396: , l2.LINE_ID source_5
133397: , l2.ACCOUNTED_AMOUNT source_11
133398: FROM xla_events_gt xet
133399: , GMF_XLA_EXTRACT_LINES l2
133400: WHERE xet.event_id between x_first_event_id and x_last_event_id
133401: and xet.event_date between p_pad_start_date and p_pad_end_date
133402: and xet.event_type_code = C_EVENT_TYPE_CODE
134237: ,555)
134238:
134239: ELSE null
134240: END source_meaning
134241: FROM xla_events_gt xet
134242: , GMF_XLA_EXTRACT_HEADERS h1
134243: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
134244: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
134245: AND xet.event_type_code = C_EVENT_TYPE_CODE
134354:
134355: ELSE null
134356: END source_value
134357: , null source_meaning
134358: FROM xla_events_gt xet
134359: , GMF_XLA_EXTRACT_LINES l2
134360: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
134361: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
134362: AND xet.event_type_code = C_EVENT_TYPE_CODE
134555: , h1.CURRENCY_CONVERSION_DATE source_8
134556: , h1.CURRENCY_CONVERSION_RATE source_9
134557: , h1.CURRENCY_CONVERSION_TYPE source_10
134558: , h1.TRANSACTION_DATE source_12
134559: FROM xla_events_gt xet
134560: , GMF_XLA_EXTRACT_HEADERS h1
134561: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
134562: and xet.event_type_code = C_EVENT_TYPE_CODE
134563: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
134600: , l2.JOURNAL_LINE_TYPE source_2
134601: , l2.ENTERED_AMOUNT source_3
134602: , l2.LINE_ID source_5
134603: , l2.ACCOUNTED_AMOUNT source_11
134604: FROM xla_events_gt xet
134605: , GMF_XLA_EXTRACT_LINES l2
134606: WHERE xet.event_id between x_first_event_id and x_last_event_id
134607: and xet.event_date between p_pad_start_date and p_pad_end_date
134608: and xet.event_type_code = C_EVENT_TYPE_CODE
135499: ,555)
135500:
135501: ELSE null
135502: END source_meaning
135503: FROM xla_events_gt xet
135504: , GMF_XLA_EXTRACT_HEADERS h1
135505: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
135506: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
135507: AND xet.event_type_code = C_EVENT_TYPE_CODE
135616:
135617: ELSE null
135618: END source_value
135619: , null source_meaning
135620: FROM xla_events_gt xet
135621: , GMF_XLA_EXTRACT_LINES l2
135622: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
135623: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
135624: AND xet.event_type_code = C_EVENT_TYPE_CODE
135817: , h1.CURRENCY_CONVERSION_DATE source_8
135818: , h1.CURRENCY_CONVERSION_RATE source_9
135819: , h1.CURRENCY_CONVERSION_TYPE source_10
135820: , h1.TRANSACTION_DATE source_12
135821: FROM xla_events_gt xet
135822: , GMF_XLA_EXTRACT_HEADERS h1
135823: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
135824: and xet.event_type_code = C_EVENT_TYPE_CODE
135825: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
135862: , l2.JOURNAL_LINE_TYPE source_2
135863: , l2.ENTERED_AMOUNT source_3
135864: , l2.LINE_ID source_5
135865: , l2.ACCOUNTED_AMOUNT source_11
135866: FROM xla_events_gt xet
135867: , GMF_XLA_EXTRACT_LINES l2
135868: WHERE xet.event_id between x_first_event_id and x_last_event_id
135869: and xet.event_date between p_pad_start_date and p_pad_end_date
135870: and xet.event_type_code = C_EVENT_TYPE_CODE
136733: ,555)
136734:
136735: ELSE null
136736: END source_meaning
136737: FROM xla_events_gt xet
136738: , GMF_XLA_EXTRACT_HEADERS h1
136739: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
136740: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
136741: AND xet.event_type_code = C_EVENT_TYPE_CODE
136850:
136851: ELSE null
136852: END source_value
136853: , null source_meaning
136854: FROM xla_events_gt xet
136855: , GMF_XLA_EXTRACT_LINES l2
136856: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
136857: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
136858: AND xet.event_type_code = C_EVENT_TYPE_CODE
137051: , h1.CURRENCY_CONVERSION_DATE source_8
137052: , h1.CURRENCY_CONVERSION_RATE source_9
137053: , h1.CURRENCY_CONVERSION_TYPE source_10
137054: , h1.TRANSACTION_DATE source_12
137055: FROM xla_events_gt xet
137056: , GMF_XLA_EXTRACT_HEADERS h1
137057: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
137058: and xet.event_type_code = C_EVENT_TYPE_CODE
137059: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
137096: , l2.JOURNAL_LINE_TYPE source_2
137097: , l2.ENTERED_AMOUNT source_3
137098: , l2.LINE_ID source_5
137099: , l2.ACCOUNTED_AMOUNT source_11
137100: FROM xla_events_gt xet
137101: , GMF_XLA_EXTRACT_LINES l2
137102: WHERE xet.event_id between x_first_event_id and x_last_event_id
137103: and xet.event_date between p_pad_start_date and p_pad_end_date
137104: and xet.event_type_code = C_EVENT_TYPE_CODE
137911: ,555)
137912:
137913: ELSE null
137914: END source_meaning
137915: FROM xla_events_gt xet
137916: , GMF_XLA_EXTRACT_HEADERS h1
137917: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
137918: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
137919: AND xet.event_type_code = C_EVENT_TYPE_CODE
138028:
138029: ELSE null
138030: END source_value
138031: , null source_meaning
138032: FROM xla_events_gt xet
138033: , GMF_XLA_EXTRACT_LINES l2
138034: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
138035: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
138036: AND xet.event_type_code = C_EVENT_TYPE_CODE
138229: , h1.CURRENCY_CONVERSION_DATE source_8
138230: , h1.CURRENCY_CONVERSION_RATE source_9
138231: , h1.CURRENCY_CONVERSION_TYPE source_10
138232: , h1.TRANSACTION_DATE source_12
138233: FROM xla_events_gt xet
138234: , GMF_XLA_EXTRACT_HEADERS h1
138235: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
138236: and xet.event_type_code = C_EVENT_TYPE_CODE
138237: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
138274: , l2.JOURNAL_LINE_TYPE source_2
138275: , l2.ENTERED_AMOUNT source_3
138276: , l2.LINE_ID source_5
138277: , l2.ACCOUNTED_AMOUNT source_11
138278: FROM xla_events_gt xet
138279: , GMF_XLA_EXTRACT_LINES l2
138280: WHERE xet.event_id between x_first_event_id and x_last_event_id
138281: and xet.event_date between p_pad_start_date and p_pad_end_date
138282: and xet.event_type_code = C_EVENT_TYPE_CODE
139089: ,555)
139090:
139091: ELSE null
139092: END source_meaning
139093: FROM xla_events_gt xet
139094: , GMF_XLA_EXTRACT_HEADERS h1
139095: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
139096: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
139097: AND xet.event_type_code = C_EVENT_TYPE_CODE
139206:
139207: ELSE null
139208: END source_value
139209: , null source_meaning
139210: FROM xla_events_gt xet
139211: , GMF_XLA_EXTRACT_LINES l2
139212: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
139213: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
139214: AND xet.event_type_code = C_EVENT_TYPE_CODE
139407: , h1.CURRENCY_CONVERSION_DATE source_8
139408: , h1.CURRENCY_CONVERSION_RATE source_9
139409: , h1.CURRENCY_CONVERSION_TYPE source_10
139410: , h1.TRANSACTION_DATE source_12
139411: FROM xla_events_gt xet
139412: , GMF_XLA_EXTRACT_HEADERS h1
139413: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
139414: and xet.event_type_code = C_EVENT_TYPE_CODE
139415: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
139452: , l2.JOURNAL_LINE_TYPE source_2
139453: , l2.ENTERED_AMOUNT source_3
139454: , l2.LINE_ID source_5
139455: , l2.ACCOUNTED_AMOUNT source_11
139456: FROM xla_events_gt xet
139457: , GMF_XLA_EXTRACT_LINES l2
139458: WHERE xet.event_id between x_first_event_id and x_last_event_id
139459: and xet.event_date between p_pad_start_date and p_pad_end_date
139460: and xet.event_type_code = C_EVENT_TYPE_CODE
140267: ,555)
140268:
140269: ELSE null
140270: END source_meaning
140271: FROM xla_events_gt xet
140272: , GMF_XLA_EXTRACT_HEADERS h1
140273: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
140274: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
140275: AND xet.event_type_code = C_EVENT_TYPE_CODE
140384:
140385: ELSE null
140386: END source_value
140387: , null source_meaning
140388: FROM xla_events_gt xet
140389: , GMF_XLA_EXTRACT_LINES l2
140390: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
140391: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
140392: AND xet.event_type_code = C_EVENT_TYPE_CODE
140585: , h1.CURRENCY_CONVERSION_DATE source_8
140586: , h1.CURRENCY_CONVERSION_RATE source_9
140587: , h1.CURRENCY_CONVERSION_TYPE source_10
140588: , h1.TRANSACTION_DATE source_12
140589: FROM xla_events_gt xet
140590: , GMF_XLA_EXTRACT_HEADERS h1
140591: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
140592: and xet.event_type_code = C_EVENT_TYPE_CODE
140593: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
140630: , l2.JOURNAL_LINE_TYPE source_2
140631: , l2.ENTERED_AMOUNT source_3
140632: , l2.LINE_ID source_5
140633: , l2.ACCOUNTED_AMOUNT source_11
140634: FROM xla_events_gt xet
140635: , GMF_XLA_EXTRACT_LINES l2
140636: WHERE xet.event_id between x_first_event_id and x_last_event_id
140637: and xet.event_date between p_pad_start_date and p_pad_end_date
140638: and xet.event_type_code = C_EVENT_TYPE_CODE
141557: ,555)
141558:
141559: ELSE null
141560: END source_meaning
141561: FROM xla_events_gt xet
141562: , GMF_XLA_EXTRACT_HEADERS h1
141563: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
141564: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
141565: AND xet.event_type_code = C_EVENT_TYPE_CODE
141674:
141675: ELSE null
141676: END source_value
141677: , null source_meaning
141678: FROM xla_events_gt xet
141679: , GMF_XLA_EXTRACT_LINES l2
141680: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
141681: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
141682: AND xet.event_type_code = C_EVENT_TYPE_CODE
141875: , h1.CURRENCY_CONVERSION_DATE source_8
141876: , h1.CURRENCY_CONVERSION_RATE source_9
141877: , h1.CURRENCY_CONVERSION_TYPE source_10
141878: , h1.TRANSACTION_DATE source_12
141879: FROM xla_events_gt xet
141880: , GMF_XLA_EXTRACT_HEADERS h1
141881: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
141882: and xet.event_type_code = C_EVENT_TYPE_CODE
141883: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
141920: , l2.JOURNAL_LINE_TYPE source_2
141921: , l2.ENTERED_AMOUNT source_3
141922: , l2.LINE_ID source_5
141923: , l2.ACCOUNTED_AMOUNT source_11
141924: FROM xla_events_gt xet
141925: , GMF_XLA_EXTRACT_LINES l2
141926: WHERE xet.event_id between x_first_event_id and x_last_event_id
141927: and xet.event_date between p_pad_start_date and p_pad_end_date
141928: and xet.event_type_code = C_EVENT_TYPE_CODE
142819: ,555)
142820:
142821: ELSE null
142822: END source_meaning
142823: FROM xla_events_gt xet
142824: , GMF_XLA_EXTRACT_HEADERS h1
142825: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
142826: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
142827: AND xet.event_type_code = C_EVENT_TYPE_CODE
142936:
142937: ELSE null
142938: END source_value
142939: , null source_meaning
142940: FROM xla_events_gt xet
142941: , GMF_XLA_EXTRACT_LINES l2
142942: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
142943: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
142944: AND xet.event_type_code = C_EVENT_TYPE_CODE
143137: , h1.CURRENCY_CONVERSION_DATE source_8
143138: , h1.CURRENCY_CONVERSION_RATE source_9
143139: , h1.CURRENCY_CONVERSION_TYPE source_10
143140: , h1.TRANSACTION_DATE source_12
143141: FROM xla_events_gt xet
143142: , GMF_XLA_EXTRACT_HEADERS h1
143143: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
143144: and xet.event_type_code = C_EVENT_TYPE_CODE
143145: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
143182: , l2.JOURNAL_LINE_TYPE source_2
143183: , l2.ENTERED_AMOUNT source_3
143184: , l2.LINE_ID source_5
143185: , l2.ACCOUNTED_AMOUNT source_11
143186: FROM xla_events_gt xet
143187: , GMF_XLA_EXTRACT_LINES l2
143188: WHERE xet.event_id between x_first_event_id and x_last_event_id
143189: and xet.event_date between p_pad_start_date and p_pad_end_date
143190: and xet.event_type_code = C_EVENT_TYPE_CODE
144081: ,555)
144082:
144083: ELSE null
144084: END source_meaning
144085: FROM xla_events_gt xet
144086: , GMF_XLA_EXTRACT_HEADERS h1
144087: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
144088: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
144089: AND xet.event_type_code = C_EVENT_TYPE_CODE
144198:
144199: ELSE null
144200: END source_value
144201: , null source_meaning
144202: FROM xla_events_gt xet
144203: , GMF_XLA_EXTRACT_LINES l2
144204: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
144205: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
144206: AND xet.event_type_code = C_EVENT_TYPE_CODE
144399: , h1.CURRENCY_CONVERSION_DATE source_8
144400: , h1.CURRENCY_CONVERSION_RATE source_9
144401: , h1.CURRENCY_CONVERSION_TYPE source_10
144402: , h1.TRANSACTION_DATE source_12
144403: FROM xla_events_gt xet
144404: , GMF_XLA_EXTRACT_HEADERS h1
144405: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
144406: and xet.event_type_code = C_EVENT_TYPE_CODE
144407: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
144444: , l2.JOURNAL_LINE_TYPE source_2
144445: , l2.ENTERED_AMOUNT source_3
144446: , l2.LINE_ID source_5
144447: , l2.ACCOUNTED_AMOUNT source_11
144448: FROM xla_events_gt xet
144449: , GMF_XLA_EXTRACT_LINES l2
144450: WHERE xet.event_id between x_first_event_id and x_last_event_id
144451: and xet.event_date between p_pad_start_date and p_pad_end_date
144452: and xet.event_type_code = C_EVENT_TYPE_CODE
145343: ,555)
145344:
145345: ELSE null
145346: END source_meaning
145347: FROM xla_events_gt xet
145348: , GMF_XLA_EXTRACT_HEADERS h1
145349: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
145350: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
145351: AND xet.event_type_code = C_EVENT_TYPE_CODE
145460:
145461: ELSE null
145462: END source_value
145463: , null source_meaning
145464: FROM xla_events_gt xet
145465: , GMF_XLA_EXTRACT_LINES l2
145466: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
145467: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
145468: AND xet.event_type_code = C_EVENT_TYPE_CODE
145661: , h1.CURRENCY_CONVERSION_DATE source_8
145662: , h1.CURRENCY_CONVERSION_RATE source_9
145663: , h1.CURRENCY_CONVERSION_TYPE source_10
145664: , h1.TRANSACTION_DATE source_12
145665: FROM xla_events_gt xet
145666: , GMF_XLA_EXTRACT_HEADERS h1
145667: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
145668: and xet.event_type_code = C_EVENT_TYPE_CODE
145669: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
145706: , l2.JOURNAL_LINE_TYPE source_2
145707: , l2.ENTERED_AMOUNT source_3
145708: , l2.LINE_ID source_5
145709: , l2.ACCOUNTED_AMOUNT source_11
145710: FROM xla_events_gt xet
145711: , GMF_XLA_EXTRACT_LINES l2
145712: WHERE xet.event_id between x_first_event_id and x_last_event_id
145713: and xet.event_date between p_pad_start_date and p_pad_end_date
145714: and xet.event_type_code = C_EVENT_TYPE_CODE
146549: ,555)
146550:
146551: ELSE null
146552: END source_meaning
146553: FROM xla_events_gt xet
146554: , GMF_XLA_EXTRACT_HEADERS h1
146555: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
146556: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
146557: AND xet.event_type_code = C_EVENT_TYPE_CODE
146666:
146667: ELSE null
146668: END source_value
146669: , null source_meaning
146670: FROM xla_events_gt xet
146671: , GMF_XLA_EXTRACT_LINES l2
146672: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
146673: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
146674: AND xet.event_type_code = C_EVENT_TYPE_CODE
146867: , h1.CURRENCY_CONVERSION_DATE source_8
146868: , h1.CURRENCY_CONVERSION_RATE source_9
146869: , h1.CURRENCY_CONVERSION_TYPE source_10
146870: , h1.TRANSACTION_DATE source_12
146871: FROM xla_events_gt xet
146872: , GMF_XLA_EXTRACT_HEADERS h1
146873: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
146874: and xet.event_type_code = C_EVENT_TYPE_CODE
146875: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
146912: , l2.JOURNAL_LINE_TYPE source_2
146913: , l2.ENTERED_AMOUNT source_3
146914: , l2.LINE_ID source_5
146915: , l2.ACCOUNTED_AMOUNT source_11
146916: FROM xla_events_gt xet
146917: , GMF_XLA_EXTRACT_LINES l2
146918: WHERE xet.event_id between x_first_event_id and x_last_event_id
146919: and xet.event_date between p_pad_start_date and p_pad_end_date
146920: and xet.event_type_code = C_EVENT_TYPE_CODE
147755: ,555)
147756:
147757: ELSE null
147758: END source_meaning
147759: FROM xla_events_gt xet
147760: , GMF_XLA_EXTRACT_HEADERS h1
147761: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
147762: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
147763: AND xet.event_type_code = C_EVENT_TYPE_CODE
147872:
147873: ELSE null
147874: END source_value
147875: , null source_meaning
147876: FROM xla_events_gt xet
147877: , GMF_XLA_EXTRACT_LINES l2
147878: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
147879: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
147880: AND xet.event_type_code = C_EVENT_TYPE_CODE
148073: , h1.CURRENCY_CONVERSION_DATE source_8
148074: , h1.CURRENCY_CONVERSION_RATE source_9
148075: , h1.CURRENCY_CONVERSION_TYPE source_10
148076: , h1.TRANSACTION_DATE source_12
148077: FROM xla_events_gt xet
148078: , GMF_XLA_EXTRACT_HEADERS h1
148079: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
148080: and xet.event_type_code = C_EVENT_TYPE_CODE
148081: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
148118: , l2.JOURNAL_LINE_TYPE source_2
148119: , l2.ENTERED_AMOUNT source_3
148120: , l2.LINE_ID source_5
148121: , l2.ACCOUNTED_AMOUNT source_11
148122: FROM xla_events_gt xet
148123: , GMF_XLA_EXTRACT_LINES l2
148124: WHERE xet.event_id between x_first_event_id and x_last_event_id
148125: and xet.event_date between p_pad_start_date and p_pad_end_date
148126: and xet.event_type_code = C_EVENT_TYPE_CODE
149073: ,555)
149074:
149075: ELSE null
149076: END source_meaning
149077: FROM xla_events_gt xet
149078: , GMF_XLA_EXTRACT_HEADERS h1
149079: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
149080: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
149081: AND xet.event_type_code = C_EVENT_TYPE_CODE
149190:
149191: ELSE null
149192: END source_value
149193: , null source_meaning
149194: FROM xla_events_gt xet
149195: , GMF_XLA_EXTRACT_LINES l2
149196: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
149197: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
149198: AND xet.event_type_code = C_EVENT_TYPE_CODE
149391: , h1.CURRENCY_CONVERSION_DATE source_8
149392: , h1.CURRENCY_CONVERSION_RATE source_9
149393: , h1.CURRENCY_CONVERSION_TYPE source_10
149394: , h1.TRANSACTION_DATE source_12
149395: FROM xla_events_gt xet
149396: , GMF_XLA_EXTRACT_HEADERS h1
149397: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
149398: and xet.event_type_code = C_EVENT_TYPE_CODE
149399: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
149436: , l2.JOURNAL_LINE_TYPE source_2
149437: , l2.ENTERED_AMOUNT source_3
149438: , l2.LINE_ID source_5
149439: , l2.ACCOUNTED_AMOUNT source_11
149440: FROM xla_events_gt xet
149441: , GMF_XLA_EXTRACT_LINES l2
149442: WHERE xet.event_id between x_first_event_id and x_last_event_id
149443: and xet.event_date between p_pad_start_date and p_pad_end_date
149444: and xet.event_type_code = C_EVENT_TYPE_CODE
150335: ,555)
150336:
150337: ELSE null
150338: END source_meaning
150339: FROM xla_events_gt xet
150340: , GMF_XLA_EXTRACT_HEADERS h1
150341: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
150342: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
150343: AND xet.event_type_code = C_EVENT_TYPE_CODE
150452:
150453: ELSE null
150454: END source_value
150455: , null source_meaning
150456: FROM xla_events_gt xet
150457: , GMF_XLA_EXTRACT_LINES l2
150458: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
150459: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
150460: AND xet.event_type_code = C_EVENT_TYPE_CODE
150653: , h1.CURRENCY_CONVERSION_DATE source_8
150654: , h1.CURRENCY_CONVERSION_RATE source_9
150655: , h1.CURRENCY_CONVERSION_TYPE source_10
150656: , h1.TRANSACTION_DATE source_12
150657: FROM xla_events_gt xet
150658: , GMF_XLA_EXTRACT_HEADERS h1
150659: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
150660: and xet.event_type_code = C_EVENT_TYPE_CODE
150661: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
150698: , l2.JOURNAL_LINE_TYPE source_2
150699: , l2.ENTERED_AMOUNT source_3
150700: , l2.LINE_ID source_5
150701: , l2.ACCOUNTED_AMOUNT source_11
150702: FROM xla_events_gt xet
150703: , GMF_XLA_EXTRACT_LINES l2
150704: WHERE xet.event_id between x_first_event_id and x_last_event_id
150705: and xet.event_date between p_pad_start_date and p_pad_end_date
150706: and xet.event_type_code = C_EVENT_TYPE_CODE
151597: ,555)
151598:
151599: ELSE null
151600: END source_meaning
151601: FROM xla_events_gt xet
151602: , GMF_XLA_EXTRACT_HEADERS h1
151603: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
151604: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
151605: AND xet.event_type_code = C_EVENT_TYPE_CODE
151714:
151715: ELSE null
151716: END source_value
151717: , null source_meaning
151718: FROM xla_events_gt xet
151719: , GMF_XLA_EXTRACT_LINES l2
151720: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
151721: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
151722: AND xet.event_type_code = C_EVENT_TYPE_CODE
151915: , h1.CURRENCY_CONVERSION_DATE source_8
151916: , h1.CURRENCY_CONVERSION_RATE source_9
151917: , h1.CURRENCY_CONVERSION_TYPE source_10
151918: , h1.TRANSACTION_DATE source_12
151919: FROM xla_events_gt xet
151920: , GMF_XLA_EXTRACT_HEADERS h1
151921: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
151922: and xet.event_type_code = C_EVENT_TYPE_CODE
151923: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
151960: , l2.JOURNAL_LINE_TYPE source_2
151961: , l2.ENTERED_AMOUNT source_3
151962: , l2.LINE_ID source_5
151963: , l2.ACCOUNTED_AMOUNT source_11
151964: FROM xla_events_gt xet
151965: , GMF_XLA_EXTRACT_LINES l2
151966: WHERE xet.event_id between x_first_event_id and x_last_event_id
151967: and xet.event_date between p_pad_start_date and p_pad_end_date
151968: and xet.event_type_code = C_EVENT_TYPE_CODE
152859: ,555)
152860:
152861: ELSE null
152862: END source_meaning
152863: FROM xla_events_gt xet
152864: , GMF_XLA_EXTRACT_HEADERS h1
152865: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
152866: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
152867: AND xet.event_type_code = C_EVENT_TYPE_CODE
152976:
152977: ELSE null
152978: END source_value
152979: , null source_meaning
152980: FROM xla_events_gt xet
152981: , GMF_XLA_EXTRACT_LINES l2
152982: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
152983: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
152984: AND xet.event_type_code = C_EVENT_TYPE_CODE
153177: , h1.CURRENCY_CONVERSION_DATE source_8
153178: , h1.CURRENCY_CONVERSION_RATE source_9
153179: , h1.CURRENCY_CONVERSION_TYPE source_10
153180: , h1.TRANSACTION_DATE source_12
153181: FROM xla_events_gt xet
153182: , GMF_XLA_EXTRACT_HEADERS h1
153183: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
153184: and xet.event_type_code = C_EVENT_TYPE_CODE
153185: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
153222: , l2.JOURNAL_LINE_TYPE source_2
153223: , l2.ENTERED_AMOUNT source_3
153224: , l2.LINE_ID source_5
153225: , l2.ACCOUNTED_AMOUNT source_11
153226: FROM xla_events_gt xet
153227: , GMF_XLA_EXTRACT_LINES l2
153228: WHERE xet.event_id between x_first_event_id and x_last_event_id
153229: and xet.event_date between p_pad_start_date and p_pad_end_date
153230: and xet.event_type_code = C_EVENT_TYPE_CODE
154037: ,555)
154038:
154039: ELSE null
154040: END source_meaning
154041: FROM xla_events_gt xet
154042: , GMF_XLA_EXTRACT_HEADERS h1
154043: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
154044: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
154045: AND xet.event_type_code = C_EVENT_TYPE_CODE
154154:
154155: ELSE null
154156: END source_value
154157: , null source_meaning
154158: FROM xla_events_gt xet
154159: , GMF_XLA_EXTRACT_LINES l2
154160: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
154161: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
154162: AND xet.event_type_code = C_EVENT_TYPE_CODE
154355: , h1.CURRENCY_CONVERSION_DATE source_8
154356: , h1.CURRENCY_CONVERSION_RATE source_9
154357: , h1.CURRENCY_CONVERSION_TYPE source_10
154358: , h1.TRANSACTION_DATE source_12
154359: FROM xla_events_gt xet
154360: , GMF_XLA_EXTRACT_HEADERS h1
154361: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
154362: and xet.event_type_code = C_EVENT_TYPE_CODE
154363: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
154400: , l2.JOURNAL_LINE_TYPE source_2
154401: , l2.ENTERED_AMOUNT source_3
154402: , l2.LINE_ID source_5
154403: , l2.ACCOUNTED_AMOUNT source_11
154404: FROM xla_events_gt xet
154405: , GMF_XLA_EXTRACT_LINES l2
154406: WHERE xet.event_id between x_first_event_id and x_last_event_id
154407: and xet.event_date between p_pad_start_date and p_pad_end_date
154408: and xet.event_type_code = C_EVENT_TYPE_CODE
155243: ,555)
155244:
155245: ELSE null
155246: END source_meaning
155247: FROM xla_events_gt xet
155248: , GMF_XLA_EXTRACT_HEADERS h1
155249: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
155250: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
155251: AND xet.event_type_code = C_EVENT_TYPE_CODE
155360:
155361: ELSE null
155362: END source_value
155363: , null source_meaning
155364: FROM xla_events_gt xet
155365: , GMF_XLA_EXTRACT_LINES l2
155366: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
155367: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
155368: AND xet.event_type_code = C_EVENT_TYPE_CODE
155561: , h1.CURRENCY_CONVERSION_DATE source_8
155562: , h1.CURRENCY_CONVERSION_RATE source_9
155563: , h1.CURRENCY_CONVERSION_TYPE source_10
155564: , h1.TRANSACTION_DATE source_12
155565: FROM xla_events_gt xet
155566: , GMF_XLA_EXTRACT_HEADERS h1
155567: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
155568: and xet.event_type_code = C_EVENT_TYPE_CODE
155569: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
155606: , l2.JOURNAL_LINE_TYPE source_2
155607: , l2.ENTERED_AMOUNT source_3
155608: , l2.LINE_ID source_5
155609: , l2.ACCOUNTED_AMOUNT source_11
155610: FROM xla_events_gt xet
155611: , GMF_XLA_EXTRACT_LINES l2
155612: WHERE xet.event_id between x_first_event_id and x_last_event_id
155613: and xet.event_date between p_pad_start_date and p_pad_end_date
155614: and xet.event_type_code = C_EVENT_TYPE_CODE
156477: ,555)
156478:
156479: ELSE null
156480: END source_meaning
156481: FROM xla_events_gt xet
156482: , GMF_XLA_EXTRACT_HEADERS h1
156483: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
156484: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
156485: AND xet.event_type_code = C_EVENT_TYPE_CODE
156594:
156595: ELSE null
156596: END source_value
156597: , null source_meaning
156598: FROM xla_events_gt xet
156599: , GMF_XLA_EXTRACT_LINES l2
156600: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
156601: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
156602: AND xet.event_type_code = C_EVENT_TYPE_CODE
156795: , h1.CURRENCY_CONVERSION_DATE source_8
156796: , h1.CURRENCY_CONVERSION_RATE source_9
156797: , h1.CURRENCY_CONVERSION_TYPE source_10
156798: , h1.TRANSACTION_DATE source_12
156799: FROM xla_events_gt xet
156800: , GMF_XLA_EXTRACT_HEADERS h1
156801: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
156802: and xet.event_type_code = C_EVENT_TYPE_CODE
156803: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
156840: , l2.JOURNAL_LINE_TYPE source_2
156841: , l2.ENTERED_AMOUNT source_3
156842: , l2.LINE_ID source_5
156843: , l2.ACCOUNTED_AMOUNT source_11
156844: FROM xla_events_gt xet
156845: , GMF_XLA_EXTRACT_LINES l2
156846: WHERE xet.event_id between x_first_event_id and x_last_event_id
156847: and xet.event_date between p_pad_start_date and p_pad_end_date
156848: and xet.event_type_code = C_EVENT_TYPE_CODE
157767: ,555)
157768:
157769: ELSE null
157770: END source_meaning
157771: FROM xla_events_gt xet
157772: , GMF_XLA_EXTRACT_HEADERS h1
157773: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
157774: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
157775: AND xet.event_type_code = C_EVENT_TYPE_CODE
157884:
157885: ELSE null
157886: END source_value
157887: , null source_meaning
157888: FROM xla_events_gt xet
157889: , GMF_XLA_EXTRACT_LINES l2
157890: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
157891: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
157892: AND xet.event_type_code = C_EVENT_TYPE_CODE
158085: , h1.CURRENCY_CONVERSION_DATE source_8
158086: , h1.CURRENCY_CONVERSION_RATE source_9
158087: , h1.CURRENCY_CONVERSION_TYPE source_10
158088: , h1.TRANSACTION_DATE source_12
158089: FROM xla_events_gt xet
158090: , GMF_XLA_EXTRACT_HEADERS h1
158091: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
158092: and xet.event_type_code = C_EVENT_TYPE_CODE
158093: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
158130: , l2.JOURNAL_LINE_TYPE source_2
158131: , l2.ENTERED_AMOUNT source_3
158132: , l2.LINE_ID source_5
158133: , l2.ACCOUNTED_AMOUNT source_11
158134: FROM xla_events_gt xet
158135: , GMF_XLA_EXTRACT_LINES l2
158136: WHERE xet.event_id between x_first_event_id and x_last_event_id
158137: and xet.event_date between p_pad_start_date and p_pad_end_date
158138: and xet.event_type_code = C_EVENT_TYPE_CODE
158945: ,555)
158946:
158947: ELSE null
158948: END source_meaning
158949: FROM xla_events_gt xet
158950: , GMF_XLA_EXTRACT_HEADERS h1
158951: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
158952: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
158953: AND xet.event_type_code = C_EVENT_TYPE_CODE
159062:
159063: ELSE null
159064: END source_value
159065: , null source_meaning
159066: FROM xla_events_gt xet
159067: , GMF_XLA_EXTRACT_LINES l2
159068: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
159069: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
159070: AND xet.event_type_code = C_EVENT_TYPE_CODE
159263: , h1.CURRENCY_CONVERSION_DATE source_8
159264: , h1.CURRENCY_CONVERSION_RATE source_9
159265: , h1.CURRENCY_CONVERSION_TYPE source_10
159266: , h1.TRANSACTION_DATE source_12
159267: FROM xla_events_gt xet
159268: , GMF_XLA_EXTRACT_HEADERS h1
159269: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
159270: and xet.event_type_code = C_EVENT_TYPE_CODE
159271: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
159308: , l2.JOURNAL_LINE_TYPE source_2
159309: , l2.ENTERED_AMOUNT source_3
159310: , l2.LINE_ID source_5
159311: , l2.ACCOUNTED_AMOUNT source_11
159312: FROM xla_events_gt xet
159313: , GMF_XLA_EXTRACT_LINES l2
159314: WHERE xet.event_id between x_first_event_id and x_last_event_id
159315: and xet.event_date between p_pad_start_date and p_pad_end_date
159316: and xet.event_type_code = C_EVENT_TYPE_CODE
160123: ,555)
160124:
160125: ELSE null
160126: END source_meaning
160127: FROM xla_events_gt xet
160128: , GMF_XLA_EXTRACT_HEADERS h1
160129: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
160130: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
160131: AND xet.event_type_code = C_EVENT_TYPE_CODE
160240:
160241: ELSE null
160242: END source_value
160243: , null source_meaning
160244: FROM xla_events_gt xet
160245: , GMF_XLA_EXTRACT_LINES l2
160246: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
160247: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
160248: AND xet.event_type_code = C_EVENT_TYPE_CODE
160441: , h1.CURRENCY_CONVERSION_DATE source_8
160442: , h1.CURRENCY_CONVERSION_RATE source_9
160443: , h1.CURRENCY_CONVERSION_TYPE source_10
160444: , h1.TRANSACTION_DATE source_12
160445: FROM xla_events_gt xet
160446: , GMF_XLA_EXTRACT_HEADERS h1
160447: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
160448: and xet.event_type_code = C_EVENT_TYPE_CODE
160449: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
160486: , l2.JOURNAL_LINE_TYPE source_2
160487: , l2.ENTERED_AMOUNT source_3
160488: , l2.LINE_ID source_5
160489: , l2.ACCOUNTED_AMOUNT source_11
160490: FROM xla_events_gt xet
160491: , GMF_XLA_EXTRACT_LINES l2
160492: WHERE xet.event_id between x_first_event_id and x_last_event_id
160493: and xet.event_date between p_pad_start_date and p_pad_end_date
160494: and xet.event_type_code = C_EVENT_TYPE_CODE
161329: ,555)
161330:
161331: ELSE null
161332: END source_meaning
161333: FROM xla_events_gt xet
161334: , GMF_XLA_EXTRACT_HEADERS h1
161335: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
161336: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
161337: AND xet.event_type_code = C_EVENT_TYPE_CODE
161446:
161447: ELSE null
161448: END source_value
161449: , null source_meaning
161450: FROM xla_events_gt xet
161451: , GMF_XLA_EXTRACT_LINES l2
161452: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
161453: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
161454: AND xet.event_type_code = C_EVENT_TYPE_CODE
161647: , h1.CURRENCY_CONVERSION_DATE source_8
161648: , h1.CURRENCY_CONVERSION_RATE source_9
161649: , h1.CURRENCY_CONVERSION_TYPE source_10
161650: , h1.TRANSACTION_DATE source_12
161651: FROM xla_events_gt xet
161652: , GMF_XLA_EXTRACT_HEADERS h1
161653: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
161654: and xet.event_type_code = C_EVENT_TYPE_CODE
161655: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
161692: , l2.JOURNAL_LINE_TYPE source_2
161693: , l2.ENTERED_AMOUNT source_3
161694: , l2.LINE_ID source_5
161695: , l2.ACCOUNTED_AMOUNT source_11
161696: FROM xla_events_gt xet
161697: , GMF_XLA_EXTRACT_LINES l2
161698: WHERE xet.event_id between x_first_event_id and x_last_event_id
161699: and xet.event_date between p_pad_start_date and p_pad_end_date
161700: and xet.event_type_code = C_EVENT_TYPE_CODE
162535: ,555)
162536:
162537: ELSE null
162538: END source_meaning
162539: FROM xla_events_gt xet
162540: , GMF_XLA_EXTRACT_HEADERS h1
162541: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
162542: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
162543: AND xet.event_type_code = C_EVENT_TYPE_CODE
162652:
162653: ELSE null
162654: END source_value
162655: , null source_meaning
162656: FROM xla_events_gt xet
162657: , GMF_XLA_EXTRACT_LINES l2
162658: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
162659: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
162660: AND xet.event_type_code = C_EVENT_TYPE_CODE
162853: , h1.CURRENCY_CONVERSION_DATE source_8
162854: , h1.CURRENCY_CONVERSION_RATE source_9
162855: , h1.CURRENCY_CONVERSION_TYPE source_10
162856: , h1.TRANSACTION_DATE source_12
162857: FROM xla_events_gt xet
162858: , GMF_XLA_EXTRACT_HEADERS h1
162859: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
162860: and xet.event_type_code = C_EVENT_TYPE_CODE
162861: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
162898: , l2.JOURNAL_LINE_TYPE source_2
162899: , l2.ENTERED_AMOUNT source_3
162900: , l2.LINE_ID source_5
162901: , l2.ACCOUNTED_AMOUNT source_11
162902: FROM xla_events_gt xet
162903: , GMF_XLA_EXTRACT_LINES l2
162904: WHERE xet.event_id between x_first_event_id and x_last_event_id
162905: and xet.event_date between p_pad_start_date and p_pad_end_date
162906: and xet.event_type_code = C_EVENT_TYPE_CODE
163741: ,555)
163742:
163743: ELSE null
163744: END source_meaning
163745: FROM xla_events_gt xet
163746: , GMF_XLA_EXTRACT_HEADERS h1
163747: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
163748: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
163749: AND xet.event_type_code = C_EVENT_TYPE_CODE
163858:
163859: ELSE null
163860: END source_value
163861: , null source_meaning
163862: FROM xla_events_gt xet
163863: , GMF_XLA_EXTRACT_LINES l2
163864: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
163865: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
163866: AND xet.event_type_code = C_EVENT_TYPE_CODE
164059: , h1.CURRENCY_CONVERSION_DATE source_8
164060: , h1.CURRENCY_CONVERSION_RATE source_9
164061: , h1.CURRENCY_CONVERSION_TYPE source_10
164062: , h1.TRANSACTION_DATE source_12
164063: FROM xla_events_gt xet
164064: , GMF_XLA_EXTRACT_HEADERS h1
164065: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
164066: and xet.event_type_code = C_EVENT_TYPE_CODE
164067: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
164104: , l2.JOURNAL_LINE_TYPE source_2
164105: , l2.ENTERED_AMOUNT source_3
164106: , l2.LINE_ID source_5
164107: , l2.ACCOUNTED_AMOUNT source_11
164108: FROM xla_events_gt xet
164109: , GMF_XLA_EXTRACT_LINES l2
164110: WHERE xet.event_id between x_first_event_id and x_last_event_id
164111: and xet.event_date between p_pad_start_date and p_pad_end_date
164112: and xet.event_type_code = C_EVENT_TYPE_CODE
164947: ,555)
164948:
164949: ELSE null
164950: END source_meaning
164951: FROM xla_events_gt xet
164952: , GMF_XLA_EXTRACT_HEADERS h1
164953: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
164954: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
164955: AND xet.event_type_code = C_EVENT_TYPE_CODE
165064:
165065: ELSE null
165066: END source_value
165067: , null source_meaning
165068: FROM xla_events_gt xet
165069: , GMF_XLA_EXTRACT_LINES l2
165070: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
165071: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
165072: AND xet.event_type_code = C_EVENT_TYPE_CODE
165265: , h1.CURRENCY_CONVERSION_DATE source_8
165266: , h1.CURRENCY_CONVERSION_RATE source_9
165267: , h1.CURRENCY_CONVERSION_TYPE source_10
165268: , h1.TRANSACTION_DATE source_12
165269: FROM xla_events_gt xet
165270: , GMF_XLA_EXTRACT_HEADERS h1
165271: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
165272: and xet.event_type_code = C_EVENT_TYPE_CODE
165273: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
165310: , l2.JOURNAL_LINE_TYPE source_2
165311: , l2.ENTERED_AMOUNT source_3
165312: , l2.LINE_ID source_5
165313: , l2.ACCOUNTED_AMOUNT source_11
165314: FROM xla_events_gt xet
165315: , GMF_XLA_EXTRACT_LINES l2
165316: WHERE xet.event_id between x_first_event_id and x_last_event_id
165317: and xet.event_date between p_pad_start_date and p_pad_end_date
165318: and xet.event_type_code = C_EVENT_TYPE_CODE
166153: ,555)
166154:
166155: ELSE null
166156: END source_meaning
166157: FROM xla_events_gt xet
166158: , GMF_XLA_EXTRACT_HEADERS h1
166159: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
166160: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
166161: AND xet.event_type_code = C_EVENT_TYPE_CODE
166270:
166271: ELSE null
166272: END source_value
166273: , null source_meaning
166274: FROM xla_events_gt xet
166275: , GMF_XLA_EXTRACT_LINES l2
166276: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
166277: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
166278: AND xet.event_type_code = C_EVENT_TYPE_CODE
166471: , h1.CURRENCY_CONVERSION_DATE source_8
166472: , h1.CURRENCY_CONVERSION_RATE source_9
166473: , h1.CURRENCY_CONVERSION_TYPE source_10
166474: , h1.TRANSACTION_DATE source_12
166475: FROM xla_events_gt xet
166476: , GMF_XLA_EXTRACT_HEADERS h1
166477: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
166478: and xet.event_type_code = C_EVENT_TYPE_CODE
166479: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
166516: , l2.JOURNAL_LINE_TYPE source_2
166517: , l2.ENTERED_AMOUNT source_3
166518: , l2.LINE_ID source_5
166519: , l2.ACCOUNTED_AMOUNT source_11
166520: FROM xla_events_gt xet
166521: , GMF_XLA_EXTRACT_LINES l2
166522: WHERE xet.event_id between x_first_event_id and x_last_event_id
166523: and xet.event_date between p_pad_start_date and p_pad_end_date
166524: and xet.event_type_code = C_EVENT_TYPE_CODE
167359: ,555)
167360:
167361: ELSE null
167362: END source_meaning
167363: FROM xla_events_gt xet
167364: , GMF_XLA_EXTRACT_HEADERS h1
167365: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
167366: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
167367: AND xet.event_type_code = C_EVENT_TYPE_CODE
167476:
167477: ELSE null
167478: END source_value
167479: , null source_meaning
167480: FROM xla_events_gt xet
167481: , GMF_XLA_EXTRACT_LINES l2
167482: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
167483: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
167484: AND xet.event_type_code = C_EVENT_TYPE_CODE
167677: , h1.CURRENCY_CONVERSION_DATE source_8
167678: , h1.CURRENCY_CONVERSION_RATE source_9
167679: , h1.CURRENCY_CONVERSION_TYPE source_10
167680: , h1.TRANSACTION_DATE source_12
167681: FROM xla_events_gt xet
167682: , GMF_XLA_EXTRACT_HEADERS h1
167683: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
167684: and xet.event_type_code = C_EVENT_TYPE_CODE
167685: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
167722: , l2.JOURNAL_LINE_TYPE source_2
167723: , l2.ENTERED_AMOUNT source_3
167724: , l2.LINE_ID source_5
167725: , l2.ACCOUNTED_AMOUNT source_11
167726: FROM xla_events_gt xet
167727: , GMF_XLA_EXTRACT_LINES l2
167728: WHERE xet.event_id between x_first_event_id and x_last_event_id
167729: and xet.event_date between p_pad_start_date and p_pad_end_date
167730: and xet.event_type_code = C_EVENT_TYPE_CODE
168565: ,555)
168566:
168567: ELSE null
168568: END source_meaning
168569: FROM xla_events_gt xet
168570: , GMF_XLA_EXTRACT_HEADERS h1
168571: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
168572: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
168573: AND xet.event_type_code = C_EVENT_TYPE_CODE
168682:
168683: ELSE null
168684: END source_value
168685: , null source_meaning
168686: FROM xla_events_gt xet
168687: , GMF_XLA_EXTRACT_LINES l2
168688: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
168689: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
168690: AND xet.event_type_code = C_EVENT_TYPE_CODE
168883: , h1.CURRENCY_CONVERSION_DATE source_8
168884: , h1.CURRENCY_CONVERSION_RATE source_9
168885: , h1.CURRENCY_CONVERSION_TYPE source_10
168886: , h1.TRANSACTION_DATE source_12
168887: FROM xla_events_gt xet
168888: , GMF_XLA_EXTRACT_HEADERS h1
168889: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
168890: and xet.event_type_code = C_EVENT_TYPE_CODE
168891: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
168928: , l2.JOURNAL_LINE_TYPE source_2
168929: , l2.ENTERED_AMOUNT source_3
168930: , l2.LINE_ID source_5
168931: , l2.ACCOUNTED_AMOUNT source_11
168932: FROM xla_events_gt xet
168933: , GMF_XLA_EXTRACT_LINES l2
168934: WHERE xet.event_id between x_first_event_id and x_last_event_id
168935: and xet.event_date between p_pad_start_date and p_pad_end_date
168936: and xet.event_type_code = C_EVENT_TYPE_CODE
169771: ,555)
169772:
169773: ELSE null
169774: END source_meaning
169775: FROM xla_events_gt xet
169776: , GMF_XLA_EXTRACT_HEADERS h1
169777: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
169778: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
169779: AND xet.event_type_code = C_EVENT_TYPE_CODE
169888:
169889: ELSE null
169890: END source_value
169891: , null source_meaning
169892: FROM xla_events_gt xet
169893: , GMF_XLA_EXTRACT_LINES l2
169894: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
169895: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
169896: AND xet.event_type_code = C_EVENT_TYPE_CODE
170089: , h1.CURRENCY_CONVERSION_DATE source_8
170090: , h1.CURRENCY_CONVERSION_RATE source_9
170091: , h1.CURRENCY_CONVERSION_TYPE source_10
170092: , h1.TRANSACTION_DATE source_12
170093: FROM xla_events_gt xet
170094: , GMF_XLA_EXTRACT_HEADERS h1
170095: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
170096: and xet.event_type_code = C_EVENT_TYPE_CODE
170097: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
170134: , l2.JOURNAL_LINE_TYPE source_2
170135: , l2.ENTERED_AMOUNT source_3
170136: , l2.LINE_ID source_5
170137: , l2.ACCOUNTED_AMOUNT source_11
170138: FROM xla_events_gt xet
170139: , GMF_XLA_EXTRACT_LINES l2
170140: WHERE xet.event_id between x_first_event_id and x_last_event_id
170141: and xet.event_date between p_pad_start_date and p_pad_end_date
170142: and xet.event_type_code = C_EVENT_TYPE_CODE
170949: ,555)
170950:
170951: ELSE null
170952: END source_meaning
170953: FROM xla_events_gt xet
170954: , GMF_XLA_EXTRACT_HEADERS h1
170955: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
170956: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
170957: AND xet.event_type_code = C_EVENT_TYPE_CODE
171066:
171067: ELSE null
171068: END source_value
171069: , null source_meaning
171070: FROM xla_events_gt xet
171071: , GMF_XLA_EXTRACT_LINES l2
171072: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
171073: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
171074: AND xet.event_type_code = C_EVENT_TYPE_CODE
171267: , h1.CURRENCY_CONVERSION_DATE source_8
171268: , h1.CURRENCY_CONVERSION_RATE source_9
171269: , h1.CURRENCY_CONVERSION_TYPE source_10
171270: , h1.TRANSACTION_DATE source_12
171271: FROM xla_events_gt xet
171272: , GMF_XLA_EXTRACT_HEADERS h1
171273: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
171274: and xet.event_type_code = C_EVENT_TYPE_CODE
171275: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
171312: , l2.JOURNAL_LINE_TYPE source_2
171313: , l2.ENTERED_AMOUNT source_3
171314: , l2.LINE_ID source_5
171315: , l2.ACCOUNTED_AMOUNT source_11
171316: FROM xla_events_gt xet
171317: , GMF_XLA_EXTRACT_LINES l2
171318: WHERE xet.event_id between x_first_event_id and x_last_event_id
171319: and xet.event_date between p_pad_start_date and p_pad_end_date
171320: and xet.event_type_code = C_EVENT_TYPE_CODE
172155: ,555)
172156:
172157: ELSE null
172158: END source_meaning
172159: FROM xla_events_gt xet
172160: , GMF_XLA_EXTRACT_HEADERS h1
172161: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
172162: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
172163: AND xet.event_type_code = C_EVENT_TYPE_CODE
172272:
172273: ELSE null
172274: END source_value
172275: , null source_meaning
172276: FROM xla_events_gt xet
172277: , GMF_XLA_EXTRACT_LINES l2
172278: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
172279: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
172280: AND xet.event_type_code = C_EVENT_TYPE_CODE
172473: , h1.CURRENCY_CONVERSION_DATE source_8
172474: , h1.CURRENCY_CONVERSION_RATE source_9
172475: , h1.CURRENCY_CONVERSION_TYPE source_10
172476: , h1.TRANSACTION_DATE source_12
172477: FROM xla_events_gt xet
172478: , GMF_XLA_EXTRACT_HEADERS h1
172479: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
172480: and xet.event_type_code = C_EVENT_TYPE_CODE
172481: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
172518: , l2.JOURNAL_LINE_TYPE source_2
172519: , l2.ENTERED_AMOUNT source_3
172520: , l2.LINE_ID source_5
172521: , l2.ACCOUNTED_AMOUNT source_11
172522: FROM xla_events_gt xet
172523: , GMF_XLA_EXTRACT_LINES l2
172524: WHERE xet.event_id between x_first_event_id and x_last_event_id
172525: and xet.event_date between p_pad_start_date and p_pad_end_date
172526: and xet.event_type_code = C_EVENT_TYPE_CODE
173328: ,555)
173329:
173330: ELSE null
173331: END source_meaning
173332: FROM xla_events_gt xet
173333: , GMF_XLA_EXTRACT_HEADERS h1
173334: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
173335: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
173336: AND xet.event_class_code = C_EVENT_CLASS_CODE
173446:
173447: ELSE null
173448: END source_value
173449: , null source_meaning
173450: FROM xla_events_gt xet
173451: , GMF_XLA_EXTRACT_LINES l2
173452: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
173453: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
173454: AND xet.event_class_code = C_EVENT_CLASS_CODE
173643: , h1.CURRENCY_CODE source_7
173644: , h1.CURRENCY_CONVERSION_DATE source_8
173645: , h1.CURRENCY_CONVERSION_RATE source_9
173646: , h1.TRANSACTION_DATE source_12
173647: FROM xla_events_gt xet
173648: , GMF_XLA_EXTRACT_HEADERS h1
173649: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
173650: and xet.event_class_code = C_EVENT_CLASS_CODE
173651: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
173688: , l2.JOURNAL_LINE_TYPE source_2
173689: , l2.ENTERED_AMOUNT source_3
173690: , l2.LINE_ID source_5
173691: , l2.ACCOUNTED_AMOUNT source_11
173692: FROM xla_events_gt xet
173693: , GMF_XLA_EXTRACT_LINES l2
173694: WHERE xet.event_id between x_first_event_id and x_last_event_id
173695: and xet.event_date between p_pad_start_date and p_pad_end_date
173696: and xet.event_class_code = C_EVENT_CLASS_CODE
174499: ,555)
174500:
174501: ELSE null
174502: END source_meaning
174503: FROM xla_events_gt xet
174504: , GMF_XLA_EXTRACT_HEADERS h1
174505: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
174506: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
174507: AND xet.event_type_code = C_EVENT_TYPE_CODE
174616:
174617: ELSE null
174618: END source_value
174619: , null source_meaning
174620: FROM xla_events_gt xet
174621: , GMF_XLA_EXTRACT_LINES l2
174622: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
174623: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
174624: AND xet.event_type_code = C_EVENT_TYPE_CODE
174817: , h1.CURRENCY_CONVERSION_DATE source_8
174818: , h1.CURRENCY_CONVERSION_RATE source_9
174819: , h1.CURRENCY_CONVERSION_TYPE source_10
174820: , h1.TRANSACTION_DATE source_12
174821: FROM xla_events_gt xet
174822: , GMF_XLA_EXTRACT_HEADERS h1
174823: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
174824: and xet.event_type_code = C_EVENT_TYPE_CODE
174825: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
174862: , l2.JOURNAL_LINE_TYPE source_2
174863: , l2.ENTERED_AMOUNT source_3
174864: , l2.LINE_ID source_5
174865: , l2.ACCOUNTED_AMOUNT source_11
174866: FROM xla_events_gt xet
174867: , GMF_XLA_EXTRACT_LINES l2
174868: WHERE xet.event_id between x_first_event_id and x_last_event_id
174869: and xet.event_date between p_pad_start_date and p_pad_end_date
174870: and xet.event_type_code = C_EVENT_TYPE_CODE
175789: ,555)
175790:
175791: ELSE null
175792: END source_meaning
175793: FROM xla_events_gt xet
175794: , GMF_XLA_EXTRACT_HEADERS h1
175795: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
175796: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
175797: AND xet.event_type_code = C_EVENT_TYPE_CODE
175906:
175907: ELSE null
175908: END source_value
175909: , null source_meaning
175910: FROM xla_events_gt xet
175911: , GMF_XLA_EXTRACT_LINES l2
175912: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
175913: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
175914: AND xet.event_type_code = C_EVENT_TYPE_CODE
176107: , h1.CURRENCY_CONVERSION_DATE source_8
176108: , h1.CURRENCY_CONVERSION_RATE source_9
176109: , h1.CURRENCY_CONVERSION_TYPE source_10
176110: , h1.TRANSACTION_DATE source_12
176111: FROM xla_events_gt xet
176112: , GMF_XLA_EXTRACT_HEADERS h1
176113: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
176114: and xet.event_type_code = C_EVENT_TYPE_CODE
176115: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
176152: , l2.JOURNAL_LINE_TYPE source_2
176153: , l2.ENTERED_AMOUNT source_3
176154: , l2.LINE_ID source_5
176155: , l2.ACCOUNTED_AMOUNT source_11
176156: FROM xla_events_gt xet
176157: , GMF_XLA_EXTRACT_LINES l2
176158: WHERE xet.event_id between x_first_event_id and x_last_event_id
176159: and xet.event_date between p_pad_start_date and p_pad_end_date
176160: and xet.event_type_code = C_EVENT_TYPE_CODE
177079: ,555)
177080:
177081: ELSE null
177082: END source_meaning
177083: FROM xla_events_gt xet
177084: , GMF_XLA_EXTRACT_HEADERS h1
177085: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
177086: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
177087: AND xet.event_type_code = C_EVENT_TYPE_CODE
177196:
177197: ELSE null
177198: END source_value
177199: , null source_meaning
177200: FROM xla_events_gt xet
177201: , GMF_XLA_EXTRACT_LINES l2
177202: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
177203: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
177204: AND xet.event_type_code = C_EVENT_TYPE_CODE
177397: , h1.CURRENCY_CONVERSION_DATE source_8
177398: , h1.CURRENCY_CONVERSION_RATE source_9
177399: , h1.CURRENCY_CONVERSION_TYPE source_10
177400: , h1.TRANSACTION_DATE source_12
177401: FROM xla_events_gt xet
177402: , GMF_XLA_EXTRACT_HEADERS h1
177403: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
177404: and xet.event_type_code = C_EVENT_TYPE_CODE
177405: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
177442: , l2.JOURNAL_LINE_TYPE source_2
177443: , l2.ENTERED_AMOUNT source_3
177444: , l2.LINE_ID source_5
177445: , l2.ACCOUNTED_AMOUNT source_11
177446: FROM xla_events_gt xet
177447: , GMF_XLA_EXTRACT_LINES l2
177448: WHERE xet.event_id between x_first_event_id and x_last_event_id
177449: and xet.event_date between p_pad_start_date and p_pad_end_date
177450: and xet.event_type_code = C_EVENT_TYPE_CODE
178285: ,555)
178286:
178287: ELSE null
178288: END source_meaning
178289: FROM xla_events_gt xet
178290: , GMF_XLA_EXTRACT_HEADERS h1
178291: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
178292: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
178293: AND xet.event_type_code = C_EVENT_TYPE_CODE
178402:
178403: ELSE null
178404: END source_value
178405: , null source_meaning
178406: FROM xla_events_gt xet
178407: , GMF_XLA_EXTRACT_LINES l2
178408: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
178409: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
178410: AND xet.event_type_code = C_EVENT_TYPE_CODE
178603: , h1.CURRENCY_CONVERSION_DATE source_8
178604: , h1.CURRENCY_CONVERSION_RATE source_9
178605: , h1.CURRENCY_CONVERSION_TYPE source_10
178606: , h1.TRANSACTION_DATE source_12
178607: FROM xla_events_gt xet
178608: , GMF_XLA_EXTRACT_HEADERS h1
178609: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
178610: and xet.event_type_code = C_EVENT_TYPE_CODE
178611: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
178648: , l2.JOURNAL_LINE_TYPE source_2
178649: , l2.ENTERED_AMOUNT source_3
178650: , l2.LINE_ID source_5
178651: , l2.ACCOUNTED_AMOUNT source_11
178652: FROM xla_events_gt xet
178653: , GMF_XLA_EXTRACT_LINES l2
178654: WHERE xet.event_id between x_first_event_id and x_last_event_id
178655: and xet.event_date between p_pad_start_date and p_pad_end_date
178656: and xet.event_type_code = C_EVENT_TYPE_CODE
179463: ,555)
179464:
179465: ELSE null
179466: END source_meaning
179467: FROM xla_events_gt xet
179468: , GMF_XLA_EXTRACT_HEADERS h1
179469: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
179470: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
179471: AND xet.event_type_code = C_EVENT_TYPE_CODE
179580:
179581: ELSE null
179582: END source_value
179583: , null source_meaning
179584: FROM xla_events_gt xet
179585: , GMF_XLA_EXTRACT_LINES l2
179586: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
179587: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
179588: AND xet.event_type_code = C_EVENT_TYPE_CODE
179781: , h1.CURRENCY_CONVERSION_DATE source_8
179782: , h1.CURRENCY_CONVERSION_RATE source_9
179783: , h1.CURRENCY_CONVERSION_TYPE source_10
179784: , h1.TRANSACTION_DATE source_12
179785: FROM xla_events_gt xet
179786: , GMF_XLA_EXTRACT_HEADERS h1
179787: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
179788: and xet.event_type_code = C_EVENT_TYPE_CODE
179789: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
179826: , l2.JOURNAL_LINE_TYPE source_2
179827: , l2.ENTERED_AMOUNT source_3
179828: , l2.LINE_ID source_5
179829: , l2.ACCOUNTED_AMOUNT source_11
179830: FROM xla_events_gt xet
179831: , GMF_XLA_EXTRACT_LINES l2
179832: WHERE xet.event_id between x_first_event_id and x_last_event_id
179833: and xet.event_date between p_pad_start_date and p_pad_end_date
179834: and xet.event_type_code = C_EVENT_TYPE_CODE
180641: ,555)
180642:
180643: ELSE null
180644: END source_meaning
180645: FROM xla_events_gt xet
180646: , GMF_XLA_EXTRACT_HEADERS h1
180647: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
180648: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
180649: AND xet.event_type_code = C_EVENT_TYPE_CODE
180758:
180759: ELSE null
180760: END source_value
180761: , null source_meaning
180762: FROM xla_events_gt xet
180763: , GMF_XLA_EXTRACT_LINES l2
180764: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
180765: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
180766: AND xet.event_type_code = C_EVENT_TYPE_CODE
180959: , h1.CURRENCY_CONVERSION_DATE source_8
180960: , h1.CURRENCY_CONVERSION_RATE source_9
180961: , h1.CURRENCY_CONVERSION_TYPE source_10
180962: , h1.TRANSACTION_DATE source_12
180963: FROM xla_events_gt xet
180964: , GMF_XLA_EXTRACT_HEADERS h1
180965: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
180966: and xet.event_type_code = C_EVENT_TYPE_CODE
180967: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
181004: , l2.JOURNAL_LINE_TYPE source_2
181005: , l2.ENTERED_AMOUNT source_3
181006: , l2.LINE_ID source_5
181007: , l2.ACCOUNTED_AMOUNT source_11
181008: FROM xla_events_gt xet
181009: , GMF_XLA_EXTRACT_LINES l2
181010: WHERE xet.event_id between x_first_event_id and x_last_event_id
181011: and xet.event_date between p_pad_start_date and p_pad_end_date
181012: and xet.event_type_code = C_EVENT_TYPE_CODE
181931: ,555)
181932:
181933: ELSE null
181934: END source_meaning
181935: FROM xla_events_gt xet
181936: , GMF_XLA_EXTRACT_HEADERS h1
181937: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
181938: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
181939: AND xet.event_type_code = C_EVENT_TYPE_CODE
182048:
182049: ELSE null
182050: END source_value
182051: , null source_meaning
182052: FROM xla_events_gt xet
182053: , GMF_XLA_EXTRACT_LINES l2
182054: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
182055: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
182056: AND xet.event_type_code = C_EVENT_TYPE_CODE
182249: , h1.CURRENCY_CONVERSION_DATE source_8
182250: , h1.CURRENCY_CONVERSION_RATE source_9
182251: , h1.CURRENCY_CONVERSION_TYPE source_10
182252: , h1.TRANSACTION_DATE source_12
182253: FROM xla_events_gt xet
182254: , GMF_XLA_EXTRACT_HEADERS h1
182255: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
182256: and xet.event_type_code = C_EVENT_TYPE_CODE
182257: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
182294: , l2.JOURNAL_LINE_TYPE source_2
182295: , l2.ENTERED_AMOUNT source_3
182296: , l2.LINE_ID source_5
182297: , l2.ACCOUNTED_AMOUNT source_11
182298: FROM xla_events_gt xet
182299: , GMF_XLA_EXTRACT_LINES l2
182300: WHERE xet.event_id between x_first_event_id and x_last_event_id
182301: and xet.event_date between p_pad_start_date and p_pad_end_date
182302: and xet.event_type_code = C_EVENT_TYPE_CODE
183109: ,555)
183110:
183111: ELSE null
183112: END source_meaning
183113: FROM xla_events_gt xet
183114: , GMF_XLA_EXTRACT_HEADERS h1
183115: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
183116: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
183117: AND xet.event_class_code = C_EVENT_CLASS_CODE
183227:
183228: ELSE null
183229: END source_value
183230: , null source_meaning
183231: FROM xla_events_gt xet
183232: , GMF_XLA_EXTRACT_LINES l2
183233: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
183234: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
183235: AND xet.event_class_code = C_EVENT_CLASS_CODE
183427: , h1.CURRENCY_CONVERSION_DATE source_8
183428: , h1.CURRENCY_CONVERSION_RATE source_9
183429: , h1.CURRENCY_CONVERSION_TYPE source_10
183430: , h1.TRANSACTION_DATE source_12
183431: FROM xla_events_gt xet
183432: , GMF_XLA_EXTRACT_HEADERS h1
183433: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
183434: and xet.event_class_code = C_EVENT_CLASS_CODE
183435: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
183472: , l2.JOURNAL_LINE_TYPE source_2
183473: , l2.ENTERED_AMOUNT source_3
183474: , l2.LINE_ID source_5
183475: , l2.ACCOUNTED_AMOUNT source_11
183476: FROM xla_events_gt xet
183477: , GMF_XLA_EXTRACT_LINES l2
183478: WHERE xet.event_id between x_first_event_id and x_last_event_id
183479: and xet.event_date between p_pad_start_date and p_pad_end_date
183480: and xet.event_class_code = C_EVENT_CLASS_CODE
184315: ,555)
184316:
184317: ELSE null
184318: END source_meaning
184319: FROM xla_events_gt xet
184320: , GMF_XLA_EXTRACT_HEADERS h1
184321: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
184322: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
184323: AND xet.event_type_code = C_EVENT_TYPE_CODE
184432:
184433: ELSE null
184434: END source_value
184435: , null source_meaning
184436: FROM xla_events_gt xet
184437: , GMF_XLA_EXTRACT_LINES l2
184438: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
184439: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
184440: AND xet.event_type_code = C_EVENT_TYPE_CODE
184633: , h1.CURRENCY_CONVERSION_DATE source_8
184634: , h1.CURRENCY_CONVERSION_RATE source_9
184635: , h1.CURRENCY_CONVERSION_TYPE source_10
184636: , h1.TRANSACTION_DATE source_12
184637: FROM xla_events_gt xet
184638: , GMF_XLA_EXTRACT_HEADERS h1
184639: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
184640: and xet.event_type_code = C_EVENT_TYPE_CODE
184641: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
184678: , l2.JOURNAL_LINE_TYPE source_2
184679: , l2.ENTERED_AMOUNT source_3
184680: , l2.LINE_ID source_5
184681: , l2.ACCOUNTED_AMOUNT source_11
184682: FROM xla_events_gt xet
184683: , GMF_XLA_EXTRACT_LINES l2
184684: WHERE xet.event_id between x_first_event_id and x_last_event_id
184685: and xet.event_date between p_pad_start_date and p_pad_end_date
184686: and xet.event_type_code = C_EVENT_TYPE_CODE
185493: ,555)
185494:
185495: ELSE null
185496: END source_meaning
185497: FROM xla_events_gt xet
185498: , GMF_XLA_EXTRACT_HEADERS h1
185499: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
185500: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
185501: AND xet.event_type_code = C_EVENT_TYPE_CODE
185610:
185611: ELSE null
185612: END source_value
185613: , null source_meaning
185614: FROM xla_events_gt xet
185615: , GMF_XLA_EXTRACT_LINES l2
185616: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
185617: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
185618: AND xet.event_type_code = C_EVENT_TYPE_CODE
185811: , h1.CURRENCY_CONVERSION_DATE source_8
185812: , h1.CURRENCY_CONVERSION_RATE source_9
185813: , h1.CURRENCY_CONVERSION_TYPE source_10
185814: , h1.TRANSACTION_DATE source_12
185815: FROM xla_events_gt xet
185816: , GMF_XLA_EXTRACT_HEADERS h1
185817: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
185818: and xet.event_type_code = C_EVENT_TYPE_CODE
185819: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
185856: , l2.JOURNAL_LINE_TYPE source_2
185857: , l2.ENTERED_AMOUNT source_3
185858: , l2.LINE_ID source_5
185859: , l2.ACCOUNTED_AMOUNT source_11
185860: FROM xla_events_gt xet
185861: , GMF_XLA_EXTRACT_LINES l2
185862: WHERE xet.event_id between x_first_event_id and x_last_event_id
185863: and xet.event_date between p_pad_start_date and p_pad_end_date
185864: and xet.event_type_code = C_EVENT_TYPE_CODE
186671: ,555)
186672:
186673: ELSE null
186674: END source_meaning
186675: FROM xla_events_gt xet
186676: , GMF_XLA_EXTRACT_HEADERS h1
186677: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
186678: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
186679: AND xet.event_class_code = C_EVENT_CLASS_CODE
186794:
186795: ELSE null
186796: END source_value
186797: , null source_meaning
186798: FROM xla_events_gt xet
186799: , GMF_XLA_EXTRACT_LINES l2
186800: , (select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
186801: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
186802: AND xet.event_class_code = C_EVENT_CLASS_CODE
186996: , h1.CURRENCY_CONVERSION_DATE source_8
186997: , h1.CURRENCY_CONVERSION_RATE source_9
186998: , h1.CURRENCY_CONVERSION_TYPE source_10
186999: , h1.TRANSACTION_DATE source_12
187000: FROM xla_events_gt xet
187001: , GMF_XLA_EXTRACT_HEADERS h1
187002: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
187003: and xet.event_class_code = C_EVENT_CLASS_CODE
187004: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
187042: , l2.ENTERED_AMOUNT source_3
187043: , l2.LINE_NUMBER source_4
187044: , l2.LINE_ID source_5
187045: , l2.ACCOUNTED_AMOUNT source_11
187046: FROM xla_events_gt xet
187047: , GMF_XLA_EXTRACT_LINES l2
187048: WHERE xet.event_id between x_first_event_id and x_last_event_id
187049: and xet.event_date between p_pad_start_date and p_pad_end_date
187050: and xet.event_class_code = C_EVENT_CLASS_CODE
187918: ,555)
187919:
187920: ELSE null
187921: END source_meaning
187922: FROM xla_events_gt xet
187923: , GMF_XLA_EXTRACT_HEADERS h1
187924: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
187925: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
187926: AND xet.event_type_code = C_EVENT_TYPE_CODE
188035:
188036: ELSE null
188037: END source_value
188038: , null source_meaning
188039: FROM xla_events_gt xet
188040: , GMF_XLA_EXTRACT_LINES l2
188041: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
188042: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
188043: AND xet.event_type_code = C_EVENT_TYPE_CODE
188236: , h1.CURRENCY_CONVERSION_DATE source_8
188237: , h1.CURRENCY_CONVERSION_RATE source_9
188238: , h1.CURRENCY_CONVERSION_TYPE source_10
188239: , h1.TRANSACTION_DATE source_12
188240: FROM xla_events_gt xet
188241: , GMF_XLA_EXTRACT_HEADERS h1
188242: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
188243: and xet.event_type_code = C_EVENT_TYPE_CODE
188244: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
188281: , l2.JOURNAL_LINE_TYPE source_2
188282: , l2.ENTERED_AMOUNT source_3
188283: , l2.LINE_ID source_5
188284: , l2.ACCOUNTED_AMOUNT source_11
188285: FROM xla_events_gt xet
188286: , GMF_XLA_EXTRACT_LINES l2
188287: WHERE xet.event_id between x_first_event_id and x_last_event_id
188288: and xet.event_date between p_pad_start_date and p_pad_end_date
188289: and xet.event_type_code = C_EVENT_TYPE_CODE
189208: ,555)
189209:
189210: ELSE null
189211: END source_meaning
189212: FROM xla_events_gt xet
189213: , GMF_XLA_EXTRACT_HEADERS h1
189214: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
189215: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
189216: AND xet.event_type_code = C_EVENT_TYPE_CODE
189325:
189326: ELSE null
189327: END source_value
189328: , null source_meaning
189329: FROM xla_events_gt xet
189330: , GMF_XLA_EXTRACT_LINES l2
189331: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
189332: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
189333: AND xet.event_type_code = C_EVENT_TYPE_CODE
189526: , h1.CURRENCY_CONVERSION_DATE source_8
189527: , h1.CURRENCY_CONVERSION_RATE source_9
189528: , h1.CURRENCY_CONVERSION_TYPE source_10
189529: , h1.TRANSACTION_DATE source_12
189530: FROM xla_events_gt xet
189531: , GMF_XLA_EXTRACT_HEADERS h1
189532: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
189533: and xet.event_type_code = C_EVENT_TYPE_CODE
189534: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
189571: , l2.JOURNAL_LINE_TYPE source_2
189572: , l2.ENTERED_AMOUNT source_3
189573: , l2.LINE_ID source_5
189574: , l2.ACCOUNTED_AMOUNT source_11
189575: FROM xla_events_gt xet
189576: , GMF_XLA_EXTRACT_LINES l2
189577: WHERE xet.event_id between x_first_event_id and x_last_event_id
189578: and xet.event_date between p_pad_start_date and p_pad_end_date
189579: and xet.event_type_code = C_EVENT_TYPE_CODE
192356: ,p_level => C_LEVEL_STATEMENT
192357: ,p_module => l_log_module);
192358:
192359: trace
192360: (p_msg => '# of events in xla_events_gt: '
192361: ||xla_context_pkg.get_event_count_context
192362: ,p_level => C_LEVEL_STATEMENT
192363: ,p_module => l_log_module);
192364: