[Home] [Help]
305201: WHEN 10 THEN fvl114.meaning
305202:
305203: ELSE null
305204: END source_meaning
305205: FROM xla_events_gt xet
305206: , CST_XLA_WIP_HEADERS_V h1
305207: , fnd_lookup_values fvl7
305208: , fnd_lookup_values fvl85
305209: , fnd_lookup_values fvl114
305334:
305335: ELSE null
305336: END source_value
305337: , null source_meaning
305338: FROM xla_events_gt xet
305339: , CST_XLA_WIP_LINES_V l2
305340: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
305341: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
305342: AND xet.event_class_code = C_EVENT_CLASS_CODE
305552: , h1.CURRENCY_CONVERSION_RATE source_93
305553: , h1.CURRENCY_CONVERSION_TYPE source_94
305554: , h1.TRANSFER_TO_GL_INDICATOR source_114
305555: , fvl114.meaning source_114_meaning
305556: FROM xla_events_gt xet
305557: , CST_XLA_WIP_HEADERS_V h1
305558: , fnd_lookup_values fvl7
305559: , fnd_lookup_values fvl85
305560: , fnd_lookup_values fvl114
305612: , l2.DISTRIBUTION_IDENTIFIER source_84
305613: , l2.ENTERED_AMOUNT source_91
305614: , l2.ACCOUNTED_AMOUNT source_95
305615: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
305616: FROM xla_events_gt xet
305617: , CST_XLA_WIP_LINES_V l2
305618: WHERE xet.event_id between x_first_event_id and x_last_event_id
305619: and xet.event_date between p_pad_start_date and p_pad_end_date
305620: and xet.event_class_code = C_EVENT_CLASS_CODE
306546: WHEN 6 THEN fvl114.meaning
306547:
306548: ELSE null
306549: END source_meaning
306550: FROM xla_events_gt xet
306551: , CST_XLA_AWO_HEADERS_V h1
306552: , fnd_lookup_values fvl85
306553: , fnd_lookup_values fvl114
306554: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
306684:
306685: ELSE null
306686: END source_value
306687: , null source_meaning
306688: FROM xla_events_gt xet
306689: , CST_XLA_AWO_LINES_V l2
306690: , (select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
306691: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
306692: AND xet.event_class_code = C_EVENT_CLASS_CODE
306892: , fvl85.meaning source_85_meaning
306893: , h1.WRITE_OFF_ID source_99
306894: , h1.TRANSFER_TO_GL_INDICATOR source_114
306895: , fvl114.meaning source_114_meaning
306896: FROM xla_events_gt xet
306897: , CST_XLA_AWO_HEADERS_V h1
306898: , fnd_lookup_values fvl85
306899: , fnd_lookup_values fvl114
306900: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
306949: , l2.CURRENCY_CONVERSION_RATE source_93
306950: , l2.CURRENCY_CONVERSION_TYPE source_94
306951: , l2.ACCOUNTED_AMOUNT source_95
306952: , l2.LINE_NUMBER source_98
306953: FROM xla_events_gt xet
306954: , CST_XLA_AWO_LINES_V l2
306955: WHERE xet.event_id between x_first_event_id and x_last_event_id
306956: and xet.event_date between p_pad_start_date and p_pad_end_date
306957: and xet.event_class_code = C_EVENT_CLASS_CODE
307869: WHEN 13 THEN fvl114.meaning
307870:
307871: ELSE null
307872: END source_meaning
307873: FROM xla_events_gt xet
307874: , CST_XLA_INV_HEADERS_V h1
307875: , CST_XLA_INV_ORG_PARAMS_REF_V h3
307876: , CST_XLA_INV_REF_V h4
307877: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
308047: ,707)
308048:
308049: ELSE null
308050: END source_meaning
308051: FROM xla_events_gt xet
308052: , CST_XLA_INV_LINES_V l2
308053: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
308054: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
308055: AND xet.event_type_code = C_EVENT_TYPE_CODE
308287: , h1.DISTRIBUTION_TYPE source_85
308288: , fvl85.meaning source_85_meaning
308289: , h1.TRANSFER_TO_GL_INDICATOR source_114
308290: , fvl114.meaning source_114_meaning
308291: FROM xla_events_gt xet
308292: , CST_XLA_INV_HEADERS_V h1
308293: , CST_XLA_INV_ORG_PARAMS_REF_V h3
308294: , CST_XLA_INV_REF_V h4
308295: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
308360: , l2.CURRENCY_CONVERSION_TYPE source_94
308361: , l2.ACCOUNTED_AMOUNT source_95
308362: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
308363: , l2.L_ORGANIZATION_CODE source_108
308364: FROM xla_events_gt xet
308365: , CST_XLA_INV_LINES_V l2
308366: WHERE xet.event_id between x_first_event_id and x_last_event_id
308367: and xet.event_date between p_pad_start_date and p_pad_end_date
308368: and xet.event_type_code = C_EVENT_TYPE_CODE
309350: WHEN 7 THEN fvl114.meaning
309351:
309352: ELSE null
309353: END source_meaning
309354: FROM xla_events_gt xet
309355: , CST_XLA_INV_HEADERS_V h1
309356: , CST_XLA_INV_REF_V h3
309357: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
309358: , CST_XLA_INV_TXN_TYPES_REF_V h5
309506:
309507: ELSE null
309508: END source_value
309509: , null source_meaning
309510: FROM xla_events_gt xet
309511: , CST_XLA_INV_LINES_V l2
309512: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
309513: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
309514: AND xet.event_type_code = C_EVENT_TYPE_CODE
309724: , h1.DISTRIBUTION_TYPE source_85
309725: , fvl85.meaning source_85_meaning
309726: , h1.TRANSFER_TO_GL_INDICATOR source_114
309727: , fvl114.meaning source_114_meaning
309728: FROM xla_events_gt xet
309729: , CST_XLA_INV_HEADERS_V h1
309730: , CST_XLA_INV_REF_V h3
309731: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
309732: , CST_XLA_INV_TXN_TYPES_REF_V h5
309788: , l2.CURRENCY_CONVERSION_TYPE source_94
309789: , l2.ACCOUNTED_AMOUNT source_95
309790: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
309791: , l2.L_ORGANIZATION_CODE source_108
309792: FROM xla_events_gt xet
309793: , CST_XLA_INV_LINES_V l2
309794: WHERE xet.event_id between x_first_event_id and x_last_event_id
309795: and xet.event_date between p_pad_start_date and p_pad_end_date
309796: and xet.event_type_code = C_EVENT_TYPE_CODE
310725: WHEN 7 THEN fvl114.meaning
310726:
310727: ELSE null
310728: END source_meaning
310729: FROM xla_events_gt xet
310730: , CST_XLA_INV_HEADERS_V h1
310731: , CST_XLA_INV_REF_V h3
310732: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
310733: , CST_XLA_INV_TXN_TYPES_REF_V h5
310881:
310882: ELSE null
310883: END source_value
310884: , null source_meaning
310885: FROM xla_events_gt xet
310886: , CST_XLA_INV_LINES_V l2
310887: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
310888: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
310889: AND xet.event_type_code = C_EVENT_TYPE_CODE
311099: , h1.DISTRIBUTION_TYPE source_85
311100: , fvl85.meaning source_85_meaning
311101: , h1.TRANSFER_TO_GL_INDICATOR source_114
311102: , fvl114.meaning source_114_meaning
311103: FROM xla_events_gt xet
311104: , CST_XLA_INV_HEADERS_V h1
311105: , CST_XLA_INV_REF_V h3
311106: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
311107: , CST_XLA_INV_TXN_TYPES_REF_V h5
311163: , l2.CURRENCY_CONVERSION_TYPE source_94
311164: , l2.ACCOUNTED_AMOUNT source_95
311165: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
311166: , l2.L_ORGANIZATION_CODE source_108
311167: FROM xla_events_gt xet
311168: , CST_XLA_INV_LINES_V l2
311169: WHERE xet.event_id between x_first_event_id and x_last_event_id
311170: and xet.event_date between p_pad_start_date and p_pad_end_date
311171: and xet.event_type_code = C_EVENT_TYPE_CODE
312150: WHEN 17 THEN fvl114.meaning
312151:
312152: ELSE null
312153: END source_meaning
312154: FROM xla_events_gt xet
312155: , CST_XLA_INV_HEADERS_V h1
312156: , CST_XLA_INV_ORG_PARAMS_REF_V h3
312157: , CST_XLA_INV_REF_V h4
312158: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
312324: ,707)
312325:
312326: ELSE null
312327: END source_meaning
312328: FROM xla_events_gt xet
312329: , CST_XLA_INV_LINES_V l2
312330: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
312331: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
312332: AND xet.event_class_code = C_EVENT_CLASS_CODE
312573: , h1.DISTRIBUTION_TYPE source_85
312574: , fvl85.meaning source_85_meaning
312575: , h1.TRANSFER_TO_GL_INDICATOR source_114
312576: , fvl114.meaning source_114_meaning
312577: FROM xla_events_gt xet
312578: , CST_XLA_INV_HEADERS_V h1
312579: , CST_XLA_INV_ORG_PARAMS_REF_V h3
312580: , CST_XLA_INV_REF_V h4
312581: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
312641: , l2.CURRENCY_CONVERSION_TYPE source_94
312642: , l2.ACCOUNTED_AMOUNT source_95
312643: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
312644: , l2.L_ORGANIZATION_CODE source_108
312645: FROM xla_events_gt xet
312646: , CST_XLA_INV_LINES_V l2
312647: WHERE xet.event_id between x_first_event_id and x_last_event_id
312648: and xet.event_date between p_pad_start_date and p_pad_end_date
312649: and xet.event_class_code = C_EVENT_CLASS_CODE
313744: WHEN 16 THEN fvl114.meaning
313745:
313746: ELSE null
313747: END source_meaning
313748: FROM xla_events_gt xet
313749: , CST_XLA_RCV_HEADERS_V h1
313750: , CST_XLA_RCV_REF_V h3
313751: , PO_DISTS_REF_V h4
313752: , PO_HEADERS_REF_V h5
313876:
313877: ELSE null
313878: END source_value
313879: , null source_meaning
313880: FROM xla_events_gt xet
313881: , CST_XLA_RCV_LINES_V l2
313882: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
313883: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
313884: AND xet.event_class_code = C_EVENT_CLASS_CODE
314110: , h5.PURCH_ENCUMBRANCE_TYPE_ID source_96
314111: , h6.CST_ENCUM_UPG_OPTION source_100
314112: , h1.TRANSFER_TO_GL_INDICATOR source_114
314113: , fvl114.meaning source_114_meaning
314114: FROM xla_events_gt xet
314115: , CST_XLA_RCV_HEADERS_V h1
314116: , CST_XLA_RCV_REF_V h3
314117: , PO_DISTS_REF_V h4
314118: , PO_HEADERS_REF_V h5
314169: , l2.RCV_ACCOUNTING_LINE_TYPE source_78
314170: , l2.DISTRIBUTION_IDENTIFIER source_84
314171: , l2.ENTERED_AMOUNT source_91
314172: , l2.ACCOUNTED_AMOUNT source_95
314173: FROM xla_events_gt xet
314174: , CST_XLA_RCV_LINES_V l2
314175: WHERE xet.event_id between x_first_event_id and x_last_event_id
314176: and xet.event_date between p_pad_start_date and p_pad_end_date
314177: and xet.event_class_code = C_EVENT_CLASS_CODE
315135: WHEN 26 THEN fvl114.meaning
315136:
315137: ELSE null
315138: END source_meaning
315139: FROM xla_events_gt xet
315140: , CST_XLA_INTERORG_PARAMS_REF_V h1
315141: , CST_XLA_INV_HEADERS_V h2
315142: , CST_XLA_INV_REF_V h4
315143: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
315314: ,707)
315315:
315316: ELSE null
315317: END source_meaning
315318: FROM xla_events_gt xet
315319: , CST_XLA_INV_LINES_V l3
315320: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
315321: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
315322: AND xet.event_class_code = C_EVENT_CLASS_CODE
315590: , h8.REQ_BUDGET_ACCOUNT source_103
315591: , h9.REQ_ENCUMBRANCE_TYPE_ID source_104
315592: , h2.TRANSFER_TO_GL_INDICATOR source_114
315593: , fvl114.meaning source_114_meaning
315594: FROM xla_events_gt xet
315595: , CST_XLA_INTERORG_PARAMS_REF_V h1
315596: , CST_XLA_INV_HEADERS_V h2
315597: , CST_XLA_INV_REF_V h4
315598: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
315663: , l3.CURRENCY_CONVERSION_TYPE source_94
315664: , l3.ACCOUNTED_AMOUNT source_95
315665: , l3.ACCOUNTING_LINE_TYPE_CODE source_97
315666: , l3.L_ORGANIZATION_CODE source_108
315667: FROM xla_events_gt xet
315668: , CST_XLA_INV_LINES_V l3
315669: WHERE xet.event_id between x_first_event_id and x_last_event_id
315670: and xet.event_date between p_pad_start_date and p_pad_end_date
315671: and xet.event_class_code = C_EVENT_CLASS_CODE
317035: WHEN 17 THEN fvl114.meaning
317036:
317037: ELSE null
317038: END source_meaning
317039: FROM xla_events_gt xet
317040: , CST_XLA_INTERORG_PARAMS_REF_V h1
317041: , CST_XLA_INV_HEADERS_V h2
317042: , CST_XLA_INV_REF_V h4
317043: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
317210: ,707)
317211:
317212: ELSE null
317213: END source_meaning
317214: FROM xla_events_gt xet
317215: , CST_XLA_INV_LINES_V l3
317216: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
317217: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
317218: AND xet.event_class_code = C_EVENT_CLASS_CODE
317459: , h2.DISTRIBUTION_TYPE source_85
317460: , fvl85.meaning source_85_meaning
317461: , h2.TRANSFER_TO_GL_INDICATOR source_114
317462: , fvl114.meaning source_114_meaning
317463: FROM xla_events_gt xet
317464: , CST_XLA_INTERORG_PARAMS_REF_V h1
317465: , CST_XLA_INV_HEADERS_V h2
317466: , CST_XLA_INV_REF_V h4
317467: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
317528: , l3.CURRENCY_CONVERSION_TYPE source_94
317529: , l3.ACCOUNTED_AMOUNT source_95
317530: , l3.ACCOUNTING_LINE_TYPE_CODE source_97
317531: , l3.L_ORGANIZATION_CODE source_108
317532: FROM xla_events_gt xet
317533: , CST_XLA_INV_LINES_V l3
317534: WHERE xet.event_id between x_first_event_id and x_last_event_id
317535: and xet.event_date between p_pad_start_date and p_pad_end_date
317536: and xet.event_class_code = C_EVENT_CLASS_CODE
318757: WHEN 14 THEN fvl114.meaning
318758:
318759: ELSE null
318760: END source_meaning
318761: FROM xla_events_gt xet
318762: , CST_XLA_DISCRETE_JOB_REF_V h1
318763: , CST_XLA_FLOW_SCHEDULE_REF_V h2
318764: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h3
318765: , CST_XLA_REP_ITEM_REF_V h4
318899:
318900: ELSE null
318901: END source_value
318902: , null source_meaning
318903: FROM xla_events_gt xet
318904: , CST_XLA_WIP_LINES_V l7
318905: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
318906: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
318907: AND xet.event_type_code = C_EVENT_TYPE_CODE
319132: , h6.CURRENCY_CONVERSION_DATE source_92
319133: , h6.CURRENCY_CONVERSION_RATE source_93
319134: , h6.TRANSFER_TO_GL_INDICATOR source_114
319135: , fvl114.meaning source_114_meaning
319136: FROM xla_events_gt xet
319137: , CST_XLA_DISCRETE_JOB_REF_V h1
319138: , CST_XLA_FLOW_SCHEDULE_REF_V h2
319139: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h3
319140: , CST_XLA_REP_ITEM_REF_V h4
319202: , l7.DISTRIBUTION_IDENTIFIER source_84
319203: , l7.ENTERED_AMOUNT source_91
319204: , l7.ACCOUNTED_AMOUNT source_95
319205: , l7.ACCOUNTING_LINE_TYPE_CODE source_97
319206: FROM xla_events_gt xet
319207: , CST_XLA_WIP_LINES_V l7
319208: WHERE xet.event_id between x_first_event_id and x_last_event_id
319209: and xet.event_date between p_pad_start_date and p_pad_end_date
319210: and xet.event_type_code = C_EVENT_TYPE_CODE
320244: WHEN 9 THEN fvl114.meaning
320245:
320246: ELSE null
320247: END source_meaning
320248: FROM xla_events_gt xet
320249: , CST_XLA_INTERORG_PARAMS_REF_V h1
320250: , CST_XLA_INV_HEADERS_V h2
320251: , CST_XLA_INV_REF_V h4
320252: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
320402:
320403: ELSE null
320404: END source_value
320405: , null source_meaning
320406: FROM xla_events_gt xet
320407: , CST_XLA_INV_LINES_V l3
320408: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
320409: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
320410: AND xet.event_type_code = C_EVENT_TYPE_CODE
320626: , h2.DISTRIBUTION_TYPE source_85
320627: , fvl85.meaning source_85_meaning
320628: , h2.TRANSFER_TO_GL_INDICATOR source_114
320629: , fvl114.meaning source_114_meaning
320630: FROM xla_events_gt xet
320631: , CST_XLA_INTERORG_PARAMS_REF_V h1
320632: , CST_XLA_INV_HEADERS_V h2
320633: , CST_XLA_INV_REF_V h4
320634: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
320692: , l3.CURRENCY_CONVERSION_TYPE source_94
320693: , l3.ACCOUNTED_AMOUNT source_95
320694: , l3.ACCOUNTING_LINE_TYPE_CODE source_97
320695: , l3.L_ORGANIZATION_CODE source_108
320696: FROM xla_events_gt xet
320697: , CST_XLA_INV_LINES_V l3
320698: WHERE xet.event_id between x_first_event_id and x_last_event_id
320699: and xet.event_date between p_pad_start_date and p_pad_end_date
320700: and xet.event_type_code = C_EVENT_TYPE_CODE
321693: WHEN 14 THEN fvl114.meaning
321694:
321695: ELSE null
321696: END source_meaning
321697: FROM xla_events_gt xet
321698: , CST_XLA_INTERORG_PARAMS_REF_V h1
321699: , CST_XLA_INV_HEADERS_V h2
321700: , CST_XLA_INV_REF_V h4
321701: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
321867: ,707)
321868:
321869: ELSE null
321870: END source_meaning
321871: FROM xla_events_gt xet
321872: , CST_XLA_INV_LINES_V l3
321873: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
321874: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
321875: AND xet.event_type_code = C_EVENT_TYPE_CODE
322108: , h2.DISTRIBUTION_TYPE source_85
322109: , fvl85.meaning source_85_meaning
322110: , h2.TRANSFER_TO_GL_INDICATOR source_114
322111: , fvl114.meaning source_114_meaning
322112: FROM xla_events_gt xet
322113: , CST_XLA_INTERORG_PARAMS_REF_V h1
322114: , CST_XLA_INV_HEADERS_V h2
322115: , CST_XLA_INV_REF_V h4
322116: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
322177: , l3.CURRENCY_CONVERSION_TYPE source_94
322178: , l3.ACCOUNTED_AMOUNT source_95
322179: , l3.ACCOUNTING_LINE_TYPE_CODE source_97
322180: , l3.L_ORGANIZATION_CODE source_108
322181: FROM xla_events_gt xet
322182: , CST_XLA_INV_LINES_V l3
322183: WHERE xet.event_id between x_first_event_id and x_last_event_id
322184: and xet.event_date between p_pad_start_date and p_pad_end_date
322185: and xet.event_type_code = C_EVENT_TYPE_CODE
323254: WHEN 26 THEN fvl114.meaning
323255:
323256: ELSE null
323257: END source_meaning
323258: FROM xla_events_gt xet
323259: , CST_XLA_INTERORG_PARAMS_REF_V h1
323260: , CST_XLA_INV_HEADERS_V h2
323261: , CST_XLA_INV_REF_V h4
323262: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
323432: ,707)
323433:
323434: ELSE null
323435: END source_meaning
323436: FROM xla_events_gt xet
323437: , CST_XLA_INV_LINES_V l3
323438: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
323439: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
323440: AND xet.event_type_code = C_EVENT_TYPE_CODE
323709: , h8.REQ_BUDGET_ACCOUNT source_103
323710: , h9.REQ_ENCUMBRANCE_TYPE_ID source_104
323711: , h2.TRANSFER_TO_GL_INDICATOR source_114
323712: , fvl114.meaning source_114_meaning
323713: FROM xla_events_gt xet
323714: , CST_XLA_INTERORG_PARAMS_REF_V h1
323715: , CST_XLA_INV_HEADERS_V h2
323716: , CST_XLA_INV_REF_V h4
323717: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
323782: , l3.CURRENCY_CONVERSION_TYPE source_94
323783: , l3.ACCOUNTED_AMOUNT source_95
323784: , l3.ACCOUNTING_LINE_TYPE_CODE source_97
323785: , l3.L_ORGANIZATION_CODE source_108
323786: FROM xla_events_gt xet
323787: , CST_XLA_INV_LINES_V l3
323788: WHERE xet.event_id between x_first_event_id and x_last_event_id
323789: and xet.event_date between p_pad_start_date and p_pad_end_date
323790: and xet.event_type_code = C_EVENT_TYPE_CODE
325160: WHEN 27 THEN fvl114.meaning
325161:
325162: ELSE null
325163: END source_meaning
325164: FROM xla_events_gt xet
325165: , CST_XLA_INTERORG_PARAMS_REF_V h1
325166: , CST_XLA_INV_HEADERS_V h2
325167: , CST_XLA_INV_REF_V h4
325168: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
325338: ,707)
325339:
325340: ELSE null
325341: END source_meaning
325342: FROM xla_events_gt xet
325343: , CST_XLA_INV_LINES_V l3
325344: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
325345: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
325346: AND xet.event_type_code = C_EVENT_TYPE_CODE
325618: , h8.REQ_BUDGET_ACCOUNT source_103
325619: , h9.REQ_ENCUMBRANCE_TYPE_ID source_104
325620: , h2.TRANSFER_TO_GL_INDICATOR source_114
325621: , fvl114.meaning source_114_meaning
325622: FROM xla_events_gt xet
325623: , CST_XLA_INTERORG_PARAMS_REF_V h1
325624: , CST_XLA_INV_HEADERS_V h2
325625: , CST_XLA_INV_REF_V h4
325626: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
325691: , l3.CURRENCY_CONVERSION_TYPE source_94
325692: , l3.ACCOUNTED_AMOUNT source_95
325693: , l3.ACCOUNTING_LINE_TYPE_CODE source_97
325694: , l3.L_ORGANIZATION_CODE source_108
325695: FROM xla_events_gt xet
325696: , CST_XLA_INV_LINES_V l3
325697: WHERE xet.event_id between x_first_event_id and x_last_event_id
325698: and xet.event_date between p_pad_start_date and p_pad_end_date
325699: and xet.event_type_code = C_EVENT_TYPE_CODE
327027: WHEN 18 THEN fvl114.meaning
327028:
327029: ELSE null
327030: END source_meaning
327031: FROM xla_events_gt xet
327032: , CST_XLA_INTERORG_PARAMS_REF_V h1
327033: , CST_XLA_INV_HEADERS_V h2
327034: , CST_XLA_INV_ORG_PARAMS_REF_V h4
327035: , CST_XLA_INV_REF_V h5
327202: ,707)
327203:
327204: ELSE null
327205: END source_meaning
327206: FROM xla_events_gt xet
327207: , CST_XLA_INV_LINES_V l3
327208: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
327209: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
327210: AND xet.event_type_code = C_EVENT_TYPE_CODE
327455: , h2.DISTRIBUTION_TYPE source_85
327456: , fvl85.meaning source_85_meaning
327457: , h2.TRANSFER_TO_GL_INDICATOR source_114
327458: , fvl114.meaning source_114_meaning
327459: FROM xla_events_gt xet
327460: , CST_XLA_INTERORG_PARAMS_REF_V h1
327461: , CST_XLA_INV_HEADERS_V h2
327462: , CST_XLA_INV_ORG_PARAMS_REF_V h4
327463: , CST_XLA_INV_REF_V h5
327529: , l3.CURRENCY_CONVERSION_RATE source_93
327530: , l3.CURRENCY_CONVERSION_TYPE source_94
327531: , l3.ACCOUNTED_AMOUNT source_95
327532: , l3.ACCOUNTING_LINE_TYPE_CODE source_97
327533: FROM xla_events_gt xet
327534: , CST_XLA_INV_LINES_V l3
327535: WHERE xet.event_id between x_first_event_id and x_last_event_id
327536: and xet.event_date between p_pad_start_date and p_pad_end_date
327537: and xet.event_type_code = C_EVENT_TYPE_CODE
328704: WHEN 16 THEN fvl114.meaning
328705:
328706: ELSE null
328707: END source_meaning
328708: FROM xla_events_gt xet
328709: , CST_XLA_INTERORG_PARAMS_REF_V h1
328710: , CST_XLA_INV_HEADERS_V h2
328711: , CST_XLA_INV_ORG_PARAMS_REF_V h4
328712: , CST_XLA_INV_REF_V h5
328879: ,707)
328880:
328881: ELSE null
328882: END source_meaning
328883: FROM xla_events_gt xet
328884: , CST_XLA_INV_LINES_V l3
328885: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
328886: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
328887: AND xet.event_type_code = C_EVENT_TYPE_CODE
329126: , h2.DISTRIBUTION_TYPE source_85
329127: , fvl85.meaning source_85_meaning
329128: , h2.TRANSFER_TO_GL_INDICATOR source_114
329129: , fvl114.meaning source_114_meaning
329130: FROM xla_events_gt xet
329131: , CST_XLA_INTERORG_PARAMS_REF_V h1
329132: , CST_XLA_INV_HEADERS_V h2
329133: , CST_XLA_INV_ORG_PARAMS_REF_V h4
329134: , CST_XLA_INV_REF_V h5
329200: , l3.CURRENCY_CONVERSION_RATE source_93
329201: , l3.CURRENCY_CONVERSION_TYPE source_94
329202: , l3.ACCOUNTED_AMOUNT source_95
329203: , l3.ACCOUNTING_LINE_TYPE_CODE source_97
329204: FROM xla_events_gt xet
329205: , CST_XLA_INV_LINES_V l3
329206: WHERE xet.event_id between x_first_event_id and x_last_event_id
329207: and xet.event_date between p_pad_start_date and p_pad_end_date
329208: and xet.event_type_code = C_EVENT_TYPE_CODE
330264: WHEN 15 THEN fvl114.meaning
330265:
330266: ELSE null
330267: END source_meaning
330268: FROM xla_events_gt xet
330269: , CST_XLA_INTERORG_PARAMS_REF_V h1
330270: , CST_XLA_INV_HEADERS_V h2
330271: , CST_XLA_INV_ORG_PARAMS_REF_V h4
330272: , CST_XLA_INV_REF_V h5
330444: ,707)
330445:
330446: ELSE null
330447: END source_meaning
330448: FROM xla_events_gt xet
330449: , CST_XLA_INV_LINES_V l3
330450: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
330451: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
330452: AND xet.event_type_code = C_EVENT_TYPE_CODE
330690: , h2.DISTRIBUTION_TYPE source_85
330691: , fvl85.meaning source_85_meaning
330692: , h2.TRANSFER_TO_GL_INDICATOR source_114
330693: , fvl114.meaning source_114_meaning
330694: FROM xla_events_gt xet
330695: , CST_XLA_INTERORG_PARAMS_REF_V h1
330696: , CST_XLA_INV_HEADERS_V h2
330697: , CST_XLA_INV_ORG_PARAMS_REF_V h4
330698: , CST_XLA_INV_REF_V h5
330765: , l3.CURRENCY_CONVERSION_TYPE source_94
330766: , l3.ACCOUNTED_AMOUNT source_95
330767: , l3.ACCOUNTING_LINE_TYPE_CODE source_97
330768: , l3.L_ORGANIZATION_CODE source_108
330769: FROM xla_events_gt xet
330770: , CST_XLA_INV_LINES_V l3
330771: WHERE xet.event_id between x_first_event_id and x_last_event_id
330772: and xet.event_date between p_pad_start_date and p_pad_end_date
330773: and xet.event_type_code = C_EVENT_TYPE_CODE
331850: WHEN 25 THEN fvl114.meaning
331851:
331852: ELSE null
331853: END source_meaning
331854: FROM xla_events_gt xet
331855: , CST_XLA_INTERORG_PARAMS_REF_V h1
331856: , CST_XLA_INV_HEADERS_V h2
331857: , CST_XLA_INV_ORG_PARAMS_REF_V h4
331858: , CST_XLA_INV_REF_V h5
332034: ,707)
332035:
332036: ELSE null
332037: END source_meaning
332038: FROM xla_events_gt xet
332039: , CST_XLA_INV_LINES_V l3
332040: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
332041: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
332042: AND xet.event_type_code = C_EVENT_TYPE_CODE
332310: , h9.REQ_BUDGET_ACCOUNT source_103
332311: , h10.REQ_ENCUMBRANCE_TYPE_ID source_104
332312: , h2.TRANSFER_TO_GL_INDICATOR source_114
332313: , fvl114.meaning source_114_meaning
332314: FROM xla_events_gt xet
332315: , CST_XLA_INTERORG_PARAMS_REF_V h1
332316: , CST_XLA_INV_HEADERS_V h2
332317: , CST_XLA_INV_ORG_PARAMS_REF_V h4
332318: , CST_XLA_INV_REF_V h5
332389: , l3.CURRENCY_CONVERSION_TYPE source_94
332390: , l3.ACCOUNTED_AMOUNT source_95
332391: , l3.ACCOUNTING_LINE_TYPE_CODE source_97
332392: , l3.L_ORGANIZATION_CODE source_108
332393: FROM xla_events_gt xet
332394: , CST_XLA_INV_LINES_V l3
332395: WHERE xet.event_id between x_first_event_id and x_last_event_id
332396: and xet.event_date between p_pad_start_date and p_pad_end_date
332397: and xet.event_type_code = C_EVENT_TYPE_CODE
333511: WHEN 18 THEN fvl114.meaning
333512:
333513: ELSE null
333514: END source_meaning
333515: FROM xla_events_gt xet
333516: , CST_XLA_INTERORG_PARAMS_REF_V h1
333517: , CST_XLA_INV_HEADERS_V h2
333518: , CST_XLA_INV_ORG_PARAMS_REF_V h4
333519: , CST_XLA_INV_REF_V h5
333686: ,707)
333687:
333688: ELSE null
333689: END source_meaning
333690: FROM xla_events_gt xet
333691: , CST_XLA_INV_LINES_V l3
333692: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
333693: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
333694: AND xet.event_type_code = C_EVENT_TYPE_CODE
333939: , h2.DISTRIBUTION_TYPE source_85
333940: , fvl85.meaning source_85_meaning
333941: , h2.TRANSFER_TO_GL_INDICATOR source_114
333942: , fvl114.meaning source_114_meaning
333943: FROM xla_events_gt xet
333944: , CST_XLA_INTERORG_PARAMS_REF_V h1
333945: , CST_XLA_INV_HEADERS_V h2
333946: , CST_XLA_INV_ORG_PARAMS_REF_V h4
333947: , CST_XLA_INV_REF_V h5
334013: , l3.CURRENCY_CONVERSION_RATE source_93
334014: , l3.CURRENCY_CONVERSION_TYPE source_94
334015: , l3.ACCOUNTED_AMOUNT source_95
334016: , l3.ACCOUNTING_LINE_TYPE_CODE source_97
334017: FROM xla_events_gt xet
334018: , CST_XLA_INV_LINES_V l3
334019: WHERE xet.event_id between x_first_event_id and x_last_event_id
334020: and xet.event_date between p_pad_start_date and p_pad_end_date
334021: and xet.event_type_code = C_EVENT_TYPE_CODE
335266: WHEN 18 THEN fvl114.meaning
335267:
335268: ELSE null
335269: END source_meaning
335270: FROM xla_events_gt xet
335271: , CST_XLA_INTERORG_PARAMS_REF_V h1
335272: , CST_XLA_INV_HEADERS_V h2
335273: , CST_XLA_INV_ORG_PARAMS_REF_V h4
335274: , CST_XLA_INV_REF_V h5
335441: ,707)
335442:
335443: ELSE null
335444: END source_meaning
335445: FROM xla_events_gt xet
335446: , CST_XLA_INV_LINES_V l3
335447: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
335448: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
335449: AND xet.event_type_code = C_EVENT_TYPE_CODE
335694: , h2.DISTRIBUTION_TYPE source_85
335695: , fvl85.meaning source_85_meaning
335696: , h2.TRANSFER_TO_GL_INDICATOR source_114
335697: , fvl114.meaning source_114_meaning
335698: FROM xla_events_gt xet
335699: , CST_XLA_INTERORG_PARAMS_REF_V h1
335700: , CST_XLA_INV_HEADERS_V h2
335701: , CST_XLA_INV_ORG_PARAMS_REF_V h4
335702: , CST_XLA_INV_REF_V h5
335768: , l3.CURRENCY_CONVERSION_RATE source_93
335769: , l3.CURRENCY_CONVERSION_TYPE source_94
335770: , l3.ACCOUNTED_AMOUNT source_95
335771: , l3.ACCOUNTING_LINE_TYPE_CODE source_97
335772: FROM xla_events_gt xet
335773: , CST_XLA_INV_LINES_V l3
335774: WHERE xet.event_id between x_first_event_id and x_last_event_id
335775: and xet.event_date between p_pad_start_date and p_pad_end_date
335776: and xet.event_type_code = C_EVENT_TYPE_CODE
336985: WHEN 11 THEN fvl114.meaning
336986:
336987: ELSE null
336988: END source_meaning
336989: FROM xla_events_gt xet
336990: , CST_XLA_INTERORG_PARAMS_REF_V h1
336991: , CST_XLA_INV_HEADERS_V h2
336992: , CST_XLA_PLA_CATEGORY_REF_V h4
336993: , fnd_lookup_values fvl85
337156: ,707)
337157:
337158: ELSE null
337159: END source_meaning
337160: FROM xla_events_gt xet
337161: , CST_XLA_INV_LINES_V l3
337162: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
337163: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
337164: AND xet.event_type_code = C_EVENT_TYPE_CODE
337388: , h2.DISTRIBUTION_TYPE source_85
337389: , fvl85.meaning source_85_meaning
337390: , h2.TRANSFER_TO_GL_INDICATOR source_114
337391: , fvl114.meaning source_114_meaning
337392: FROM xla_events_gt xet
337393: , CST_XLA_INTERORG_PARAMS_REF_V h1
337394: , CST_XLA_INV_HEADERS_V h2
337395: , CST_XLA_PLA_CATEGORY_REF_V h4
337396: , fnd_lookup_values fvl85
337454: , l3.CURRENCY_CONVERSION_TYPE source_94
337455: , l3.ACCOUNTED_AMOUNT source_95
337456: , l3.ACCOUNTING_LINE_TYPE_CODE source_97
337457: , l3.L_ORGANIZATION_CODE source_108
337458: FROM xla_events_gt xet
337459: , CST_XLA_INV_LINES_V l3
337460: WHERE xet.event_id between x_first_event_id and x_last_event_id
337461: and xet.event_date between p_pad_start_date and p_pad_end_date
337462: and xet.event_type_code = C_EVENT_TYPE_CODE
338519: WHEN 15 THEN fvl114.meaning
338520:
338521: ELSE null
338522: END source_meaning
338523: FROM xla_events_gt xet
338524: , CST_XLA_INTERORG_PARAMS_REF_V h1
338525: , CST_XLA_INV_HEADERS_V h2
338526: , CST_XLA_INV_REF_V h4
338527: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
338688: ,707)
338689:
338690: ELSE null
338691: END source_meaning
338692: FROM xla_events_gt xet
338693: , CST_XLA_INV_LINES_V l3
338694: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
338695: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
338696: AND xet.event_type_code = C_EVENT_TYPE_CODE
338930: , h2.DISTRIBUTION_TYPE source_85
338931: , fvl85.meaning source_85_meaning
338932: , h2.TRANSFER_TO_GL_INDICATOR source_114
338933: , fvl114.meaning source_114_meaning
338934: FROM xla_events_gt xet
338935: , CST_XLA_INTERORG_PARAMS_REF_V h1
338936: , CST_XLA_INV_HEADERS_V h2
338937: , CST_XLA_INV_REF_V h4
338938: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
338998: , l3.CURRENCY_CONVERSION_TYPE source_94
338999: , l3.ACCOUNTED_AMOUNT source_95
339000: , l3.ACCOUNTING_LINE_TYPE_CODE source_97
339001: , l3.L_ORGANIZATION_CODE source_108
339002: FROM xla_events_gt xet
339003: , CST_XLA_INV_LINES_V l3
339004: WHERE xet.event_id between x_first_event_id and x_last_event_id
339005: and xet.event_date between p_pad_start_date and p_pad_end_date
339006: and xet.event_type_code = C_EVENT_TYPE_CODE
340024: WHEN 25 THEN fvl114.meaning
340025:
340026: ELSE null
340027: END source_meaning
340028: FROM xla_events_gt xet
340029: , CST_XLA_INV_HEADERS_V h1
340030: , CST_XLA_INV_REF_V h3
340031: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
340032: , CST_XLA_INV_TXN_TYPES_REF_V h5
340211: ,707)
340212:
340213: ELSE null
340214: END source_meaning
340215: FROM xla_events_gt xet
340216: , CST_XLA_INV_LINES_V l2
340217: , (select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
340218: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
340219: AND xet.event_class_code = C_EVENT_CLASS_CODE
340486: , h1.DISTRIBUTION_TYPE source_85
340487: , fvl85.meaning source_85_meaning
340488: , h1.TRANSFER_TO_GL_INDICATOR source_114
340489: , fvl114.meaning source_114_meaning
340490: FROM xla_events_gt xet
340491: , CST_XLA_INV_HEADERS_V h1
340492: , CST_XLA_INV_REF_V h3
340493: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
340494: , CST_XLA_INV_TXN_TYPES_REF_V h5
340557: , l2.CURRENCY_CONVERSION_TYPE source_94
340558: , l2.ACCOUNTED_AMOUNT source_95
340559: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
340560: , l2.L_ORGANIZATION_CODE source_108
340561: FROM xla_events_gt xet
340562: , CST_XLA_INV_LINES_V l2
340563: WHERE xet.event_id between x_first_event_id and x_last_event_id
340564: and xet.event_date between p_pad_start_date and p_pad_end_date
340565: and xet.event_class_code = C_EVENT_CLASS_CODE
341618: WHEN 17 THEN fvl114.meaning
341619:
341620: ELSE null
341621: END source_meaning
341622: FROM xla_events_gt xet
341623: , CST_XLA_INTERORG_PARAMS_REF_V h1
341624: , CST_XLA_INV_HEADERS_V h2
341625: , CST_XLA_INV_REF_V h4
341626: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
341792: ,707)
341793:
341794: ELSE null
341795: END source_meaning
341796: FROM xla_events_gt xet
341797: , CST_XLA_INV_LINES_V l3
341798: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
341799: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
341800: AND xet.event_type_code = C_EVENT_TYPE_CODE
342042: , h2.ORGANIZATION_ID source_111
342043: , h2.TRANSFER_ORGANIZATION_ID source_112
342044: , h2.TRANSFER_TO_GL_INDICATOR source_114
342045: , fvl114.meaning source_114_meaning
342046: FROM xla_events_gt xet
342047: , CST_XLA_INTERORG_PARAMS_REF_V h1
342048: , CST_XLA_INV_HEADERS_V h2
342049: , CST_XLA_INV_REF_V h4
342050: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
342111: , l3.CURRENCY_CONVERSION_TYPE source_94
342112: , l3.ACCOUNTED_AMOUNT source_95
342113: , l3.ACCOUNTING_LINE_TYPE_CODE source_97
342114: , l3.L_ORGANIZATION_CODE source_108
342115: FROM xla_events_gt xet
342116: , CST_XLA_INV_LINES_V l3
342117: WHERE xet.event_id between x_first_event_id and x_last_event_id
342118: and xet.event_date between p_pad_start_date and p_pad_end_date
342119: and xet.event_type_code = C_EVENT_TYPE_CODE
343233: WHEN 17 THEN fvl114.meaning
343234:
343235: ELSE null
343236: END source_meaning
343237: FROM xla_events_gt xet
343238: , CST_XLA_INTERORG_PARAMS_REF_V h1
343239: , CST_XLA_INV_HEADERS_V h2
343240: , CST_XLA_INV_REF_V h4
343241: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
343407: ,707)
343408:
343409: ELSE null
343410: END source_meaning
343411: FROM xla_events_gt xet
343412: , CST_XLA_INV_LINES_V l3
343413: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
343414: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
343415: AND xet.event_type_code = C_EVENT_TYPE_CODE
343657: , h2.ORGANIZATION_ID source_111
343658: , h2.TRANSFER_ORGANIZATION_ID source_112
343659: , h2.TRANSFER_TO_GL_INDICATOR source_114
343660: , fvl114.meaning source_114_meaning
343661: FROM xla_events_gt xet
343662: , CST_XLA_INTERORG_PARAMS_REF_V h1
343663: , CST_XLA_INV_HEADERS_V h2
343664: , CST_XLA_INV_REF_V h4
343665: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
343726: , l3.CURRENCY_CONVERSION_TYPE source_94
343727: , l3.ACCOUNTED_AMOUNT source_95
343728: , l3.ACCOUNTING_LINE_TYPE_CODE source_97
343729: , l3.L_ORGANIZATION_CODE source_108
343730: FROM xla_events_gt xet
343731: , CST_XLA_INV_LINES_V l3
343732: WHERE xet.event_id between x_first_event_id and x_last_event_id
343733: and xet.event_date between p_pad_start_date and p_pad_end_date
343734: and xet.event_type_code = C_EVENT_TYPE_CODE
344823: WHEN 14 THEN fvl114.meaning
344824:
344825: ELSE null
344826: END source_meaning
344827: FROM xla_events_gt xet
344828: , CST_XLA_DISCRETE_JOB_REF_V h1
344829: , CST_XLA_FLOW_SCHEDULE_REF_V h2
344830: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h3
344831: , CST_XLA_REP_ITEM_REF_V h4
344965:
344966: ELSE null
344967: END source_value
344968: , null source_meaning
344969: FROM xla_events_gt xet
344970: , CST_XLA_WIP_LINES_V l7
344971: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
344972: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
344973: AND xet.event_type_code = C_EVENT_TYPE_CODE
345198: , h6.CURRENCY_CONVERSION_DATE source_92
345199: , h6.CURRENCY_CONVERSION_RATE source_93
345200: , h6.TRANSFER_TO_GL_INDICATOR source_114
345201: , fvl114.meaning source_114_meaning
345202: FROM xla_events_gt xet
345203: , CST_XLA_DISCRETE_JOB_REF_V h1
345204: , CST_XLA_FLOW_SCHEDULE_REF_V h2
345205: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h3
345206: , CST_XLA_REP_ITEM_REF_V h4
345268: , l7.DISTRIBUTION_IDENTIFIER source_84
345269: , l7.ENTERED_AMOUNT source_91
345270: , l7.ACCOUNTED_AMOUNT source_95
345271: , l7.ACCOUNTING_LINE_TYPE_CODE source_97
345272: FROM xla_events_gt xet
345273: , CST_XLA_WIP_LINES_V l7
345274: WHERE xet.event_id between x_first_event_id and x_last_event_id
345275: and xet.event_date between p_pad_start_date and p_pad_end_date
345276: and xet.event_type_code = C_EVENT_TYPE_CODE
346331: WHEN 13 THEN fvl114.meaning
346332:
346333: ELSE null
346334: END source_meaning
346335: FROM xla_events_gt xet
346336: , CST_XLA_INV_HEADERS_V h1
346337: , CST_XLA_INV_ORG_PARAMS_REF_V h3
346338: , CST_XLA_INV_REF_V h4
346339: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
346509: ,707)
346510:
346511: ELSE null
346512: END source_meaning
346513: FROM xla_events_gt xet
346514: , CST_XLA_INV_LINES_V l2
346515: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
346516: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
346517: AND xet.event_type_code = C_EVENT_TYPE_CODE
346749: , h1.DISTRIBUTION_TYPE source_85
346750: , fvl85.meaning source_85_meaning
346751: , h1.TRANSFER_TO_GL_INDICATOR source_114
346752: , fvl114.meaning source_114_meaning
346753: FROM xla_events_gt xet
346754: , CST_XLA_INV_HEADERS_V h1
346755: , CST_XLA_INV_ORG_PARAMS_REF_V h3
346756: , CST_XLA_INV_REF_V h4
346757: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
346822: , l2.CURRENCY_CONVERSION_TYPE source_94
346823: , l2.ACCOUNTED_AMOUNT source_95
346824: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
346825: , l2.L_ORGANIZATION_CODE source_108
346826: FROM xla_events_gt xet
346827: , CST_XLA_INV_LINES_V l2
346828: WHERE xet.event_id between x_first_event_id and x_last_event_id
346829: and xet.event_date between p_pad_start_date and p_pad_end_date
346830: and xet.event_type_code = C_EVENT_TYPE_CODE
347809: WHEN 13 THEN fvl114.meaning
347810:
347811: ELSE null
347812: END source_meaning
347813: FROM xla_events_gt xet
347814: , CST_XLA_INV_HEADERS_V h1
347815: , CST_XLA_INV_ORG_PARAMS_REF_V h3
347816: , CST_XLA_INV_REF_V h4
347817: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
347987: ,707)
347988:
347989: ELSE null
347990: END source_meaning
347991: FROM xla_events_gt xet
347992: , CST_XLA_INV_LINES_V l2
347993: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
347994: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
347995: AND xet.event_type_code = C_EVENT_TYPE_CODE
348227: , h1.DISTRIBUTION_TYPE source_85
348228: , fvl85.meaning source_85_meaning
348229: , h1.TRANSFER_TO_GL_INDICATOR source_114
348230: , fvl114.meaning source_114_meaning
348231: FROM xla_events_gt xet
348232: , CST_XLA_INV_HEADERS_V h1
348233: , CST_XLA_INV_ORG_PARAMS_REF_V h3
348234: , CST_XLA_INV_REF_V h4
348235: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
348300: , l2.CURRENCY_CONVERSION_TYPE source_94
348301: , l2.ACCOUNTED_AMOUNT source_95
348302: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
348303: , l2.L_ORGANIZATION_CODE source_108
348304: FROM xla_events_gt xet
348305: , CST_XLA_INV_LINES_V l2
348306: WHERE xet.event_id between x_first_event_id and x_last_event_id
348307: and xet.event_date between p_pad_start_date and p_pad_end_date
348308: and xet.event_type_code = C_EVENT_TYPE_CODE
349280: WHEN 5 THEN fvl114.meaning
349281:
349282: ELSE null
349283: END source_meaning
349284: FROM xla_events_gt xet
349285: , CST_XLA_RCV_HEADERS_V h1
349286: , CST_XLA_RCV_REF_V h3
349287: , PO_DISTS_REF_V h4
349288: , fnd_lookup_values fvl85
349410:
349411: ELSE null
349412: END source_value
349413: , null source_meaning
349414: FROM xla_events_gt xet
349415: , CST_XLA_RCV_LINES_V l2
349416: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
349417: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
349418: AND xet.event_class_code = C_EVENT_CLASS_CODE
349611: , h4.CURRENCY_CONVERSION_DATE source_106
349612: , h4.CURRENCY_CONVERSION_RATE source_107
349613: , h1.TRANSFER_TO_GL_INDICATOR source_114
349614: , fvl114.meaning source_114_meaning
349615: FROM xla_events_gt xet
349616: , CST_XLA_RCV_HEADERS_V h1
349617: , CST_XLA_RCV_REF_V h3
349618: , PO_DISTS_REF_V h4
349619: , fnd_lookup_values fvl85
349668: , l2.RCV_ACCOUNTING_LINE_TYPE source_78
349669: , l2.DISTRIBUTION_IDENTIFIER source_84
349670: , l2.ENTERED_AMOUNT source_91
349671: , l2.ACCOUNTED_AMOUNT source_95
349672: FROM xla_events_gt xet
349673: , CST_XLA_RCV_LINES_V l2
349674: WHERE xet.event_id between x_first_event_id and x_last_event_id
349675: and xet.event_date between p_pad_start_date and p_pad_end_date
349676: and xet.event_class_code = C_EVENT_CLASS_CODE
350544: WHEN 6 THEN fvl114.meaning
350545:
350546: ELSE null
350547: END source_meaning
350548: FROM xla_events_gt xet
350549: , CST_XLA_RCV_HEADERS_V h1
350550: , CST_XLA_RCV_REF_V h3
350551: , PO_DISTS_REF_V h4
350552: , fnd_lookup_values fvl85
350674:
350675: ELSE null
350676: END source_value
350677: , null source_meaning
350678: FROM xla_events_gt xet
350679: , CST_XLA_RCV_LINES_V l2
350680: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
350681: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
350682: AND xet.event_class_code = C_EVENT_CLASS_CODE
350878: , h4.CURRENCY_CONVERSION_RATE source_107
350879: , h4.CURRENCY_CONVERSION_TYPE source_109
350880: , h1.TRANSFER_TO_GL_INDICATOR source_114
350881: , fvl114.meaning source_114_meaning
350882: FROM xla_events_gt xet
350883: , CST_XLA_RCV_HEADERS_V h1
350884: , CST_XLA_RCV_REF_V h3
350885: , PO_DISTS_REF_V h4
350886: , fnd_lookup_values fvl85
350935: , l2.RCV_ACCOUNTING_LINE_TYPE source_78
350936: , l2.DISTRIBUTION_IDENTIFIER source_84
350937: , l2.ENTERED_AMOUNT source_91
350938: , l2.ACCOUNTED_AMOUNT source_95
350939: FROM xla_events_gt xet
350940: , CST_XLA_RCV_LINES_V l2
350941: WHERE xet.event_id between x_first_event_id and x_last_event_id
350942: and xet.event_date between p_pad_start_date and p_pad_end_date
350943: and xet.event_class_code = C_EVENT_CLASS_CODE
351810: WHEN 16 THEN fvl114.meaning
351811:
351812: ELSE null
351813: END source_meaning
351814: FROM xla_events_gt xet
351815: , CST_XLA_INV_HEADERS_V h1
351816: , CST_XLA_INV_REF_V h3
351817: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
351818: , CST_XLA_INV_TXN_TYPES_REF_V h5
351987: ,707)
351988:
351989: ELSE null
351990: END source_meaning
351991: FROM xla_events_gt xet
351992: , CST_XLA_INV_LINES_V l2
351993: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
351994: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
351995: AND xet.event_type_code = C_EVENT_TYPE_CODE
352236: , h1.DISTRIBUTION_TYPE source_85
352237: , fvl85.meaning source_85_meaning
352238: , h1.TRANSFER_TO_GL_INDICATOR source_114
352239: , fvl114.meaning source_114_meaning
352240: FROM xla_events_gt xet
352241: , CST_XLA_INV_HEADERS_V h1
352242: , CST_XLA_INV_REF_V h3
352243: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
352244: , CST_XLA_INV_TXN_TYPES_REF_V h5
352308: , l2.CURRENCY_CONVERSION_TYPE source_94
352309: , l2.ACCOUNTED_AMOUNT source_95
352310: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
352311: , l2.L_ORGANIZATION_CODE source_108
352312: FROM xla_events_gt xet
352313: , CST_XLA_INV_LINES_V l2
352314: WHERE xet.event_id between x_first_event_id and x_last_event_id
352315: and xet.event_date between p_pad_start_date and p_pad_end_date
352316: and xet.event_type_code = C_EVENT_TYPE_CODE
353399: WHEN 13 THEN fvl114.meaning
353400:
353401: ELSE null
353402: END source_meaning
353403: FROM xla_events_gt xet
353404: , CST_XLA_INV_HEADERS_V h1
353405: , CST_XLA_INV_REF_V h3
353406: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
353407: , CST_XLA_INV_TXN_TYPES_REF_V h5
353576: ,707)
353577:
353578: ELSE null
353579: END source_meaning
353580: FROM xla_events_gt xet
353581: , CST_XLA_INV_LINES_V l2
353582: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
353583: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
353584: AND xet.event_type_code = C_EVENT_TYPE_CODE
353816: , h1.DISTRIBUTION_TYPE source_85
353817: , fvl85.meaning source_85_meaning
353818: , h1.TRANSFER_TO_GL_INDICATOR source_114
353819: , fvl114.meaning source_114_meaning
353820: FROM xla_events_gt xet
353821: , CST_XLA_INV_HEADERS_V h1
353822: , CST_XLA_INV_REF_V h3
353823: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
353824: , CST_XLA_INV_TXN_TYPES_REF_V h5
353888: , l2.CURRENCY_CONVERSION_TYPE source_94
353889: , l2.ACCOUNTED_AMOUNT source_95
353890: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
353891: , l2.L_ORGANIZATION_CODE source_108
353892: FROM xla_events_gt xet
353893: , CST_XLA_INV_LINES_V l2
353894: WHERE xet.event_id between x_first_event_id and x_last_event_id
353895: and xet.event_date between p_pad_start_date and p_pad_end_date
353896: and xet.event_type_code = C_EVENT_TYPE_CODE
354801: WHEN 13 THEN fvl114.meaning
354802:
354803: ELSE null
354804: END source_meaning
354805: FROM xla_events_gt xet
354806: , CST_XLA_INV_HEADERS_V h1
354807: , CST_XLA_INV_REF_V h3
354808: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
354809: , CST_XLA_INV_TXN_TYPES_REF_V h5
354978: ,707)
354979:
354980: ELSE null
354981: END source_meaning
354982: FROM xla_events_gt xet
354983: , CST_XLA_INV_LINES_V l2
354984: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
354985: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
354986: AND xet.event_type_code = C_EVENT_TYPE_CODE
355218: , h1.DISTRIBUTION_TYPE source_85
355219: , fvl85.meaning source_85_meaning
355220: , h1.TRANSFER_TO_GL_INDICATOR source_114
355221: , fvl114.meaning source_114_meaning
355222: FROM xla_events_gt xet
355223: , CST_XLA_INV_HEADERS_V h1
355224: , CST_XLA_INV_REF_V h3
355225: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
355226: , CST_XLA_INV_TXN_TYPES_REF_V h5
355290: , l2.CURRENCY_CONVERSION_TYPE source_94
355291: , l2.ACCOUNTED_AMOUNT source_95
355292: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
355293: , l2.L_ORGANIZATION_CODE source_108
355294: FROM xla_events_gt xet
355295: , CST_XLA_INV_LINES_V l2
355296: WHERE xet.event_id between x_first_event_id and x_last_event_id
355297: and xet.event_date between p_pad_start_date and p_pad_end_date
355298: and xet.event_type_code = C_EVENT_TYPE_CODE
356218: WHEN 16 THEN fvl114.meaning
356219:
356220: ELSE null
356221: END source_meaning
356222: FROM xla_events_gt xet
356223: , CST_XLA_INV_HEADERS_V h1
356224: , CST_XLA_INV_REF_V h3
356225: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
356226: , CST_XLA_INV_TXN_TYPES_REF_V h5
356395: ,707)
356396:
356397: ELSE null
356398: END source_meaning
356399: FROM xla_events_gt xet
356400: , CST_XLA_INV_LINES_V l2
356401: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
356402: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
356403: AND xet.event_type_code = C_EVENT_TYPE_CODE
356644: , h1.DISTRIBUTION_TYPE source_85
356645: , fvl85.meaning source_85_meaning
356646: , h1.TRANSFER_TO_GL_INDICATOR source_114
356647: , fvl114.meaning source_114_meaning
356648: FROM xla_events_gt xet
356649: , CST_XLA_INV_HEADERS_V h1
356650: , CST_XLA_INV_REF_V h3
356651: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
356652: , CST_XLA_INV_TXN_TYPES_REF_V h5
356716: , l2.CURRENCY_CONVERSION_TYPE source_94
356717: , l2.ACCOUNTED_AMOUNT source_95
356718: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
356719: , l2.L_ORGANIZATION_CODE source_108
356720: FROM xla_events_gt xet
356721: , CST_XLA_INV_LINES_V l2
356722: WHERE xet.event_id between x_first_event_id and x_last_event_id
356723: and xet.event_date between p_pad_start_date and p_pad_end_date
356724: and xet.event_type_code = C_EVENT_TYPE_CODE
357861: WHEN 24 THEN fvl114.meaning
357862:
357863: ELSE null
357864: END source_meaning
357865: FROM xla_events_gt xet
357866: , CST_XLA_INV_HEADERS_V h1
357867: , CST_XLA_INV_REF_V h3
357868: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
357869: , CST_XLA_INV_TXN_TYPES_REF_V h5
358036: ,707)
358037:
358038: ELSE null
358039: END source_meaning
358040: FROM xla_events_gt xet
358041: , CST_XLA_INV_LINES_V l2
358042: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
358043: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
358044: AND xet.event_type_code = C_EVENT_TYPE_CODE
358307: , h9.CST_ENCUM_UPG_OPTION source_100
358308: , h3.TXN_PO_DISTRIBUTION_ID source_101
358309: , h1.TRANSFER_TO_GL_INDICATOR source_114
358310: , fvl114.meaning source_114_meaning
358311: FROM xla_events_gt xet
358312: , CST_XLA_INV_HEADERS_V h1
358313: , CST_XLA_INV_REF_V h3
358314: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
358315: , CST_XLA_INV_TXN_TYPES_REF_V h5
358377: , l2.CURRENCY_CONVERSION_TYPE source_94
358378: , l2.ACCOUNTED_AMOUNT source_95
358379: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
358380: , l2.L_ORGANIZATION_CODE source_108
358381: FROM xla_events_gt xet
358382: , CST_XLA_INV_LINES_V l2
358383: WHERE xet.event_id between x_first_event_id and x_last_event_id
358384: and xet.event_date between p_pad_start_date and p_pad_end_date
358385: and xet.event_type_code = C_EVENT_TYPE_CODE
359736: WHEN 24 THEN fvl114.meaning
359737:
359738: ELSE null
359739: END source_meaning
359740: FROM xla_events_gt xet
359741: , CST_XLA_INV_HEADERS_V h1
359742: , CST_XLA_INV_REF_V h3
359743: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
359744: , CST_XLA_INV_TXN_TYPES_REF_V h5
359911: ,707)
359912:
359913: ELSE null
359914: END source_meaning
359915: FROM xla_events_gt xet
359916: , CST_XLA_INV_LINES_V l2
359917: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
359918: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
359919: AND xet.event_type_code = C_EVENT_TYPE_CODE
360182: , h9.CST_ENCUM_UPG_OPTION source_100
360183: , h3.TXN_PO_DISTRIBUTION_ID source_101
360184: , h1.TRANSFER_TO_GL_INDICATOR source_114
360185: , fvl114.meaning source_114_meaning
360186: FROM xla_events_gt xet
360187: , CST_XLA_INV_HEADERS_V h1
360188: , CST_XLA_INV_REF_V h3
360189: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
360190: , CST_XLA_INV_TXN_TYPES_REF_V h5
360252: , l2.CURRENCY_CONVERSION_TYPE source_94
360253: , l2.ACCOUNTED_AMOUNT source_95
360254: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
360255: , l2.L_ORGANIZATION_CODE source_108
360256: FROM xla_events_gt xet
360257: , CST_XLA_INV_LINES_V l2
360258: WHERE xet.event_id between x_first_event_id and x_last_event_id
360259: and xet.event_date between p_pad_start_date and p_pad_end_date
360260: and xet.event_type_code = C_EVENT_TYPE_CODE
361616: WHEN 25 THEN fvl114.meaning
361617:
361618: ELSE null
361619: END source_meaning
361620: FROM xla_events_gt xet
361621: , CST_XLA_INV_HEADERS_V h1
361622: , CST_XLA_INV_REF_V h3
361623: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
361624: , CST_XLA_INV_TXN_TYPES_REF_V h5
361791: ,707)
361792:
361793: ELSE null
361794: END source_meaning
361795: FROM xla_events_gt xet
361796: , CST_XLA_INV_LINES_V l2
361797: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
361798: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
361799: AND xet.event_type_code = C_EVENT_TYPE_CODE
362065: , h9.CST_ENCUM_UPG_OPTION source_100
362066: , h3.TXN_PO_DISTRIBUTION_ID source_101
362067: , h1.TRANSFER_TO_GL_INDICATOR source_114
362068: , fvl114.meaning source_114_meaning
362069: FROM xla_events_gt xet
362070: , CST_XLA_INV_HEADERS_V h1
362071: , CST_XLA_INV_REF_V h3
362072: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
362073: , CST_XLA_INV_TXN_TYPES_REF_V h5
362135: , l2.CURRENCY_CONVERSION_TYPE source_94
362136: , l2.ACCOUNTED_AMOUNT source_95
362137: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
362138: , l2.L_ORGANIZATION_CODE source_108
362139: FROM xla_events_gt xet
362140: , CST_XLA_INV_LINES_V l2
362141: WHERE xet.event_id between x_first_event_id and x_last_event_id
362142: and xet.event_date between p_pad_start_date and p_pad_end_date
362143: and xet.event_type_code = C_EVENT_TYPE_CODE
363436: WHEN 12 THEN fvl114.meaning
363437:
363438: ELSE null
363439: END source_meaning
363440: FROM xla_events_gt xet
363441: , CST_XLA_INV_HEADERS_V h1
363442: , CST_XLA_INV_REF_V h3
363443: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
363444: , CST_XLA_INV_TXN_TYPES_REF_V h5
363608: ,707)
363609:
363610: ELSE null
363611: END source_meaning
363612: FROM xla_events_gt xet
363613: , CST_XLA_INV_LINES_V l2
363614: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
363615: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
363616: AND xet.event_type_code = C_EVENT_TYPE_CODE
363843: , h1.DISTRIBUTION_TYPE source_85
363844: , fvl85.meaning source_85_meaning
363845: , h1.TRANSFER_TO_GL_INDICATOR source_114
363846: , fvl114.meaning source_114_meaning
363847: FROM xla_events_gt xet
363848: , CST_XLA_INV_HEADERS_V h1
363849: , CST_XLA_INV_REF_V h3
363850: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
363851: , CST_XLA_INV_TXN_TYPES_REF_V h5
363910: , l2.CURRENCY_CONVERSION_TYPE source_94
363911: , l2.ACCOUNTED_AMOUNT source_95
363912: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
363913: , l2.L_ORGANIZATION_CODE source_108
363914: FROM xla_events_gt xet
363915: , CST_XLA_INV_LINES_V l2
363916: WHERE xet.event_id between x_first_event_id and x_last_event_id
363917: and xet.event_date between p_pad_start_date and p_pad_end_date
363918: and xet.event_type_code = C_EVENT_TYPE_CODE
364879: WHEN 12 THEN fvl114.meaning
364880:
364881: ELSE null
364882: END source_meaning
364883: FROM xla_events_gt xet
364884: , CST_XLA_INV_HEADERS_V h1
364885: , CST_XLA_INV_REF_V h3
364886: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
364887: , CST_XLA_INV_TXN_TYPES_REF_V h5
365051: ,707)
365052:
365053: ELSE null
365054: END source_meaning
365055: FROM xla_events_gt xet
365056: , CST_XLA_INV_LINES_V l2
365057: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
365058: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
365059: AND xet.event_type_code = C_EVENT_TYPE_CODE
365286: , h1.DISTRIBUTION_TYPE source_85
365287: , fvl85.meaning source_85_meaning
365288: , h1.TRANSFER_TO_GL_INDICATOR source_114
365289: , fvl114.meaning source_114_meaning
365290: FROM xla_events_gt xet
365291: , CST_XLA_INV_HEADERS_V h1
365292: , CST_XLA_INV_REF_V h3
365293: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
365294: , CST_XLA_INV_TXN_TYPES_REF_V h5
365353: , l2.CURRENCY_CONVERSION_TYPE source_94
365354: , l2.ACCOUNTED_AMOUNT source_95
365355: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
365356: , l2.L_ORGANIZATION_CODE source_108
365357: FROM xla_events_gt xet
365358: , CST_XLA_INV_LINES_V l2
365359: WHERE xet.event_id between x_first_event_id and x_last_event_id
365360: and xet.event_date between p_pad_start_date and p_pad_end_date
365361: and xet.event_type_code = C_EVENT_TYPE_CODE
366229: WHEN 7 THEN fvl114.meaning
366230:
366231: ELSE null
366232: END source_meaning
366233: FROM xla_events_gt xet
366234: , CST_XLA_INV_HEADERS_V h1
366235: , CST_XLA_INV_REF_V h3
366236: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
366237: , CST_XLA_INV_TXN_TYPES_REF_V h5
366381:
366382: ELSE null
366383: END source_value
366384: , null source_meaning
366385: FROM xla_events_gt xet
366386: , CST_XLA_INV_LINES_V l2
366387: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
366388: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
366389: AND xet.event_class_code = C_EVENT_CLASS_CODE
366596: , h1.DISTRIBUTION_TYPE source_85
366597: , fvl85.meaning source_85_meaning
366598: , h1.TRANSFER_TO_GL_INDICATOR source_114
366599: , fvl114.meaning source_114_meaning
366600: FROM xla_events_gt xet
366601: , CST_XLA_INV_HEADERS_V h1
366602: , CST_XLA_INV_REF_V h3
366603: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
366604: , CST_XLA_INV_TXN_TYPES_REF_V h5
366659: , l2.CURRENCY_CONVERSION_RATE source_93
366660: , l2.CURRENCY_CONVERSION_TYPE source_94
366661: , l2.ACCOUNTED_AMOUNT source_95
366662: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
366663: FROM xla_events_gt xet
366664: , CST_XLA_INV_LINES_V l2
366665: WHERE xet.event_id between x_first_event_id and x_last_event_id
366666: and xet.event_date between p_pad_start_date and p_pad_end_date
366667: and xet.event_class_code = C_EVENT_CLASS_CODE
367532: WHEN 12 THEN fvl114.meaning
367533:
367534: ELSE null
367535: END source_meaning
367536: FROM xla_events_gt xet
367537: , CST_XLA_INV_HEADERS_V h1
367538: , CST_XLA_INV_REF_V h3
367539: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
367540: , CST_XLA_INV_TXN_TYPES_REF_V h5
367705: ,707)
367706:
367707: ELSE null
367708: END source_meaning
367709: FROM xla_events_gt xet
367710: , CST_XLA_INV_LINES_V l2
367711: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
367712: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
367713: AND xet.event_class_code = C_EVENT_CLASS_CODE
367939: , h1.DISTRIBUTION_TYPE source_85
367940: , fvl85.meaning source_85_meaning
367941: , h1.TRANSFER_TO_GL_INDICATOR source_114
367942: , fvl114.meaning source_114_meaning
367943: FROM xla_events_gt xet
367944: , CST_XLA_INV_HEADERS_V h1
367945: , CST_XLA_INV_REF_V h3
367946: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
367947: , CST_XLA_INV_TXN_TYPES_REF_V h5
368006: , l2.CURRENCY_CONVERSION_TYPE source_94
368007: , l2.ACCOUNTED_AMOUNT source_95
368008: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
368009: , l2.L_ORGANIZATION_CODE source_108
368010: FROM xla_events_gt xet
368011: , CST_XLA_INV_LINES_V l2
368012: WHERE xet.event_id between x_first_event_id and x_last_event_id
368013: and xet.event_date between p_pad_start_date and p_pad_end_date
368014: and xet.event_class_code = C_EVENT_CLASS_CODE
368953: WHEN 14 THEN fvl114.meaning
368954:
368955: ELSE null
368956: END source_meaning
368957: FROM xla_events_gt xet
368958: , CST_XLA_DISCRETE_JOB_REF_V h1
368959: , CST_XLA_FLOW_SCHEDULE_REF_V h2
368960: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h3
368961: , CST_XLA_REP_ITEM_REF_V h4
369095:
369096: ELSE null
369097: END source_value
369098: , null source_meaning
369099: FROM xla_events_gt xet
369100: , CST_XLA_WIP_LINES_V l7
369101: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
369102: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
369103: AND xet.event_type_code = C_EVENT_TYPE_CODE
369328: , h6.CURRENCY_CONVERSION_DATE source_92
369329: , h6.CURRENCY_CONVERSION_RATE source_93
369330: , h6.TRANSFER_TO_GL_INDICATOR source_114
369331: , fvl114.meaning source_114_meaning
369332: FROM xla_events_gt xet
369333: , CST_XLA_DISCRETE_JOB_REF_V h1
369334: , CST_XLA_FLOW_SCHEDULE_REF_V h2
369335: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h3
369336: , CST_XLA_REP_ITEM_REF_V h4
369398: , l7.DISTRIBUTION_IDENTIFIER source_84
369399: , l7.ENTERED_AMOUNT source_91
369400: , l7.ACCOUNTED_AMOUNT source_95
369401: , l7.ACCOUNTING_LINE_TYPE_CODE source_97
369402: FROM xla_events_gt xet
369403: , CST_XLA_WIP_LINES_V l7
369404: WHERE xet.event_id between x_first_event_id and x_last_event_id
369405: and xet.event_date between p_pad_start_date and p_pad_end_date
369406: and xet.event_type_code = C_EVENT_TYPE_CODE
370515: WHEN 16 THEN fvl114.meaning
370516:
370517: ELSE null
370518: END source_meaning
370519: FROM xla_events_gt xet
370520: , CST_XLA_RCV_HEADERS_V h1
370521: , CST_XLA_RCV_REF_V h3
370522: , PO_DISTS_REF_V h4
370523: , PO_HEADERS_REF_V h5
370647:
370648: ELSE null
370649: END source_value
370650: , null source_meaning
370651: FROM xla_events_gt xet
370652: , CST_XLA_RCV_LINES_V l2
370653: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
370654: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
370655: AND xet.event_class_code = C_EVENT_CLASS_CODE
370881: , h1.CURRENCY_CONVERSION_TYPE source_94
370882: , h5.PURCH_ENCUMBRANCE_TYPE_ID source_96
370883: , h1.TRANSFER_TO_GL_INDICATOR source_114
370884: , fvl114.meaning source_114_meaning
370885: FROM xla_events_gt xet
370886: , CST_XLA_RCV_HEADERS_V h1
370887: , CST_XLA_RCV_REF_V h3
370888: , PO_DISTS_REF_V h4
370889: , PO_HEADERS_REF_V h5
370940: , l2.RCV_ACCOUNTING_LINE_TYPE source_78
370941: , l2.DISTRIBUTION_IDENTIFIER source_84
370942: , l2.ENTERED_AMOUNT source_91
370943: , l2.ACCOUNTED_AMOUNT source_95
370944: FROM xla_events_gt xet
370945: , CST_XLA_RCV_LINES_V l2
370946: WHERE xet.event_id between x_first_event_id and x_last_event_id
370947: and xet.event_date between p_pad_start_date and p_pad_end_date
370948: and xet.event_class_code = C_EVENT_CLASS_CODE
371947: WHEN 25 THEN fvl114.meaning
371948:
371949: ELSE null
371950: END source_meaning
371951: FROM xla_events_gt xet
371952: , CST_XLA_INV_HEADERS_V h1
371953: , CST_XLA_INV_ORG_PARAMS_REF_V h3
371954: , CST_XLA_INV_REF_V h4
371955: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
372129: WHEN 12 THEN fvl110.meaning
372130:
372131: ELSE null
372132: END source_meaning
372133: FROM xla_events_gt xet
372134: , CST_XLA_INV_LINES_V l2
372135: , CST_XLA_INV_SEC_INVS_REF_V l5
372136: , fnd_lookup_values fvl110
372137: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
372412: , h11.CST_ENCUM_UPG_OPTION source_100
372413: , h4.TXN_PO_DISTRIBUTION_ID source_101
372414: , h1.TRANSFER_TO_GL_INDICATOR source_114
372415: , fvl114.meaning source_114_meaning
372416: FROM xla_events_gt xet
372417: , CST_XLA_INV_HEADERS_V h1
372418: , CST_XLA_INV_ORG_PARAMS_REF_V h3
372419: , CST_XLA_INV_REF_V h4
372420: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
372485: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
372486: , l2.L_ORGANIZATION_CODE source_108
372487: , l5.ASSET_INVENTORY source_110
372488: , fvl110.meaning source_110_meaning
372489: FROM xla_events_gt xet
372490: , CST_XLA_INV_LINES_V l2
372491: , CST_XLA_INV_SEC_INVS_REF_V l5
372492: , fnd_lookup_values fvl110
372493: WHERE xet.event_id between x_first_event_id and x_last_event_id
373868: WHEN 26 THEN fvl114.meaning
373869:
373870: ELSE null
373871: END source_meaning
373872: FROM xla_events_gt xet
373873: , CST_XLA_INV_HEADERS_V h1
373874: , CST_XLA_INV_ORG_PARAMS_REF_V h3
373875: , CST_XLA_INV_REF_V h4
373876: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
374050: WHEN 12 THEN fvl110.meaning
374051:
374052: ELSE null
374053: END source_meaning
374054: FROM xla_events_gt xet
374055: , CST_XLA_INV_LINES_V l2
374056: , CST_XLA_INV_SEC_INVS_REF_V l5
374057: , fnd_lookup_values fvl110
374058: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
374336: , h11.CST_ENCUM_UPG_OPTION source_100
374337: , h4.TXN_PO_DISTRIBUTION_ID source_101
374338: , h1.TRANSFER_TO_GL_INDICATOR source_114
374339: , fvl114.meaning source_114_meaning
374340: FROM xla_events_gt xet
374341: , CST_XLA_INV_HEADERS_V h1
374342: , CST_XLA_INV_ORG_PARAMS_REF_V h3
374343: , CST_XLA_INV_REF_V h4
374344: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
374409: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
374410: , l2.L_ORGANIZATION_CODE source_108
374411: , l5.ASSET_INVENTORY source_110
374412: , fvl110.meaning source_110_meaning
374413: FROM xla_events_gt xet
374414: , CST_XLA_INV_LINES_V l2
374415: , CST_XLA_INV_SEC_INVS_REF_V l5
374416: , fnd_lookup_values fvl110
374417: WHERE xet.event_id between x_first_event_id and x_last_event_id
375694: WHEN 6 THEN fvl114.meaning
375695:
375696: ELSE null
375697: END source_meaning
375698: FROM xla_events_gt xet
375699: , CST_XLA_RCV_HEADERS_V h1
375700: , fnd_lookup_values fvl85
375701: , fnd_lookup_values fvl114
375702: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
375822:
375823: ELSE null
375824: END source_value
375825: , null source_meaning
375826: FROM xla_events_gt xet
375827: , CST_XLA_RCV_LINES_V l2
375828: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
375829: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
375830: AND xet.event_class_code = C_EVENT_CLASS_CODE
376026: , h1.CURRENCY_CONVERSION_RATE source_93
376027: , h1.CURRENCY_CONVERSION_TYPE source_94
376028: , h1.TRANSFER_TO_GL_INDICATOR source_114
376029: , fvl114.meaning source_114_meaning
376030: FROM xla_events_gt xet
376031: , CST_XLA_RCV_HEADERS_V h1
376032: , fnd_lookup_values fvl85
376033: , fnd_lookup_values fvl114
376034: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
376081: , l2.RCV_ACCOUNTING_LINE_TYPE source_78
376082: , l2.DISTRIBUTION_IDENTIFIER source_84
376083: , l2.ENTERED_AMOUNT source_91
376084: , l2.ACCOUNTED_AMOUNT source_95
376085: FROM xla_events_gt xet
376086: , CST_XLA_RCV_LINES_V l2
376087: WHERE xet.event_id between x_first_event_id and x_last_event_id
376088: and xet.event_date between p_pad_start_date and p_pad_end_date
376089: and xet.event_class_code = C_EVENT_CLASS_CODE
377026: WHEN 7 THEN fvl114.meaning
377027:
377028: ELSE null
377029: END source_meaning
377030: FROM xla_events_gt xet
377031: , CST_XLA_INV_HEADERS_V h1
377032: , CST_XLA_INV_REF_V h3
377033: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
377034: , CST_XLA_INV_TXN_TYPES_REF_V h5
377178:
377179: ELSE null
377180: END source_value
377181: , null source_meaning
377182: FROM xla_events_gt xet
377183: , CST_XLA_INV_LINES_V l2
377184: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
377185: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
377186: AND xet.event_class_code = C_EVENT_CLASS_CODE
377393: , h1.DISTRIBUTION_TYPE source_85
377394: , fvl85.meaning source_85_meaning
377395: , h1.TRANSFER_TO_GL_INDICATOR source_114
377396: , fvl114.meaning source_114_meaning
377397: FROM xla_events_gt xet
377398: , CST_XLA_INV_HEADERS_V h1
377399: , CST_XLA_INV_REF_V h3
377400: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
377401: , CST_XLA_INV_TXN_TYPES_REF_V h5
377456: , l2.CURRENCY_CONVERSION_RATE source_93
377457: , l2.CURRENCY_CONVERSION_TYPE source_94
377458: , l2.ACCOUNTED_AMOUNT source_95
377459: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
377460: FROM xla_events_gt xet
377461: , CST_XLA_INV_LINES_V l2
377462: WHERE xet.event_id between x_first_event_id and x_last_event_id
377463: and xet.event_date between p_pad_start_date and p_pad_end_date
377464: and xet.event_class_code = C_EVENT_CLASS_CODE
378294: WHEN 5 THEN fvl114.meaning
378295:
378296: ELSE null
378297: END source_meaning
378298: FROM xla_events_gt xet
378299: , CST_XLA_RCV_HEADERS_V h1
378300: , fnd_lookup_values fvl85
378301: , fnd_lookup_values fvl114
378302: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
378422:
378423: ELSE null
378424: END source_value
378425: , null source_meaning
378426: FROM xla_events_gt xet
378427: , CST_XLA_RCV_LINES_V l2
378428: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
378429: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
378430: AND xet.event_class_code = C_EVENT_CLASS_CODE
378623: , h1.CURRENCY_CONVERSION_DATE source_92
378624: , h1.CURRENCY_CONVERSION_RATE source_93
378625: , h1.TRANSFER_TO_GL_INDICATOR source_114
378626: , fvl114.meaning source_114_meaning
378627: FROM xla_events_gt xet
378628: , CST_XLA_RCV_HEADERS_V h1
378629: , fnd_lookup_values fvl85
378630: , fnd_lookup_values fvl114
378631: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
378678: , l2.RCV_ACCOUNTING_LINE_TYPE source_78
378679: , l2.DISTRIBUTION_IDENTIFIER source_84
378680: , l2.ENTERED_AMOUNT source_91
378681: , l2.ACCOUNTED_AMOUNT source_95
378682: FROM xla_events_gt xet
378683: , CST_XLA_RCV_LINES_V l2
378684: WHERE xet.event_id between x_first_event_id and x_last_event_id
378685: and xet.event_date between p_pad_start_date and p_pad_end_date
378686: and xet.event_class_code = C_EVENT_CLASS_CODE
379526: WHEN 6 THEN fvl114.meaning
379527:
379528: ELSE null
379529: END source_meaning
379530: FROM xla_events_gt xet
379531: , CST_XLA_RCV_HEADERS_V h1
379532: , fnd_lookup_values fvl85
379533: , fnd_lookup_values fvl114
379534: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
379654:
379655: ELSE null
379656: END source_value
379657: , null source_meaning
379658: FROM xla_events_gt xet
379659: , CST_XLA_RCV_LINES_V l2
379660: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
379661: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
379662: AND xet.event_class_code = C_EVENT_CLASS_CODE
379858: , h1.CURRENCY_CONVERSION_RATE source_93
379859: , h1.CURRENCY_CONVERSION_TYPE source_94
379860: , h1.TRANSFER_TO_GL_INDICATOR source_114
379861: , fvl114.meaning source_114_meaning
379862: FROM xla_events_gt xet
379863: , CST_XLA_RCV_HEADERS_V h1
379864: , fnd_lookup_values fvl85
379865: , fnd_lookup_values fvl114
379866: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
379913: , l2.RCV_ACCOUNTING_LINE_TYPE source_78
379914: , l2.DISTRIBUTION_IDENTIFIER source_84
379915: , l2.ENTERED_AMOUNT source_91
379916: , l2.ACCOUNTED_AMOUNT source_95
379917: FROM xla_events_gt xet
379918: , CST_XLA_RCV_LINES_V l2
379919: WHERE xet.event_id between x_first_event_id and x_last_event_id
379920: and xet.event_date between p_pad_start_date and p_pad_end_date
379921: and xet.event_class_code = C_EVENT_CLASS_CODE
380890: WHEN 25 THEN fvl114.meaning
380891:
380892: ELSE null
380893: END source_meaning
380894: FROM xla_events_gt xet
380895: , CST_XLA_INV_HEADERS_V h1
380896: , CST_XLA_INV_ORG_PARAMS_REF_V h3
380897: , CST_XLA_INV_REF_V h4
380898: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
381072: WHEN 12 THEN fvl110.meaning
381073:
381074: ELSE null
381075: END source_meaning
381076: FROM xla_events_gt xet
381077: , CST_XLA_INV_LINES_V l2
381078: , CST_XLA_INV_SEC_INVS_REF_V l5
381079: , fnd_lookup_values fvl110
381080: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
381355: , h11.CST_ENCUM_UPG_OPTION source_100
381356: , h4.TXN_PO_DISTRIBUTION_ID source_101
381357: , h1.TRANSFER_TO_GL_INDICATOR source_114
381358: , fvl114.meaning source_114_meaning
381359: FROM xla_events_gt xet
381360: , CST_XLA_INV_HEADERS_V h1
381361: , CST_XLA_INV_ORG_PARAMS_REF_V h3
381362: , CST_XLA_INV_REF_V h4
381363: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
381428: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
381429: , l2.L_ORGANIZATION_CODE source_108
381430: , l5.ASSET_INVENTORY source_110
381431: , fvl110.meaning source_110_meaning
381432: FROM xla_events_gt xet
381433: , CST_XLA_INV_LINES_V l2
381434: , CST_XLA_INV_SEC_INVS_REF_V l5
381435: , fnd_lookup_values fvl110
381436: WHERE xet.event_id between x_first_event_id and x_last_event_id
382741: WHEN 12 THEN fvl114.meaning
382742:
382743: ELSE null
382744: END source_meaning
382745: FROM xla_events_gt xet
382746: , CST_XLA_INV_HEADERS_V h1
382747: , CST_XLA_INV_REF_V h3
382748: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
382749: , CST_XLA_INV_TXN_TYPES_REF_V h5
382913: ,707)
382914:
382915: ELSE null
382916: END source_meaning
382917: FROM xla_events_gt xet
382918: , CST_XLA_INV_LINES_V l2
382919: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
382920: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
382921: AND xet.event_type_code = C_EVENT_TYPE_CODE
383148: , h1.DISTRIBUTION_TYPE source_85
383149: , fvl85.meaning source_85_meaning
383150: , h1.TRANSFER_TO_GL_INDICATOR source_114
383151: , fvl114.meaning source_114_meaning
383152: FROM xla_events_gt xet
383153: , CST_XLA_INV_HEADERS_V h1
383154: , CST_XLA_INV_REF_V h3
383155: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
383156: , CST_XLA_INV_TXN_TYPES_REF_V h5
383215: , l2.CURRENCY_CONVERSION_TYPE source_94
383216: , l2.ACCOUNTED_AMOUNT source_95
383217: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
383218: , l2.L_ORGANIZATION_CODE source_108
383219: FROM xla_events_gt xet
383220: , CST_XLA_INV_LINES_V l2
383221: WHERE xet.event_id between x_first_event_id and x_last_event_id
383222: and xet.event_date between p_pad_start_date and p_pad_end_date
383223: and xet.event_type_code = C_EVENT_TYPE_CODE
384218: WHEN 12 THEN fvl114.meaning
384219:
384220: ELSE null
384221: END source_meaning
384222: FROM xla_events_gt xet
384223: , CST_XLA_INV_HEADERS_V h1
384224: , CST_XLA_INV_REF_V h3
384225: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
384226: , CST_XLA_INV_TXN_TYPES_REF_V h5
384390: ,707)
384391:
384392: ELSE null
384393: END source_meaning
384394: FROM xla_events_gt xet
384395: , CST_XLA_INV_LINES_V l2
384396: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
384397: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
384398: AND xet.event_type_code = C_EVENT_TYPE_CODE
384625: , h1.DISTRIBUTION_TYPE source_85
384626: , fvl85.meaning source_85_meaning
384627: , h1.TRANSFER_TO_GL_INDICATOR source_114
384628: , fvl114.meaning source_114_meaning
384629: FROM xla_events_gt xet
384630: , CST_XLA_INV_HEADERS_V h1
384631: , CST_XLA_INV_REF_V h3
384632: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
384633: , CST_XLA_INV_TXN_TYPES_REF_V h5
384692: , l2.CURRENCY_CONVERSION_TYPE source_94
384693: , l2.ACCOUNTED_AMOUNT source_95
384694: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
384695: , l2.L_ORGANIZATION_CODE source_108
384696: FROM xla_events_gt xet
384697: , CST_XLA_INV_LINES_V l2
384698: WHERE xet.event_id between x_first_event_id and x_last_event_id
384699: and xet.event_date between p_pad_start_date and p_pad_end_date
384700: and xet.event_type_code = C_EVENT_TYPE_CODE
385682: WHEN 12 THEN fvl114.meaning
385683:
385684: ELSE null
385685: END source_meaning
385686: FROM xla_events_gt xet
385687: , CST_XLA_INV_HEADERS_V h1
385688: , CST_XLA_INV_REF_V h3
385689: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
385690: , CST_XLA_INV_TXN_TYPES_REF_V h5
385854: ,707)
385855:
385856: ELSE null
385857: END source_meaning
385858: FROM xla_events_gt xet
385859: , CST_XLA_INV_LINES_V l2
385860: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
385861: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
385862: AND xet.event_type_code = C_EVENT_TYPE_CODE
386089: , h1.DISTRIBUTION_TYPE source_85
386090: , fvl85.meaning source_85_meaning
386091: , h1.TRANSFER_TO_GL_INDICATOR source_114
386092: , fvl114.meaning source_114_meaning
386093: FROM xla_events_gt xet
386094: , CST_XLA_INV_HEADERS_V h1
386095: , CST_XLA_INV_REF_V h3
386096: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
386097: , CST_XLA_INV_TXN_TYPES_REF_V h5
386156: , l2.CURRENCY_CONVERSION_TYPE source_94
386157: , l2.ACCOUNTED_AMOUNT source_95
386158: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
386159: , l2.L_ORGANIZATION_CODE source_108
386160: FROM xla_events_gt xet
386161: , CST_XLA_INV_LINES_V l2
386162: WHERE xet.event_id between x_first_event_id and x_last_event_id
386163: and xet.event_date between p_pad_start_date and p_pad_end_date
386164: and xet.event_type_code = C_EVENT_TYPE_CODE
387165: WHEN 13 THEN fvl114.meaning
387166:
387167: ELSE null
387168: END source_meaning
387169: FROM xla_events_gt xet
387170: , CST_XLA_INV_HEADERS_V h1
387171: , CST_XLA_INV_ORG_PARAMS_REF_V h3
387172: , CST_XLA_INV_REF_V h4
387173: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
387343: ,707)
387344:
387345: ELSE null
387346: END source_meaning
387347: FROM xla_events_gt xet
387348: , CST_XLA_INV_LINES_V l2
387349: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
387350: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
387351: AND xet.event_type_code = C_EVENT_TYPE_CODE
387583: , h1.DISTRIBUTION_TYPE source_85
387584: , fvl85.meaning source_85_meaning
387585: , h1.TRANSFER_TO_GL_INDICATOR source_114
387586: , fvl114.meaning source_114_meaning
387587: FROM xla_events_gt xet
387588: , CST_XLA_INV_HEADERS_V h1
387589: , CST_XLA_INV_ORG_PARAMS_REF_V h3
387590: , CST_XLA_INV_REF_V h4
387591: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
387656: , l2.CURRENCY_CONVERSION_TYPE source_94
387657: , l2.ACCOUNTED_AMOUNT source_95
387658: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
387659: , l2.L_ORGANIZATION_CODE source_108
387660: FROM xla_events_gt xet
387661: , CST_XLA_INV_LINES_V l2
387662: WHERE xet.event_id between x_first_event_id and x_last_event_id
387663: and xet.event_date between p_pad_start_date and p_pad_end_date
387664: and xet.event_type_code = C_EVENT_TYPE_CODE
388672: WHEN 19 THEN fvl114.meaning
388673:
388674: ELSE null
388675: END source_meaning
388676: FROM xla_events_gt xet
388677: , CST_XLA_INV_HEADERS_V h1
388678: , CST_XLA_INV_REF_V h3
388679: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
388680: , CST_XLA_INV_TXN_TYPES_REF_V h5
388842: ,707)
388843:
388844: ELSE null
388845: END source_meaning
388846: FROM xla_events_gt xet
388847: , CST_XLA_INV_LINES_V l2
388848: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
388849: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
388850: AND xet.event_type_code = C_EVENT_TYPE_CODE
389098: , h1.DISTRIBUTION_TYPE source_85
389099: , fvl85.meaning source_85_meaning
389100: , h1.TRANSFER_TO_GL_INDICATOR source_114
389101: , fvl114.meaning source_114_meaning
389102: FROM xla_events_gt xet
389103: , CST_XLA_INV_HEADERS_V h1
389104: , CST_XLA_INV_REF_V h3
389105: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
389106: , CST_XLA_INV_TXN_TYPES_REF_V h5
389163: , l2.CURRENCY_CONVERSION_TYPE source_94
389164: , l2.ACCOUNTED_AMOUNT source_95
389165: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
389166: , l2.L_ORGANIZATION_CODE source_108
389167: FROM xla_events_gt xet
389168: , CST_XLA_INV_LINES_V l2
389169: WHERE xet.event_id between x_first_event_id and x_last_event_id
389170: and xet.event_date between p_pad_start_date and p_pad_end_date
389171: and xet.event_type_code = C_EVENT_TYPE_CODE
390218: WHEN 21 THEN fvl114.meaning
390219:
390220: ELSE null
390221: END source_meaning
390222: FROM xla_events_gt xet
390223: , CST_XLA_INV_HEADERS_V h1
390224: , CST_XLA_INV_REF_V h3
390225: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
390226: , CST_XLA_INV_TXN_TYPES_REF_V h5
390400: ,707)
390401:
390402: ELSE null
390403: END source_meaning
390404: FROM xla_events_gt xet
390405: , CST_XLA_INV_LINES_V l2
390406: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
390407: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
390408: AND xet.event_type_code = C_EVENT_TYPE_CODE
390664: , h1.DISTRIBUTION_TYPE source_85
390665: , fvl85.meaning source_85_meaning
390666: , h1.TRANSFER_TO_GL_INDICATOR source_114
390667: , fvl114.meaning source_114_meaning
390668: FROM xla_events_gt xet
390669: , CST_XLA_INV_HEADERS_V h1
390670: , CST_XLA_INV_REF_V h3
390671: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
390672: , CST_XLA_INV_TXN_TYPES_REF_V h5
390731: , l2.CURRENCY_CONVERSION_TYPE source_94
390732: , l2.ACCOUNTED_AMOUNT source_95
390733: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
390734: , l2.L_ORGANIZATION_CODE source_108
390735: FROM xla_events_gt xet
390736: , CST_XLA_INV_LINES_V l2
390737: WHERE xet.event_id between x_first_event_id and x_last_event_id
390738: and xet.event_date between p_pad_start_date and p_pad_end_date
390739: and xet.event_type_code = C_EVENT_TYPE_CODE
391778: WHEN 16 THEN fvl114.meaning
391779:
391780: ELSE null
391781: END source_meaning
391782: FROM xla_events_gt xet
391783: , CST_XLA_INTERORG_PARAMS_REF_V h1
391784: , CST_XLA_INV_HEADERS_V h2
391785: , CST_XLA_INV_REF_V h4
391786: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
391950: ,707)
391951:
391952: ELSE null
391953: END source_meaning
391954: FROM xla_events_gt xet
391955: , CST_XLA_INV_LINES_V l3
391956: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
391957: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
391958: AND xet.event_type_code = C_EVENT_TYPE_CODE
392197: , h2.DISTRIBUTION_TYPE source_85
392198: , fvl85.meaning source_85_meaning
392199: , h2.TRANSFER_TO_GL_INDICATOR source_114
392200: , fvl114.meaning source_114_meaning
392201: FROM xla_events_gt xet
392202: , CST_XLA_INTERORG_PARAMS_REF_V h1
392203: , CST_XLA_INV_HEADERS_V h2
392204: , CST_XLA_INV_REF_V h4
392205: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
392264: , l3.CURRENCY_CONVERSION_TYPE source_94
392265: , l3.ACCOUNTED_AMOUNT source_95
392266: , l3.ACCOUNTING_LINE_TYPE_CODE source_97
392267: , l3.L_ORGANIZATION_CODE source_108
392268: FROM xla_events_gt xet
392269: , CST_XLA_INV_LINES_V l3
392270: WHERE xet.event_id between x_first_event_id and x_last_event_id
392271: and xet.event_date between p_pad_start_date and p_pad_end_date
392272: and xet.event_type_code = C_EVENT_TYPE_CODE
393461: WHEN 11 THEN fvl114.meaning
393462:
393463: ELSE null
393464: END source_meaning
393465: FROM xla_events_gt xet
393466: , CST_XLA_INTERORG_PARAMS_REF_V h1
393467: , CST_XLA_INV_HEADERS_V h2
393468: , CST_XLA_PLA_CATEGORY_REF_V h4
393469: , fnd_lookup_values fvl85
393630: ,707)
393631:
393632: ELSE null
393633: END source_meaning
393634: FROM xla_events_gt xet
393635: , CST_XLA_INV_LINES_V l3
393636: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
393637: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
393638: AND xet.event_type_code = C_EVENT_TYPE_CODE
393862: , h2.DISTRIBUTION_TYPE source_85
393863: , fvl85.meaning source_85_meaning
393864: , h2.TRANSFER_TO_GL_INDICATOR source_114
393865: , fvl114.meaning source_114_meaning
393866: FROM xla_events_gt xet
393867: , CST_XLA_INTERORG_PARAMS_REF_V h1
393868: , CST_XLA_INV_HEADERS_V h2
393869: , CST_XLA_PLA_CATEGORY_REF_V h4
393870: , fnd_lookup_values fvl85
393926: , l3.CURRENCY_CONVERSION_TYPE source_94
393927: , l3.ACCOUNTED_AMOUNT source_95
393928: , l3.ACCOUNTING_LINE_TYPE_CODE source_97
393929: , l3.L_ORGANIZATION_CODE source_108
393930: FROM xla_events_gt xet
393931: , CST_XLA_INV_LINES_V l3
393932: WHERE xet.event_id between x_first_event_id and x_last_event_id
393933: and xet.event_date between p_pad_start_date and p_pad_end_date
393934: and xet.event_type_code = C_EVENT_TYPE_CODE
395083: WHEN 16 THEN fvl114.meaning
395084:
395085: ELSE null
395086: END source_meaning
395087: FROM xla_events_gt xet
395088: , CST_XLA_INTERORG_PARAMS_REF_V h1
395089: , CST_XLA_INV_HEADERS_V h2
395090: , CST_XLA_INV_REF_V h4
395091: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
395255: ,707)
395256:
395257: ELSE null
395258: END source_meaning
395259: FROM xla_events_gt xet
395260: , CST_XLA_INV_LINES_V l3
395261: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
395262: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
395263: AND xet.event_type_code = C_EVENT_TYPE_CODE
395502: , h2.DISTRIBUTION_TYPE source_85
395503: , fvl85.meaning source_85_meaning
395504: , h2.TRANSFER_TO_GL_INDICATOR source_114
395505: , fvl114.meaning source_114_meaning
395506: FROM xla_events_gt xet
395507: , CST_XLA_INTERORG_PARAMS_REF_V h1
395508: , CST_XLA_INV_HEADERS_V h2
395509: , CST_XLA_INV_REF_V h4
395510: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
395569: , l3.CURRENCY_CONVERSION_TYPE source_94
395570: , l3.ACCOUNTED_AMOUNT source_95
395571: , l3.ACCOUNTING_LINE_TYPE_CODE source_97
395572: , l3.L_ORGANIZATION_CODE source_108
395573: FROM xla_events_gt xet
395574: , CST_XLA_INV_LINES_V l3
395575: WHERE xet.event_id between x_first_event_id and x_last_event_id
395576: and xet.event_date between p_pad_start_date and p_pad_end_date
395577: and xet.event_type_code = C_EVENT_TYPE_CODE
396806: WHEN 19 THEN fvl114.meaning
396807:
396808: ELSE null
396809: END source_meaning
396810: FROM xla_events_gt xet
396811: , CST_XLA_INTERORG_PARAMS_REF_V h1
396812: , CST_XLA_INV_HEADERS_V h2
396813: , CST_XLA_INV_ORG_PARAMS_REF_V h4
396814: , CST_XLA_INV_REF_V h5
396979: ,707)
396980:
396981: ELSE null
396982: END source_meaning
396983: FROM xla_events_gt xet
396984: , CST_XLA_INV_LINES_V l3
396985: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
396986: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
396987: AND xet.event_type_code = C_EVENT_TYPE_CODE
397235: , h2.DISTRIBUTION_TYPE source_85
397236: , fvl85.meaning source_85_meaning
397237: , h2.TRANSFER_TO_GL_INDICATOR source_114
397238: , fvl114.meaning source_114_meaning
397239: FROM xla_events_gt xet
397240: , CST_XLA_INTERORG_PARAMS_REF_V h1
397241: , CST_XLA_INV_HEADERS_V h2
397242: , CST_XLA_INV_ORG_PARAMS_REF_V h4
397243: , CST_XLA_INV_REF_V h5
397303: , l3.CURRENCY_CONVERSION_TYPE source_94
397304: , l3.ACCOUNTED_AMOUNT source_95
397305: , l3.ACCOUNTING_LINE_TYPE_CODE source_97
397306: , l3.L_ORGANIZATION_CODE source_108
397307: FROM xla_events_gt xet
397308: , CST_XLA_INV_LINES_V l3
397309: WHERE xet.event_id between x_first_event_id and x_last_event_id
397310: and xet.event_date between p_pad_start_date and p_pad_end_date
397311: and xet.event_type_code = C_EVENT_TYPE_CODE
398541: WHEN 18 THEN fvl114.meaning
398542:
398543: ELSE null
398544: END source_meaning
398545: FROM xla_events_gt xet
398546: , CST_XLA_INTERORG_PARAMS_REF_V h1
398547: , CST_XLA_INV_HEADERS_V h2
398548: , CST_XLA_INV_REF_V h4
398549: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
398713: ,707)
398714:
398715: ELSE null
398716: END source_meaning
398717: FROM xla_events_gt xet
398718: , CST_XLA_INV_LINES_V l3
398719: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
398720: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
398721: AND xet.event_type_code = C_EVENT_TYPE_CODE
398966: , h2.DISTRIBUTION_TYPE source_85
398967: , fvl85.meaning source_85_meaning
398968: , h2.TRANSFER_TO_GL_INDICATOR source_114
398969: , fvl114.meaning source_114_meaning
398970: FROM xla_events_gt xet
398971: , CST_XLA_INTERORG_PARAMS_REF_V h1
398972: , CST_XLA_INV_HEADERS_V h2
398973: , CST_XLA_INV_REF_V h4
398974: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
399033: , l3.CURRENCY_CONVERSION_TYPE source_94
399034: , l3.ACCOUNTED_AMOUNT source_95
399035: , l3.ACCOUNTING_LINE_TYPE_CODE source_97
399036: , l3.L_ORGANIZATION_CODE source_108
399037: FROM xla_events_gt xet
399038: , CST_XLA_INV_LINES_V l3
399039: WHERE xet.event_id between x_first_event_id and x_last_event_id
399040: and xet.event_date between p_pad_start_date and p_pad_end_date
399041: and xet.event_type_code = C_EVENT_TYPE_CODE
400240: WHEN 19 THEN fvl114.meaning
400241:
400242: ELSE null
400243: END source_meaning
400244: FROM xla_events_gt xet
400245: , CST_XLA_INTERORG_PARAMS_REF_V h1
400246: , CST_XLA_INV_HEADERS_V h2
400247: , CST_XLA_INV_ORG_PARAMS_REF_V h4
400248: , CST_XLA_INV_REF_V h5
400413: ,707)
400414:
400415: ELSE null
400416: END source_meaning
400417: FROM xla_events_gt xet
400418: , CST_XLA_INV_LINES_V l3
400419: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
400420: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
400421: AND xet.event_type_code = C_EVENT_TYPE_CODE
400669: , h2.DISTRIBUTION_TYPE source_85
400670: , fvl85.meaning source_85_meaning
400671: , h2.TRANSFER_TO_GL_INDICATOR source_114
400672: , fvl114.meaning source_114_meaning
400673: FROM xla_events_gt xet
400674: , CST_XLA_INTERORG_PARAMS_REF_V h1
400675: , CST_XLA_INV_HEADERS_V h2
400676: , CST_XLA_INV_ORG_PARAMS_REF_V h4
400677: , CST_XLA_INV_REF_V h5
400737: , l3.CURRENCY_CONVERSION_TYPE source_94
400738: , l3.ACCOUNTED_AMOUNT source_95
400739: , l3.ACCOUNTING_LINE_TYPE_CODE source_97
400740: , l3.L_ORGANIZATION_CODE source_108
400741: FROM xla_events_gt xet
400742: , CST_XLA_INV_LINES_V l3
400743: WHERE xet.event_id between x_first_event_id and x_last_event_id
400744: and xet.event_date between p_pad_start_date and p_pad_end_date
400745: and xet.event_type_code = C_EVENT_TYPE_CODE
401961: WHEN 15 THEN fvl114.meaning
401962:
401963: ELSE null
401964: END source_meaning
401965: FROM xla_events_gt xet
401966: , CST_XLA_INTERORG_PARAMS_REF_V h1
401967: , CST_XLA_INV_HEADERS_V h2
401968: , CST_XLA_INV_ORG_PARAMS_REF_V h4
401969: , CST_XLA_INV_REF_V h5
402139: ,707)
402140:
402141: ELSE null
402142: END source_meaning
402143: FROM xla_events_gt xet
402144: , CST_XLA_INV_LINES_V l3
402145: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
402146: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
402147: AND xet.event_type_code = C_EVENT_TYPE_CODE
402385: , h2.DISTRIBUTION_TYPE source_85
402386: , fvl85.meaning source_85_meaning
402387: , h2.TRANSFER_TO_GL_INDICATOR source_114
402388: , fvl114.meaning source_114_meaning
402389: FROM xla_events_gt xet
402390: , CST_XLA_INTERORG_PARAMS_REF_V h1
402391: , CST_XLA_INV_HEADERS_V h2
402392: , CST_XLA_INV_ORG_PARAMS_REF_V h4
402393: , CST_XLA_INV_REF_V h5
402458: , l3.CURRENCY_CONVERSION_TYPE source_94
402459: , l3.ACCOUNTED_AMOUNT source_95
402460: , l3.ACCOUNTING_LINE_TYPE_CODE source_97
402461: , l3.L_ORGANIZATION_CODE source_108
402462: FROM xla_events_gt xet
402463: , CST_XLA_INV_LINES_V l3
402464: WHERE xet.event_id between x_first_event_id and x_last_event_id
402465: and xet.event_date between p_pad_start_date and p_pad_end_date
402466: and xet.event_type_code = C_EVENT_TYPE_CODE
403495: WHEN 18 THEN fvl114.meaning
403496:
403497: ELSE null
403498: END source_meaning
403499: FROM xla_events_gt xet
403500: , CST_XLA_INTERORG_PARAMS_REF_V h1
403501: , CST_XLA_INV_HEADERS_V h2
403502: , CST_XLA_INV_ORG_PARAMS_REF_V h4
403503: , CST_XLA_INV_REF_V h5
403668: ,707)
403669:
403670: ELSE null
403671: END source_meaning
403672: FROM xla_events_gt xet
403673: , CST_XLA_INV_LINES_V l3
403674: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
403675: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
403676: AND xet.event_type_code = C_EVENT_TYPE_CODE
403921: , h2.DISTRIBUTION_TYPE source_85
403922: , fvl85.meaning source_85_meaning
403923: , h2.TRANSFER_TO_GL_INDICATOR source_114
403924: , fvl114.meaning source_114_meaning
403925: FROM xla_events_gt xet
403926: , CST_XLA_INTERORG_PARAMS_REF_V h1
403927: , CST_XLA_INV_HEADERS_V h2
403928: , CST_XLA_INV_ORG_PARAMS_REF_V h4
403929: , CST_XLA_INV_REF_V h5
403993: , l3.CURRENCY_CONVERSION_RATE source_93
403994: , l3.CURRENCY_CONVERSION_TYPE source_94
403995: , l3.ACCOUNTED_AMOUNT source_95
403996: , l3.ACCOUNTING_LINE_TYPE_CODE source_97
403997: FROM xla_events_gt xet
403998: , CST_XLA_INV_LINES_V l3
403999: WHERE xet.event_id between x_first_event_id and x_last_event_id
404000: and xet.event_date between p_pad_start_date and p_pad_end_date
404001: and xet.event_type_code = C_EVENT_TYPE_CODE
405238: WHEN 19 THEN fvl114.meaning
405239:
405240: ELSE null
405241: END source_meaning
405242: FROM xla_events_gt xet
405243: , CST_XLA_INTERORG_PARAMS_REF_V h1
405244: , CST_XLA_INV_HEADERS_V h2
405245: , CST_XLA_INV_ORG_PARAMS_REF_V h4
405246: , CST_XLA_INV_REF_V h5
405411: ,707)
405412:
405413: ELSE null
405414: END source_meaning
405415: FROM xla_events_gt xet
405416: , CST_XLA_INV_LINES_V l3
405417: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
405418: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
405419: AND xet.event_type_code = C_EVENT_TYPE_CODE
405667: , h2.DISTRIBUTION_TYPE source_85
405668: , fvl85.meaning source_85_meaning
405669: , h2.TRANSFER_TO_GL_INDICATOR source_114
405670: , fvl114.meaning source_114_meaning
405671: FROM xla_events_gt xet
405672: , CST_XLA_INTERORG_PARAMS_REF_V h1
405673: , CST_XLA_INV_HEADERS_V h2
405674: , CST_XLA_INV_ORG_PARAMS_REF_V h4
405675: , CST_XLA_INV_REF_V h5
405739: , l3.CURRENCY_CONVERSION_RATE source_93
405740: , l3.CURRENCY_CONVERSION_TYPE source_94
405741: , l3.ACCOUNTED_AMOUNT source_95
405742: , l3.ACCOUNTING_LINE_TYPE_CODE source_97
405743: FROM xla_events_gt xet
405744: , CST_XLA_INV_LINES_V l3
405745: WHERE xet.event_id between x_first_event_id and x_last_event_id
405746: and xet.event_date between p_pad_start_date and p_pad_end_date
405747: and xet.event_type_code = C_EVENT_TYPE_CODE
406973: WHEN 16 THEN fvl114.meaning
406974:
406975: ELSE null
406976: END source_meaning
406977: FROM xla_events_gt xet
406978: , CST_XLA_INTERORG_PARAMS_REF_V h1
406979: , CST_XLA_INV_HEADERS_V h2
406980: , CST_XLA_INV_REF_V h4
406981: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
407145: ,707)
407146:
407147: ELSE null
407148: END source_meaning
407149: FROM xla_events_gt xet
407150: , CST_XLA_INV_LINES_V l3
407151: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
407152: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
407153: AND xet.event_type_code = C_EVENT_TYPE_CODE
407392: , h2.DISTRIBUTION_TYPE source_85
407393: , fvl85.meaning source_85_meaning
407394: , h2.TRANSFER_TO_GL_INDICATOR source_114
407395: , fvl114.meaning source_114_meaning
407396: FROM xla_events_gt xet
407397: , CST_XLA_INTERORG_PARAMS_REF_V h1
407398: , CST_XLA_INV_HEADERS_V h2
407399: , CST_XLA_INV_REF_V h4
407400: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
407459: , l3.CURRENCY_CONVERSION_TYPE source_94
407460: , l3.ACCOUNTED_AMOUNT source_95
407461: , l3.ACCOUNTING_LINE_TYPE_CODE source_97
407462: , l3.L_ORGANIZATION_CODE source_108
407463: FROM xla_events_gt xet
407464: , CST_XLA_INV_LINES_V l3
407465: WHERE xet.event_id between x_first_event_id and x_last_event_id
407466: and xet.event_date between p_pad_start_date and p_pad_end_date
407467: and xet.event_type_code = C_EVENT_TYPE_CODE
408574: WHEN 15 THEN fvl114.meaning
408575:
408576: ELSE null
408577: END source_meaning
408578: FROM xla_events_gt xet
408579: , CST_XLA_INTERORG_PARAMS_REF_V h1
408580: , CST_XLA_INV_HEADERS_V h2
408581: , CST_XLA_INV_REF_V h4
408582: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
408741: ,707)
408742:
408743: ELSE null
408744: END source_meaning
408745: FROM xla_events_gt xet
408746: , CST_XLA_INV_LINES_V l3
408747: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
408748: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
408749: AND xet.event_type_code = C_EVENT_TYPE_CODE
408983: , h2.DISTRIBUTION_TYPE source_85
408984: , fvl85.meaning source_85_meaning
408985: , h2.TRANSFER_TO_GL_INDICATOR source_114
408986: , fvl114.meaning source_114_meaning
408987: FROM xla_events_gt xet
408988: , CST_XLA_INTERORG_PARAMS_REF_V h1
408989: , CST_XLA_INV_HEADERS_V h2
408990: , CST_XLA_INV_REF_V h4
408991: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
409049: , l3.CURRENCY_CONVERSION_TYPE source_94
409050: , l3.ACCOUNTED_AMOUNT source_95
409051: , l3.ACCOUNTING_LINE_TYPE_CODE source_97
409052: , l3.L_ORGANIZATION_CODE source_108
409053: FROM xla_events_gt xet
409054: , CST_XLA_INV_LINES_V l3
409055: WHERE xet.event_id between x_first_event_id and x_last_event_id
409056: and xet.event_date between p_pad_start_date and p_pad_end_date
409057: and xet.event_type_code = C_EVENT_TYPE_CODE
410085: WHEN 27 THEN fvl114.meaning
410086:
410087: ELSE null
410088: END source_meaning
410089: FROM xla_events_gt xet
410090: , CST_XLA_INV_HEADERS_V h1
410091: , CST_XLA_INV_REF_V h3
410092: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
410093: , CST_XLA_INV_TXN_TYPES_REF_V h5
410267: ,707)
410268:
410269: ELSE null
410270: END source_meaning
410271: FROM xla_events_gt xet
410272: , CST_XLA_INV_LINES_V l2
410273: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
410274: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
410275: AND xet.event_type_code = C_EVENT_TYPE_CODE
410549: , h1.DISTRIBUTION_TYPE source_85
410550: , fvl85.meaning source_85_meaning
410551: , h1.TRANSFER_TO_GL_INDICATOR source_114
410552: , fvl114.meaning source_114_meaning
410553: FROM xla_events_gt xet
410554: , CST_XLA_INV_HEADERS_V h1
410555: , CST_XLA_INV_REF_V h3
410556: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
410557: , CST_XLA_INV_TXN_TYPES_REF_V h5
410616: , l2.CURRENCY_CONVERSION_TYPE source_94
410617: , l2.ACCOUNTED_AMOUNT source_95
410618: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
410619: , l2.L_ORGANIZATION_CODE source_108
410620: FROM xla_events_gt xet
410621: , CST_XLA_INV_LINES_V l2
410622: WHERE xet.event_id between x_first_event_id and x_last_event_id
410623: and xet.event_date between p_pad_start_date and p_pad_end_date
410624: and xet.event_type_code = C_EVENT_TYPE_CODE
411629: WHEN 13 THEN fvl114.meaning
411630:
411631: ELSE null
411632: END source_meaning
411633: FROM xla_events_gt xet
411634: , CST_XLA_INV_HEADERS_V h1
411635: , CST_XLA_INV_REF_V h3
411636: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
411637: , CST_XLA_INV_TXN_TYPES_REF_V h5
411799: ,707)
411800:
411801: ELSE null
411802: END source_meaning
411803: FROM xla_events_gt xet
411804: , CST_XLA_INV_LINES_V l2
411805: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
411806: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
411807: AND xet.event_type_code = C_EVENT_TYPE_CODE
412037: , h1.DISTRIBUTION_TYPE source_85
412038: , fvl85.meaning source_85_meaning
412039: , h1.TRANSFER_TO_GL_INDICATOR source_114
412040: , fvl114.meaning source_114_meaning
412041: FROM xla_events_gt xet
412042: , CST_XLA_INV_HEADERS_V h1
412043: , CST_XLA_INV_REF_V h3
412044: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
412045: , CST_XLA_INV_TXN_TYPES_REF_V h5
412102: , l2.CURRENCY_CONVERSION_TYPE source_94
412103: , l2.ACCOUNTED_AMOUNT source_95
412104: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
412105: , l2.L_ORGANIZATION_CODE source_108
412106: FROM xla_events_gt xet
412107: , CST_XLA_INV_LINES_V l2
412108: WHERE xet.event_id between x_first_event_id and x_last_event_id
412109: and xet.event_date between p_pad_start_date and p_pad_end_date
412110: and xet.event_type_code = C_EVENT_TYPE_CODE
413006: WHEN 8 THEN fvl114.meaning
413007:
413008: ELSE null
413009: END source_meaning
413010: FROM xla_events_gt xet
413011: , CST_XLA_INV_HEADERS_V h1
413012: , CST_XLA_PLA_CATEGORY_REF_V h3
413013: , fnd_lookup_values fvl85
413014: , fnd_lookup_values fvl114
413173: ,707)
413174:
413175: ELSE null
413176: END source_meaning
413177: FROM xla_events_gt xet
413178: , CST_XLA_INV_LINES_V l2
413179: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
413180: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
413181: AND xet.event_type_code = C_EVENT_TYPE_CODE
413396: , h1.DISTRIBUTION_TYPE source_85
413397: , fvl85.meaning source_85_meaning
413398: , h1.TRANSFER_TO_GL_INDICATOR source_114
413399: , fvl114.meaning source_114_meaning
413400: FROM xla_events_gt xet
413401: , CST_XLA_INV_HEADERS_V h1
413402: , CST_XLA_PLA_CATEGORY_REF_V h3
413403: , fnd_lookup_values fvl85
413404: , fnd_lookup_values fvl114
413458: , l2.CURRENCY_CONVERSION_TYPE source_94
413459: , l2.ACCOUNTED_AMOUNT source_95
413460: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
413461: , l2.L_ORGANIZATION_CODE source_108
413462: FROM xla_events_gt xet
413463: , CST_XLA_INV_LINES_V l2
413464: WHERE xet.event_id between x_first_event_id and x_last_event_id
413465: and xet.event_date between p_pad_start_date and p_pad_end_date
413466: and xet.event_type_code = C_EVENT_TYPE_CODE
414427: WHEN 26 THEN fvl114.meaning
414428:
414429: ELSE null
414430: END source_meaning
414431: FROM xla_events_gt xet
414432: , CST_XLA_INV_HEADERS_V h1
414433: , CST_XLA_INV_REF_V h3
414434: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
414435: , CST_XLA_INV_TXN_TYPES_REF_V h5
414609: ,707)
414610:
414611: ELSE null
414612: END source_meaning
414613: FROM xla_events_gt xet
414614: , CST_XLA_INV_LINES_V l2
414615: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
414616: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
414617: AND xet.event_type_code = C_EVENT_TYPE_CODE
414888: , h1.DISTRIBUTION_TYPE source_85
414889: , fvl85.meaning source_85_meaning
414890: , h1.TRANSFER_TO_GL_INDICATOR source_114
414891: , fvl114.meaning source_114_meaning
414892: FROM xla_events_gt xet
414893: , CST_XLA_INV_HEADERS_V h1
414894: , CST_XLA_INV_REF_V h3
414895: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
414896: , CST_XLA_INV_TXN_TYPES_REF_V h5
414955: , l2.CURRENCY_CONVERSION_TYPE source_94
414956: , l2.ACCOUNTED_AMOUNT source_95
414957: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
414958: , l2.L_ORGANIZATION_CODE source_108
414959: FROM xla_events_gt xet
414960: , CST_XLA_INV_LINES_V l2
414961: WHERE xet.event_id between x_first_event_id and x_last_event_id
414962: and xet.event_date between p_pad_start_date and p_pad_end_date
414963: and xet.event_type_code = C_EVENT_TYPE_CODE
415993: WHEN 10 THEN fvl114.meaning
415994:
415995: ELSE null
415996: END source_meaning
415997: FROM xla_events_gt xet
415998: , CST_XLA_WIP_HEADERS_V h1
415999: , fnd_lookup_values fvl7
416000: , fnd_lookup_values fvl85
416001: , fnd_lookup_values fvl114
416126:
416127: ELSE null
416128: END source_value
416129: , null source_meaning
416130: FROM xla_events_gt xet
416131: , CST_XLA_WIP_LINES_V l2
416132: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
416133: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
416134: AND xet.event_class_code = C_EVENT_CLASS_CODE
416344: , h1.CURRENCY_CONVERSION_RATE source_93
416345: , h1.CURRENCY_CONVERSION_TYPE source_94
416346: , h1.TRANSFER_TO_GL_INDICATOR source_114
416347: , fvl114.meaning source_114_meaning
416348: FROM xla_events_gt xet
416349: , CST_XLA_WIP_HEADERS_V h1
416350: , fnd_lookup_values fvl7
416351: , fnd_lookup_values fvl85
416352: , fnd_lookup_values fvl114
416404: , l2.DISTRIBUTION_IDENTIFIER source_84
416405: , l2.ENTERED_AMOUNT source_91
416406: , l2.ACCOUNTED_AMOUNT source_95
416407: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
416408: FROM xla_events_gt xet
416409: , CST_XLA_WIP_LINES_V l2
416410: WHERE xet.event_id between x_first_event_id and x_last_event_id
416411: and xet.event_date between p_pad_start_date and p_pad_end_date
416412: and xet.event_class_code = C_EVENT_CLASS_CODE
417328: WHEN 21 THEN fvl114.meaning
417329:
417330: ELSE null
417331: END source_meaning
417332: FROM xla_events_gt xet
417333: , CST_XLA_DISCRETE_JOB_REF_V h1
417334: , CST_XLA_FLOW_SCHEDULE_REF_V h2
417335: , CST_XLA_INV_HEADERS_V h3
417336: , CST_XLA_INV_ORG_PARAMS_REF_V h5
417526: WHEN 13 THEN fvl110.meaning
417527:
417528: ELSE null
417529: END source_meaning
417530: FROM xla_events_gt xet
417531: , CST_XLA_INV_LINES_V l4
417532: , CST_XLA_INV_SEC_INVS_REF_V l7
417533: , CST_XLA_RES_OVH_REF_V l12
417534: , fnd_lookup_values fvl110
417804: , h3.DISTRIBUTION_TYPE source_85
417805: , fvl85.meaning source_85_meaning
417806: , h3.TRANSFER_TO_GL_INDICATOR source_114
417807: , fvl114.meaning source_114_meaning
417808: FROM xla_events_gt xet
417809: , CST_XLA_DISCRETE_JOB_REF_V h1
417810: , CST_XLA_FLOW_SCHEDULE_REF_V h2
417811: , CST_XLA_INV_HEADERS_V h3
417812: , CST_XLA_INV_ORG_PARAMS_REF_V h5
417889: , l4.ACCOUNTING_LINE_TYPE_CODE source_97
417890: , l4.L_ORGANIZATION_CODE source_108
417891: , l7.ASSET_INVENTORY source_110
417892: , fvl110.meaning source_110_meaning
417893: FROM xla_events_gt xet
417894: , CST_XLA_INV_LINES_V l4
417895: , CST_XLA_INV_SEC_INVS_REF_V l7
417896: , CST_XLA_RES_OVH_REF_V l12
417897: , fnd_lookup_values fvl110
419051: WHEN 21 THEN fvl114.meaning
419052:
419053: ELSE null
419054: END source_meaning
419055: FROM xla_events_gt xet
419056: , CST_XLA_DISCRETE_JOB_REF_V h1
419057: , CST_XLA_FLOW_SCHEDULE_REF_V h2
419058: , CST_XLA_INV_HEADERS_V h3
419059: , CST_XLA_INV_ORG_PARAMS_REF_V h5
419249: WHEN 13 THEN fvl110.meaning
419250:
419251: ELSE null
419252: END source_meaning
419253: FROM xla_events_gt xet
419254: , CST_XLA_INV_LINES_V l4
419255: , CST_XLA_INV_SEC_INVS_REF_V l7
419256: , CST_XLA_RES_OVH_REF_V l12
419257: , fnd_lookup_values fvl110
419527: , h3.DISTRIBUTION_TYPE source_85
419528: , fvl85.meaning source_85_meaning
419529: , h3.TRANSFER_TO_GL_INDICATOR source_114
419530: , fvl114.meaning source_114_meaning
419531: FROM xla_events_gt xet
419532: , CST_XLA_DISCRETE_JOB_REF_V h1
419533: , CST_XLA_FLOW_SCHEDULE_REF_V h2
419534: , CST_XLA_INV_HEADERS_V h3
419535: , CST_XLA_INV_ORG_PARAMS_REF_V h5
419612: , l4.ACCOUNTING_LINE_TYPE_CODE source_97
419613: , l4.L_ORGANIZATION_CODE source_108
419614: , l7.ASSET_INVENTORY source_110
419615: , fvl110.meaning source_110_meaning
419616: FROM xla_events_gt xet
419617: , CST_XLA_INV_LINES_V l4
419618: , CST_XLA_INV_SEC_INVS_REF_V l7
419619: , CST_XLA_RES_OVH_REF_V l12
419620: , fnd_lookup_values fvl110
420774: WHEN 21 THEN fvl114.meaning
420775:
420776: ELSE null
420777: END source_meaning
420778: FROM xla_events_gt xet
420779: , CST_XLA_DISCRETE_JOB_REF_V h1
420780: , CST_XLA_FLOW_SCHEDULE_REF_V h2
420781: , CST_XLA_INV_HEADERS_V h3
420782: , CST_XLA_INV_REF_V h5
420966: WHEN 12 THEN fvl110.meaning
420967:
420968: ELSE null
420969: END source_meaning
420970: FROM xla_events_gt xet
420971: , CST_XLA_INV_LINES_V l4
420972: , CST_XLA_INV_SEC_INVS_REF_V l6
420973: , fnd_lookup_values fvl110
420974: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
421241: , h3.DISTRIBUTION_TYPE source_85
421242: , fvl85.meaning source_85_meaning
421243: , h3.TRANSFER_TO_GL_INDICATOR source_114
421244: , fvl114.meaning source_114_meaning
421245: FROM xla_events_gt xet
421246: , CST_XLA_DISCRETE_JOB_REF_V h1
421247: , CST_XLA_FLOW_SCHEDULE_REF_V h2
421248: , CST_XLA_INV_HEADERS_V h3
421249: , CST_XLA_INV_REF_V h5
421324: , l4.ACCOUNTING_LINE_TYPE_CODE source_97
421325: , l4.L_ORGANIZATION_CODE source_108
421326: , l6.ASSET_INVENTORY source_110
421327: , fvl110.meaning source_110_meaning
421328: FROM xla_events_gt xet
421329: , CST_XLA_INV_LINES_V l4
421330: , CST_XLA_INV_SEC_INVS_REF_V l6
421331: , fnd_lookup_values fvl110
421332: WHERE xet.event_id between x_first_event_id and x_last_event_id
422479: WHEN 20 THEN fvl114.meaning
422480:
422481: ELSE null
422482: END source_meaning
422483: FROM xla_events_gt xet
422484: , CST_XLA_DISCRETE_JOB_REF_V h1
422485: , CST_XLA_FLOW_SCHEDULE_REF_V h2
422486: , CST_XLA_INV_HEADERS_V h3
422487: , CST_XLA_INV_REF_V h5
422671: WHEN 12 THEN fvl110.meaning
422672:
422673: ELSE null
422674: END source_meaning
422675: FROM xla_events_gt xet
422676: , CST_XLA_INV_LINES_V l4
422677: , CST_XLA_INV_SEC_INVS_REF_V l6
422678: , fnd_lookup_values fvl110
422679: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
422943: , h3.DISTRIBUTION_TYPE source_85
422944: , fvl85.meaning source_85_meaning
422945: , h3.TRANSFER_TO_GL_INDICATOR source_114
422946: , fvl114.meaning source_114_meaning
422947: FROM xla_events_gt xet
422948: , CST_XLA_DISCRETE_JOB_REF_V h1
422949: , CST_XLA_FLOW_SCHEDULE_REF_V h2
422950: , CST_XLA_INV_HEADERS_V h3
422951: , CST_XLA_INV_REF_V h5
423026: , l4.ACCOUNTING_LINE_TYPE_CODE source_97
423027: , l4.L_ORGANIZATION_CODE source_108
423028: , l6.ASSET_INVENTORY source_110
423029: , fvl110.meaning source_110_meaning
423030: FROM xla_events_gt xet
423031: , CST_XLA_INV_LINES_V l4
423032: , CST_XLA_INV_SEC_INVS_REF_V l6
423033: , fnd_lookup_values fvl110
423034: WHERE xet.event_id between x_first_event_id and x_last_event_id
424128: WHEN 10 THEN fvl114.meaning
424129:
424130: ELSE null
424131: END source_meaning
424132: FROM xla_events_gt xet
424133: , CST_XLA_WIP_HEADERS_V h1
424134: , fnd_lookup_values fvl7
424135: , fnd_lookup_values fvl85
424136: , fnd_lookup_values fvl114
424261:
424262: ELSE null
424263: END source_value
424264: , null source_meaning
424265: FROM xla_events_gt xet
424266: , CST_XLA_WIP_LINES_V l2
424267: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
424268: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
424269: AND xet.event_class_code = C_EVENT_CLASS_CODE
424479: , h1.CURRENCY_CONVERSION_RATE source_93
424480: , h1.CURRENCY_CONVERSION_TYPE source_94
424481: , h1.TRANSFER_TO_GL_INDICATOR source_114
424482: , fvl114.meaning source_114_meaning
424483: FROM xla_events_gt xet
424484: , CST_XLA_WIP_HEADERS_V h1
424485: , fnd_lookup_values fvl7
424486: , fnd_lookup_values fvl85
424487: , fnd_lookup_values fvl114
424539: , l2.DISTRIBUTION_IDENTIFIER source_84
424540: , l2.ENTERED_AMOUNT source_91
424541: , l2.ACCOUNTED_AMOUNT source_95
424542: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
424543: FROM xla_events_gt xet
424544: , CST_XLA_WIP_LINES_V l2
424545: WHERE xet.event_id between x_first_event_id and x_last_event_id
424546: and xet.event_date between p_pad_start_date and p_pad_end_date
424547: and xet.event_class_code = C_EVENT_CLASS_CODE
425391: WHEN 7 THEN fvl114.meaning
425392:
425393: ELSE null
425394: END source_meaning
425395: FROM xla_events_gt xet
425396: , CST_XLA_INV_HEADERS_V h1
425397: , CST_XLA_INV_REF_V h3
425398: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
425399: , CST_XLA_INV_TXN_TYPES_REF_V h5
425542:
425543: ELSE null
425544: END source_value
425545: , null source_meaning
425546: FROM xla_events_gt xet
425547: , CST_XLA_INV_LINES_V l2
425548: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
425549: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
425550: AND xet.event_type_code = C_EVENT_TYPE_CODE
425758: , h1.DISTRIBUTION_TYPE source_85
425759: , fvl85.meaning source_85_meaning
425760: , h1.TRANSFER_TO_GL_INDICATOR source_114
425761: , fvl114.meaning source_114_meaning
425762: FROM xla_events_gt xet
425763: , CST_XLA_INV_HEADERS_V h1
425764: , CST_XLA_INV_REF_V h3
425765: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
425766: , CST_XLA_INV_TXN_TYPES_REF_V h5
425821: , l2.CURRENCY_CONVERSION_RATE source_93
425822: , l2.CURRENCY_CONVERSION_TYPE source_94
425823: , l2.ACCOUNTED_AMOUNT source_95
425824: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
425825: FROM xla_events_gt xet
425826: , CST_XLA_INV_LINES_V l2
425827: WHERE xet.event_id between x_first_event_id and x_last_event_id
425828: and xet.event_date between p_pad_start_date and p_pad_end_date
425829: and xet.event_type_code = C_EVENT_TYPE_CODE
426695: WHEN 10 THEN fvl114.meaning
426696:
426697: ELSE null
426698: END source_meaning
426699: FROM xla_events_gt xet
426700: , CST_XLA_WIP_HEADERS_V h1
426701: , fnd_lookup_values fvl7
426702: , fnd_lookup_values fvl85
426703: , fnd_lookup_values fvl114
426828:
426829: ELSE null
426830: END source_value
426831: , null source_meaning
426832: FROM xla_events_gt xet
426833: , CST_XLA_WIP_LINES_V l2
426834: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
426835: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
426836: AND xet.event_class_code = C_EVENT_CLASS_CODE
427046: , h1.CURRENCY_CONVERSION_RATE source_93
427047: , h1.CURRENCY_CONVERSION_TYPE source_94
427048: , h1.TRANSFER_TO_GL_INDICATOR source_114
427049: , fvl114.meaning source_114_meaning
427050: FROM xla_events_gt xet
427051: , CST_XLA_WIP_HEADERS_V h1
427052: , fnd_lookup_values fvl7
427053: , fnd_lookup_values fvl85
427054: , fnd_lookup_values fvl114
427106: , l2.DISTRIBUTION_IDENTIFIER source_84
427107: , l2.ENTERED_AMOUNT source_91
427108: , l2.ACCOUNTED_AMOUNT source_95
427109: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
427110: FROM xla_events_gt xet
427111: , CST_XLA_WIP_LINES_V l2
427112: WHERE xet.event_id between x_first_event_id and x_last_event_id
427113: and xet.event_date between p_pad_start_date and p_pad_end_date
427114: and xet.event_class_code = C_EVENT_CLASS_CODE
428100: WHEN 35 THEN fvl114.meaning
428101:
428102: ELSE null
428103: END source_meaning
428104: FROM xla_events_gt xet
428105: , CST_XLA_DISCRETE_JOB_REF_V h1
428106: , CST_XLA_FLOW_SCHEDULE_REF_V h2
428107: , CST_XLA_INV_HEADERS_V h3
428108: , CST_XLA_INV_REF_V h5
428293: WHEN 12 THEN fvl110.meaning
428294:
428295: ELSE null
428296: END source_meaning
428297: FROM xla_events_gt xet
428298: , CST_XLA_INV_LINES_V l4
428299: , CST_XLA_INV_SEC_INVS_REF_V l6
428300: , fnd_lookup_values fvl110
428301: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
428610: , h3.DISTRIBUTION_TYPE source_85
428611: , fvl85.meaning source_85_meaning
428612: , h3.TRANSFER_TO_GL_INDICATOR source_114
428613: , fvl114.meaning source_114_meaning
428614: FROM xla_events_gt xet
428615: , CST_XLA_DISCRETE_JOB_REF_V h1
428616: , CST_XLA_FLOW_SCHEDULE_REF_V h2
428617: , CST_XLA_INV_HEADERS_V h3
428618: , CST_XLA_INV_REF_V h5
428694: , l4.ACCOUNTING_LINE_TYPE_CODE source_97
428695: , l4.L_ORGANIZATION_CODE source_108
428696: , l6.ASSET_INVENTORY source_110
428697: , fvl110.meaning source_110_meaning
428698: FROM xla_events_gt xet
428699: , CST_XLA_INV_LINES_V l4
428700: , CST_XLA_INV_SEC_INVS_REF_V l6
428701: , fnd_lookup_values fvl110
428702: WHERE xet.event_id between x_first_event_id and x_last_event_id
429969: WHEN 35 THEN fvl114.meaning
429970:
429971: ELSE null
429972: END source_meaning
429973: FROM xla_events_gt xet
429974: , CST_XLA_DISCRETE_JOB_REF_V h1
429975: , CST_XLA_FLOW_SCHEDULE_REF_V h2
429976: , CST_XLA_INV_HEADERS_V h3
429977: , CST_XLA_INV_REF_V h5
430162: WHEN 12 THEN fvl110.meaning
430163:
430164: ELSE null
430165: END source_meaning
430166: FROM xla_events_gt xet
430167: , CST_XLA_INV_LINES_V l4
430168: , CST_XLA_INV_SEC_INVS_REF_V l6
430169: , fnd_lookup_values fvl110
430170: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
430479: , h3.DISTRIBUTION_TYPE source_85
430480: , fvl85.meaning source_85_meaning
430481: , h3.TRANSFER_TO_GL_INDICATOR source_114
430482: , fvl114.meaning source_114_meaning
430483: FROM xla_events_gt xet
430484: , CST_XLA_DISCRETE_JOB_REF_V h1
430485: , CST_XLA_FLOW_SCHEDULE_REF_V h2
430486: , CST_XLA_INV_HEADERS_V h3
430487: , CST_XLA_INV_REF_V h5
430563: , l4.ACCOUNTING_LINE_TYPE_CODE source_97
430564: , l4.L_ORGANIZATION_CODE source_108
430565: , l6.ASSET_INVENTORY source_110
430566: , fvl110.meaning source_110_meaning
430567: FROM xla_events_gt xet
430568: , CST_XLA_INV_LINES_V l4
430569: , CST_XLA_INV_SEC_INVS_REF_V l6
430570: , fnd_lookup_values fvl110
430571: WHERE xet.event_id between x_first_event_id and x_last_event_id
431696: WHEN 7 THEN fvl114.meaning
431697:
431698: ELSE null
431699: END source_meaning
431700: FROM xla_events_gt xet
431701: , CST_XLA_INV_HEADERS_V h1
431702: , CST_XLA_INV_REF_V h3
431703: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
431704: , CST_XLA_INV_TXN_TYPES_REF_V h5
431847:
431848: ELSE null
431849: END source_value
431850: , null source_meaning
431851: FROM xla_events_gt xet
431852: , CST_XLA_INV_LINES_V l2
431853: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
431854: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
431855: AND xet.event_type_code = C_EVENT_TYPE_CODE
432063: , h1.DISTRIBUTION_TYPE source_85
432064: , fvl85.meaning source_85_meaning
432065: , h1.TRANSFER_TO_GL_INDICATOR source_114
432066: , fvl114.meaning source_114_meaning
432067: FROM xla_events_gt xet
432068: , CST_XLA_INV_HEADERS_V h1
432069: , CST_XLA_INV_REF_V h3
432070: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
432071: , CST_XLA_INV_TXN_TYPES_REF_V h5
432126: , l2.CURRENCY_CONVERSION_RATE source_93
432127: , l2.CURRENCY_CONVERSION_TYPE source_94
432128: , l2.ACCOUNTED_AMOUNT source_95
432129: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
432130: FROM xla_events_gt xet
432131: , CST_XLA_INV_LINES_V l2
432132: WHERE xet.event_id between x_first_event_id and x_last_event_id
432133: and xet.event_date between p_pad_start_date and p_pad_end_date
432134: and xet.event_type_code = C_EVENT_TYPE_CODE
435685: ,p_level => C_LEVEL_STATEMENT
435686: ,p_module => l_log_module);
435687:
435688: trace
435689: (p_msg => '# of events in xla_events_gt: '
435690: ||xla_context_pkg.get_event_count_context
435691: ,p_level => C_LEVEL_STATEMENT
435692: ,p_module => l_log_module);
435693: