[Home] [Help]
143214: WHEN 6 THEN fvl38.meaning
143215:
143216: ELSE null
143217: END source_meaning
143218: FROM xla_events_gt xet
143219: , CST_XLA_WIP_HEADERS_V h1
143220: , fnd_lookup_values fvl12
143221: , fnd_lookup_values fvl38
143222: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
143342:
143343: ELSE null
143344: END source_value
143345: , null source_meaning
143346: FROM xla_events_gt xet
143347: , CST_XLA_WIP_LINES_V l2
143348: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
143349: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
143350: AND xet.event_class_code = C_EVENT_CLASS_CODE
143546: , h1.CURRENCY_CONVERSION_RATE source_20
143547: , h1.CURRENCY_CONVERSION_TYPE source_21
143548: , h1.TRANSFER_TO_GL_INDICATOR source_38
143549: , fvl38.meaning source_38_meaning
143550: FROM xla_events_gt xet
143551: , CST_XLA_WIP_HEADERS_V h1
143552: , fnd_lookup_values fvl12
143553: , fnd_lookup_values fvl38
143554: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
143601: , l2.DISTRIBUTION_IDENTIFIER source_11
143602: , l2.ENTERED_AMOUNT source_18
143603: , l2.ACCOUNTED_AMOUNT source_22
143604: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
143605: FROM xla_events_gt xet
143606: , CST_XLA_WIP_LINES_V l2
143607: WHERE xet.event_id between x_first_event_id and x_last_event_id
143608: and xet.event_date between p_pad_start_date and p_pad_end_date
143609: and xet.event_class_code = C_EVENT_CLASS_CODE
144512: WHEN 6 THEN fvl38.meaning
144513:
144514: ELSE null
144515: END source_meaning
144516: FROM xla_events_gt xet
144517: , CST_XLA_AWO_HEADERS_V h1
144518: , fnd_lookup_values fvl12
144519: , fnd_lookup_values fvl38
144520: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
144650:
144651: ELSE null
144652: END source_value
144653: , null source_meaning
144654: FROM xla_events_gt xet
144655: , CST_XLA_AWO_LINES_V l2
144656: , (select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
144657: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
144658: AND xet.event_class_code = C_EVENT_CLASS_CODE
144858: , fvl12.meaning source_12_meaning
144859: , h1.WRITE_OFF_ID source_26
144860: , h1.TRANSFER_TO_GL_INDICATOR source_38
144861: , fvl38.meaning source_38_meaning
144862: FROM xla_events_gt xet
144863: , CST_XLA_AWO_HEADERS_V h1
144864: , fnd_lookup_values fvl12
144865: , fnd_lookup_values fvl38
144866: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
144915: , l2.CURRENCY_CONVERSION_RATE source_20
144916: , l2.CURRENCY_CONVERSION_TYPE source_21
144917: , l2.ACCOUNTED_AMOUNT source_22
144918: , l2.LINE_NUMBER source_25
144919: FROM xla_events_gt xet
144920: , CST_XLA_AWO_LINES_V l2
144921: WHERE xet.event_id between x_first_event_id and x_last_event_id
144922: and xet.event_date between p_pad_start_date and p_pad_end_date
144923: and xet.event_class_code = C_EVENT_CLASS_CODE
145779: WHEN 2 THEN fvl38.meaning
145780:
145781: ELSE null
145782: END source_meaning
145783: FROM xla_events_gt xet
145784: , CST_XLA_INV_HEADERS_V h1
145785: , fnd_lookup_values fvl12
145786: , fnd_lookup_values fvl38
145787: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
145927:
145928: ELSE null
145929: END source_value
145930: , null source_meaning
145931: FROM xla_events_gt xet
145932: , CST_XLA_INV_LINES_V l2
145933: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
145934: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
145935: AND xet.event_class_code = C_EVENT_CLASS_CODE
146127: , h1.DISTRIBUTION_TYPE source_12
146128: , fvl12.meaning source_12_meaning
146129: , h1.TRANSFER_TO_GL_INDICATOR source_38
146130: , fvl38.meaning source_38_meaning
146131: FROM xla_events_gt xet
146132: , CST_XLA_INV_HEADERS_V h1
146133: , fnd_lookup_values fvl12
146134: , fnd_lookup_values fvl38
146135: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
146186: , l2.CURRENCY_CONVERSION_RATE source_20
146187: , l2.CURRENCY_CONVERSION_TYPE source_21
146188: , l2.ACCOUNTED_AMOUNT source_22
146189: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
146190: FROM xla_events_gt xet
146191: , CST_XLA_INV_LINES_V l2
146192: WHERE xet.event_id between x_first_event_id and x_last_event_id
146193: and xet.event_date between p_pad_start_date and p_pad_end_date
146194: and xet.event_class_code = C_EVENT_CLASS_CODE
147143: WHEN 16 THEN fvl38.meaning
147144:
147145: ELSE null
147146: END source_meaning
147147: FROM xla_events_gt xet
147148: , CST_XLA_RCV_HEADERS_V h1
147149: , CST_XLA_RCV_REF_V h3
147150: , PO_DISTS_REF_V h4
147151: , PO_HEADERS_REF_V h5
147275:
147276: ELSE null
147277: END source_value
147278: , null source_meaning
147279: FROM xla_events_gt xet
147280: , CST_XLA_RCV_LINES_V l2
147281: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
147282: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
147283: AND xet.event_class_code = C_EVENT_CLASS_CODE
147509: , h5.PURCH_ENCUMBRANCE_TYPE_ID source_23
147510: , h6.CST_ENCUM_UPG_OPTION source_27
147511: , h1.TRANSFER_TO_GL_INDICATOR source_38
147512: , fvl38.meaning source_38_meaning
147513: FROM xla_events_gt xet
147514: , CST_XLA_RCV_HEADERS_V h1
147515: , CST_XLA_RCV_REF_V h3
147516: , PO_DISTS_REF_V h4
147517: , PO_HEADERS_REF_V h5
147568: , l2.RCV_ACCOUNTING_LINE_TYPE source_5
147569: , l2.DISTRIBUTION_IDENTIFIER source_11
147570: , l2.ENTERED_AMOUNT source_18
147571: , l2.ACCOUNTED_AMOUNT source_22
147572: FROM xla_events_gt xet
147573: , CST_XLA_RCV_LINES_V l2
147574: WHERE xet.event_id between x_first_event_id and x_last_event_id
147575: and xet.event_date between p_pad_start_date and p_pad_end_date
147576: and xet.event_class_code = C_EVENT_CLASS_CODE
148464: WHEN 12 THEN fvl38.meaning
148465:
148466: ELSE null
148467: END source_meaning
148468: FROM xla_events_gt xet
148469: , CST_XLA_INV_HEADERS_V h1
148470: , CST_XLA_INV_REF_V h3
148471: , PO_REQ_DISTS_REF_V h4
148472: , PO_REQ_HEADERS_REF_V h5
148616:
148617: ELSE null
148618: END source_value
148619: , null source_meaning
148620: FROM xla_events_gt xet
148621: , CST_XLA_INV_LINES_V l2
148622: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
148623: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
148624: AND xet.event_class_code = C_EVENT_CLASS_CODE
148846: , h4.REQ_BUDGET_ACCOUNT source_30
148847: , h5.REQ_ENCUMBRANCE_TYPE_ID source_31
148848: , h1.TRANSFER_TO_GL_INDICATOR source_38
148849: , fvl38.meaning source_38_meaning
148850: FROM xla_events_gt xet
148851: , CST_XLA_INV_HEADERS_V h1
148852: , CST_XLA_INV_REF_V h3
148853: , PO_REQ_DISTS_REF_V h4
148854: , PO_REQ_HEADERS_REF_V h5
148909: , l2.CURRENCY_CONVERSION_RATE source_20
148910: , l2.CURRENCY_CONVERSION_TYPE source_21
148911: , l2.ACCOUNTED_AMOUNT source_22
148912: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
148913: FROM xla_events_gt xet
148914: , CST_XLA_INV_LINES_V l2
148915: WHERE xet.event_id between x_first_event_id and x_last_event_id
148916: and xet.event_date between p_pad_start_date and p_pad_end_date
148917: and xet.event_class_code = C_EVENT_CLASS_CODE
150024: WHEN 2 THEN fvl38.meaning
150025:
150026: ELSE null
150027: END source_meaning
150028: FROM xla_events_gt xet
150029: , CST_XLA_INV_HEADERS_V h1
150030: , fnd_lookup_values fvl12
150031: , fnd_lookup_values fvl38
150032: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
150172:
150173: ELSE null
150174: END source_value
150175: , null source_meaning
150176: FROM xla_events_gt xet
150177: , CST_XLA_INV_LINES_V l2
150178: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
150179: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
150180: AND xet.event_class_code = C_EVENT_CLASS_CODE
150372: , h1.DISTRIBUTION_TYPE source_12
150373: , fvl12.meaning source_12_meaning
150374: , h1.TRANSFER_TO_GL_INDICATOR source_38
150375: , fvl38.meaning source_38_meaning
150376: FROM xla_events_gt xet
150377: , CST_XLA_INV_HEADERS_V h1
150378: , fnd_lookup_values fvl12
150379: , fnd_lookup_values fvl38
150380: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
150431: , l2.CURRENCY_CONVERSION_RATE source_20
150432: , l2.CURRENCY_CONVERSION_TYPE source_21
150433: , l2.ACCOUNTED_AMOUNT source_22
150434: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
150435: FROM xla_events_gt xet
150436: , CST_XLA_INV_LINES_V l2
150437: WHERE xet.event_id between x_first_event_id and x_last_event_id
150438: and xet.event_date between p_pad_start_date and p_pad_end_date
150439: and xet.event_class_code = C_EVENT_CLASS_CODE
151484: WHEN 12 THEN fvl38.meaning
151485:
151486: ELSE null
151487: END source_meaning
151488: FROM xla_events_gt xet
151489: , CST_XLA_INV_HEADERS_V h1
151490: , CST_XLA_INV_REF_V h3
151491: , PO_REQ_DISTS_REF_V h4
151492: , PO_REQ_HEADERS_REF_V h5
151636:
151637: ELSE null
151638: END source_value
151639: , null source_meaning
151640: FROM xla_events_gt xet
151641: , CST_XLA_INV_LINES_V l2
151642: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
151643: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
151644: AND xet.event_class_code = C_EVENT_CLASS_CODE
151866: , h4.REQ_BUDGET_ACCOUNT source_30
151867: , h5.REQ_ENCUMBRANCE_TYPE_ID source_31
151868: , h1.TRANSFER_TO_GL_INDICATOR source_38
151869: , fvl38.meaning source_38_meaning
151870: FROM xla_events_gt xet
151871: , CST_XLA_INV_HEADERS_V h1
151872: , CST_XLA_INV_REF_V h3
151873: , PO_REQ_DISTS_REF_V h4
151874: , PO_REQ_HEADERS_REF_V h5
151929: , l2.CURRENCY_CONVERSION_RATE source_20
151930: , l2.CURRENCY_CONVERSION_TYPE source_21
151931: , l2.ACCOUNTED_AMOUNT source_22
151932: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
151933: FROM xla_events_gt xet
151934: , CST_XLA_INV_LINES_V l2
151935: WHERE xet.event_id between x_first_event_id and x_last_event_id
151936: and xet.event_date between p_pad_start_date and p_pad_end_date
151937: and xet.event_class_code = C_EVENT_CLASS_CODE
153005: WHEN 2 THEN fvl38.meaning
153006:
153007: ELSE null
153008: END source_meaning
153009: FROM xla_events_gt xet
153010: , CST_XLA_INV_HEADERS_V h1
153011: , fnd_lookup_values fvl12
153012: , fnd_lookup_values fvl38
153013: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
153153:
153154: ELSE null
153155: END source_value
153156: , null source_meaning
153157: FROM xla_events_gt xet
153158: , CST_XLA_INV_LINES_V l2
153159: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
153160: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
153161: AND xet.event_class_code = C_EVENT_CLASS_CODE
153353: , h1.DISTRIBUTION_TYPE source_12
153354: , fvl12.meaning source_12_meaning
153355: , h1.TRANSFER_TO_GL_INDICATOR source_38
153356: , fvl38.meaning source_38_meaning
153357: FROM xla_events_gt xet
153358: , CST_XLA_INV_HEADERS_V h1
153359: , fnd_lookup_values fvl12
153360: , fnd_lookup_values fvl38
153361: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
153412: , l2.CURRENCY_CONVERSION_RATE source_20
153413: , l2.CURRENCY_CONVERSION_TYPE source_21
153414: , l2.ACCOUNTED_AMOUNT source_22
153415: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
153416: FROM xla_events_gt xet
153417: , CST_XLA_INV_LINES_V l2
153418: WHERE xet.event_id between x_first_event_id and x_last_event_id
153419: and xet.event_date between p_pad_start_date and p_pad_end_date
153420: and xet.event_class_code = C_EVENT_CLASS_CODE
154357: WHEN 2 THEN fvl38.meaning
154358:
154359: ELSE null
154360: END source_meaning
154361: FROM xla_events_gt xet
154362: , CST_XLA_INV_HEADERS_V h1
154363: , fnd_lookup_values fvl12
154364: , fnd_lookup_values fvl38
154365: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
154505:
154506: ELSE null
154507: END source_value
154508: , null source_meaning
154509: FROM xla_events_gt xet
154510: , CST_XLA_INV_LINES_V l2
154511: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
154512: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
154513: AND xet.event_class_code = C_EVENT_CLASS_CODE
154705: , h1.DISTRIBUTION_TYPE source_12
154706: , fvl12.meaning source_12_meaning
154707: , h1.TRANSFER_TO_GL_INDICATOR source_38
154708: , fvl38.meaning source_38_meaning
154709: FROM xla_events_gt xet
154710: , CST_XLA_INV_HEADERS_V h1
154711: , fnd_lookup_values fvl12
154712: , fnd_lookup_values fvl38
154713: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
154764: , l2.CURRENCY_CONVERSION_RATE source_20
154765: , l2.CURRENCY_CONVERSION_TYPE source_21
154766: , l2.ACCOUNTED_AMOUNT source_22
154767: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
154768: FROM xla_events_gt xet
154769: , CST_XLA_INV_LINES_V l2
154770: WHERE xet.event_id between x_first_event_id and x_last_event_id
154771: and xet.event_date between p_pad_start_date and p_pad_end_date
154772: and xet.event_class_code = C_EVENT_CLASS_CODE
155643: WHEN 12 THEN fvl38.meaning
155644:
155645: ELSE null
155646: END source_meaning
155647: FROM xla_events_gt xet
155648: , CST_XLA_INV_HEADERS_V h1
155649: , CST_XLA_INV_REF_V h3
155650: , PO_REQ_DISTS_REF_V h4
155651: , PO_REQ_HEADERS_REF_V h5
155795:
155796: ELSE null
155797: END source_value
155798: , null source_meaning
155799: FROM xla_events_gt xet
155800: , CST_XLA_INV_LINES_V l2
155801: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
155802: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
155803: AND xet.event_class_code = C_EVENT_CLASS_CODE
156025: , h4.REQ_BUDGET_ACCOUNT source_30
156026: , h5.REQ_ENCUMBRANCE_TYPE_ID source_31
156027: , h1.TRANSFER_TO_GL_INDICATOR source_38
156028: , fvl38.meaning source_38_meaning
156029: FROM xla_events_gt xet
156030: , CST_XLA_INV_HEADERS_V h1
156031: , CST_XLA_INV_REF_V h3
156032: , PO_REQ_DISTS_REF_V h4
156033: , PO_REQ_HEADERS_REF_V h5
156088: , l2.CURRENCY_CONVERSION_RATE source_20
156089: , l2.CURRENCY_CONVERSION_TYPE source_21
156090: , l2.ACCOUNTED_AMOUNT source_22
156091: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
156092: FROM xla_events_gt xet
156093: , CST_XLA_INV_LINES_V l2
156094: WHERE xet.event_id between x_first_event_id and x_last_event_id
156095: and xet.event_date between p_pad_start_date and p_pad_end_date
156096: and xet.event_class_code = C_EVENT_CLASS_CODE
156969: WHEN 2 THEN fvl38.meaning
156970:
156971: ELSE null
156972: END source_meaning
156973: FROM xla_events_gt xet
156974: , CST_XLA_INV_HEADERS_V h1
156975: , fnd_lookup_values fvl12
156976: , fnd_lookup_values fvl38
156977: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
157117:
157118: ELSE null
157119: END source_value
157120: , null source_meaning
157121: FROM xla_events_gt xet
157122: , CST_XLA_INV_LINES_V l2
157123: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
157124: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
157125: AND xet.event_class_code = C_EVENT_CLASS_CODE
157317: , h1.DISTRIBUTION_TYPE source_12
157318: , fvl12.meaning source_12_meaning
157319: , h1.TRANSFER_TO_GL_INDICATOR source_38
157320: , fvl38.meaning source_38_meaning
157321: FROM xla_events_gt xet
157322: , CST_XLA_INV_HEADERS_V h1
157323: , fnd_lookup_values fvl12
157324: , fnd_lookup_values fvl38
157325: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
157376: , l2.CURRENCY_CONVERSION_RATE source_20
157377: , l2.CURRENCY_CONVERSION_TYPE source_21
157378: , l2.ACCOUNTED_AMOUNT source_22
157379: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
157380: FROM xla_events_gt xet
157381: , CST_XLA_INV_LINES_V l2
157382: WHERE xet.event_id between x_first_event_id and x_last_event_id
157383: and xet.event_date between p_pad_start_date and p_pad_end_date
157384: and xet.event_class_code = C_EVENT_CLASS_CODE
158379: WHEN 2 THEN fvl38.meaning
158380:
158381: ELSE null
158382: END source_meaning
158383: FROM xla_events_gt xet
158384: , CST_XLA_INV_HEADERS_V h1
158385: , fnd_lookup_values fvl12
158386: , fnd_lookup_values fvl38
158387: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
158527:
158528: ELSE null
158529: END source_value
158530: , null source_meaning
158531: FROM xla_events_gt xet
158532: , CST_XLA_INV_LINES_V l2
158533: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
158534: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
158535: AND xet.event_class_code = C_EVENT_CLASS_CODE
158727: , h1.DISTRIBUTION_TYPE source_12
158728: , fvl12.meaning source_12_meaning
158729: , h1.TRANSFER_TO_GL_INDICATOR source_38
158730: , fvl38.meaning source_38_meaning
158731: FROM xla_events_gt xet
158732: , CST_XLA_INV_HEADERS_V h1
158733: , fnd_lookup_values fvl12
158734: , fnd_lookup_values fvl38
158735: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
158786: , l2.CURRENCY_CONVERSION_RATE source_20
158787: , l2.CURRENCY_CONVERSION_TYPE source_21
158788: , l2.ACCOUNTED_AMOUNT source_22
158789: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
158790: FROM xla_events_gt xet
158791: , CST_XLA_INV_LINES_V l2
158792: WHERE xet.event_id between x_first_event_id and x_last_event_id
158793: and xet.event_date between p_pad_start_date and p_pad_end_date
158794: and xet.event_class_code = C_EVENT_CLASS_CODE
159702: WHEN 2 THEN fvl38.meaning
159703:
159704: ELSE null
159705: END source_meaning
159706: FROM xla_events_gt xet
159707: , CST_XLA_INV_HEADERS_V h1
159708: , fnd_lookup_values fvl12
159709: , fnd_lookup_values fvl38
159710: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
159850:
159851: ELSE null
159852: END source_value
159853: , null source_meaning
159854: FROM xla_events_gt xet
159855: , CST_XLA_INV_LINES_V l2
159856: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
159857: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
159858: AND xet.event_class_code = C_EVENT_CLASS_CODE
160050: , h1.DISTRIBUTION_TYPE source_12
160051: , fvl12.meaning source_12_meaning
160052: , h1.TRANSFER_TO_GL_INDICATOR source_38
160053: , fvl38.meaning source_38_meaning
160054: FROM xla_events_gt xet
160055: , CST_XLA_INV_HEADERS_V h1
160056: , fnd_lookup_values fvl12
160057: , fnd_lookup_values fvl38
160058: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
160109: , l2.CURRENCY_CONVERSION_RATE source_20
160110: , l2.CURRENCY_CONVERSION_TYPE source_21
160111: , l2.ACCOUNTED_AMOUNT source_22
160112: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
160113: FROM xla_events_gt xet
160114: , CST_XLA_INV_LINES_V l2
160115: WHERE xet.event_id between x_first_event_id and x_last_event_id
160116: and xet.event_date between p_pad_start_date and p_pad_end_date
160117: and xet.event_class_code = C_EVENT_CLASS_CODE
160938: WHEN 2 THEN fvl38.meaning
160939:
160940: ELSE null
160941: END source_meaning
160942: FROM xla_events_gt xet
160943: , CST_XLA_INV_HEADERS_V h1
160944: , fnd_lookup_values fvl12
160945: , fnd_lookup_values fvl38
160946: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
161086:
161087: ELSE null
161088: END source_value
161089: , null source_meaning
161090: FROM xla_events_gt xet
161091: , CST_XLA_INV_LINES_V l2
161092: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
161093: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
161094: AND xet.event_class_code = C_EVENT_CLASS_CODE
161286: , h1.DISTRIBUTION_TYPE source_12
161287: , fvl12.meaning source_12_meaning
161288: , h1.TRANSFER_TO_GL_INDICATOR source_38
161289: , fvl38.meaning source_38_meaning
161290: FROM xla_events_gt xet
161291: , CST_XLA_INV_HEADERS_V h1
161292: , fnd_lookup_values fvl12
161293: , fnd_lookup_values fvl38
161294: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
161345: , l2.CURRENCY_CONVERSION_RATE source_20
161346: , l2.CURRENCY_CONVERSION_TYPE source_21
161347: , l2.ACCOUNTED_AMOUNT source_22
161348: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
161349: FROM xla_events_gt xet
161350: , CST_XLA_INV_LINES_V l2
161351: WHERE xet.event_id between x_first_event_id and x_last_event_id
161352: and xet.event_date between p_pad_start_date and p_pad_end_date
161353: and xet.event_class_code = C_EVENT_CLASS_CODE
162247: WHEN 5 THEN fvl38.meaning
162248:
162249: ELSE null
162250: END source_meaning
162251: FROM xla_events_gt xet
162252: , CST_XLA_RCV_HEADERS_V h1
162253: , CST_XLA_RCV_REF_V h3
162254: , PO_DISTS_REF_V h4
162255: , fnd_lookup_values fvl12
162377:
162378: ELSE null
162379: END source_value
162380: , null source_meaning
162381: FROM xla_events_gt xet
162382: , CST_XLA_RCV_LINES_V l2
162383: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
162384: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
162385: AND xet.event_class_code = C_EVENT_CLASS_CODE
162578: , h4.CURRENCY_CONVERSION_DATE source_33
162579: , h4.CURRENCY_CONVERSION_RATE source_34
162580: , h1.TRANSFER_TO_GL_INDICATOR source_38
162581: , fvl38.meaning source_38_meaning
162582: FROM xla_events_gt xet
162583: , CST_XLA_RCV_HEADERS_V h1
162584: , CST_XLA_RCV_REF_V h3
162585: , PO_DISTS_REF_V h4
162586: , fnd_lookup_values fvl12
162635: , l2.RCV_ACCOUNTING_LINE_TYPE source_5
162636: , l2.DISTRIBUTION_IDENTIFIER source_11
162637: , l2.ENTERED_AMOUNT source_18
162638: , l2.ACCOUNTED_AMOUNT source_22
162639: FROM xla_events_gt xet
162640: , CST_XLA_RCV_LINES_V l2
162641: WHERE xet.event_id between x_first_event_id and x_last_event_id
162642: and xet.event_date between p_pad_start_date and p_pad_end_date
162643: and xet.event_class_code = C_EVENT_CLASS_CODE
163511: WHEN 6 THEN fvl38.meaning
163512:
163513: ELSE null
163514: END source_meaning
163515: FROM xla_events_gt xet
163516: , CST_XLA_RCV_HEADERS_V h1
163517: , CST_XLA_RCV_REF_V h3
163518: , PO_DISTS_REF_V h4
163519: , fnd_lookup_values fvl12
163641:
163642: ELSE null
163643: END source_value
163644: , null source_meaning
163645: FROM xla_events_gt xet
163646: , CST_XLA_RCV_LINES_V l2
163647: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
163648: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
163649: AND xet.event_class_code = C_EVENT_CLASS_CODE
163845: , h4.CURRENCY_CONVERSION_RATE source_34
163846: , h4.CURRENCY_CONVERSION_TYPE source_36
163847: , h1.TRANSFER_TO_GL_INDICATOR source_38
163848: , fvl38.meaning source_38_meaning
163849: FROM xla_events_gt xet
163850: , CST_XLA_RCV_HEADERS_V h1
163851: , CST_XLA_RCV_REF_V h3
163852: , PO_DISTS_REF_V h4
163853: , fnd_lookup_values fvl12
163902: , l2.RCV_ACCOUNTING_LINE_TYPE source_5
163903: , l2.DISTRIBUTION_IDENTIFIER source_11
163904: , l2.ENTERED_AMOUNT source_18
163905: , l2.ACCOUNTED_AMOUNT source_22
163906: FROM xla_events_gt xet
163907: , CST_XLA_RCV_LINES_V l2
163908: WHERE xet.event_id between x_first_event_id and x_last_event_id
163909: and xet.event_date between p_pad_start_date and p_pad_end_date
163910: and xet.event_class_code = C_EVENT_CLASS_CODE
164712: WHEN 3 THEN fvl38.meaning
164713:
164714: ELSE null
164715: END source_meaning
164716: FROM xla_events_gt xet
164717: , CST_XLA_INV_HEADERS_V h1
164718: , fnd_lookup_values fvl12
164719: , fnd_lookup_values fvl35
164720: , fnd_lookup_values fvl38
164865:
164866: ELSE null
164867: END source_value
164868: , null source_meaning
164869: FROM xla_events_gt xet
164870: , CST_XLA_INV_LINES_V l2
164871: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
164872: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
164873: AND xet.event_class_code = C_EVENT_CLASS_CODE
165070: , h1.TRANSACTION_ACTION_ID source_35
165071: , fvl35.meaning source_35_meaning
165072: , h1.TRANSFER_TO_GL_INDICATOR source_38
165073: , fvl38.meaning source_38_meaning
165074: FROM xla_events_gt xet
165075: , CST_XLA_INV_HEADERS_V h1
165076: , fnd_lookup_values fvl12
165077: , fnd_lookup_values fvl35
165078: , fnd_lookup_values fvl38
165134: , l2.CURRENCY_CONVERSION_RATE source_20
165135: , l2.CURRENCY_CONVERSION_TYPE source_21
165136: , l2.ACCOUNTED_AMOUNT source_22
165137: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
165138: FROM xla_events_gt xet
165139: , CST_XLA_INV_LINES_V l2
165140: WHERE xet.event_id between x_first_event_id and x_last_event_id
165141: and xet.event_date between p_pad_start_date and p_pad_end_date
165142: and xet.event_class_code = C_EVENT_CLASS_CODE
166029: WHEN 2 THEN fvl38.meaning
166030:
166031: ELSE null
166032: END source_meaning
166033: FROM xla_events_gt xet
166034: , CST_XLA_INV_HEADERS_V h1
166035: , fnd_lookup_values fvl12
166036: , fnd_lookup_values fvl38
166037: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
166177:
166178: ELSE null
166179: END source_value
166180: , null source_meaning
166181: FROM xla_events_gt xet
166182: , CST_XLA_INV_LINES_V l2
166183: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
166184: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
166185: AND xet.event_class_code = C_EVENT_CLASS_CODE
166377: , h1.DISTRIBUTION_TYPE source_12
166378: , fvl12.meaning source_12_meaning
166379: , h1.TRANSFER_TO_GL_INDICATOR source_38
166380: , fvl38.meaning source_38_meaning
166381: FROM xla_events_gt xet
166382: , CST_XLA_INV_HEADERS_V h1
166383: , fnd_lookup_values fvl12
166384: , fnd_lookup_values fvl38
166385: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
166436: , l2.CURRENCY_CONVERSION_RATE source_20
166437: , l2.CURRENCY_CONVERSION_TYPE source_21
166438: , l2.ACCOUNTED_AMOUNT source_22
166439: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
166440: FROM xla_events_gt xet
166441: , CST_XLA_INV_LINES_V l2
166442: WHERE xet.event_id between x_first_event_id and x_last_event_id
166443: and xet.event_date between p_pad_start_date and p_pad_end_date
166444: and xet.event_class_code = C_EVENT_CLASS_CODE
167236: WHEN 2 THEN fvl38.meaning
167237:
167238: ELSE null
167239: END source_meaning
167240: FROM xla_events_gt xet
167241: , CST_XLA_INV_HEADERS_V h1
167242: , fnd_lookup_values fvl12
167243: , fnd_lookup_values fvl38
167244: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
167384:
167385: ELSE null
167386: END source_value
167387: , null source_meaning
167388: FROM xla_events_gt xet
167389: , CST_XLA_INV_LINES_V l2
167390: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
167391: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
167392: AND xet.event_class_code = C_EVENT_CLASS_CODE
167584: , h1.DISTRIBUTION_TYPE source_12
167585: , fvl12.meaning source_12_meaning
167586: , h1.TRANSFER_TO_GL_INDICATOR source_38
167587: , fvl38.meaning source_38_meaning
167588: FROM xla_events_gt xet
167589: , CST_XLA_INV_HEADERS_V h1
167590: , fnd_lookup_values fvl12
167591: , fnd_lookup_values fvl38
167592: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
167643: , l2.CURRENCY_CONVERSION_RATE source_20
167644: , l2.CURRENCY_CONVERSION_TYPE source_21
167645: , l2.ACCOUNTED_AMOUNT source_22
167646: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
167647: FROM xla_events_gt xet
167648: , CST_XLA_INV_LINES_V l2
167649: WHERE xet.event_id between x_first_event_id and x_last_event_id
167650: and xet.event_date between p_pad_start_date and p_pad_end_date
167651: and xet.event_class_code = C_EVENT_CLASS_CODE
168472: WHEN 2 THEN fvl38.meaning
168473:
168474: ELSE null
168475: END source_meaning
168476: FROM xla_events_gt xet
168477: , CST_XLA_INV_HEADERS_V h1
168478: , fnd_lookup_values fvl12
168479: , fnd_lookup_values fvl38
168480: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
168620:
168621: ELSE null
168622: END source_value
168623: , null source_meaning
168624: FROM xla_events_gt xet
168625: , CST_XLA_INV_LINES_V l2
168626: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
168627: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
168628: AND xet.event_class_code = C_EVENT_CLASS_CODE
168820: , h1.DISTRIBUTION_TYPE source_12
168821: , fvl12.meaning source_12_meaning
168822: , h1.TRANSFER_TO_GL_INDICATOR source_38
168823: , fvl38.meaning source_38_meaning
168824: FROM xla_events_gt xet
168825: , CST_XLA_INV_HEADERS_V h1
168826: , fnd_lookup_values fvl12
168827: , fnd_lookup_values fvl38
168828: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
168879: , l2.CURRENCY_CONVERSION_RATE source_20
168880: , l2.CURRENCY_CONVERSION_TYPE source_21
168881: , l2.ACCOUNTED_AMOUNT source_22
168882: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
168883: FROM xla_events_gt xet
168884: , CST_XLA_INV_LINES_V l2
168885: WHERE xet.event_id between x_first_event_id and x_last_event_id
168886: and xet.event_date between p_pad_start_date and p_pad_end_date
168887: and xet.event_class_code = C_EVENT_CLASS_CODE
169781: WHEN 5 THEN fvl38.meaning
169782:
169783: ELSE null
169784: END source_meaning
169785: FROM xla_events_gt xet
169786: , CST_XLA_WIP_HEADERS_V h1
169787: , fnd_lookup_values fvl12
169788: , fnd_lookup_values fvl38
169789: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
169909:
169910: ELSE null
169911: END source_value
169912: , null source_meaning
169913: FROM xla_events_gt xet
169914: , CST_XLA_WIP_LINES_V l2
169915: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
169916: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
169917: AND xet.event_class_code = C_EVENT_CLASS_CODE
170110: , h1.CURRENCY_CONVERSION_DATE source_19
170111: , h1.CURRENCY_CONVERSION_RATE source_20
170112: , h1.TRANSFER_TO_GL_INDICATOR source_38
170113: , fvl38.meaning source_38_meaning
170114: FROM xla_events_gt xet
170115: , CST_XLA_WIP_HEADERS_V h1
170116: , fnd_lookup_values fvl12
170117: , fnd_lookup_values fvl38
170118: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
170165: , l2.DISTRIBUTION_IDENTIFIER source_11
170166: , l2.ENTERED_AMOUNT source_18
170167: , l2.ACCOUNTED_AMOUNT source_22
170168: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
170169: FROM xla_events_gt xet
170170: , CST_XLA_WIP_LINES_V l2
170171: WHERE xet.event_id between x_first_event_id and x_last_event_id
170172: and xet.event_date between p_pad_start_date and p_pad_end_date
170173: and xet.event_class_code = C_EVENT_CLASS_CODE
171147: WHEN 16 THEN fvl38.meaning
171148:
171149: ELSE null
171150: END source_meaning
171151: FROM xla_events_gt xet
171152: , CST_XLA_RCV_HEADERS_V h1
171153: , CST_XLA_RCV_REF_V h3
171154: , PO_DISTS_REF_V h4
171155: , PO_HEADERS_REF_V h5
171279:
171280: ELSE null
171281: END source_value
171282: , null source_meaning
171283: FROM xla_events_gt xet
171284: , CST_XLA_RCV_LINES_V l2
171285: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
171286: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
171287: AND xet.event_class_code = C_EVENT_CLASS_CODE
171513: , h1.CURRENCY_CONVERSION_TYPE source_21
171514: , h5.PURCH_ENCUMBRANCE_TYPE_ID source_23
171515: , h1.TRANSFER_TO_GL_INDICATOR source_38
171516: , fvl38.meaning source_38_meaning
171517: FROM xla_events_gt xet
171518: , CST_XLA_RCV_HEADERS_V h1
171519: , CST_XLA_RCV_REF_V h3
171520: , PO_DISTS_REF_V h4
171521: , PO_HEADERS_REF_V h5
171572: , l2.RCV_ACCOUNTING_LINE_TYPE source_5
171573: , l2.DISTRIBUTION_IDENTIFIER source_11
171574: , l2.ENTERED_AMOUNT source_18
171575: , l2.ACCOUNTED_AMOUNT source_22
171576: FROM xla_events_gt xet
171577: , CST_XLA_RCV_LINES_V l2
171578: WHERE xet.event_id between x_first_event_id and x_last_event_id
171579: and xet.event_date between p_pad_start_date and p_pad_end_date
171580: and xet.event_class_code = C_EVENT_CLASS_CODE
172514: WHEN 12 THEN fvl38.meaning
172515:
172516: ELSE null
172517: END source_meaning
172518: FROM xla_events_gt xet
172519: , CST_XLA_INV_HEADERS_V h1
172520: , CST_XLA_INV_REF_V h3
172521: , PO_DISTS_REF_V h4
172522: , PO_HEADERS_REF_V h5
172666:
172667: ELSE null
172668: END source_value
172669: , null source_meaning
172670: FROM xla_events_gt xet
172671: , CST_XLA_INV_LINES_V l2
172672: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
172673: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
172674: AND xet.event_class_code = C_EVENT_CLASS_CODE
172896: , h6.CST_ENCUM_UPG_OPTION source_27
172897: , h3.TXN_PO_DISTRIBUTION_ID source_28
172898: , h1.TRANSFER_TO_GL_INDICATOR source_38
172899: , fvl38.meaning source_38_meaning
172900: FROM xla_events_gt xet
172901: , CST_XLA_INV_HEADERS_V h1
172902: , CST_XLA_INV_REF_V h3
172903: , PO_DISTS_REF_V h4
172904: , PO_HEADERS_REF_V h5
172959: , l2.CURRENCY_CONVERSION_RATE source_20
172960: , l2.CURRENCY_CONVERSION_TYPE source_21
172961: , l2.ACCOUNTED_AMOUNT source_22
172962: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
172963: FROM xla_events_gt xet
172964: , CST_XLA_INV_LINES_V l2
172965: WHERE xet.event_id between x_first_event_id and x_last_event_id
172966: and xet.event_date between p_pad_start_date and p_pad_end_date
172967: and xet.event_class_code = C_EVENT_CLASS_CODE
174055: WHEN 6 THEN fvl38.meaning
174056:
174057: ELSE null
174058: END source_meaning
174059: FROM xla_events_gt xet
174060: , CST_XLA_RCV_HEADERS_V h1
174061: , fnd_lookup_values fvl12
174062: , fnd_lookup_values fvl38
174063: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
174183:
174184: ELSE null
174185: END source_value
174186: , null source_meaning
174187: FROM xla_events_gt xet
174188: , CST_XLA_RCV_LINES_V l2
174189: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
174190: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
174191: AND xet.event_class_code = C_EVENT_CLASS_CODE
174387: , h1.CURRENCY_CONVERSION_RATE source_20
174388: , h1.CURRENCY_CONVERSION_TYPE source_21
174389: , h1.TRANSFER_TO_GL_INDICATOR source_38
174390: , fvl38.meaning source_38_meaning
174391: FROM xla_events_gt xet
174392: , CST_XLA_RCV_HEADERS_V h1
174393: , fnd_lookup_values fvl12
174394: , fnd_lookup_values fvl38
174395: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
174442: , l2.RCV_ACCOUNTING_LINE_TYPE source_5
174443: , l2.DISTRIBUTION_IDENTIFIER source_11
174444: , l2.ENTERED_AMOUNT source_18
174445: , l2.ACCOUNTED_AMOUNT source_22
174446: FROM xla_events_gt xet
174447: , CST_XLA_RCV_LINES_V l2
174448: WHERE xet.event_id between x_first_event_id and x_last_event_id
174449: and xet.event_date between p_pad_start_date and p_pad_end_date
174450: and xet.event_class_code = C_EVENT_CLASS_CODE
175362: WHEN 2 THEN fvl38.meaning
175363:
175364: ELSE null
175365: END source_meaning
175366: FROM xla_events_gt xet
175367: , CST_XLA_INV_HEADERS_V h1
175368: , fnd_lookup_values fvl12
175369: , fnd_lookup_values fvl38
175370: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
175510:
175511: ELSE null
175512: END source_value
175513: , null source_meaning
175514: FROM xla_events_gt xet
175515: , CST_XLA_INV_LINES_V l2
175516: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
175517: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
175518: AND xet.event_class_code = C_EVENT_CLASS_CODE
175710: , h1.DISTRIBUTION_TYPE source_12
175711: , fvl12.meaning source_12_meaning
175712: , h1.TRANSFER_TO_GL_INDICATOR source_38
175713: , fvl38.meaning source_38_meaning
175714: FROM xla_events_gt xet
175715: , CST_XLA_INV_HEADERS_V h1
175716: , fnd_lookup_values fvl12
175717: , fnd_lookup_values fvl38
175718: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
175769: , l2.CURRENCY_CONVERSION_RATE source_20
175770: , l2.CURRENCY_CONVERSION_TYPE source_21
175771: , l2.ACCOUNTED_AMOUNT source_22
175772: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
175773: FROM xla_events_gt xet
175774: , CST_XLA_INV_LINES_V l2
175775: WHERE xet.event_id between x_first_event_id and x_last_event_id
175776: and xet.event_date between p_pad_start_date and p_pad_end_date
175777: and xet.event_class_code = C_EVENT_CLASS_CODE
176584: WHEN 5 THEN fvl38.meaning
176585:
176586: ELSE null
176587: END source_meaning
176588: FROM xla_events_gt xet
176589: , CST_XLA_RCV_HEADERS_V h1
176590: , fnd_lookup_values fvl12
176591: , fnd_lookup_values fvl38
176592: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
176712:
176713: ELSE null
176714: END source_value
176715: , null source_meaning
176716: FROM xla_events_gt xet
176717: , CST_XLA_RCV_LINES_V l2
176718: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
176719: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
176720: AND xet.event_class_code = C_EVENT_CLASS_CODE
176913: , h1.CURRENCY_CONVERSION_DATE source_19
176914: , h1.CURRENCY_CONVERSION_RATE source_20
176915: , h1.TRANSFER_TO_GL_INDICATOR source_38
176916: , fvl38.meaning source_38_meaning
176917: FROM xla_events_gt xet
176918: , CST_XLA_RCV_HEADERS_V h1
176919: , fnd_lookup_values fvl12
176920: , fnd_lookup_values fvl38
176921: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
176968: , l2.RCV_ACCOUNTING_LINE_TYPE source_5
176969: , l2.DISTRIBUTION_IDENTIFIER source_11
176970: , l2.ENTERED_AMOUNT source_18
176971: , l2.ACCOUNTED_AMOUNT source_22
176972: FROM xla_events_gt xet
176973: , CST_XLA_RCV_LINES_V l2
176974: WHERE xet.event_id between x_first_event_id and x_last_event_id
176975: and xet.event_date between p_pad_start_date and p_pad_end_date
176976: and xet.event_class_code = C_EVENT_CLASS_CODE
177816: WHEN 6 THEN fvl38.meaning
177817:
177818: ELSE null
177819: END source_meaning
177820: FROM xla_events_gt xet
177821: , CST_XLA_RCV_HEADERS_V h1
177822: , fnd_lookup_values fvl12
177823: , fnd_lookup_values fvl38
177824: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
177944:
177945: ELSE null
177946: END source_value
177947: , null source_meaning
177948: FROM xla_events_gt xet
177949: , CST_XLA_RCV_LINES_V l2
177950: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
177951: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
177952: AND xet.event_class_code = C_EVENT_CLASS_CODE
178148: , h1.CURRENCY_CONVERSION_RATE source_20
178149: , h1.CURRENCY_CONVERSION_TYPE source_21
178150: , h1.TRANSFER_TO_GL_INDICATOR source_38
178151: , fvl38.meaning source_38_meaning
178152: FROM xla_events_gt xet
178153: , CST_XLA_RCV_HEADERS_V h1
178154: , fnd_lookup_values fvl12
178155: , fnd_lookup_values fvl38
178156: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
178203: , l2.RCV_ACCOUNTING_LINE_TYPE source_5
178204: , l2.DISTRIBUTION_IDENTIFIER source_11
178205: , l2.ENTERED_AMOUNT source_18
178206: , l2.ACCOUNTED_AMOUNT source_22
178207: FROM xla_events_gt xet
178208: , CST_XLA_RCV_LINES_V l2
178209: WHERE xet.event_id between x_first_event_id and x_last_event_id
178210: and xet.event_date between p_pad_start_date and p_pad_end_date
178211: and xet.event_class_code = C_EVENT_CLASS_CODE
179065: WHEN 2 THEN fvl38.meaning
179066:
179067: ELSE null
179068: END source_meaning
179069: FROM xla_events_gt xet
179070: , CST_XLA_INV_HEADERS_V h1
179071: , fnd_lookup_values fvl12
179072: , fnd_lookup_values fvl38
179073: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
179213:
179214: ELSE null
179215: END source_value
179216: , null source_meaning
179217: FROM xla_events_gt xet
179218: , CST_XLA_INV_LINES_V l2
179219: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
179220: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
179221: AND xet.event_class_code = C_EVENT_CLASS_CODE
179413: , h1.DISTRIBUTION_TYPE source_12
179414: , fvl12.meaning source_12_meaning
179415: , h1.TRANSFER_TO_GL_INDICATOR source_38
179416: , fvl38.meaning source_38_meaning
179417: FROM xla_events_gt xet
179418: , CST_XLA_INV_HEADERS_V h1
179419: , fnd_lookup_values fvl12
179420: , fnd_lookup_values fvl38
179421: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
179472: , l2.CURRENCY_CONVERSION_RATE source_20
179473: , l2.CURRENCY_CONVERSION_TYPE source_21
179474: , l2.ACCOUNTED_AMOUNT source_22
179475: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
179476: FROM xla_events_gt xet
179477: , CST_XLA_INV_LINES_V l2
179478: WHERE xet.event_id between x_first_event_id and x_last_event_id
179479: and xet.event_date between p_pad_start_date and p_pad_end_date
179480: and xet.event_class_code = C_EVENT_CLASS_CODE
180359: WHEN 2 THEN fvl38.meaning
180360:
180361: ELSE null
180362: END source_meaning
180363: FROM xla_events_gt xet
180364: , CST_XLA_INV_HEADERS_V h1
180365: , fnd_lookup_values fvl12
180366: , fnd_lookup_values fvl38
180367: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
180506:
180507: ELSE null
180508: END source_value
180509: , null source_meaning
180510: FROM xla_events_gt xet
180511: , CST_XLA_INV_LINES_V l2
180512: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
180513: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
180514: AND xet.event_type_code = C_EVENT_TYPE_CODE
180707: , h1.DISTRIBUTION_TYPE source_12
180708: , fvl12.meaning source_12_meaning
180709: , h1.TRANSFER_TO_GL_INDICATOR source_38
180710: , fvl38.meaning source_38_meaning
180711: FROM xla_events_gt xet
180712: , CST_XLA_INV_HEADERS_V h1
180713: , fnd_lookup_values fvl12
180714: , fnd_lookup_values fvl38
180715: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
180766: , l2.CURRENCY_CONVERSION_RATE source_20
180767: , l2.CURRENCY_CONVERSION_TYPE source_21
180768: , l2.ACCOUNTED_AMOUNT source_22
180769: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
180770: FROM xla_events_gt xet
180771: , CST_XLA_INV_LINES_V l2
180772: WHERE xet.event_id between x_first_event_id and x_last_event_id
180773: and xet.event_date between p_pad_start_date and p_pad_end_date
180774: and xet.event_type_code = C_EVENT_TYPE_CODE
181653: WHEN 2 THEN fvl38.meaning
181654:
181655: ELSE null
181656: END source_meaning
181657: FROM xla_events_gt xet
181658: , CST_XLA_INV_HEADERS_V h1
181659: , fnd_lookup_values fvl12
181660: , fnd_lookup_values fvl38
181661: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
181800:
181801: ELSE null
181802: END source_value
181803: , null source_meaning
181804: FROM xla_events_gt xet
181805: , CST_XLA_INV_LINES_V l2
181806: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
181807: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
181808: AND xet.event_type_code = C_EVENT_TYPE_CODE
182001: , h1.DISTRIBUTION_TYPE source_12
182002: , fvl12.meaning source_12_meaning
182003: , h1.TRANSFER_TO_GL_INDICATOR source_38
182004: , fvl38.meaning source_38_meaning
182005: FROM xla_events_gt xet
182006: , CST_XLA_INV_HEADERS_V h1
182007: , fnd_lookup_values fvl12
182008: , fnd_lookup_values fvl38
182009: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
182060: , l2.CURRENCY_CONVERSION_RATE source_20
182061: , l2.CURRENCY_CONVERSION_TYPE source_21
182062: , l2.ACCOUNTED_AMOUNT source_22
182063: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
182064: FROM xla_events_gt xet
182065: , CST_XLA_INV_LINES_V l2
182066: WHERE xet.event_id between x_first_event_id and x_last_event_id
182067: and xet.event_date between p_pad_start_date and p_pad_end_date
182068: and xet.event_type_code = C_EVENT_TYPE_CODE
182889: WHEN 2 THEN fvl38.meaning
182890:
182891: ELSE null
182892: END source_meaning
182893: FROM xla_events_gt xet
182894: , CST_XLA_INV_HEADERS_V h1
182895: , fnd_lookup_values fvl12
182896: , fnd_lookup_values fvl38
182897: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
183036:
183037: ELSE null
183038: END source_value
183039: , null source_meaning
183040: FROM xla_events_gt xet
183041: , CST_XLA_INV_LINES_V l2
183042: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
183043: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
183044: AND xet.event_type_code = C_EVENT_TYPE_CODE
183237: , h1.DISTRIBUTION_TYPE source_12
183238: , fvl12.meaning source_12_meaning
183239: , h1.TRANSFER_TO_GL_INDICATOR source_38
183240: , fvl38.meaning source_38_meaning
183241: FROM xla_events_gt xet
183242: , CST_XLA_INV_HEADERS_V h1
183243: , fnd_lookup_values fvl12
183244: , fnd_lookup_values fvl38
183245: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
183296: , l2.CURRENCY_CONVERSION_RATE source_20
183297: , l2.CURRENCY_CONVERSION_TYPE source_21
183298: , l2.ACCOUNTED_AMOUNT source_22
183299: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
183300: FROM xla_events_gt xet
183301: , CST_XLA_INV_LINES_V l2
183302: WHERE xet.event_id between x_first_event_id and x_last_event_id
183303: and xet.event_date between p_pad_start_date and p_pad_end_date
183304: and xet.event_type_code = C_EVENT_TYPE_CODE
184299: WHEN 2 THEN fvl38.meaning
184300:
184301: ELSE null
184302: END source_meaning
184303: FROM xla_events_gt xet
184304: , CST_XLA_INV_HEADERS_V h1
184305: , fnd_lookup_values fvl12
184306: , fnd_lookup_values fvl38
184307: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
184446:
184447: ELSE null
184448: END source_value
184449: , null source_meaning
184450: FROM xla_events_gt xet
184451: , CST_XLA_INV_LINES_V l2
184452: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
184453: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
184454: AND xet.event_type_code = C_EVENT_TYPE_CODE
184647: , h1.DISTRIBUTION_TYPE source_12
184648: , fvl12.meaning source_12_meaning
184649: , h1.TRANSFER_TO_GL_INDICATOR source_38
184650: , fvl38.meaning source_38_meaning
184651: FROM xla_events_gt xet
184652: , CST_XLA_INV_HEADERS_V h1
184653: , fnd_lookup_values fvl12
184654: , fnd_lookup_values fvl38
184655: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
184706: , l2.CURRENCY_CONVERSION_RATE source_20
184707: , l2.CURRENCY_CONVERSION_TYPE source_21
184708: , l2.ACCOUNTED_AMOUNT source_22
184709: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
184710: FROM xla_events_gt xet
184711: , CST_XLA_INV_LINES_V l2
184712: WHERE xet.event_id between x_first_event_id and x_last_event_id
184713: and xet.event_date between p_pad_start_date and p_pad_end_date
184714: and xet.event_type_code = C_EVENT_TYPE_CODE
185709: WHEN 2 THEN fvl38.meaning
185710:
185711: ELSE null
185712: END source_meaning
185713: FROM xla_events_gt xet
185714: , CST_XLA_INV_HEADERS_V h1
185715: , fnd_lookup_values fvl12
185716: , fnd_lookup_values fvl38
185717: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
185856:
185857: ELSE null
185858: END source_value
185859: , null source_meaning
185860: FROM xla_events_gt xet
185861: , CST_XLA_INV_LINES_V l2
185862: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
185863: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
185864: AND xet.event_type_code = C_EVENT_TYPE_CODE
186057: , h1.DISTRIBUTION_TYPE source_12
186058: , fvl12.meaning source_12_meaning
186059: , h1.TRANSFER_TO_GL_INDICATOR source_38
186060: , fvl38.meaning source_38_meaning
186061: FROM xla_events_gt xet
186062: , CST_XLA_INV_HEADERS_V h1
186063: , fnd_lookup_values fvl12
186064: , fnd_lookup_values fvl38
186065: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
186116: , l2.CURRENCY_CONVERSION_RATE source_20
186117: , l2.CURRENCY_CONVERSION_TYPE source_21
186118: , l2.ACCOUNTED_AMOUNT source_22
186119: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
186120: FROM xla_events_gt xet
186121: , CST_XLA_INV_LINES_V l2
186122: WHERE xet.event_id between x_first_event_id and x_last_event_id
186123: and xet.event_date between p_pad_start_date and p_pad_end_date
186124: and xet.event_type_code = C_EVENT_TYPE_CODE
187119: WHEN 2 THEN fvl38.meaning
187120:
187121: ELSE null
187122: END source_meaning
187123: FROM xla_events_gt xet
187124: , CST_XLA_INV_HEADERS_V h1
187125: , fnd_lookup_values fvl12
187126: , fnd_lookup_values fvl38
187127: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
187266:
187267: ELSE null
187268: END source_value
187269: , null source_meaning
187270: FROM xla_events_gt xet
187271: , CST_XLA_INV_LINES_V l2
187272: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
187273: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
187274: AND xet.event_type_code = C_EVENT_TYPE_CODE
187467: , h1.DISTRIBUTION_TYPE source_12
187468: , fvl12.meaning source_12_meaning
187469: , h1.TRANSFER_TO_GL_INDICATOR source_38
187470: , fvl38.meaning source_38_meaning
187471: FROM xla_events_gt xet
187472: , CST_XLA_INV_HEADERS_V h1
187473: , fnd_lookup_values fvl12
187474: , fnd_lookup_values fvl38
187475: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
187526: , l2.CURRENCY_CONVERSION_RATE source_20
187527: , l2.CURRENCY_CONVERSION_TYPE source_21
187528: , l2.ACCOUNTED_AMOUNT source_22
187529: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
187530: FROM xla_events_gt xet
187531: , CST_XLA_INV_LINES_V l2
187532: WHERE xet.event_id between x_first_event_id and x_last_event_id
187533: and xet.event_date between p_pad_start_date and p_pad_end_date
187534: and xet.event_type_code = C_EVENT_TYPE_CODE
188529: WHEN 2 THEN fvl38.meaning
188530:
188531: ELSE null
188532: END source_meaning
188533: FROM xla_events_gt xet
188534: , CST_XLA_INV_HEADERS_V h1
188535: , fnd_lookup_values fvl12
188536: , fnd_lookup_values fvl38
188537: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
188676:
188677: ELSE null
188678: END source_value
188679: , null source_meaning
188680: FROM xla_events_gt xet
188681: , CST_XLA_INV_LINES_V l2
188682: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
188683: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
188684: AND xet.event_type_code = C_EVENT_TYPE_CODE
188877: , h1.DISTRIBUTION_TYPE source_12
188878: , fvl12.meaning source_12_meaning
188879: , h1.TRANSFER_TO_GL_INDICATOR source_38
188880: , fvl38.meaning source_38_meaning
188881: FROM xla_events_gt xet
188882: , CST_XLA_INV_HEADERS_V h1
188883: , fnd_lookup_values fvl12
188884: , fnd_lookup_values fvl38
188885: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
188936: , l2.CURRENCY_CONVERSION_RATE source_20
188937: , l2.CURRENCY_CONVERSION_TYPE source_21
188938: , l2.ACCOUNTED_AMOUNT source_22
188939: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
188940: FROM xla_events_gt xet
188941: , CST_XLA_INV_LINES_V l2
188942: WHERE xet.event_id between x_first_event_id and x_last_event_id
188943: and xet.event_date between p_pad_start_date and p_pad_end_date
188944: and xet.event_type_code = C_EVENT_TYPE_CODE
189939: WHEN 2 THEN fvl38.meaning
189940:
189941: ELSE null
189942: END source_meaning
189943: FROM xla_events_gt xet
189944: , CST_XLA_INV_HEADERS_V h1
189945: , fnd_lookup_values fvl12
189946: , fnd_lookup_values fvl38
189947: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
190086:
190087: ELSE null
190088: END source_value
190089: , null source_meaning
190090: FROM xla_events_gt xet
190091: , CST_XLA_INV_LINES_V l2
190092: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
190093: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
190094: AND xet.event_type_code = C_EVENT_TYPE_CODE
190287: , h1.DISTRIBUTION_TYPE source_12
190288: , fvl12.meaning source_12_meaning
190289: , h1.TRANSFER_TO_GL_INDICATOR source_38
190290: , fvl38.meaning source_38_meaning
190291: FROM xla_events_gt xet
190292: , CST_XLA_INV_HEADERS_V h1
190293: , fnd_lookup_values fvl12
190294: , fnd_lookup_values fvl38
190295: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
190346: , l2.CURRENCY_CONVERSION_RATE source_20
190347: , l2.CURRENCY_CONVERSION_TYPE source_21
190348: , l2.ACCOUNTED_AMOUNT source_22
190349: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
190350: FROM xla_events_gt xet
190351: , CST_XLA_INV_LINES_V l2
190352: WHERE xet.event_id between x_first_event_id and x_last_event_id
190353: and xet.event_date between p_pad_start_date and p_pad_end_date
190354: and xet.event_type_code = C_EVENT_TYPE_CODE
191349: WHEN 2 THEN fvl38.meaning
191350:
191351: ELSE null
191352: END source_meaning
191353: FROM xla_events_gt xet
191354: , CST_XLA_INV_HEADERS_V h1
191355: , fnd_lookup_values fvl12
191356: , fnd_lookup_values fvl38
191357: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
191496:
191497: ELSE null
191498: END source_value
191499: , null source_meaning
191500: FROM xla_events_gt xet
191501: , CST_XLA_INV_LINES_V l2
191502: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
191503: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
191504: AND xet.event_type_code = C_EVENT_TYPE_CODE
191697: , h1.DISTRIBUTION_TYPE source_12
191698: , fvl12.meaning source_12_meaning
191699: , h1.TRANSFER_TO_GL_INDICATOR source_38
191700: , fvl38.meaning source_38_meaning
191701: FROM xla_events_gt xet
191702: , CST_XLA_INV_HEADERS_V h1
191703: , fnd_lookup_values fvl12
191704: , fnd_lookup_values fvl38
191705: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
191756: , l2.CURRENCY_CONVERSION_RATE source_20
191757: , l2.CURRENCY_CONVERSION_TYPE source_21
191758: , l2.ACCOUNTED_AMOUNT source_22
191759: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
191760: FROM xla_events_gt xet
191761: , CST_XLA_INV_LINES_V l2
191762: WHERE xet.event_id between x_first_event_id and x_last_event_id
191763: and xet.event_date between p_pad_start_date and p_pad_end_date
191764: and xet.event_type_code = C_EVENT_TYPE_CODE
192585: WHEN 2 THEN fvl38.meaning
192586:
192587: ELSE null
192588: END source_meaning
192589: FROM xla_events_gt xet
192590: , CST_XLA_INV_HEADERS_V h1
192591: , fnd_lookup_values fvl12
192592: , fnd_lookup_values fvl38
192593: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
192732:
192733: ELSE null
192734: END source_value
192735: , null source_meaning
192736: FROM xla_events_gt xet
192737: , CST_XLA_INV_LINES_V l2
192738: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
192739: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
192740: AND xet.event_type_code = C_EVENT_TYPE_CODE
192933: , h1.DISTRIBUTION_TYPE source_12
192934: , fvl12.meaning source_12_meaning
192935: , h1.TRANSFER_TO_GL_INDICATOR source_38
192936: , fvl38.meaning source_38_meaning
192937: FROM xla_events_gt xet
192938: , CST_XLA_INV_HEADERS_V h1
192939: , fnd_lookup_values fvl12
192940: , fnd_lookup_values fvl38
192941: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
192992: , l2.CURRENCY_CONVERSION_RATE source_20
192993: , l2.CURRENCY_CONVERSION_TYPE source_21
192994: , l2.ACCOUNTED_AMOUNT source_22
192995: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
192996: FROM xla_events_gt xet
192997: , CST_XLA_INV_LINES_V l2
192998: WHERE xet.event_id between x_first_event_id and x_last_event_id
192999: and xet.event_date between p_pad_start_date and p_pad_end_date
193000: and xet.event_type_code = C_EVENT_TYPE_CODE
193995: WHEN 2 THEN fvl38.meaning
193996:
193997: ELSE null
193998: END source_meaning
193999: FROM xla_events_gt xet
194000: , CST_XLA_INV_HEADERS_V h1
194001: , fnd_lookup_values fvl12
194002: , fnd_lookup_values fvl38
194003: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
194142:
194143: ELSE null
194144: END source_value
194145: , null source_meaning
194146: FROM xla_events_gt xet
194147: , CST_XLA_INV_LINES_V l2
194148: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
194149: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
194150: AND xet.event_type_code = C_EVENT_TYPE_CODE
194343: , h1.DISTRIBUTION_TYPE source_12
194344: , fvl12.meaning source_12_meaning
194345: , h1.TRANSFER_TO_GL_INDICATOR source_38
194346: , fvl38.meaning source_38_meaning
194347: FROM xla_events_gt xet
194348: , CST_XLA_INV_HEADERS_V h1
194349: , fnd_lookup_values fvl12
194350: , fnd_lookup_values fvl38
194351: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
194402: , l2.CURRENCY_CONVERSION_RATE source_20
194403: , l2.CURRENCY_CONVERSION_TYPE source_21
194404: , l2.ACCOUNTED_AMOUNT source_22
194405: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
194406: FROM xla_events_gt xet
194407: , CST_XLA_INV_LINES_V l2
194408: WHERE xet.event_id between x_first_event_id and x_last_event_id
194409: and xet.event_date between p_pad_start_date and p_pad_end_date
194410: and xet.event_type_code = C_EVENT_TYPE_CODE
195405: WHEN 2 THEN fvl38.meaning
195406:
195407: ELSE null
195408: END source_meaning
195409: FROM xla_events_gt xet
195410: , CST_XLA_INV_HEADERS_V h1
195411: , fnd_lookup_values fvl12
195412: , fnd_lookup_values fvl38
195413: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
195552:
195553: ELSE null
195554: END source_value
195555: , null source_meaning
195556: FROM xla_events_gt xet
195557: , CST_XLA_INV_LINES_V l2
195558: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
195559: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
195560: AND xet.event_type_code = C_EVENT_TYPE_CODE
195753: , h1.DISTRIBUTION_TYPE source_12
195754: , fvl12.meaning source_12_meaning
195755: , h1.TRANSFER_TO_GL_INDICATOR source_38
195756: , fvl38.meaning source_38_meaning
195757: FROM xla_events_gt xet
195758: , CST_XLA_INV_HEADERS_V h1
195759: , fnd_lookup_values fvl12
195760: , fnd_lookup_values fvl38
195761: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
195812: , l2.CURRENCY_CONVERSION_RATE source_20
195813: , l2.CURRENCY_CONVERSION_TYPE source_21
195814: , l2.ACCOUNTED_AMOUNT source_22
195815: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
195816: FROM xla_events_gt xet
195817: , CST_XLA_INV_LINES_V l2
195818: WHERE xet.event_id between x_first_event_id and x_last_event_id
195819: and xet.event_date between p_pad_start_date and p_pad_end_date
195820: and xet.event_type_code = C_EVENT_TYPE_CODE
196728: WHEN 2 THEN fvl38.meaning
196729:
196730: ELSE null
196731: END source_meaning
196732: FROM xla_events_gt xet
196733: , CST_XLA_INV_HEADERS_V h1
196734: , fnd_lookup_values fvl12
196735: , fnd_lookup_values fvl38
196736: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
196875:
196876: ELSE null
196877: END source_value
196878: , null source_meaning
196879: FROM xla_events_gt xet
196880: , CST_XLA_INV_LINES_V l2
196881: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
196882: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
196883: AND xet.event_type_code = C_EVENT_TYPE_CODE
197076: , h1.DISTRIBUTION_TYPE source_12
197077: , fvl12.meaning source_12_meaning
197078: , h1.TRANSFER_TO_GL_INDICATOR source_38
197079: , fvl38.meaning source_38_meaning
197080: FROM xla_events_gt xet
197081: , CST_XLA_INV_HEADERS_V h1
197082: , fnd_lookup_values fvl12
197083: , fnd_lookup_values fvl38
197084: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
197135: , l2.CURRENCY_CONVERSION_RATE source_20
197136: , l2.CURRENCY_CONVERSION_TYPE source_21
197137: , l2.ACCOUNTED_AMOUNT source_22
197138: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
197139: FROM xla_events_gt xet
197140: , CST_XLA_INV_LINES_V l2
197141: WHERE xet.event_id between x_first_event_id and x_last_event_id
197142: and xet.event_date between p_pad_start_date and p_pad_end_date
197143: and xet.event_type_code = C_EVENT_TYPE_CODE
198051: WHEN 2 THEN fvl38.meaning
198052:
198053: ELSE null
198054: END source_meaning
198055: FROM xla_events_gt xet
198056: , CST_XLA_INV_HEADERS_V h1
198057: , fnd_lookup_values fvl12
198058: , fnd_lookup_values fvl38
198059: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
198198:
198199: ELSE null
198200: END source_value
198201: , null source_meaning
198202: FROM xla_events_gt xet
198203: , CST_XLA_INV_LINES_V l2
198204: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
198205: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
198206: AND xet.event_type_code = C_EVENT_TYPE_CODE
198399: , h1.DISTRIBUTION_TYPE source_12
198400: , fvl12.meaning source_12_meaning
198401: , h1.TRANSFER_TO_GL_INDICATOR source_38
198402: , fvl38.meaning source_38_meaning
198403: FROM xla_events_gt xet
198404: , CST_XLA_INV_HEADERS_V h1
198405: , fnd_lookup_values fvl12
198406: , fnd_lookup_values fvl38
198407: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
198458: , l2.CURRENCY_CONVERSION_RATE source_20
198459: , l2.CURRENCY_CONVERSION_TYPE source_21
198460: , l2.ACCOUNTED_AMOUNT source_22
198461: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
198462: FROM xla_events_gt xet
198463: , CST_XLA_INV_LINES_V l2
198464: WHERE xet.event_id between x_first_event_id and x_last_event_id
198465: and xet.event_date between p_pad_start_date and p_pad_end_date
198466: and xet.event_type_code = C_EVENT_TYPE_CODE
199316: WHEN 2 THEN fvl38.meaning
199317:
199318: ELSE null
199319: END source_meaning
199320: FROM xla_events_gt xet
199321: , CST_XLA_INV_HEADERS_V h1
199322: , fnd_lookup_values fvl12
199323: , fnd_lookup_values fvl38
199324: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
199463:
199464: ELSE null
199465: END source_value
199466: , null source_meaning
199467: FROM xla_events_gt xet
199468: , CST_XLA_INV_LINES_V l2
199469: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
199470: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
199471: AND xet.event_type_code = C_EVENT_TYPE_CODE
199664: , h1.DISTRIBUTION_TYPE source_12
199665: , fvl12.meaning source_12_meaning
199666: , h1.TRANSFER_TO_GL_INDICATOR source_38
199667: , fvl38.meaning source_38_meaning
199668: FROM xla_events_gt xet
199669: , CST_XLA_INV_HEADERS_V h1
199670: , fnd_lookup_values fvl12
199671: , fnd_lookup_values fvl38
199672: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
199723: , l2.CURRENCY_CONVERSION_RATE source_20
199724: , l2.CURRENCY_CONVERSION_TYPE source_21
199725: , l2.ACCOUNTED_AMOUNT source_22
199726: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
199727: FROM xla_events_gt xet
199728: , CST_XLA_INV_LINES_V l2
199729: WHERE xet.event_id between x_first_event_id and x_last_event_id
199730: and xet.event_date between p_pad_start_date and p_pad_end_date
199731: and xet.event_type_code = C_EVENT_TYPE_CODE
200552: WHEN 2 THEN fvl38.meaning
200553:
200554: ELSE null
200555: END source_meaning
200556: FROM xla_events_gt xet
200557: , CST_XLA_INV_HEADERS_V h1
200558: , fnd_lookup_values fvl12
200559: , fnd_lookup_values fvl38
200560: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
200699:
200700: ELSE null
200701: END source_value
200702: , null source_meaning
200703: FROM xla_events_gt xet
200704: , CST_XLA_INV_LINES_V l2
200705: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
200706: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
200707: AND xet.event_type_code = C_EVENT_TYPE_CODE
200900: , h1.DISTRIBUTION_TYPE source_12
200901: , fvl12.meaning source_12_meaning
200902: , h1.TRANSFER_TO_GL_INDICATOR source_38
200903: , fvl38.meaning source_38_meaning
200904: FROM xla_events_gt xet
200905: , CST_XLA_INV_HEADERS_V h1
200906: , fnd_lookup_values fvl12
200907: , fnd_lookup_values fvl38
200908: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
200959: , l2.CURRENCY_CONVERSION_RATE source_20
200960: , l2.CURRENCY_CONVERSION_TYPE source_21
200961: , l2.ACCOUNTED_AMOUNT source_22
200962: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
200963: FROM xla_events_gt xet
200964: , CST_XLA_INV_LINES_V l2
200965: WHERE xet.event_id between x_first_event_id and x_last_event_id
200966: and xet.event_date between p_pad_start_date and p_pad_end_date
200967: and xet.event_type_code = C_EVENT_TYPE_CODE
201788: WHEN 2 THEN fvl38.meaning
201789:
201790: ELSE null
201791: END source_meaning
201792: FROM xla_events_gt xet
201793: , CST_XLA_INV_HEADERS_V h1
201794: , fnd_lookup_values fvl12
201795: , fnd_lookup_values fvl38
201796: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
201935:
201936: ELSE null
201937: END source_value
201938: , null source_meaning
201939: FROM xla_events_gt xet
201940: , CST_XLA_INV_LINES_V l2
201941: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
201942: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
201943: AND xet.event_type_code = C_EVENT_TYPE_CODE
202136: , h1.DISTRIBUTION_TYPE source_12
202137: , fvl12.meaning source_12_meaning
202138: , h1.TRANSFER_TO_GL_INDICATOR source_38
202139: , fvl38.meaning source_38_meaning
202140: FROM xla_events_gt xet
202141: , CST_XLA_INV_HEADERS_V h1
202142: , fnd_lookup_values fvl12
202143: , fnd_lookup_values fvl38
202144: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
202195: , l2.CURRENCY_CONVERSION_RATE source_20
202196: , l2.CURRENCY_CONVERSION_TYPE source_21
202197: , l2.ACCOUNTED_AMOUNT source_22
202198: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
202199: FROM xla_events_gt xet
202200: , CST_XLA_INV_LINES_V l2
202201: WHERE xet.event_id between x_first_event_id and x_last_event_id
202202: and xet.event_date between p_pad_start_date and p_pad_end_date
202203: and xet.event_type_code = C_EVENT_TYPE_CODE
203044: WHEN 6 THEN fvl38.meaning
203045:
203046: ELSE null
203047: END source_meaning
203048: FROM xla_events_gt xet
203049: , CST_XLA_WIP_HEADERS_V h1
203050: , fnd_lookup_values fvl12
203051: , fnd_lookup_values fvl38
203052: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
203172:
203173: ELSE null
203174: END source_value
203175: , null source_meaning
203176: FROM xla_events_gt xet
203177: , CST_XLA_WIP_LINES_V l2
203178: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
203179: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
203180: AND xet.event_class_code = C_EVENT_CLASS_CODE
203376: , h1.CURRENCY_CONVERSION_RATE source_20
203377: , h1.CURRENCY_CONVERSION_TYPE source_21
203378: , h1.TRANSFER_TO_GL_INDICATOR source_38
203379: , fvl38.meaning source_38_meaning
203380: FROM xla_events_gt xet
203381: , CST_XLA_WIP_HEADERS_V h1
203382: , fnd_lookup_values fvl12
203383: , fnd_lookup_values fvl38
203384: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
203431: , l2.DISTRIBUTION_IDENTIFIER source_11
203432: , l2.ENTERED_AMOUNT source_18
203433: , l2.ACCOUNTED_AMOUNT source_22
203434: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
203435: FROM xla_events_gt xet
203436: , CST_XLA_WIP_LINES_V l2
203437: WHERE xet.event_id between x_first_event_id and x_last_event_id
203438: and xet.event_date between p_pad_start_date and p_pad_end_date
203439: and xet.event_class_code = C_EVENT_CLASS_CODE
204255: WHEN 6 THEN fvl38.meaning
204256:
204257: ELSE null
204258: END source_meaning
204259: FROM xla_events_gt xet
204260: , CST_XLA_WIP_HEADERS_V h1
204261: , fnd_lookup_values fvl12
204262: , fnd_lookup_values fvl38
204263: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
204383:
204384: ELSE null
204385: END source_value
204386: , null source_meaning
204387: FROM xla_events_gt xet
204388: , CST_XLA_WIP_LINES_V l2
204389: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
204390: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
204391: AND xet.event_class_code = C_EVENT_CLASS_CODE
204587: , h1.CURRENCY_CONVERSION_RATE source_20
204588: , h1.CURRENCY_CONVERSION_TYPE source_21
204589: , h1.TRANSFER_TO_GL_INDICATOR source_38
204590: , fvl38.meaning source_38_meaning
204591: FROM xla_events_gt xet
204592: , CST_XLA_WIP_HEADERS_V h1
204593: , fnd_lookup_values fvl12
204594: , fnd_lookup_values fvl38
204595: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
204642: , l2.DISTRIBUTION_IDENTIFIER source_11
204643: , l2.ENTERED_AMOUNT source_18
204644: , l2.ACCOUNTED_AMOUNT source_22
204645: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
204646: FROM xla_events_gt xet
204647: , CST_XLA_WIP_LINES_V l2
204648: WHERE xet.event_id between x_first_event_id and x_last_event_id
204649: and xet.event_date between p_pad_start_date and p_pad_end_date
204650: and xet.event_class_code = C_EVENT_CLASS_CODE
205466: WHEN 6 THEN fvl38.meaning
205467:
205468: ELSE null
205469: END source_meaning
205470: FROM xla_events_gt xet
205471: , CST_XLA_WIP_HEADERS_V h1
205472: , fnd_lookup_values fvl12
205473: , fnd_lookup_values fvl38
205474: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
205594:
205595: ELSE null
205596: END source_value
205597: , null source_meaning
205598: FROM xla_events_gt xet
205599: , CST_XLA_WIP_LINES_V l2
205600: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
205601: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
205602: AND xet.event_class_code = C_EVENT_CLASS_CODE
205798: , h1.CURRENCY_CONVERSION_RATE source_20
205799: , h1.CURRENCY_CONVERSION_TYPE source_21
205800: , h1.TRANSFER_TO_GL_INDICATOR source_38
205801: , fvl38.meaning source_38_meaning
205802: FROM xla_events_gt xet
205803: , CST_XLA_WIP_HEADERS_V h1
205804: , fnd_lookup_values fvl12
205805: , fnd_lookup_values fvl38
205806: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
205853: , l2.DISTRIBUTION_IDENTIFIER source_11
205854: , l2.ENTERED_AMOUNT source_18
205855: , l2.ACCOUNTED_AMOUNT source_22
205856: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
205857: FROM xla_events_gt xet
205858: , CST_XLA_WIP_LINES_V l2
205859: WHERE xet.event_id between x_first_event_id and x_last_event_id
205860: and xet.event_date between p_pad_start_date and p_pad_end_date
205861: and xet.event_class_code = C_EVENT_CLASS_CODE
206657: WHEN 2 THEN fvl38.meaning
206658:
206659: ELSE null
206660: END source_meaning
206661: FROM xla_events_gt xet
206662: , CST_XLA_INV_HEADERS_V h1
206663: , fnd_lookup_values fvl12
206664: , fnd_lookup_values fvl38
206665: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
206805:
206806: ELSE null
206807: END source_value
206808: , null source_meaning
206809: FROM xla_events_gt xet
206810: , CST_XLA_INV_LINES_V l2
206811: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
206812: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
206813: AND xet.event_class_code = C_EVENT_CLASS_CODE
207005: , h1.DISTRIBUTION_TYPE source_12
207006: , fvl12.meaning source_12_meaning
207007: , h1.TRANSFER_TO_GL_INDICATOR source_38
207008: , fvl38.meaning source_38_meaning
207009: FROM xla_events_gt xet
207010: , CST_XLA_INV_HEADERS_V h1
207011: , fnd_lookup_values fvl12
207012: , fnd_lookup_values fvl38
207013: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
207064: , l2.CURRENCY_CONVERSION_RATE source_20
207065: , l2.CURRENCY_CONVERSION_TYPE source_21
207066: , l2.ACCOUNTED_AMOUNT source_22
207067: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
207068: FROM xla_events_gt xet
207069: , CST_XLA_INV_LINES_V l2
207070: WHERE xet.event_id between x_first_event_id and x_last_event_id
207071: and xet.event_date between p_pad_start_date and p_pad_end_date
207072: and xet.event_class_code = C_EVENT_CLASS_CODE
209555: ,p_level => C_LEVEL_STATEMENT
209556: ,p_module => l_log_module);
209557:
209558: trace
209559: (p_msg => '# of events in xla_events_gt: '
209560: ||xla_context_pkg.get_event_count_context
209561: ,p_level => C_LEVEL_STATEMENT
209562: ,p_module => l_log_module);
209563: