[Home] [Help]
55308: WHEN 2 THEN fvl67.meaning
55309:
55310: ELSE null
55311: END source_meaning
55312: FROM xla_events_gt xet
55313: , PA_XLA_EXP_HEADER_V h2
55314: , fnd_lookup_values fvl67
55315: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
55316: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
55506: WHEN 15 THEN fvl34.meaning
55507:
55508: ELSE null
55509: END source_meaning
55510: FROM xla_events_gt xet
55511: , PA_XLA_CCDL_LINES_V l1
55512: , fnd_lookup_values fvl34
55513: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
55514: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
55729: , h2.EXPENDITURE_ITEM_ID source_32
55730: , h2.TP_AMT_TYPE_CODE source_67
55731: , fvl67.meaning source_67_meaning
55732: , h2.GL_DATE source_87
55733: FROM xla_events_gt xet
55734: , PA_XLA_EXP_HEADER_V h2
55735: , fnd_lookup_values fvl67
55736: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
55737: and xet.event_class_code = C_EVENT_CLASS_CODE
55793: , fvl34.meaning source_34_meaning
55794: , l1.LINE_NUM_REVERSED source_35
55795: , l1.ENTERED_AMOUNT source_41
55796: , l1.ACCT_AMOUNT source_43
55797: FROM xla_events_gt xet
55798: , PA_XLA_CCDL_LINES_V l1
55799: , fnd_lookup_values fvl34
55800: WHERE xet.event_id between x_first_event_id and x_last_event_id
55801: and xet.event_date between p_pad_start_date and p_pad_end_date
56716: WHEN 2 THEN fvl67.meaning
56717:
56718: ELSE null
56719: END source_meaning
56720: FROM xla_events_gt xet
56721: , PA_XLA_EXP_HEADER_V h2
56722: , fnd_lookup_values fvl67
56723: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
56724: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
56914: WHEN 15 THEN fvl34.meaning
56915:
56916: ELSE null
56917: END source_meaning
56918: FROM xla_events_gt xet
56919: , PA_XLA_CCDL_LINES_V l1
56920: , fnd_lookup_values fvl34
56921: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
56922: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
57137: , h2.EXPENDITURE_ITEM_ID source_32
57138: , h2.TP_AMT_TYPE_CODE source_67
57139: , fvl67.meaning source_67_meaning
57140: , h2.GL_DATE source_87
57141: FROM xla_events_gt xet
57142: , PA_XLA_EXP_HEADER_V h2
57143: , fnd_lookup_values fvl67
57144: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
57145: and xet.event_class_code = C_EVENT_CLASS_CODE
57201: , fvl34.meaning source_34_meaning
57202: , l1.LINE_NUM_REVERSED source_35
57203: , l1.ENTERED_AMOUNT source_41
57204: , l1.ACCT_AMOUNT source_43
57205: FROM xla_events_gt xet
57206: , PA_XLA_CCDL_LINES_V l1
57207: , fnd_lookup_values fvl34
57208: WHERE xet.event_id between x_first_event_id and x_last_event_id
57209: and xet.event_date between p_pad_start_date and p_pad_end_date
58115:
58116: ELSE null
58117: END source_value
58118: , null source_meaning
58119: FROM xla_events_gt xet
58120: , PA_XLA_BC_BUDGET_HEADER_V h1
58121: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
58122: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
58123: AND xet.event_class_code = C_EVENT_CLASS_CODE
58262: WHEN 4 THEN fvl34.meaning
58263:
58264: ELSE null
58265: END source_meaning
58266: FROM xla_events_gt xet
58267: , PA_XLA_BC_BUDGET_LINES_V l2
58268: , fnd_lookup_values fvl34
58269: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
58270: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
58464: ,xet.event_created_by
58465: ,xet.budgetary_control_flag
58466: , h1.GL_DATE source_87
58467: , h1.GL_BUDGET_VERSION_ID source_88
58468: FROM xla_events_gt xet
58469: , PA_XLA_BC_BUDGET_HEADER_V h1
58470: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
58471: and xet.event_class_code = C_EVENT_CLASS_CODE
58472: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
58515: , l2.ENC_UPG_DR_ACCT_CLASS source_53
58516: , l2.USE_ENC_UPG_ATTRIB_FLAG source_55
58517: , l2.BUDGET_LINE_ID source_89
58518: , l2.ENC_UPG_ENC_TYPE_ID source_90
58519: FROM xla_events_gt xet
58520: , PA_XLA_BC_BUDGET_LINES_V l2
58521: , fnd_lookup_values fvl34
58522: WHERE xet.event_id between x_first_event_id and x_last_event_id
58523: and xet.event_date between p_pad_start_date and p_pad_end_date
59239:
59240: ELSE null
59241: END source_value
59242: , null source_meaning
59243: FROM xla_events_gt xet
59244: , PA_XLA_EXP_HEADER_V h2
59245: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
59246: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
59247: AND xet.event_class_code = C_EVENT_CLASS_CODE
59497: WHEN 16 THEN fvl34.meaning
59498:
59499: ELSE null
59500: END source_meaning
59501: FROM xla_events_gt xet
59502: , PA_XLA_CDL_LINES_V l1
59503: , fnd_lookup_values fvl34
59504: , (select rownum r from all_objects where rownum <= 31 and owner = p_apps_owner)
59505: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
59741: ,xet.event_created_by
59742: ,xet.budgetary_control_flag
59743: , h2.EXPENDITURE_ITEM_ID source_32
59744: , h2.GL_DATE source_87
59745: FROM xla_events_gt xet
59746: , PA_XLA_EXP_HEADER_V h2
59747: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
59748: and xet.event_class_code = C_EVENT_CLASS_CODE
59749: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
59813: , l1.ENC_UPG_CR_ACCT_CLASS source_54
59814: , l1.USE_ENC_UPG_ATTRIB_FLAG source_55
59815: , l1.ENCUMBRANCE_TYPE_ID source_56
59816: , l1.PROJ_ENCUMBRANCE_TYPE_ID source_57
59817: FROM xla_events_gt xet
59818: , PA_XLA_CDL_LINES_V l1
59819: , fnd_lookup_values fvl34
59820: WHERE xet.event_id between x_first_event_id and x_last_event_id
59821: and xet.event_date between p_pad_start_date and p_pad_end_date
60711:
60712: ELSE null
60713: END source_value
60714: , null source_meaning
60715: FROM xla_events_gt xet
60716: , PA_XLA_EXP_HEADER_V h2
60717: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
60718: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
60719: AND xet.event_class_code = C_EVENT_CLASS_CODE
61060: WHEN 32 THEN fvl69.meaning
61061:
61062: ELSE null
61063: END source_meaning
61064: FROM xla_events_gt xet
61065: , PA_XLA_CDL_LINES_V l1
61066: , fnd_lookup_values fvl34
61067: , fnd_lookup_values fvl69
61068: , (select rownum r from all_objects where rownum <= 49 and owner = p_apps_owner)
61349: ,xet.budgetary_control_flag
61350: , h2.EXPENDITURE_ITEM_ID source_32
61351: , h2.SYSTEM_LINKAGE_FUNCTION source_37
61352: , h2.GL_DATE source_87
61353: FROM xla_events_gt xet
61354: , PA_XLA_EXP_HEADER_V h2
61355: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
61356: and xet.event_class_code = C_EVENT_CLASS_CODE
61357: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
61440: , l1.PO_FIRST_SYS_TRANS_ID source_83
61441: , l1.PO_SECOND_DIST_ID source_84
61442: , l1.ENC_ACCT_ENABLED source_85
61443: , l1.LIQUIDATE_ENCUM_FLAG source_86
61444: FROM xla_events_gt xet
61445: , PA_XLA_CDL_LINES_V l1
61446: , fnd_lookup_values fvl34
61447: , fnd_lookup_values fvl69
61448: WHERE xet.event_id between x_first_event_id and x_last_event_id
62716:
62717: ELSE null
62718: END source_value
62719: , null source_meaning
62720: FROM xla_events_gt xet
62721: , PA_XLA_EXP_HEADER_V h2
62722: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
62723: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
62724: AND xet.event_class_code = C_EVENT_CLASS_CODE
62909: WHEN 17 THEN fvl34.meaning
62910:
62911: ELSE null
62912: END source_meaning
62913: FROM xla_events_gt xet
62914: , PA_XLA_CDL_LINES_V l1
62915: , fnd_lookup_values fvl34
62916: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
62917: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
63127: ,xet.event_created_by
63128: ,xet.budgetary_control_flag
63129: , h2.EXPENDITURE_ITEM_ID source_32
63130: , h2.GL_DATE source_87
63131: FROM xla_events_gt xet
63132: , PA_XLA_EXP_HEADER_V h2
63133: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
63134: and xet.event_class_code = C_EVENT_CLASS_CODE
63135: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
63186: , l1.LINE_NUMBER source_33
63187: , l1.LINE_TYPE source_34
63188: , fvl34.meaning source_34_meaning
63189: , l1.LINE_NUM_REVERSED source_35
63190: FROM xla_events_gt xet
63191: , PA_XLA_CDL_LINES_V l1
63192: , fnd_lookup_values fvl34
63193: WHERE xet.event_id between x_first_event_id and x_last_event_id
63194: and xet.event_date between p_pad_start_date and p_pad_end_date
64014:
64015: ELSE null
64016: END source_value
64017: , null source_meaning
64018: FROM xla_events_gt xet
64019: , PA_XLA_EXP_HEADER_V h2
64020: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
64021: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
64022: AND xet.event_class_code = C_EVENT_CLASS_CODE
64207: WHEN 17 THEN fvl34.meaning
64208:
64209: ELSE null
64210: END source_meaning
64211: FROM xla_events_gt xet
64212: , PA_XLA_CDL_LINES_V l1
64213: , fnd_lookup_values fvl34
64214: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
64215: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
64425: ,xet.event_created_by
64426: ,xet.budgetary_control_flag
64427: , h2.EXPENDITURE_ITEM_ID source_32
64428: , h2.GL_DATE source_87
64429: FROM xla_events_gt xet
64430: , PA_XLA_EXP_HEADER_V h2
64431: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
64432: and xet.event_class_code = C_EVENT_CLASS_CODE
64433: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
64484: , l1.LINE_NUMBER source_33
64485: , l1.LINE_TYPE source_34
64486: , fvl34.meaning source_34_meaning
64487: , l1.LINE_NUM_REVERSED source_35
64488: FROM xla_events_gt xet
64489: , PA_XLA_CDL_LINES_V l1
64490: , fnd_lookup_values fvl34
64491: WHERE xet.event_id between x_first_event_id and x_last_event_id
64492: and xet.event_date between p_pad_start_date and p_pad_end_date
65312:
65313: ELSE null
65314: END source_value
65315: , null source_meaning
65316: FROM xla_events_gt xet
65317: , PA_XLA_EXP_HEADER_V h2
65318: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
65319: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
65320: AND xet.event_class_code = C_EVENT_CLASS_CODE
65505: WHEN 17 THEN fvl34.meaning
65506:
65507: ELSE null
65508: END source_meaning
65509: FROM xla_events_gt xet
65510: , PA_XLA_CDL_LINES_V l1
65511: , fnd_lookup_values fvl34
65512: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
65513: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
65723: ,xet.event_created_by
65724: ,xet.budgetary_control_flag
65725: , h2.EXPENDITURE_ITEM_ID source_32
65726: , h2.GL_DATE source_87
65727: FROM xla_events_gt xet
65728: , PA_XLA_EXP_HEADER_V h2
65729: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
65730: and xet.event_class_code = C_EVENT_CLASS_CODE
65731: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
65782: , l1.LINE_NUMBER source_33
65783: , l1.LINE_TYPE source_34
65784: , fvl34.meaning source_34_meaning
65785: , l1.LINE_NUM_REVERSED source_35
65786: FROM xla_events_gt xet
65787: , PA_XLA_CDL_LINES_V l1
65788: , fnd_lookup_values fvl34
65789: WHERE xet.event_id between x_first_event_id and x_last_event_id
65790: and xet.event_date between p_pad_start_date and p_pad_end_date
66610:
66611: ELSE null
66612: END source_value
66613: , null source_meaning
66614: FROM xla_events_gt xet
66615: , PA_XLA_EXP_HEADER_V h2
66616: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
66617: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
66618: AND xet.event_class_code = C_EVENT_CLASS_CODE
66803: WHEN 17 THEN fvl34.meaning
66804:
66805: ELSE null
66806: END source_meaning
66807: FROM xla_events_gt xet
66808: , PA_XLA_CDL_LINES_V l1
66809: , fnd_lookup_values fvl34
66810: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
66811: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
67021: ,xet.event_created_by
67022: ,xet.budgetary_control_flag
67023: , h2.EXPENDITURE_ITEM_ID source_32
67024: , h2.GL_DATE source_87
67025: FROM xla_events_gt xet
67026: , PA_XLA_EXP_HEADER_V h2
67027: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
67028: and xet.event_class_code = C_EVENT_CLASS_CODE
67029: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
67080: , l1.LINE_NUMBER source_33
67081: , l1.LINE_TYPE source_34
67082: , fvl34.meaning source_34_meaning
67083: , l1.LINE_NUM_REVERSED source_35
67084: FROM xla_events_gt xet
67085: , PA_XLA_CDL_LINES_V l1
67086: , fnd_lookup_values fvl34
67087: WHERE xet.event_id between x_first_event_id and x_last_event_id
67088: and xet.event_date between p_pad_start_date and p_pad_end_date
67908:
67909: ELSE null
67910: END source_value
67911: , null source_meaning
67912: FROM xla_events_gt xet
67913: , PA_XLA_EXP_HEADER_V h2
67914: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
67915: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
67916: AND xet.event_class_code = C_EVENT_CLASS_CODE
68101: WHEN 17 THEN fvl34.meaning
68102:
68103: ELSE null
68104: END source_meaning
68105: FROM xla_events_gt xet
68106: , PA_XLA_CDL_LINES_V l1
68107: , fnd_lookup_values fvl34
68108: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
68109: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68319: ,xet.event_created_by
68320: ,xet.budgetary_control_flag
68321: , h2.EXPENDITURE_ITEM_ID source_32
68322: , h2.GL_DATE source_87
68323: FROM xla_events_gt xet
68324: , PA_XLA_EXP_HEADER_V h2
68325: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
68326: and xet.event_class_code = C_EVENT_CLASS_CODE
68327: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
68378: , l1.LINE_NUMBER source_33
68379: , l1.LINE_TYPE source_34
68380: , fvl34.meaning source_34_meaning
68381: , l1.LINE_NUM_REVERSED source_35
68382: FROM xla_events_gt xet
68383: , PA_XLA_CDL_LINES_V l1
68384: , fnd_lookup_values fvl34
68385: WHERE xet.event_id between x_first_event_id and x_last_event_id
68386: and xet.event_date between p_pad_start_date and p_pad_end_date
69206:
69207: ELSE null
69208: END source_value
69209: , null source_meaning
69210: FROM xla_events_gt xet
69211: , PA_XLA_EXP_HEADER_V h2
69212: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
69213: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69214: AND xet.event_class_code = C_EVENT_CLASS_CODE
69399: WHEN 17 THEN fvl34.meaning
69400:
69401: ELSE null
69402: END source_meaning
69403: FROM xla_events_gt xet
69404: , PA_XLA_CDL_LINES_V l1
69405: , fnd_lookup_values fvl34
69406: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
69407: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69617: ,xet.event_created_by
69618: ,xet.budgetary_control_flag
69619: , h2.EXPENDITURE_ITEM_ID source_32
69620: , h2.GL_DATE source_87
69621: FROM xla_events_gt xet
69622: , PA_XLA_EXP_HEADER_V h2
69623: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
69624: and xet.event_class_code = C_EVENT_CLASS_CODE
69625: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
69676: , l1.LINE_NUMBER source_33
69677: , l1.LINE_TYPE source_34
69678: , fvl34.meaning source_34_meaning
69679: , l1.LINE_NUM_REVERSED source_35
69680: FROM xla_events_gt xet
69681: , PA_XLA_CDL_LINES_V l1
69682: , fnd_lookup_values fvl34
69683: WHERE xet.event_id between x_first_event_id and x_last_event_id
69684: and xet.event_date between p_pad_start_date and p_pad_end_date
70504:
70505: ELSE null
70506: END source_value
70507: , null source_meaning
70508: FROM xla_events_gt xet
70509: , PA_XLA_EXP_HEADER_V h2
70510: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
70511: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
70512: AND xet.event_class_code = C_EVENT_CLASS_CODE
70697: WHEN 15 THEN fvl34.meaning
70698:
70699: ELSE null
70700: END source_meaning
70701: FROM xla_events_gt xet
70702: , PA_XLA_CCDL_LINES_V l1
70703: , fnd_lookup_values fvl34
70704: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
70705: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
70915: ,xet.event_created_by
70916: ,xet.budgetary_control_flag
70917: , h2.EXPENDITURE_ITEM_ID source_32
70918: , h2.GL_DATE source_87
70919: FROM xla_events_gt xet
70920: , PA_XLA_EXP_HEADER_V h2
70921: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
70922: and xet.event_class_code = C_EVENT_CLASS_CODE
70923: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
70974: , fvl34.meaning source_34_meaning
70975: , l1.LINE_NUM_REVERSED source_35
70976: , l1.ENTERED_AMOUNT source_41
70977: , l1.ACCT_AMOUNT source_43
70978: FROM xla_events_gt xet
70979: , PA_XLA_CCDL_LINES_V l1
70980: , fnd_lookup_values fvl34
70981: WHERE xet.event_id between x_first_event_id and x_last_event_id
70982: and xet.event_date between p_pad_start_date and p_pad_end_date
71802:
71803: ELSE null
71804: END source_value
71805: , null source_meaning
71806: FROM xla_events_gt xet
71807: , PA_XLA_EXP_HEADER_V h2
71808: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
71809: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
71810: AND xet.event_class_code = C_EVENT_CLASS_CODE
71995: WHEN 15 THEN fvl34.meaning
71996:
71997: ELSE null
71998: END source_meaning
71999: FROM xla_events_gt xet
72000: , PA_XLA_CCDL_LINES_V l1
72001: , fnd_lookup_values fvl34
72002: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
72003: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
72213: ,xet.event_created_by
72214: ,xet.budgetary_control_flag
72215: , h2.EXPENDITURE_ITEM_ID source_32
72216: , h2.GL_DATE source_87
72217: FROM xla_events_gt xet
72218: , PA_XLA_EXP_HEADER_V h2
72219: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
72220: and xet.event_class_code = C_EVENT_CLASS_CODE
72221: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
72272: , fvl34.meaning source_34_meaning
72273: , l1.LINE_NUM_REVERSED source_35
72274: , l1.ENTERED_AMOUNT source_41
72275: , l1.ACCT_AMOUNT source_43
72276: FROM xla_events_gt xet
72277: , PA_XLA_CCDL_LINES_V l1
72278: , fnd_lookup_values fvl34
72279: WHERE xet.event_id between x_first_event_id and x_last_event_id
72280: and xet.event_date between p_pad_start_date and p_pad_end_date
73124: ,275)
73125:
73126: ELSE null
73127: END source_meaning
73128: FROM xla_events_gt xet
73129: , PA_XLA_REVENUE_HEADERS_V h2
73130: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
73131: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73132: AND xet.event_class_code = C_EVENT_CLASS_CODE
73336: WHEN 15 THEN fvl58.meaning
73337:
73338: ELSE null
73339: END source_meaning
73340: FROM xla_events_gt xet
73341: , PA_XLA_EVENT_TYPE_REF_V l1
73342: , PA_XLA_REVENUE_LINES_ADJ_V l3
73343: , fnd_lookup_values fvl58
73344: , (select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
73574: , h2.EVENT_ID source_42
73575: , h2.GL_DATE source_87
73576: , h2.UER_CCID source_91
73577: , h2.UBR_CCID source_92
73578: FROM xla_events_gt xet
73579: , PA_XLA_REVENUE_HEADERS_V h2
73580: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
73581: and xet.event_class_code = C_EVENT_CLASS_CODE
73582: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
73638: , l3.CR_REVENUE_FIRST_DIST_ID source_63
73639: , l3.PROJECT_ID source_64
73640: , l3.CR_REVENUE_SECOND_DIST_ID source_65
73641: , l3.PDR_DRAFT_REV_NUM_CREDITED source_66
73642: FROM xla_events_gt xet
73643: , PA_XLA_EVENT_TYPE_REF_V l1
73644: , PA_XLA_REVENUE_LINES_ADJ_V l3
73645: , fnd_lookup_values fvl58
73646: WHERE xet.event_id between x_first_event_id and x_last_event_id
74666: ,275)
74667:
74668: ELSE null
74669: END source_meaning
74670: FROM xla_events_gt xet
74671: , PA_XLA_REVENUE_HEADERS_V h2
74672: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
74673: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74674: AND xet.event_class_code = C_EVENT_CLASS_CODE
74848: WHEN 17 THEN fvl58.meaning
74849:
74850: ELSE null
74851: END source_meaning
74852: FROM xla_events_gt xet
74853: , PA_XLA_EVENT_TYPE_REF_V l1
74854: , PA_XLA_REVENUE_LINES_V l3
74855: , fnd_lookup_values fvl58
74856: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
75074: , h2.EVENT_ID source_42
75075: , h2.GL_DATE source_87
75076: , h2.UER_CCID source_91
75077: , h2.UBR_CCID source_92
75078: FROM xla_events_gt xet
75079: , PA_XLA_REVENUE_HEADERS_V h2
75080: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
75081: and xet.event_class_code = C_EVENT_CLASS_CODE
75082: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
75132: , l3.ENTERED_AMOUNT source_41
75133: , l3.ACCT_AMOUNT source_43
75134: , l1.REV_EVENT_TYPE_CLASSIFICATION source_58
75135: , fvl58.meaning source_58_meaning
75136: FROM xla_events_gt xet
75137: , PA_XLA_EVENT_TYPE_REF_V l1
75138: , PA_XLA_REVENUE_LINES_V l3
75139: , fnd_lookup_values fvl58
75140: WHERE xet.event_id between x_first_event_id and x_last_event_id
76290: ,275)
76291:
76292: ELSE null
76293: END source_meaning
76294: FROM xla_events_gt xet
76295: , PA_XLA_EXP_HEADER_V h2
76296: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
76297: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
76298: AND xet.event_class_code = C_EVENT_CLASS_CODE
76483: WHEN 17 THEN fvl34.meaning
76484:
76485: ELSE null
76486: END source_meaning
76487: FROM xla_events_gt xet
76488: , PA_XLA_CDL_LINES_V l1
76489: , fnd_lookup_values fvl34
76490: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
76491: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
76704: ,xet.budgetary_control_flag
76705: , h2.EXCHANGE_RATE_VARIANCE_FLAG source_21
76706: , h2.EXPENDITURE_ITEM_ID source_32
76707: , h2.GL_DATE source_87
76708: FROM xla_events_gt xet
76709: , PA_XLA_EXP_HEADER_V h2
76710: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
76711: and xet.event_class_code = C_EVENT_CLASS_CODE
76712: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
76763: , l1.LINE_NUMBER source_33
76764: , l1.LINE_TYPE source_34
76765: , fvl34.meaning source_34_meaning
76766: , l1.LINE_NUM_REVERSED source_35
76767: FROM xla_events_gt xet
76768: , PA_XLA_CDL_LINES_V l1
76769: , fnd_lookup_values fvl34
76770: WHERE xet.event_id between x_first_event_id and x_last_event_id
76771: and xet.event_date between p_pad_start_date and p_pad_end_date
77685: ,275)
77686:
77687: ELSE null
77688: END source_meaning
77689: FROM xla_events_gt xet
77690: , PA_XLA_EXP_HEADER_V h2
77691: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
77692: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77693: AND xet.event_class_code = C_EVENT_CLASS_CODE
77878: WHEN 17 THEN fvl34.meaning
77879:
77880: ELSE null
77881: END source_meaning
77882: FROM xla_events_gt xet
77883: , PA_XLA_CDL_LINES_V l1
77884: , fnd_lookup_values fvl34
77885: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
77886: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
78099: ,xet.budgetary_control_flag
78100: , h2.EXCHANGE_RATE_VARIANCE_FLAG source_21
78101: , h2.EXPENDITURE_ITEM_ID source_32
78102: , h2.GL_DATE source_87
78103: FROM xla_events_gt xet
78104: , PA_XLA_EXP_HEADER_V h2
78105: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
78106: and xet.event_class_code = C_EVENT_CLASS_CODE
78107: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
78158: , l1.LINE_NUMBER source_33
78159: , l1.LINE_TYPE source_34
78160: , fvl34.meaning source_34_meaning
78161: , l1.LINE_NUM_REVERSED source_35
78162: FROM xla_events_gt xet
78163: , PA_XLA_CDL_LINES_V l1
78164: , fnd_lookup_values fvl34
78165: WHERE xet.event_id between x_first_event_id and x_last_event_id
78166: and xet.event_date between p_pad_start_date and p_pad_end_date
79071:
79072: ELSE null
79073: END source_value
79074: , null source_meaning
79075: FROM xla_events_gt xet
79076: , PA_XLA_EXP_HEADER_V h2
79077: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
79078: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
79079: AND xet.event_class_code = C_EVENT_CLASS_CODE
79415: WHEN 31 THEN fvl69.meaning
79416:
79417: ELSE null
79418: END source_meaning
79419: FROM xla_events_gt xet
79420: , PA_XLA_CDL_LINES_V l1
79421: , fnd_lookup_values fvl34
79422: , fnd_lookup_values fvl69
79423: , (select rownum r from all_objects where rownum <= 48 and owner = p_apps_owner)
79702: ,xet.budgetary_control_flag
79703: , h2.EXPENDITURE_ITEM_ID source_32
79704: , h2.SYSTEM_LINKAGE_FUNCTION source_37
79705: , h2.GL_DATE source_87
79706: FROM xla_events_gt xet
79707: , PA_XLA_EXP_HEADER_V h2
79708: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
79709: and xet.event_class_code = C_EVENT_CLASS_CODE
79710: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
79792: , l1.PO_FIRST_SYS_TRANS_ID source_83
79793: , l1.PO_SECOND_DIST_ID source_84
79794: , l1.ENC_ACCT_ENABLED source_85
79795: , l1.LIQUIDATE_ENCUM_FLAG source_86
79796: FROM xla_events_gt xet
79797: , PA_XLA_CDL_LINES_V l1
79798: , fnd_lookup_values fvl34
79799: , fnd_lookup_values fvl69
79800: WHERE xet.event_id between x_first_event_id and x_last_event_id
81059:
81060: ELSE null
81061: END source_value
81062: , null source_meaning
81063: FROM xla_events_gt xet
81064: , PA_XLA_EXP_HEADER_V h2
81065: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
81066: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
81067: AND xet.event_class_code = C_EVENT_CLASS_CODE
81408: WHEN 32 THEN fvl69.meaning
81409:
81410: ELSE null
81411: END source_meaning
81412: FROM xla_events_gt xet
81413: , PA_XLA_CDL_LINES_V l1
81414: , fnd_lookup_values fvl34
81415: , fnd_lookup_values fvl69
81416: , (select rownum r from all_objects where rownum <= 49 and owner = p_apps_owner)
81697: ,xet.budgetary_control_flag
81698: , h2.EXPENDITURE_ITEM_ID source_32
81699: , h2.SYSTEM_LINKAGE_FUNCTION source_37
81700: , h2.GL_DATE source_87
81701: FROM xla_events_gt xet
81702: , PA_XLA_EXP_HEADER_V h2
81703: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
81704: and xet.event_class_code = C_EVENT_CLASS_CODE
81705: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
81788: , l1.PO_FIRST_SYS_TRANS_ID source_83
81789: , l1.PO_SECOND_DIST_ID source_84
81790: , l1.ENC_ACCT_ENABLED source_85
81791: , l1.LIQUIDATE_ENCUM_FLAG source_86
81792: FROM xla_events_gt xet
81793: , PA_XLA_CDL_LINES_V l1
81794: , fnd_lookup_values fvl34
81795: , fnd_lookup_values fvl69
81796: WHERE xet.event_id between x_first_event_id and x_last_event_id
83077:
83078: ELSE null
83079: END source_value
83080: , null source_meaning
83081: FROM xla_events_gt xet
83082: , PA_XLA_EXP_HEADER_V h2
83083: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
83084: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
83085: AND xet.event_class_code = C_EVENT_CLASS_CODE
83270: WHEN 17 THEN fvl34.meaning
83271:
83272: ELSE null
83273: END source_meaning
83274: FROM xla_events_gt xet
83275: , PA_XLA_CDL_LINES_V l1
83276: , fnd_lookup_values fvl34
83277: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
83278: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
83488: ,xet.event_created_by
83489: ,xet.budgetary_control_flag
83490: , h2.EXPENDITURE_ITEM_ID source_32
83491: , h2.GL_DATE source_87
83492: FROM xla_events_gt xet
83493: , PA_XLA_EXP_HEADER_V h2
83494: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
83495: and xet.event_class_code = C_EVENT_CLASS_CODE
83496: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
83547: , l1.LINE_NUMBER source_33
83548: , l1.LINE_TYPE source_34
83549: , fvl34.meaning source_34_meaning
83550: , l1.LINE_NUM_REVERSED source_35
83551: FROM xla_events_gt xet
83552: , PA_XLA_CDL_LINES_V l1
83553: , fnd_lookup_values fvl34
83554: WHERE xet.event_id between x_first_event_id and x_last_event_id
83555: and xet.event_date between p_pad_start_date and p_pad_end_date
84375:
84376: ELSE null
84377: END source_value
84378: , null source_meaning
84379: FROM xla_events_gt xet
84380: , PA_XLA_EXP_HEADER_V h2
84381: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
84382: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
84383: AND xet.event_class_code = C_EVENT_CLASS_CODE
84568: WHEN 17 THEN fvl34.meaning
84569:
84570: ELSE null
84571: END source_meaning
84572: FROM xla_events_gt xet
84573: , PA_XLA_CDL_LINES_V l1
84574: , fnd_lookup_values fvl34
84575: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
84576: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
84786: ,xet.event_created_by
84787: ,xet.budgetary_control_flag
84788: , h2.EXPENDITURE_ITEM_ID source_32
84789: , h2.GL_DATE source_87
84790: FROM xla_events_gt xet
84791: , PA_XLA_EXP_HEADER_V h2
84792: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
84793: and xet.event_class_code = C_EVENT_CLASS_CODE
84794: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
84845: , l1.LINE_NUMBER source_33
84846: , l1.LINE_TYPE source_34
84847: , fvl34.meaning source_34_meaning
84848: , l1.LINE_NUM_REVERSED source_35
84849: FROM xla_events_gt xet
84850: , PA_XLA_CDL_LINES_V l1
84851: , fnd_lookup_values fvl34
84852: WHERE xet.event_id between x_first_event_id and x_last_event_id
84853: and xet.event_date between p_pad_start_date and p_pad_end_date
85673:
85674: ELSE null
85675: END source_value
85676: , null source_meaning
85677: FROM xla_events_gt xet
85678: , PA_XLA_EXP_HEADER_V h2
85679: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
85680: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
85681: AND xet.event_class_code = C_EVENT_CLASS_CODE
85866: WHEN 17 THEN fvl34.meaning
85867:
85868: ELSE null
85869: END source_meaning
85870: FROM xla_events_gt xet
85871: , PA_XLA_CDL_LINES_V l1
85872: , fnd_lookup_values fvl34
85873: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
85874: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
86084: ,xet.event_created_by
86085: ,xet.budgetary_control_flag
86086: , h2.EXPENDITURE_ITEM_ID source_32
86087: , h2.GL_DATE source_87
86088: FROM xla_events_gt xet
86089: , PA_XLA_EXP_HEADER_V h2
86090: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
86091: and xet.event_class_code = C_EVENT_CLASS_CODE
86092: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
86143: , l1.LINE_NUMBER source_33
86144: , l1.LINE_TYPE source_34
86145: , fvl34.meaning source_34_meaning
86146: , l1.LINE_NUM_REVERSED source_35
86147: FROM xla_events_gt xet
86148: , PA_XLA_CDL_LINES_V l1
86149: , fnd_lookup_values fvl34
86150: WHERE xet.event_id between x_first_event_id and x_last_event_id
86151: and xet.event_date between p_pad_start_date and p_pad_end_date
86971:
86972: ELSE null
86973: END source_value
86974: , null source_meaning
86975: FROM xla_events_gt xet
86976: , PA_XLA_EXP_HEADER_V h2
86977: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
86978: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
86979: AND xet.event_class_code = C_EVENT_CLASS_CODE
87164: WHEN 17 THEN fvl34.meaning
87165:
87166: ELSE null
87167: END source_meaning
87168: FROM xla_events_gt xet
87169: , PA_XLA_CDL_LINES_V l1
87170: , fnd_lookup_values fvl34
87171: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
87172: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
87382: ,xet.event_created_by
87383: ,xet.budgetary_control_flag
87384: , h2.EXPENDITURE_ITEM_ID source_32
87385: , h2.GL_DATE source_87
87386: FROM xla_events_gt xet
87387: , PA_XLA_EXP_HEADER_V h2
87388: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
87389: and xet.event_class_code = C_EVENT_CLASS_CODE
87390: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
87441: , l1.LINE_NUMBER source_33
87442: , l1.LINE_TYPE source_34
87443: , fvl34.meaning source_34_meaning
87444: , l1.LINE_NUM_REVERSED source_35
87445: FROM xla_events_gt xet
87446: , PA_XLA_CDL_LINES_V l1
87447: , fnd_lookup_values fvl34
87448: WHERE xet.event_id between x_first_event_id and x_last_event_id
87449: and xet.event_date between p_pad_start_date and p_pad_end_date
88994: ,p_level => C_LEVEL_STATEMENT
88995: ,p_module => l_log_module);
88996:
88997: trace
88998: (p_msg => '# of events in xla_events_gt: '
88999: ||xla_context_pkg.get_event_count_context
89000: ,p_level => C_LEVEL_STATEMENT
89001: ,p_module => l_log_module);
89002: