[Home] [Help]
74073: WHEN 2 THEN fvl73.meaning
74074:
74075: ELSE null
74076: END source_meaning
74077: FROM xla_events_gt xet
74078: , PA_XLA_EXP_HEADER_V h2
74079: , fnd_lookup_values fvl73
74080: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
74081: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74271: WHEN 15 THEN fvl35.meaning
74272:
74273: ELSE null
74274: END source_meaning
74275: FROM xla_events_gt xet
74276: , PA_XLA_CCDL_LINES_V l1
74277: , fnd_lookup_values fvl35
74278: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
74279: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74494: , h2.EXPENDITURE_ITEM_ID source_33
74495: , h2.TP_AMT_TYPE_CODE source_73
74496: , fvl73.meaning source_73_meaning
74497: , h2.GL_DATE source_75
74498: FROM xla_events_gt xet
74499: , PA_XLA_EXP_HEADER_V h2
74500: , fnd_lookup_values fvl73
74501: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
74502: and xet.event_class_code = C_EVENT_CLASS_CODE
74558: , fvl35.meaning source_35_meaning
74559: , l1.LINE_NUM_REVERSED source_36
74560: , l1.ENTERED_AMOUNT source_42
74561: , l1.ACCT_AMOUNT source_43
74562: FROM xla_events_gt xet
74563: , PA_XLA_CCDL_LINES_V l1
74564: , fnd_lookup_values fvl35
74565: WHERE xet.event_id between x_first_event_id and x_last_event_id
74566: and xet.event_date between p_pad_start_date and p_pad_end_date
75481: WHEN 2 THEN fvl73.meaning
75482:
75483: ELSE null
75484: END source_meaning
75485: FROM xla_events_gt xet
75486: , PA_XLA_EXP_HEADER_V h2
75487: , fnd_lookup_values fvl73
75488: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
75489: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
75679: WHEN 15 THEN fvl35.meaning
75680:
75681: ELSE null
75682: END source_meaning
75683: FROM xla_events_gt xet
75684: , PA_XLA_CCDL_LINES_V l1
75685: , fnd_lookup_values fvl35
75686: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
75687: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
75902: , h2.EXPENDITURE_ITEM_ID source_33
75903: , h2.TP_AMT_TYPE_CODE source_73
75904: , fvl73.meaning source_73_meaning
75905: , h2.GL_DATE source_75
75906: FROM xla_events_gt xet
75907: , PA_XLA_EXP_HEADER_V h2
75908: , fnd_lookup_values fvl73
75909: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
75910: and xet.event_class_code = C_EVENT_CLASS_CODE
75966: , fvl35.meaning source_35_meaning
75967: , l1.LINE_NUM_REVERSED source_36
75968: , l1.ENTERED_AMOUNT source_42
75969: , l1.ACCT_AMOUNT source_43
75970: FROM xla_events_gt xet
75971: , PA_XLA_CCDL_LINES_V l1
75972: , fnd_lookup_values fvl35
75973: WHERE xet.event_id between x_first_event_id and x_last_event_id
75974: and xet.event_date between p_pad_start_date and p_pad_end_date
76899: WHEN 2 THEN fvl38.meaning
76900:
76901: ELSE null
76902: END source_meaning
76903: FROM xla_events_gt xet
76904: , PA_XLA_BC_BUDGET_HEADER_V h1
76905: , PA_XLA_PROJECT_REF_V h3
76906: , fnd_lookup_values fvl38
76907: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
77067: WHEN 7 THEN fvl35.meaning
77068:
77069: ELSE null
77070: END source_meaning
77071: FROM xla_events_gt xet
77072: , PA_XLA_BC_BUDGET_LINES_V l2
77073: , fnd_lookup_values fvl35
77074: , (select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
77075: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77286: , fvl38.meaning source_38_meaning
77287: , h1.BC_BALANCE_TYPE source_39
77288: , h1.GL_DATE source_75
77289: , h1.GL_BUDGET_VERSION_ID source_76
77290: FROM xla_events_gt xet
77291: , PA_XLA_BC_BUDGET_HEADER_V h1
77292: , PA_XLA_PROJECT_REF_V h3
77293: , fnd_lookup_values fvl38
77294: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
77346: , l2.ENTERED_AMOUNT source_42
77347: , l2.ACCT_AMOUNT source_43
77348: , l2.USE_ENC_UPG_ATTRIB_FLAG source_44
77349: , l2.ENC_UPG_ENC_TYPE_ID source_45
77350: FROM xla_events_gt xet
77351: , PA_XLA_BC_BUDGET_LINES_V l2
77352: , fnd_lookup_values fvl35
77353: WHERE xet.event_id between x_first_event_id and x_last_event_id
77354: and xet.event_date between p_pad_start_date and p_pad_end_date
78217:
78218: ELSE null
78219: END source_value
78220: , null source_meaning
78221: FROM xla_events_gt xet
78222: , PA_XLA_EXP_HEADER_V h2
78223: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
78224: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
78225: AND xet.event_class_code = C_EVENT_CLASS_CODE
78475: WHEN 16 THEN fvl35.meaning
78476:
78477: ELSE null
78478: END source_meaning
78479: FROM xla_events_gt xet
78480: , PA_XLA_CDL_LINES_V l1
78481: , fnd_lookup_values fvl35
78482: , (select rownum r from all_objects where rownum <= 31 and owner = p_apps_owner)
78483: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
78719: ,xet.event_created_by
78720: ,xet.budgetary_control_flag
78721: , h2.EXPENDITURE_ITEM_ID source_33
78722: , h2.GL_DATE source_75
78723: FROM xla_events_gt xet
78724: , PA_XLA_EXP_HEADER_V h2
78725: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
78726: and xet.event_class_code = C_EVENT_CLASS_CODE
78727: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
78791: , l1.PA_SECOND_DIST_ID source_60
78792: , l1.ENC_UPG_CR_ACCT_CLASS source_61
78793: , l1.ENCUMBRANCE_TYPE_ID source_62
78794: , l1.PROJ_ENCUMBRANCE_TYPE_ID source_63
78795: FROM xla_events_gt xet
78796: , PA_XLA_CDL_LINES_V l1
78797: , fnd_lookup_values fvl35
78798: WHERE xet.event_id between x_first_event_id and x_last_event_id
78799: and xet.event_date between p_pad_start_date and p_pad_end_date
79784:
79785: ELSE null
79786: END source_value
79787: , null source_meaning
79788: FROM xla_events_gt xet
79789: , PA_XLA_EXP_HEADER_V h2
79790: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
79791: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
79792: AND xet.event_class_code = C_EVENT_CLASS_CODE
80042: WHEN 16 THEN fvl35.meaning
80043:
80044: ELSE null
80045: END source_meaning
80046: FROM xla_events_gt xet
80047: , PA_XLA_CDL_LINES_V l1
80048: , fnd_lookup_values fvl35
80049: , (select rownum r from all_objects where rownum <= 31 and owner = p_apps_owner)
80050: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
80286: ,xet.event_created_by
80287: ,xet.budgetary_control_flag
80288: , h2.EXPENDITURE_ITEM_ID source_33
80289: , h2.GL_DATE source_75
80290: FROM xla_events_gt xet
80291: , PA_XLA_EXP_HEADER_V h2
80292: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
80293: and xet.event_class_code = C_EVENT_CLASS_CODE
80294: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
80358: , l1.PA_SECOND_DIST_ID source_60
80359: , l1.ENC_UPG_CR_ACCT_CLASS source_61
80360: , l1.ENCUMBRANCE_TYPE_ID source_62
80361: , l1.PROJ_ENCUMBRANCE_TYPE_ID source_63
80362: FROM xla_events_gt xet
80363: , PA_XLA_CDL_LINES_V l1
80364: , fnd_lookup_values fvl35
80365: WHERE xet.event_id between x_first_event_id and x_last_event_id
80366: and xet.event_date between p_pad_start_date and p_pad_end_date
81351:
81352: ELSE null
81353: END source_value
81354: , null source_meaning
81355: FROM xla_events_gt xet
81356: , PA_XLA_EXP_HEADER_V h2
81357: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
81358: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
81359: AND xet.event_class_code = C_EVENT_CLASS_CODE
81544: WHEN 17 THEN fvl35.meaning
81545:
81546: ELSE null
81547: END source_meaning
81548: FROM xla_events_gt xet
81549: , PA_XLA_CDL_LINES_V l1
81550: , fnd_lookup_values fvl35
81551: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
81552: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
81762: ,xet.event_created_by
81763: ,xet.budgetary_control_flag
81764: , h2.EXPENDITURE_ITEM_ID source_33
81765: , h2.GL_DATE source_75
81766: FROM xla_events_gt xet
81767: , PA_XLA_EXP_HEADER_V h2
81768: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
81769: and xet.event_class_code = C_EVENT_CLASS_CODE
81770: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
81821: , l1.LINE_NUMBER source_34
81822: , l1.LINE_TYPE source_35
81823: , fvl35.meaning source_35_meaning
81824: , l1.LINE_NUM_REVERSED source_36
81825: FROM xla_events_gt xet
81826: , PA_XLA_CDL_LINES_V l1
81827: , fnd_lookup_values fvl35
81828: WHERE xet.event_id between x_first_event_id and x_last_event_id
81829: and xet.event_date between p_pad_start_date and p_pad_end_date
82723:
82724: ELSE null
82725: END source_value
82726: , null source_meaning
82727: FROM xla_events_gt xet
82728: , PA_XLA_EXP_HEADER_V h2
82729: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
82730: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
82731: AND xet.event_class_code = C_EVENT_CLASS_CODE
82916: WHEN 17 THEN fvl35.meaning
82917:
82918: ELSE null
82919: END source_meaning
82920: FROM xla_events_gt xet
82921: , PA_XLA_CDL_LINES_V l1
82922: , fnd_lookup_values fvl35
82923: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
82924: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
83134: ,xet.event_created_by
83135: ,xet.budgetary_control_flag
83136: , h2.EXPENDITURE_ITEM_ID source_33
83137: , h2.GL_DATE source_75
83138: FROM xla_events_gt xet
83139: , PA_XLA_EXP_HEADER_V h2
83140: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
83141: and xet.event_class_code = C_EVENT_CLASS_CODE
83142: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
83193: , l1.LINE_NUMBER source_34
83194: , l1.LINE_TYPE source_35
83195: , fvl35.meaning source_35_meaning
83196: , l1.LINE_NUM_REVERSED source_36
83197: FROM xla_events_gt xet
83198: , PA_XLA_CDL_LINES_V l1
83199: , fnd_lookup_values fvl35
83200: WHERE xet.event_id between x_first_event_id and x_last_event_id
83201: and xet.event_date between p_pad_start_date and p_pad_end_date
84095:
84096: ELSE null
84097: END source_value
84098: , null source_meaning
84099: FROM xla_events_gt xet
84100: , PA_XLA_EXP_HEADER_V h2
84101: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
84102: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
84103: AND xet.event_class_code = C_EVENT_CLASS_CODE
84288: WHEN 17 THEN fvl35.meaning
84289:
84290: ELSE null
84291: END source_meaning
84292: FROM xla_events_gt xet
84293: , PA_XLA_CDL_LINES_V l1
84294: , fnd_lookup_values fvl35
84295: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
84296: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
84506: ,xet.event_created_by
84507: ,xet.budgetary_control_flag
84508: , h2.EXPENDITURE_ITEM_ID source_33
84509: , h2.GL_DATE source_75
84510: FROM xla_events_gt xet
84511: , PA_XLA_EXP_HEADER_V h2
84512: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
84513: and xet.event_class_code = C_EVENT_CLASS_CODE
84514: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
84565: , l1.LINE_NUMBER source_34
84566: , l1.LINE_TYPE source_35
84567: , fvl35.meaning source_35_meaning
84568: , l1.LINE_NUM_REVERSED source_36
84569: FROM xla_events_gt xet
84570: , PA_XLA_CDL_LINES_V l1
84571: , fnd_lookup_values fvl35
84572: WHERE xet.event_id between x_first_event_id and x_last_event_id
84573: and xet.event_date between p_pad_start_date and p_pad_end_date
85467:
85468: ELSE null
85469: END source_value
85470: , null source_meaning
85471: FROM xla_events_gt xet
85472: , PA_XLA_EXP_HEADER_V h2
85473: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
85474: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
85475: AND xet.event_class_code = C_EVENT_CLASS_CODE
85660: WHEN 17 THEN fvl35.meaning
85661:
85662: ELSE null
85663: END source_meaning
85664: FROM xla_events_gt xet
85665: , PA_XLA_CDL_LINES_V l1
85666: , fnd_lookup_values fvl35
85667: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
85668: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
85878: ,xet.event_created_by
85879: ,xet.budgetary_control_flag
85880: , h2.EXPENDITURE_ITEM_ID source_33
85881: , h2.GL_DATE source_75
85882: FROM xla_events_gt xet
85883: , PA_XLA_EXP_HEADER_V h2
85884: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
85885: and xet.event_class_code = C_EVENT_CLASS_CODE
85886: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
85937: , l1.LINE_NUMBER source_34
85938: , l1.LINE_TYPE source_35
85939: , fvl35.meaning source_35_meaning
85940: , l1.LINE_NUM_REVERSED source_36
85941: FROM xla_events_gt xet
85942: , PA_XLA_CDL_LINES_V l1
85943: , fnd_lookup_values fvl35
85944: WHERE xet.event_id between x_first_event_id and x_last_event_id
85945: and xet.event_date between p_pad_start_date and p_pad_end_date
86839:
86840: ELSE null
86841: END source_value
86842: , null source_meaning
86843: FROM xla_events_gt xet
86844: , PA_XLA_EXP_HEADER_V h2
86845: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
86846: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
86847: AND xet.event_class_code = C_EVENT_CLASS_CODE
87032: WHEN 17 THEN fvl35.meaning
87033:
87034: ELSE null
87035: END source_meaning
87036: FROM xla_events_gt xet
87037: , PA_XLA_CDL_LINES_V l1
87038: , fnd_lookup_values fvl35
87039: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
87040: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
87250: ,xet.event_created_by
87251: ,xet.budgetary_control_flag
87252: , h2.EXPENDITURE_ITEM_ID source_33
87253: , h2.GL_DATE source_75
87254: FROM xla_events_gt xet
87255: , PA_XLA_EXP_HEADER_V h2
87256: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
87257: and xet.event_class_code = C_EVENT_CLASS_CODE
87258: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
87309: , l1.LINE_NUMBER source_34
87310: , l1.LINE_TYPE source_35
87311: , fvl35.meaning source_35_meaning
87312: , l1.LINE_NUM_REVERSED source_36
87313: FROM xla_events_gt xet
87314: , PA_XLA_CDL_LINES_V l1
87315: , fnd_lookup_values fvl35
87316: WHERE xet.event_id between x_first_event_id and x_last_event_id
87317: and xet.event_date between p_pad_start_date and p_pad_end_date
88211:
88212: ELSE null
88213: END source_value
88214: , null source_meaning
88215: FROM xla_events_gt xet
88216: , PA_XLA_EXP_HEADER_V h2
88217: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
88218: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
88219: AND xet.event_class_code = C_EVENT_CLASS_CODE
88404: WHEN 17 THEN fvl35.meaning
88405:
88406: ELSE null
88407: END source_meaning
88408: FROM xla_events_gt xet
88409: , PA_XLA_CDL_LINES_V l1
88410: , fnd_lookup_values fvl35
88411: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
88412: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
88622: ,xet.event_created_by
88623: ,xet.budgetary_control_flag
88624: , h2.EXPENDITURE_ITEM_ID source_33
88625: , h2.GL_DATE source_75
88626: FROM xla_events_gt xet
88627: , PA_XLA_EXP_HEADER_V h2
88628: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
88629: and xet.event_class_code = C_EVENT_CLASS_CODE
88630: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
88681: , l1.LINE_NUMBER source_34
88682: , l1.LINE_TYPE source_35
88683: , fvl35.meaning source_35_meaning
88684: , l1.LINE_NUM_REVERSED source_36
88685: FROM xla_events_gt xet
88686: , PA_XLA_CDL_LINES_V l1
88687: , fnd_lookup_values fvl35
88688: WHERE xet.event_id between x_first_event_id and x_last_event_id
88689: and xet.event_date between p_pad_start_date and p_pad_end_date
89583:
89584: ELSE null
89585: END source_value
89586: , null source_meaning
89587: FROM xla_events_gt xet
89588: , PA_XLA_EXP_HEADER_V h2
89589: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
89590: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
89591: AND xet.event_class_code = C_EVENT_CLASS_CODE
89776: WHEN 15 THEN fvl35.meaning
89777:
89778: ELSE null
89779: END source_meaning
89780: FROM xla_events_gt xet
89781: , PA_XLA_CCDL_LINES_V l1
89782: , fnd_lookup_values fvl35
89783: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
89784: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
89994: ,xet.event_created_by
89995: ,xet.budgetary_control_flag
89996: , h2.EXPENDITURE_ITEM_ID source_33
89997: , h2.GL_DATE source_75
89998: FROM xla_events_gt xet
89999: , PA_XLA_EXP_HEADER_V h2
90000: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
90001: and xet.event_class_code = C_EVENT_CLASS_CODE
90002: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
90053: , fvl35.meaning source_35_meaning
90054: , l1.LINE_NUM_REVERSED source_36
90055: , l1.ENTERED_AMOUNT source_42
90056: , l1.ACCT_AMOUNT source_43
90057: FROM xla_events_gt xet
90058: , PA_XLA_CCDL_LINES_V l1
90059: , fnd_lookup_values fvl35
90060: WHERE xet.event_id between x_first_event_id and x_last_event_id
90061: and xet.event_date between p_pad_start_date and p_pad_end_date
90881:
90882: ELSE null
90883: END source_value
90884: , null source_meaning
90885: FROM xla_events_gt xet
90886: , PA_XLA_EXP_HEADER_V h2
90887: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
90888: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
90889: AND xet.event_class_code = C_EVENT_CLASS_CODE
91074: WHEN 15 THEN fvl35.meaning
91075:
91076: ELSE null
91077: END source_meaning
91078: FROM xla_events_gt xet
91079: , PA_XLA_CCDL_LINES_V l1
91080: , fnd_lookup_values fvl35
91081: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
91082: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
91292: ,xet.event_created_by
91293: ,xet.budgetary_control_flag
91294: , h2.EXPENDITURE_ITEM_ID source_33
91295: , h2.GL_DATE source_75
91296: FROM xla_events_gt xet
91297: , PA_XLA_EXP_HEADER_V h2
91298: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
91299: and xet.event_class_code = C_EVENT_CLASS_CODE
91300: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
91351: , fvl35.meaning source_35_meaning
91352: , l1.LINE_NUM_REVERSED source_36
91353: , l1.ENTERED_AMOUNT source_42
91354: , l1.ACCT_AMOUNT source_43
91355: FROM xla_events_gt xet
91356: , PA_XLA_CCDL_LINES_V l1
91357: , fnd_lookup_values fvl35
91358: WHERE xet.event_id between x_first_event_id and x_last_event_id
91359: and xet.event_date between p_pad_start_date and p_pad_end_date
92203: ,275)
92204:
92205: ELSE null
92206: END source_meaning
92207: FROM xla_events_gt xet
92208: , PA_XLA_REVENUE_HEADERS_V h2
92209: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
92210: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
92211: AND xet.event_class_code = C_EVENT_CLASS_CODE
92425: WHEN 25 THEN fvl72.meaning
92426:
92427: ELSE null
92428: END source_meaning
92429: FROM xla_events_gt xet
92430: , PA_XLA_EVENT_TYPE_REF_V l1
92431: , PA_XLA_REVENUE_LINES_ADJ_V l3
92432: , fnd_lookup_values fvl72
92433: , (select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
92667: , h2.EVENT_ID source_51
92668: , h2.GL_DATE source_75
92669: , h2.UER_CCID source_77
92670: , h2.UBR_CCID source_78
92671: FROM xla_events_gt xet
92672: , PA_XLA_REVENUE_HEADERS_V h2
92673: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
92674: and xet.event_class_code = C_EVENT_CLASS_CODE
92675: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
92733: , l3.CR_REVENUE_SECOND_DIST_ID source_70
92734: , l3.PDR_DRAFT_REV_NUM_CREDITED source_71
92735: , l1.REV_EVENT_TYPE_CLASSIFICATION source_72
92736: , fvl72.meaning source_72_meaning
92737: FROM xla_events_gt xet
92738: , PA_XLA_EVENT_TYPE_REF_V l1
92739: , PA_XLA_REVENUE_LINES_ADJ_V l3
92740: , fnd_lookup_values fvl72
92741: WHERE xet.event_id between x_first_event_id and x_last_event_id
93972: ,275)
93973:
93974: ELSE null
93975: END source_meaning
93976: FROM xla_events_gt xet
93977: , PA_XLA_REVENUE_HEADERS_V h2
93978: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
93979: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
93980: AND xet.event_class_code = C_EVENT_CLASS_CODE
94154: WHEN 17 THEN fvl72.meaning
94155:
94156: ELSE null
94157: END source_meaning
94158: FROM xla_events_gt xet
94159: , PA_XLA_EVENT_TYPE_REF_V l1
94160: , PA_XLA_REVENUE_LINES_V l3
94161: , fnd_lookup_values fvl72
94162: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
94380: , h2.EVENT_ID source_51
94381: , h2.GL_DATE source_75
94382: , h2.UER_CCID source_77
94383: , h2.UBR_CCID source_78
94384: FROM xla_events_gt xet
94385: , PA_XLA_REVENUE_HEADERS_V h2
94386: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
94387: and xet.event_class_code = C_EVENT_CLASS_CODE
94388: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
94438: , l3.REVENUE_FIRST_DIST_ID source_49
94439: , l3.REVENUE_SECOND_DIST_ID source_50
94440: , l1.REV_EVENT_TYPE_CLASSIFICATION source_72
94441: , fvl72.meaning source_72_meaning
94442: FROM xla_events_gt xet
94443: , PA_XLA_EVENT_TYPE_REF_V l1
94444: , PA_XLA_REVENUE_LINES_V l3
94445: , fnd_lookup_values fvl72
94446: WHERE xet.event_id between x_first_event_id and x_last_event_id
95740: ,275)
95741:
95742: ELSE null
95743: END source_meaning
95744: FROM xla_events_gt xet
95745: , GMS_XLA_AWARD_REF_V h1
95746: , PA_XLA_EXP_HEADER_V h3
95747: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
95748: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
95934: WHEN 17 THEN fvl35.meaning
95935:
95936: ELSE null
95937: END source_meaning
95938: FROM xla_events_gt xet
95939: , PA_XLA_CDL_LINES_V l2
95940: , fnd_lookup_values fvl35
95941: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
95942: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
96158: , h1.PO_DISTRIBUTION_ID source_2
96159: , h3.EXCHANGE_RATE_VARIANCE_FLAG source_22
96160: , h3.EXPENDITURE_ITEM_ID source_33
96161: , h3.GL_DATE source_75
96162: FROM xla_events_gt xet
96163: , GMS_XLA_AWARD_REF_V h1
96164: , PA_XLA_EXP_HEADER_V h3
96165: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
96166: and xet.event_class_code = C_EVENT_CLASS_CODE
96218: , l2.LINE_NUMBER source_34
96219: , l2.LINE_TYPE source_35
96220: , fvl35.meaning source_35_meaning
96221: , l2.LINE_NUM_REVERSED source_36
96222: FROM xla_events_gt xet
96223: , PA_XLA_CDL_LINES_V l2
96224: , fnd_lookup_values fvl35
96225: WHERE xet.event_id between x_first_event_id and x_last_event_id
96226: and xet.event_date between p_pad_start_date and p_pad_end_date
97301: ,275)
97302:
97303: ELSE null
97304: END source_meaning
97305: FROM xla_events_gt xet
97306: , GMS_XLA_AWARD_REF_V h1
97307: , PA_XLA_EXP_HEADER_V h3
97308: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
97309: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
97495: WHEN 17 THEN fvl35.meaning
97496:
97497: ELSE null
97498: END source_meaning
97499: FROM xla_events_gt xet
97500: , PA_XLA_CDL_LINES_V l2
97501: , fnd_lookup_values fvl35
97502: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
97503: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
97719: , h1.PO_DISTRIBUTION_ID source_2
97720: , h3.EXCHANGE_RATE_VARIANCE_FLAG source_22
97721: , h3.EXPENDITURE_ITEM_ID source_33
97722: , h3.GL_DATE source_75
97723: FROM xla_events_gt xet
97724: , GMS_XLA_AWARD_REF_V h1
97725: , PA_XLA_EXP_HEADER_V h3
97726: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
97727: and xet.event_class_code = C_EVENT_CLASS_CODE
97779: , l2.LINE_NUMBER source_34
97780: , l2.LINE_TYPE source_35
97781: , fvl35.meaning source_35_meaning
97782: , l2.LINE_NUM_REVERSED source_36
97783: FROM xla_events_gt xet
97784: , PA_XLA_CDL_LINES_V l2
97785: , fnd_lookup_values fvl35
97786: WHERE xet.event_id between x_first_event_id and x_last_event_id
97787: and xet.event_date between p_pad_start_date and p_pad_end_date
98843:
98844: ELSE null
98845: END source_value
98846: , null source_meaning
98847: FROM xla_events_gt xet
98848: , PA_XLA_EXP_HEADER_V h2
98849: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
98850: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
98851: AND xet.event_class_code = C_EVENT_CLASS_CODE
99096: WHEN 16 THEN fvl35.meaning
99097:
99098: ELSE null
99099: END source_meaning
99100: FROM xla_events_gt xet
99101: , PA_XLA_CDL_LINES_V l1
99102: , fnd_lookup_values fvl35
99103: , (select rownum r from all_objects where rownum <= 30 and owner = p_apps_owner)
99104: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
99338: ,xet.event_created_by
99339: ,xet.budgetary_control_flag
99340: , h2.EXPENDITURE_ITEM_ID source_33
99341: , h2.GL_DATE source_75
99342: FROM xla_events_gt xet
99343: , PA_XLA_EXP_HEADER_V h2
99344: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
99345: and xet.event_class_code = C_EVENT_CLASS_CODE
99346: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
99409: , l1.PA_SECOND_DIST_ID source_60
99410: , l1.ENC_UPG_CR_ACCT_CLASS source_61
99411: , l1.ENCUMBRANCE_TYPE_ID source_62
99412: , l1.PROJ_ENCUMBRANCE_TYPE_ID source_63
99413: FROM xla_events_gt xet
99414: , PA_XLA_CDL_LINES_V l1
99415: , fnd_lookup_values fvl35
99416: WHERE xet.event_id between x_first_event_id and x_last_event_id
99417: and xet.event_date between p_pad_start_date and p_pad_end_date
100392:
100393: ELSE null
100394: END source_value
100395: , null source_meaning
100396: FROM xla_events_gt xet
100397: , PA_XLA_EXP_HEADER_V h2
100398: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
100399: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
100400: AND xet.event_class_code = C_EVENT_CLASS_CODE
100650: WHEN 16 THEN fvl35.meaning
100651:
100652: ELSE null
100653: END source_meaning
100654: FROM xla_events_gt xet
100655: , PA_XLA_CDL_LINES_V l1
100656: , fnd_lookup_values fvl35
100657: , (select rownum r from all_objects where rownum <= 31 and owner = p_apps_owner)
100658: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
100894: ,xet.event_created_by
100895: ,xet.budgetary_control_flag
100896: , h2.EXPENDITURE_ITEM_ID source_33
100897: , h2.GL_DATE source_75
100898: FROM xla_events_gt xet
100899: , PA_XLA_EXP_HEADER_V h2
100900: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
100901: and xet.event_class_code = C_EVENT_CLASS_CODE
100902: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
100966: , l1.PA_SECOND_DIST_ID source_60
100967: , l1.ENC_UPG_CR_ACCT_CLASS source_61
100968: , l1.ENCUMBRANCE_TYPE_ID source_62
100969: , l1.PROJ_ENCUMBRANCE_TYPE_ID source_63
100970: FROM xla_events_gt xet
100971: , PA_XLA_CDL_LINES_V l1
100972: , fnd_lookup_values fvl35
100973: WHERE xet.event_id between x_first_event_id and x_last_event_id
100974: and xet.event_date between p_pad_start_date and p_pad_end_date
101971:
101972: ELSE null
101973: END source_value
101974: , null source_meaning
101975: FROM xla_events_gt xet
101976: , PA_XLA_EXP_HEADER_V h2
101977: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
101978: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
101979: AND xet.event_class_code = C_EVENT_CLASS_CODE
102164: WHEN 17 THEN fvl35.meaning
102165:
102166: ELSE null
102167: END source_meaning
102168: FROM xla_events_gt xet
102169: , PA_XLA_CDL_LINES_V l1
102170: , fnd_lookup_values fvl35
102171: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
102172: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
102382: ,xet.event_created_by
102383: ,xet.budgetary_control_flag
102384: , h2.EXPENDITURE_ITEM_ID source_33
102385: , h2.GL_DATE source_75
102386: FROM xla_events_gt xet
102387: , PA_XLA_EXP_HEADER_V h2
102388: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
102389: and xet.event_class_code = C_EVENT_CLASS_CODE
102390: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
102441: , l1.LINE_NUMBER source_34
102442: , l1.LINE_TYPE source_35
102443: , fvl35.meaning source_35_meaning
102444: , l1.LINE_NUM_REVERSED source_36
102445: FROM xla_events_gt xet
102446: , PA_XLA_CDL_LINES_V l1
102447: , fnd_lookup_values fvl35
102448: WHERE xet.event_id between x_first_event_id and x_last_event_id
102449: and xet.event_date between p_pad_start_date and p_pad_end_date
103343:
103344: ELSE null
103345: END source_value
103346: , null source_meaning
103347: FROM xla_events_gt xet
103348: , PA_XLA_EXP_HEADER_V h2
103349: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
103350: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
103351: AND xet.event_class_code = C_EVENT_CLASS_CODE
103536: WHEN 17 THEN fvl35.meaning
103537:
103538: ELSE null
103539: END source_meaning
103540: FROM xla_events_gt xet
103541: , PA_XLA_CDL_LINES_V l1
103542: , fnd_lookup_values fvl35
103543: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
103544: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
103754: ,xet.event_created_by
103755: ,xet.budgetary_control_flag
103756: , h2.EXPENDITURE_ITEM_ID source_33
103757: , h2.GL_DATE source_75
103758: FROM xla_events_gt xet
103759: , PA_XLA_EXP_HEADER_V h2
103760: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
103761: and xet.event_class_code = C_EVENT_CLASS_CODE
103762: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
103813: , l1.LINE_NUMBER source_34
103814: , l1.LINE_TYPE source_35
103815: , fvl35.meaning source_35_meaning
103816: , l1.LINE_NUM_REVERSED source_36
103817: FROM xla_events_gt xet
103818: , PA_XLA_CDL_LINES_V l1
103819: , fnd_lookup_values fvl35
103820: WHERE xet.event_id between x_first_event_id and x_last_event_id
103821: and xet.event_date between p_pad_start_date and p_pad_end_date
104715:
104716: ELSE null
104717: END source_value
104718: , null source_meaning
104719: FROM xla_events_gt xet
104720: , PA_XLA_EXP_HEADER_V h2
104721: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
104722: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
104723: AND xet.event_class_code = C_EVENT_CLASS_CODE
104908: WHEN 17 THEN fvl35.meaning
104909:
104910: ELSE null
104911: END source_meaning
104912: FROM xla_events_gt xet
104913: , PA_XLA_CDL_LINES_V l1
104914: , fnd_lookup_values fvl35
104915: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
104916: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
105126: ,xet.event_created_by
105127: ,xet.budgetary_control_flag
105128: , h2.EXPENDITURE_ITEM_ID source_33
105129: , h2.GL_DATE source_75
105130: FROM xla_events_gt xet
105131: , PA_XLA_EXP_HEADER_V h2
105132: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
105133: and xet.event_class_code = C_EVENT_CLASS_CODE
105134: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
105185: , l1.LINE_NUMBER source_34
105186: , l1.LINE_TYPE source_35
105187: , fvl35.meaning source_35_meaning
105188: , l1.LINE_NUM_REVERSED source_36
105189: FROM xla_events_gt xet
105190: , PA_XLA_CDL_LINES_V l1
105191: , fnd_lookup_values fvl35
105192: WHERE xet.event_id between x_first_event_id and x_last_event_id
105193: and xet.event_date between p_pad_start_date and p_pad_end_date
106087:
106088: ELSE null
106089: END source_value
106090: , null source_meaning
106091: FROM xla_events_gt xet
106092: , PA_XLA_EXP_HEADER_V h2
106093: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
106094: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
106095: AND xet.event_class_code = C_EVENT_CLASS_CODE
106280: WHEN 17 THEN fvl35.meaning
106281:
106282: ELSE null
106283: END source_meaning
106284: FROM xla_events_gt xet
106285: , PA_XLA_CDL_LINES_V l1
106286: , fnd_lookup_values fvl35
106287: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
106288: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
106498: ,xet.event_created_by
106499: ,xet.budgetary_control_flag
106500: , h2.EXPENDITURE_ITEM_ID source_33
106501: , h2.GL_DATE source_75
106502: FROM xla_events_gt xet
106503: , PA_XLA_EXP_HEADER_V h2
106504: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
106505: and xet.event_class_code = C_EVENT_CLASS_CODE
106506: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
106557: , l1.LINE_NUMBER source_34
106558: , l1.LINE_TYPE source_35
106559: , fvl35.meaning source_35_meaning
106560: , l1.LINE_NUM_REVERSED source_36
106561: FROM xla_events_gt xet
106562: , PA_XLA_CDL_LINES_V l1
106563: , fnd_lookup_values fvl35
106564: WHERE xet.event_id between x_first_event_id and x_last_event_id
106565: and xet.event_date between p_pad_start_date and p_pad_end_date
108184: ,p_level => C_LEVEL_STATEMENT
108185: ,p_module => l_log_module);
108186:
108187: trace
108188: (p_msg => '# of events in xla_events_gt: '
108189: ||xla_context_pkg.get_event_count_context
108190: ,p_level => C_LEVEL_STATEMENT
108191: ,p_module => l_log_module);
108192: