[Home] [Help]
13958: WHEN 15 THEN fvl42.meaning
13959:
13960: ELSE null
13961: END source_meaning
13962: FROM xla_events_gt xet
13963: , CST_XLA_RCV_HEADERS_V h1
13964: , CST_XLA_RCV_REF_V h3
13965: , PO_DISTS_REF_V h4
13966: , PO_HEADERS_REF_V h5
14075:
14076: ELSE null
14077: END source_value
14078: , null source_meaning
14079: FROM xla_events_gt xet
14080: , CST_XLA_RCV_LINES_V l2
14081: , (select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
14082: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
14083: AND xet.event_class_code = C_EVENT_CLASS_CODE
14300: , h3.PO_DISTRIBUTION_ID source_30
14301: , h4.RESERVED_FLAG source_31
14302: , h1.TRANSFER_TO_GL_INDICATOR source_42
14303: , fvl42.meaning source_42_meaning
14304: FROM xla_events_gt xet
14305: , CST_XLA_RCV_HEADERS_V h1
14306: , CST_XLA_RCV_REF_V h3
14307: , PO_DISTS_REF_V h4
14308: , PO_HEADERS_REF_V h5
14356: ,xet.budgetary_control_flag
14357: , l2.LINE_NUMBER
14358: , l2.DISTRIBUTION_IDENTIFIER source_8
14359: , l2.RCV_ACCOUNTING_LINE_TYPE source_29
14360: FROM xla_events_gt xet
14361: , CST_XLA_RCV_LINES_V l2
14362: WHERE xet.event_id between x_first_event_id and x_last_event_id
14363: and xet.event_date between p_pad_start_date and p_pad_end_date
14364: and xet.event_class_code = C_EVENT_CLASS_CODE
15278: WHEN 20 THEN fvl42.meaning
15279:
15280: ELSE null
15281: END source_meaning
15282: FROM xla_events_gt xet
15283: , CST_XLA_INV_HEADERS_V h1
15284: , CST_XLA_INV_ORG_PARAMS_REF_V h3
15285: , CST_XLA_INV_REF_V h4
15286: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
15398:
15399: ELSE null
15400: END source_value
15401: , null source_meaning
15402: FROM xla_events_gt xet
15403: , CST_XLA_INV_LINES_V l2
15404: , (select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
15405: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
15406: AND xet.event_class_code = C_EVENT_CLASS_CODE
15638: , h7.REQ_BUDGET_ACCOUNT source_39
15639: , h8.REQ_ENCUMBRANCE_TYPE_ID source_40
15640: , h1.TRANSFER_TO_GL_INDICATOR source_42
15641: , fvl42.meaning source_42_meaning
15642: FROM xla_events_gt xet
15643: , CST_XLA_INV_HEADERS_V h1
15644: , CST_XLA_INV_ORG_PARAMS_REF_V h3
15645: , CST_XLA_INV_REF_V h4
15646: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
15697: ,xet.budgetary_control_flag
15698: , l2.LINE_NUMBER
15699: , l2.DISTRIBUTION_IDENTIFIER source_8
15700: , l2.CURRENCY_CODE source_11
15701: FROM xla_events_gt xet
15702: , CST_XLA_INV_LINES_V l2
15703: WHERE xet.event_id between x_first_event_id and x_last_event_id
15704: and xet.event_date between p_pad_start_date and p_pad_end_date
15705: and xet.event_class_code = C_EVENT_CLASS_CODE
16543: WHEN 7 THEN fvl42.meaning
16544:
16545: ELSE null
16546: END source_meaning
16547: FROM xla_events_gt xet
16548: , CST_XLA_INV_HEADERS_V h1
16549: , CST_XLA_INV_REF_V h3
16550: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
16551: , CST_XLA_INV_TXN_TYPES_REF_V h5
16693:
16694: ELSE null
16695: END source_value
16696: , null source_meaning
16697: FROM xla_events_gt xet
16698: , CST_XLA_INV_LINES_V l2
16699: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
16700: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
16701: AND xet.event_type_code = C_EVENT_TYPE_CODE
16909: , h1.DISTRIBUTION_TYPE source_9
16910: , fvl9.meaning source_9_meaning
16911: , h1.TRANSFER_TO_GL_INDICATOR source_42
16912: , fvl42.meaning source_42_meaning
16913: FROM xla_events_gt xet
16914: , CST_XLA_INV_HEADERS_V h1
16915: , CST_XLA_INV_REF_V h3
16916: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
16917: , CST_XLA_INV_TXN_TYPES_REF_V h5
16971: , l2.CURRENCY_CONVERSION_DATE source_12
16972: , l2.CURRENCY_CONVERSION_RATE source_13
16973: , l2.CURRENCY_CONVERSION_TYPE source_14
16974: , l2.ACCOUNTED_AMOUNT source_15
16975: FROM xla_events_gt xet
16976: , CST_XLA_INV_LINES_V l2
16977: WHERE xet.event_id between x_first_event_id and x_last_event_id
16978: and xet.event_date between p_pad_start_date and p_pad_end_date
16979: and xet.event_type_code = C_EVENT_TYPE_CODE
17790: WHEN 7 THEN fvl42.meaning
17791:
17792: ELSE null
17793: END source_meaning
17794: FROM xla_events_gt xet
17795: , CST_XLA_INV_HEADERS_V h1
17796: , CST_XLA_INV_REF_V h3
17797: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
17798: , CST_XLA_INV_TXN_TYPES_REF_V h5
17940:
17941: ELSE null
17942: END source_value
17943: , null source_meaning
17944: FROM xla_events_gt xet
17945: , CST_XLA_INV_LINES_V l2
17946: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
17947: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
17948: AND xet.event_type_code = C_EVENT_TYPE_CODE
18156: , h1.DISTRIBUTION_TYPE source_9
18157: , fvl9.meaning source_9_meaning
18158: , h1.TRANSFER_TO_GL_INDICATOR source_42
18159: , fvl42.meaning source_42_meaning
18160: FROM xla_events_gt xet
18161: , CST_XLA_INV_HEADERS_V h1
18162: , CST_XLA_INV_REF_V h3
18163: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
18164: , CST_XLA_INV_TXN_TYPES_REF_V h5
18218: , l2.CURRENCY_CONVERSION_DATE source_12
18219: , l2.CURRENCY_CONVERSION_RATE source_13
18220: , l2.CURRENCY_CONVERSION_TYPE source_14
18221: , l2.ACCOUNTED_AMOUNT source_15
18222: FROM xla_events_gt xet
18223: , CST_XLA_INV_LINES_V l2
18224: WHERE xet.event_id between x_first_event_id and x_last_event_id
18225: and xet.event_date between p_pad_start_date and p_pad_end_date
18226: and xet.event_type_code = C_EVENT_TYPE_CODE
19102: WHEN 20 THEN fvl42.meaning
19103:
19104: ELSE null
19105: END source_meaning
19106: FROM xla_events_gt xet
19107: , CST_XLA_INV_HEADERS_V h1
19108: , CST_XLA_INV_ORG_PARAMS_REF_V h3
19109: , CST_XLA_INV_REF_V h4
19110: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
19226:
19227: ELSE null
19228: END source_value
19229: , null source_meaning
19230: FROM xla_events_gt xet
19231: , CST_XLA_INV_LINES_V l2
19232: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
19233: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
19234: AND xet.event_type_code = C_EVENT_TYPE_CODE
19469: , h7.REQ_BUDGET_ACCOUNT source_39
19470: , h8.REQ_ENCUMBRANCE_TYPE_ID source_40
19471: , h1.TRANSFER_TO_GL_INDICATOR source_42
19472: , fvl42.meaning source_42_meaning
19473: FROM xla_events_gt xet
19474: , CST_XLA_INV_HEADERS_V h1
19475: , CST_XLA_INV_ORG_PARAMS_REF_V h3
19476: , CST_XLA_INV_REF_V h4
19477: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
19529: ,xet.budgetary_control_flag , l2.LINE_NUMBER
19530: , l2.ACCOUNTING_LINE_TYPE_CODE source_7
19531: , l2.DISTRIBUTION_IDENTIFIER source_8
19532: , l2.CURRENCY_CODE source_11
19533: FROM xla_events_gt xet
19534: , CST_XLA_INV_LINES_V l2
19535: WHERE xet.event_id between x_first_event_id and x_last_event_id
19536: and xet.event_date between p_pad_start_date and p_pad_end_date
19537: and xet.event_type_code = C_EVENT_TYPE_CODE
20442: WHEN 20 THEN fvl42.meaning
20443:
20444: ELSE null
20445: END source_meaning
20446: FROM xla_events_gt xet
20447: , CST_XLA_INV_HEADERS_V h1
20448: , CST_XLA_INV_ORG_PARAMS_REF_V h3
20449: , CST_XLA_INV_REF_V h4
20450: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
20566:
20567: ELSE null
20568: END source_value
20569: , null source_meaning
20570: FROM xla_events_gt xet
20571: , CST_XLA_INV_LINES_V l2
20572: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
20573: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
20574: AND xet.event_type_code = C_EVENT_TYPE_CODE
20809: , h7.REQ_BUDGET_ACCOUNT source_39
20810: , h8.REQ_ENCUMBRANCE_TYPE_ID source_40
20811: , h1.TRANSFER_TO_GL_INDICATOR source_42
20812: , fvl42.meaning source_42_meaning
20813: FROM xla_events_gt xet
20814: , CST_XLA_INV_HEADERS_V h1
20815: , CST_XLA_INV_ORG_PARAMS_REF_V h3
20816: , CST_XLA_INV_REF_V h4
20817: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
20869: ,xet.budgetary_control_flag , l2.LINE_NUMBER
20870: , l2.ACCOUNTING_LINE_TYPE_CODE source_7
20871: , l2.DISTRIBUTION_IDENTIFIER source_8
20872: , l2.CURRENCY_CODE source_11
20873: FROM xla_events_gt xet
20874: , CST_XLA_INV_LINES_V l2
20875: WHERE xet.event_id between x_first_event_id and x_last_event_id
20876: and xet.event_date between p_pad_start_date and p_pad_end_date
20877: and xet.event_type_code = C_EVENT_TYPE_CODE
21692: WHEN 2 THEN fvl42.meaning
21693:
21694: ELSE null
21695: END source_meaning
21696: FROM xla_events_gt xet
21697: , CST_XLA_INV_HEADERS_V h1
21698: , fnd_lookup_values fvl9
21699: , fnd_lookup_values fvl42
21700: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
21839:
21840: ELSE null
21841: END source_value
21842: , null source_meaning
21843: FROM xla_events_gt xet
21844: , CST_XLA_INV_LINES_V l2
21845: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
21846: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
21847: AND xet.event_type_code = C_EVENT_TYPE_CODE
22040: , h1.DISTRIBUTION_TYPE source_9
22041: , fvl9.meaning source_9_meaning
22042: , h1.TRANSFER_TO_GL_INDICATOR source_42
22043: , fvl42.meaning source_42_meaning
22044: FROM xla_events_gt xet
22045: , CST_XLA_INV_HEADERS_V h1
22046: , fnd_lookup_values fvl9
22047: , fnd_lookup_values fvl42
22048: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
22099: , l2.CURRENCY_CONVERSION_DATE source_12
22100: , l2.CURRENCY_CONVERSION_RATE source_13
22101: , l2.CURRENCY_CONVERSION_TYPE source_14
22102: , l2.ACCOUNTED_AMOUNT source_15
22103: FROM xla_events_gt xet
22104: , CST_XLA_INV_LINES_V l2
22105: WHERE xet.event_id between x_first_event_id and x_last_event_id
22106: and xet.event_date between p_pad_start_date and p_pad_end_date
22107: and xet.event_type_code = C_EVENT_TYPE_CODE
22870: WHEN 2 THEN fvl42.meaning
22871:
22872: ELSE null
22873: END source_meaning
22874: FROM xla_events_gt xet
22875: , CST_XLA_INV_HEADERS_V h1
22876: , fnd_lookup_values fvl9
22877: , fnd_lookup_values fvl42
22878: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
23017:
23018: ELSE null
23019: END source_value
23020: , null source_meaning
23021: FROM xla_events_gt xet
23022: , CST_XLA_INV_LINES_V l2
23023: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
23024: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
23025: AND xet.event_type_code = C_EVENT_TYPE_CODE
23218: , h1.DISTRIBUTION_TYPE source_9
23219: , fvl9.meaning source_9_meaning
23220: , h1.TRANSFER_TO_GL_INDICATOR source_42
23221: , fvl42.meaning source_42_meaning
23222: FROM xla_events_gt xet
23223: , CST_XLA_INV_HEADERS_V h1
23224: , fnd_lookup_values fvl9
23225: , fnd_lookup_values fvl42
23226: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
23277: , l2.CURRENCY_CONVERSION_DATE source_12
23278: , l2.CURRENCY_CONVERSION_RATE source_13
23279: , l2.CURRENCY_CONVERSION_TYPE source_14
23280: , l2.ACCOUNTED_AMOUNT source_15
23281: FROM xla_events_gt xet
23282: , CST_XLA_INV_LINES_V l2
23283: WHERE xet.event_id between x_first_event_id and x_last_event_id
23284: and xet.event_date between p_pad_start_date and p_pad_end_date
23285: and xet.event_type_code = C_EVENT_TYPE_CODE
24073: WHEN 7 THEN fvl42.meaning
24074:
24075: ELSE null
24076: END source_meaning
24077: FROM xla_events_gt xet
24078: , CST_XLA_INV_HEADERS_V h1
24079: , CST_XLA_INV_REF_V h3
24080: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
24081: , CST_XLA_INV_TXN_TYPES_REF_V h5
24223:
24224: ELSE null
24225: END source_value
24226: , null source_meaning
24227: FROM xla_events_gt xet
24228: , CST_XLA_INV_LINES_V l2
24229: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
24230: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
24231: AND xet.event_type_code = C_EVENT_TYPE_CODE
24439: , h1.DISTRIBUTION_TYPE source_9
24440: , fvl9.meaning source_9_meaning
24441: , h1.TRANSFER_TO_GL_INDICATOR source_42
24442: , fvl42.meaning source_42_meaning
24443: FROM xla_events_gt xet
24444: , CST_XLA_INV_HEADERS_V h1
24445: , CST_XLA_INV_REF_V h3
24446: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
24447: , CST_XLA_INV_TXN_TYPES_REF_V h5
24501: , l2.CURRENCY_CONVERSION_DATE source_12
24502: , l2.CURRENCY_CONVERSION_RATE source_13
24503: , l2.CURRENCY_CONVERSION_TYPE source_14
24504: , l2.ACCOUNTED_AMOUNT source_15
24505: FROM xla_events_gt xet
24506: , CST_XLA_INV_LINES_V l2
24507: WHERE xet.event_id between x_first_event_id and x_last_event_id
24508: and xet.event_date between p_pad_start_date and p_pad_end_date
24509: and xet.event_type_code = C_EVENT_TYPE_CODE
25320: WHEN 7 THEN fvl42.meaning
25321:
25322: ELSE null
25323: END source_meaning
25324: FROM xla_events_gt xet
25325: , CST_XLA_INV_HEADERS_V h1
25326: , CST_XLA_INV_REF_V h3
25327: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
25328: , CST_XLA_INV_TXN_TYPES_REF_V h5
25470:
25471: ELSE null
25472: END source_value
25473: , null source_meaning
25474: FROM xla_events_gt xet
25475: , CST_XLA_INV_LINES_V l2
25476: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
25477: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
25478: AND xet.event_type_code = C_EVENT_TYPE_CODE
25686: , h1.DISTRIBUTION_TYPE source_9
25687: , fvl9.meaning source_9_meaning
25688: , h1.TRANSFER_TO_GL_INDICATOR source_42
25689: , fvl42.meaning source_42_meaning
25690: FROM xla_events_gt xet
25691: , CST_XLA_INV_HEADERS_V h1
25692: , CST_XLA_INV_REF_V h3
25693: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
25694: , CST_XLA_INV_TXN_TYPES_REF_V h5
25748: , l2.CURRENCY_CONVERSION_DATE source_12
25749: , l2.CURRENCY_CONVERSION_RATE source_13
25750: , l2.CURRENCY_CONVERSION_TYPE source_14
25751: , l2.ACCOUNTED_AMOUNT source_15
25752: FROM xla_events_gt xet
25753: , CST_XLA_INV_LINES_V l2
25754: WHERE xet.event_id between x_first_event_id and x_last_event_id
25755: and xet.event_date between p_pad_start_date and p_pad_end_date
25756: and xet.event_type_code = C_EVENT_TYPE_CODE
26632: WHEN 20 THEN fvl42.meaning
26633:
26634: ELSE null
26635: END source_meaning
26636: FROM xla_events_gt xet
26637: , CST_XLA_INV_HEADERS_V h1
26638: , CST_XLA_INV_ORG_PARAMS_REF_V h3
26639: , CST_XLA_INV_REF_V h4
26640: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
26757:
26758: ELSE null
26759: END source_value
26760: , null source_meaning
26761: FROM xla_events_gt xet
26762: , CST_XLA_INV_LINES_V l2
26763: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
26764: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
26765: AND xet.event_type_code = C_EVENT_TYPE_CODE
27000: , h8.PURCH_ENCUMBRANCE_TYPE_ID source_28
27001: , h7.RESERVED_FLAG source_31
27002: , h1.TRANSFER_TO_GL_INDICATOR source_42
27003: , fvl42.meaning source_42_meaning
27004: FROM xla_events_gt xet
27005: , CST_XLA_INV_HEADERS_V h1
27006: , CST_XLA_INV_ORG_PARAMS_REF_V h3
27007: , CST_XLA_INV_REF_V h4
27008: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
27061: ,xet.budgetary_control_flag , l2.LINE_NUMBER
27062: , l2.ACCOUNTING_LINE_TYPE_CODE source_7
27063: , l2.DISTRIBUTION_IDENTIFIER source_8
27064: , l2.CURRENCY_CODE source_11
27065: FROM xla_events_gt xet
27066: , CST_XLA_INV_LINES_V l2
27067: WHERE xet.event_id between x_first_event_id and x_last_event_id
27068: and xet.event_date between p_pad_start_date and p_pad_end_date
27069: and xet.event_type_code = C_EVENT_TYPE_CODE
28008: WHEN 20 THEN fvl42.meaning
28009:
28010: ELSE null
28011: END source_meaning
28012: FROM xla_events_gt xet
28013: , CST_XLA_INV_HEADERS_V h1
28014: , CST_XLA_INV_ORG_PARAMS_REF_V h3
28015: , CST_XLA_INV_REF_V h4
28016: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
28133:
28134: ELSE null
28135: END source_value
28136: , null source_meaning
28137: FROM xla_events_gt xet
28138: , CST_XLA_INV_LINES_V l2
28139: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
28140: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
28141: AND xet.event_type_code = C_EVENT_TYPE_CODE
28376: , h8.PURCH_ENCUMBRANCE_TYPE_ID source_28
28377: , h7.RESERVED_FLAG source_31
28378: , h1.TRANSFER_TO_GL_INDICATOR source_42
28379: , fvl42.meaning source_42_meaning
28380: FROM xla_events_gt xet
28381: , CST_XLA_INV_HEADERS_V h1
28382: , CST_XLA_INV_ORG_PARAMS_REF_V h3
28383: , CST_XLA_INV_REF_V h4
28384: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
28437: ,xet.budgetary_control_flag , l2.LINE_NUMBER
28438: , l2.ACCOUNTING_LINE_TYPE_CODE source_7
28439: , l2.DISTRIBUTION_IDENTIFIER source_8
28440: , l2.CURRENCY_CODE source_11
28441: FROM xla_events_gt xet
28442: , CST_XLA_INV_LINES_V l2
28443: WHERE xet.event_id between x_first_event_id and x_last_event_id
28444: and xet.event_date between p_pad_start_date and p_pad_end_date
28445: and xet.event_type_code = C_EVENT_TYPE_CODE
29384: WHEN 20 THEN fvl42.meaning
29385:
29386: ELSE null
29387: END source_meaning
29388: FROM xla_events_gt xet
29389: , CST_XLA_INV_HEADERS_V h1
29390: , CST_XLA_INV_ORG_PARAMS_REF_V h3
29391: , CST_XLA_INV_REF_V h4
29392: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
29509:
29510: ELSE null
29511: END source_value
29512: , null source_meaning
29513: FROM xla_events_gt xet
29514: , CST_XLA_INV_LINES_V l2
29515: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
29516: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
29517: AND xet.event_type_code = C_EVENT_TYPE_CODE
29752: , h8.PURCH_ENCUMBRANCE_TYPE_ID source_28
29753: , h7.RESERVED_FLAG source_31
29754: , h1.TRANSFER_TO_GL_INDICATOR source_42
29755: , fvl42.meaning source_42_meaning
29756: FROM xla_events_gt xet
29757: , CST_XLA_INV_HEADERS_V h1
29758: , CST_XLA_INV_ORG_PARAMS_REF_V h3
29759: , CST_XLA_INV_REF_V h4
29760: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
29813: ,xet.budgetary_control_flag , l2.LINE_NUMBER
29814: , l2.ACCOUNTING_LINE_TYPE_CODE source_7
29815: , l2.DISTRIBUTION_IDENTIFIER source_8
29816: , l2.CURRENCY_CODE source_11
29817: FROM xla_events_gt xet
29818: , CST_XLA_INV_LINES_V l2
29819: WHERE xet.event_id between x_first_event_id and x_last_event_id
29820: and xet.event_date between p_pad_start_date and p_pad_end_date
29821: and xet.event_type_code = C_EVENT_TYPE_CODE
30730: WHEN 14 THEN fvl42.meaning
30731:
30732: ELSE null
30733: END source_meaning
30734: FROM xla_events_gt xet
30735: , CST_XLA_RCV_HEADERS_V h1
30736: , CST_XLA_RCV_REF_V h3
30737: , PO_DISTS_REF_V h4
30738: , PO_HEADERS_REF_V h5
30847:
30848: ELSE null
30849: END source_value
30850: , null source_meaning
30851: FROM xla_events_gt xet
30852: , CST_XLA_RCV_LINES_V l2
30853: , (select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
30854: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
30855: AND xet.event_class_code = C_EVENT_CLASS_CODE
31069: , h3.PO_DISTRIBUTION_ID source_30
31070: , h6.CST_PEA_ENC_UPG_OPTION source_32
31071: , h1.TRANSFER_TO_GL_INDICATOR source_42
31072: , fvl42.meaning source_42_meaning
31073: FROM xla_events_gt xet
31074: , CST_XLA_RCV_HEADERS_V h1
31075: , CST_XLA_RCV_REF_V h3
31076: , PO_DISTS_REF_V h4
31077: , PO_HEADERS_REF_V h5
31125: ,xet.budgetary_control_flag
31126: , l2.LINE_NUMBER
31127: , l2.DISTRIBUTION_IDENTIFIER source_8
31128: , l2.RCV_ACCOUNTING_LINE_TYPE source_29
31129: FROM xla_events_gt xet
31130: , CST_XLA_RCV_LINES_V l2
31131: WHERE xet.event_id between x_first_event_id and x_last_event_id
31132: and xet.event_date between p_pad_start_date and p_pad_end_date
31133: and xet.event_class_code = C_EVENT_CLASS_CODE
32056: WHEN 20 THEN fvl42.meaning
32057:
32058: ELSE null
32059: END source_meaning
32060: FROM xla_events_gt xet
32061: , CST_XLA_INV_HEADERS_V h1
32062: , CST_XLA_INV_ORG_PARAMS_REF_V h3
32063: , CST_XLA_INV_REF_V h4
32064: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
32181:
32182: ELSE null
32183: END source_value
32184: , null source_meaning
32185: FROM xla_events_gt xet
32186: , CST_XLA_INV_LINES_V l2
32187: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
32188: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
32189: AND xet.event_type_code = C_EVENT_TYPE_CODE
32424: , h8.PURCH_ENCUMBRANCE_TYPE_ID source_28
32425: , h7.RESERVED_FLAG source_31
32426: , h1.TRANSFER_TO_GL_INDICATOR source_42
32427: , fvl42.meaning source_42_meaning
32428: FROM xla_events_gt xet
32429: , CST_XLA_INV_HEADERS_V h1
32430: , CST_XLA_INV_ORG_PARAMS_REF_V h3
32431: , CST_XLA_INV_REF_V h4
32432: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
32485: ,xet.budgetary_control_flag , l2.LINE_NUMBER
32486: , l2.ACCOUNTING_LINE_TYPE_CODE source_7
32487: , l2.DISTRIBUTION_IDENTIFIER source_8
32488: , l2.CURRENCY_CODE source_11
32489: FROM xla_events_gt xet
32490: , CST_XLA_INV_LINES_V l2
32491: WHERE xet.event_id between x_first_event_id and x_last_event_id
32492: and xet.event_date between p_pad_start_date and p_pad_end_date
32493: and xet.event_type_code = C_EVENT_TYPE_CODE
33432: WHEN 20 THEN fvl42.meaning
33433:
33434: ELSE null
33435: END source_meaning
33436: FROM xla_events_gt xet
33437: , CST_XLA_INV_HEADERS_V h1
33438: , CST_XLA_INV_ORG_PARAMS_REF_V h3
33439: , CST_XLA_INV_REF_V h4
33440: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
33557:
33558: ELSE null
33559: END source_value
33560: , null source_meaning
33561: FROM xla_events_gt xet
33562: , CST_XLA_INV_LINES_V l2
33563: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
33564: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
33565: AND xet.event_type_code = C_EVENT_TYPE_CODE
33800: , h8.PURCH_ENCUMBRANCE_TYPE_ID source_28
33801: , h7.RESERVED_FLAG source_31
33802: , h1.TRANSFER_TO_GL_INDICATOR source_42
33803: , fvl42.meaning source_42_meaning
33804: FROM xla_events_gt xet
33805: , CST_XLA_INV_HEADERS_V h1
33806: , CST_XLA_INV_ORG_PARAMS_REF_V h3
33807: , CST_XLA_INV_REF_V h4
33808: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
33861: ,xet.budgetary_control_flag , l2.LINE_NUMBER
33862: , l2.ACCOUNTING_LINE_TYPE_CODE source_7
33863: , l2.DISTRIBUTION_IDENTIFIER source_8
33864: , l2.CURRENCY_CODE source_11
33865: FROM xla_events_gt xet
33866: , CST_XLA_INV_LINES_V l2
33867: WHERE xet.event_id between x_first_event_id and x_last_event_id
33868: and xet.event_date between p_pad_start_date and p_pad_end_date
33869: and xet.event_type_code = C_EVENT_TYPE_CODE
34808: WHEN 20 THEN fvl42.meaning
34809:
34810: ELSE null
34811: END source_meaning
34812: FROM xla_events_gt xet
34813: , CST_XLA_INV_HEADERS_V h1
34814: , CST_XLA_INV_ORG_PARAMS_REF_V h3
34815: , CST_XLA_INV_REF_V h4
34816: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
34933:
34934: ELSE null
34935: END source_value
34936: , null source_meaning
34937: FROM xla_events_gt xet
34938: , CST_XLA_INV_LINES_V l2
34939: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
34940: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
34941: AND xet.event_type_code = C_EVENT_TYPE_CODE
35176: , h8.PURCH_ENCUMBRANCE_TYPE_ID source_28
35177: , h7.RESERVED_FLAG source_31
35178: , h1.TRANSFER_TO_GL_INDICATOR source_42
35179: , fvl42.meaning source_42_meaning
35180: FROM xla_events_gt xet
35181: , CST_XLA_INV_HEADERS_V h1
35182: , CST_XLA_INV_ORG_PARAMS_REF_V h3
35183: , CST_XLA_INV_REF_V h4
35184: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
35237: ,xet.budgetary_control_flag , l2.LINE_NUMBER
35238: , l2.ACCOUNTING_LINE_TYPE_CODE source_7
35239: , l2.DISTRIBUTION_IDENTIFIER source_8
35240: , l2.CURRENCY_CODE source_11
35241: FROM xla_events_gt xet
35242: , CST_XLA_INV_LINES_V l2
35243: WHERE xet.event_id between x_first_event_id and x_last_event_id
35244: and xet.event_date between p_pad_start_date and p_pad_end_date
35245: and xet.event_type_code = C_EVENT_TYPE_CODE
36610: ,p_level => C_LEVEL_STATEMENT
36611: ,p_module => l_log_module);
36612:
36613: trace
36614: (p_msg => '# of events in xla_events_gt: '
36615: ||xla_context_pkg.get_event_count_context
36616: ,p_level => C_LEVEL_STATEMENT
36617: ,p_module => l_log_module);
36618: