eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_00275_AAD_S_000016_PKG dependencies on XLA_EVENTS_GT

Line 55392: FROM xla_events_gt xet

55388: WHEN 2 THEN fvl67.meaning
55389:
55390: ELSE null
55391: END source_meaning
55392: FROM xla_events_gt xet
55393: , PA_XLA_EXP_HEADER_V h2
55394: , fnd_lookup_values fvl67
55395: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
55396: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 55590: FROM xla_events_gt xet

55586: WHEN 15 THEN fvl34.meaning
55587:
55588: ELSE null
55589: END source_meaning
55590: FROM xla_events_gt xet
55591: , PA_XLA_CCDL_LINES_V l1
55592: , fnd_lookup_values fvl34
55593: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
55594: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 55813: FROM xla_events_gt xet

55809: , h2.EXPENDITURE_ITEM_ID source_32
55810: , h2.TP_AMT_TYPE_CODE source_67
55811: , fvl67.meaning source_67_meaning
55812: , h2.GL_DATE source_88
55813: FROM xla_events_gt xet
55814: , PA_XLA_EXP_HEADER_V h2
55815: , fnd_lookup_values fvl67
55816: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
55817: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 55877: FROM xla_events_gt xet

55873: , fvl34.meaning source_34_meaning
55874: , l1.LINE_NUM_REVERSED source_35
55875: , l1.ENTERED_AMOUNT source_41
55876: , l1.ACCT_AMOUNT source_43
55877: FROM xla_events_gt xet
55878: , PA_XLA_CCDL_LINES_V l1
55879: , fnd_lookup_values fvl34
55880: WHERE xet.event_id between x_first_event_id and x_last_event_id
55881: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 56800: FROM xla_events_gt xet

56796: WHEN 2 THEN fvl67.meaning
56797:
56798: ELSE null
56799: END source_meaning
56800: FROM xla_events_gt xet
56801: , PA_XLA_EXP_HEADER_V h2
56802: , fnd_lookup_values fvl67
56803: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
56804: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 56998: FROM xla_events_gt xet

56994: WHEN 15 THEN fvl34.meaning
56995:
56996: ELSE null
56997: END source_meaning
56998: FROM xla_events_gt xet
56999: , PA_XLA_CCDL_LINES_V l1
57000: , fnd_lookup_values fvl34
57001: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
57002: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 57221: FROM xla_events_gt xet

57217: , h2.EXPENDITURE_ITEM_ID source_32
57218: , h2.TP_AMT_TYPE_CODE source_67
57219: , fvl67.meaning source_67_meaning
57220: , h2.GL_DATE source_88
57221: FROM xla_events_gt xet
57222: , PA_XLA_EXP_HEADER_V h2
57223: , fnd_lookup_values fvl67
57224: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
57225: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 57285: FROM xla_events_gt xet

57281: , fvl34.meaning source_34_meaning
57282: , l1.LINE_NUM_REVERSED source_35
57283: , l1.ENTERED_AMOUNT source_41
57284: , l1.ACCT_AMOUNT source_43
57285: FROM xla_events_gt xet
57286: , PA_XLA_CCDL_LINES_V l1
57287: , fnd_lookup_values fvl34
57288: WHERE xet.event_id between x_first_event_id and x_last_event_id
57289: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 58199: FROM xla_events_gt xet

58195:
58196: ELSE null
58197: END source_value
58198: , null source_meaning
58199: FROM xla_events_gt xet
58200: , PA_XLA_BC_BUDGET_HEADER_V h1
58201: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
58202: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
58203: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 58346: FROM xla_events_gt xet

58342: WHEN 4 THEN fvl34.meaning
58343:
58344: ELSE null
58345: END source_meaning
58346: FROM xla_events_gt xet
58347: , PA_XLA_BC_BUDGET_LINES_V l2
58348: , fnd_lookup_values fvl34
58349: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
58350: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 58548: FROM xla_events_gt xet

58544: ,xet.event_created_by
58545: ,xet.budgetary_control_flag
58546: , h1.GL_DATE source_88
58547: , h1.GL_BUDGET_VERSION_ID source_89
58548: FROM xla_events_gt xet
58549: , PA_XLA_BC_BUDGET_HEADER_V h1
58550: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
58551: and xet.event_class_code = C_EVENT_CLASS_CODE
58552: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 58599: FROM xla_events_gt xet

58595: , l2.ENC_UPG_DR_ACCT_CLASS source_53
58596: , l2.USE_ENC_UPG_ATTRIB_FLAG source_55
58597: , l2.BUDGET_LINE_ID source_90
58598: , l2.ENC_UPG_ENC_TYPE_ID source_91
58599: FROM xla_events_gt xet
58600: , PA_XLA_BC_BUDGET_LINES_V l2
58601: , fnd_lookup_values fvl34
58602: WHERE xet.event_id between x_first_event_id and x_last_event_id
58603: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 59323: FROM xla_events_gt xet

59319:
59320: ELSE null
59321: END source_value
59322: , null source_meaning
59323: FROM xla_events_gt xet
59324: , PA_XLA_EXP_HEADER_V h2
59325: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
59326: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
59327: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 59581: FROM xla_events_gt xet

59577: WHEN 16 THEN fvl34.meaning
59578:
59579: ELSE null
59580: END source_meaning
59581: FROM xla_events_gt xet
59582: , PA_XLA_CDL_LINES_V l1
59583: , fnd_lookup_values fvl34
59584: , (select rownum r from all_objects where rownum <= 31 and owner = p_apps_owner)
59585: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 59825: FROM xla_events_gt xet

59821: ,xet.event_created_by
59822: ,xet.budgetary_control_flag
59823: , h2.EXPENDITURE_ITEM_ID source_32
59824: , h2.GL_DATE source_88
59825: FROM xla_events_gt xet
59826: , PA_XLA_EXP_HEADER_V h2
59827: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
59828: and xet.event_class_code = C_EVENT_CLASS_CODE
59829: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 59897: FROM xla_events_gt xet

59893: , l1.ENC_UPG_CR_ACCT_CLASS source_54
59894: , l1.USE_ENC_UPG_ATTRIB_FLAG source_55
59895: , l1.ENCUMBRANCE_TYPE_ID source_56
59896: , l1.PROJ_ENCUMBRANCE_TYPE_ID source_57
59897: FROM xla_events_gt xet
59898: , PA_XLA_CDL_LINES_V l1
59899: , fnd_lookup_values fvl34
59900: WHERE xet.event_id between x_first_event_id and x_last_event_id
59901: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 60795: FROM xla_events_gt xet

60791:
60792: ELSE null
60793: END source_value
60794: , null source_meaning
60795: FROM xla_events_gt xet
60796: , PA_XLA_EXP_HEADER_V h2
60797: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
60798: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
60799: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 61144: FROM xla_events_gt xet

61140: WHEN 32 THEN fvl70.meaning
61141:
61142: ELSE null
61143: END source_meaning
61144: FROM xla_events_gt xet
61145: , PA_XLA_CDL_LINES_V l1
61146: , fnd_lookup_values fvl34
61147: , fnd_lookup_values fvl70
61148: , (select rownum r from all_objects where rownum <= 49 and owner = p_apps_owner)

Line 61433: FROM xla_events_gt xet

61429: ,xet.budgetary_control_flag
61430: , h2.EXPENDITURE_ITEM_ID source_32
61431: , h2.SYSTEM_LINKAGE_FUNCTION source_37
61432: , h2.GL_DATE source_88
61433: FROM xla_events_gt xet
61434: , PA_XLA_EXP_HEADER_V h2
61435: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
61436: and xet.event_class_code = C_EVENT_CLASS_CODE
61437: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 61524: FROM xla_events_gt xet

61520: , l1.PO_FIRST_SYS_TRANS_ID source_84
61521: , l1.PO_SECOND_DIST_ID source_85
61522: , l1.ENC_ACCT_ENABLED source_86
61523: , l1.LIQUIDATE_ENCUM_FLAG source_87
61524: FROM xla_events_gt xet
61525: , PA_XLA_CDL_LINES_V l1
61526: , fnd_lookup_values fvl34
61527: , fnd_lookup_values fvl70
61528: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 62800: FROM xla_events_gt xet

62796:
62797: ELSE null
62798: END source_value
62799: , null source_meaning
62800: FROM xla_events_gt xet
62801: , PA_XLA_EXP_HEADER_V h2
62802: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
62803: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
62804: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 62993: FROM xla_events_gt xet

62989: WHEN 17 THEN fvl34.meaning
62990:
62991: ELSE null
62992: END source_meaning
62993: FROM xla_events_gt xet
62994: , PA_XLA_CDL_LINES_V l1
62995: , fnd_lookup_values fvl34
62996: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
62997: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 63211: FROM xla_events_gt xet

63207: ,xet.event_created_by
63208: ,xet.budgetary_control_flag
63209: , h2.EXPENDITURE_ITEM_ID source_32
63210: , h2.GL_DATE source_88
63211: FROM xla_events_gt xet
63212: , PA_XLA_EXP_HEADER_V h2
63213: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
63214: and xet.event_class_code = C_EVENT_CLASS_CODE
63215: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 63270: FROM xla_events_gt xet

63266: , l1.LINE_NUMBER source_33
63267: , l1.LINE_TYPE source_34
63268: , fvl34.meaning source_34_meaning
63269: , l1.LINE_NUM_REVERSED source_35
63270: FROM xla_events_gt xet
63271: , PA_XLA_CDL_LINES_V l1
63272: , fnd_lookup_values fvl34
63273: WHERE xet.event_id between x_first_event_id and x_last_event_id
63274: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 64098: FROM xla_events_gt xet

64094:
64095: ELSE null
64096: END source_value
64097: , null source_meaning
64098: FROM xla_events_gt xet
64099: , PA_XLA_EXP_HEADER_V h2
64100: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
64101: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
64102: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 64291: FROM xla_events_gt xet

64287: WHEN 17 THEN fvl34.meaning
64288:
64289: ELSE null
64290: END source_meaning
64291: FROM xla_events_gt xet
64292: , PA_XLA_CDL_LINES_V l1
64293: , fnd_lookup_values fvl34
64294: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
64295: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 64509: FROM xla_events_gt xet

64505: ,xet.event_created_by
64506: ,xet.budgetary_control_flag
64507: , h2.EXPENDITURE_ITEM_ID source_32
64508: , h2.GL_DATE source_88
64509: FROM xla_events_gt xet
64510: , PA_XLA_EXP_HEADER_V h2
64511: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
64512: and xet.event_class_code = C_EVENT_CLASS_CODE
64513: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 64568: FROM xla_events_gt xet

64564: , l1.LINE_NUMBER source_33
64565: , l1.LINE_TYPE source_34
64566: , fvl34.meaning source_34_meaning
64567: , l1.LINE_NUM_REVERSED source_35
64568: FROM xla_events_gt xet
64569: , PA_XLA_CDL_LINES_V l1
64570: , fnd_lookup_values fvl34
64571: WHERE xet.event_id between x_first_event_id and x_last_event_id
64572: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 65396: FROM xla_events_gt xet

65392:
65393: ELSE null
65394: END source_value
65395: , null source_meaning
65396: FROM xla_events_gt xet
65397: , PA_XLA_EXP_HEADER_V h2
65398: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
65399: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
65400: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 65589: FROM xla_events_gt xet

65585: WHEN 17 THEN fvl34.meaning
65586:
65587: ELSE null
65588: END source_meaning
65589: FROM xla_events_gt xet
65590: , PA_XLA_CDL_LINES_V l1
65591: , fnd_lookup_values fvl34
65592: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
65593: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 65807: FROM xla_events_gt xet

65803: ,xet.event_created_by
65804: ,xet.budgetary_control_flag
65805: , h2.EXPENDITURE_ITEM_ID source_32
65806: , h2.GL_DATE source_88
65807: FROM xla_events_gt xet
65808: , PA_XLA_EXP_HEADER_V h2
65809: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
65810: and xet.event_class_code = C_EVENT_CLASS_CODE
65811: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 65866: FROM xla_events_gt xet

65862: , l1.LINE_NUMBER source_33
65863: , l1.LINE_TYPE source_34
65864: , fvl34.meaning source_34_meaning
65865: , l1.LINE_NUM_REVERSED source_35
65866: FROM xla_events_gt xet
65867: , PA_XLA_CDL_LINES_V l1
65868: , fnd_lookup_values fvl34
65869: WHERE xet.event_id between x_first_event_id and x_last_event_id
65870: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 66694: FROM xla_events_gt xet

66690:
66691: ELSE null
66692: END source_value
66693: , null source_meaning
66694: FROM xla_events_gt xet
66695: , PA_XLA_EXP_HEADER_V h2
66696: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
66697: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
66698: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 66887: FROM xla_events_gt xet

66883: WHEN 17 THEN fvl34.meaning
66884:
66885: ELSE null
66886: END source_meaning
66887: FROM xla_events_gt xet
66888: , PA_XLA_CDL_LINES_V l1
66889: , fnd_lookup_values fvl34
66890: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
66891: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 67105: FROM xla_events_gt xet

67101: ,xet.event_created_by
67102: ,xet.budgetary_control_flag
67103: , h2.EXPENDITURE_ITEM_ID source_32
67104: , h2.GL_DATE source_88
67105: FROM xla_events_gt xet
67106: , PA_XLA_EXP_HEADER_V h2
67107: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
67108: and xet.event_class_code = C_EVENT_CLASS_CODE
67109: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 67164: FROM xla_events_gt xet

67160: , l1.LINE_NUMBER source_33
67161: , l1.LINE_TYPE source_34
67162: , fvl34.meaning source_34_meaning
67163: , l1.LINE_NUM_REVERSED source_35
67164: FROM xla_events_gt xet
67165: , PA_XLA_CDL_LINES_V l1
67166: , fnd_lookup_values fvl34
67167: WHERE xet.event_id between x_first_event_id and x_last_event_id
67168: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 67997: FROM xla_events_gt xet

67993:
67994: ELSE null
67995: END source_value
67996: , null source_meaning
67997: FROM xla_events_gt xet
67998: , PA_XLA_EXP_HEADER_V h2
67999: , PA_XLA_PROJECT_REF_V h3
68000: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
68001: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 68191: FROM xla_events_gt xet

68187: WHEN 17 THEN fvl34.meaning
68188:
68189: ELSE null
68190: END source_meaning
68191: FROM xla_events_gt xet
68192: , PA_XLA_CDL_LINES_V l1
68193: , fnd_lookup_values fvl34
68194: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
68195: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 68412: FROM xla_events_gt xet

68408: ,xet.budgetary_control_flag
68409: , h2.EXPENDITURE_ITEM_ID source_32
68410: , h3.PROJECT_NUMBER source_68
68411: , h2.GL_DATE source_88
68412: FROM xla_events_gt xet
68413: , PA_XLA_EXP_HEADER_V h2
68414: , PA_XLA_PROJECT_REF_V h3
68415: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
68416: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 68472: FROM xla_events_gt xet

68468: , l1.LINE_NUMBER source_33
68469: , l1.LINE_TYPE source_34
68470: , fvl34.meaning source_34_meaning
68471: , l1.LINE_NUM_REVERSED source_35
68472: FROM xla_events_gt xet
68473: , PA_XLA_CDL_LINES_V l1
68474: , fnd_lookup_values fvl34
68475: WHERE xet.event_id between x_first_event_id and x_last_event_id
68476: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 69309: FROM xla_events_gt xet

69305:
69306: ELSE null
69307: END source_value
69308: , null source_meaning
69309: FROM xla_events_gt xet
69310: , PA_XLA_EXP_HEADER_V h2
69311: , PA_XLA_PROJECT_REF_V h3
69312: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
69313: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 69503: FROM xla_events_gt xet

69499: WHEN 17 THEN fvl34.meaning
69500:
69501: ELSE null
69502: END source_meaning
69503: FROM xla_events_gt xet
69504: , PA_XLA_CDL_LINES_V l1
69505: , fnd_lookup_values fvl34
69506: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
69507: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 69724: FROM xla_events_gt xet

69720: ,xet.budgetary_control_flag
69721: , h2.EXPENDITURE_ITEM_ID source_32
69722: , h3.PROJECT_NUMBER source_68
69723: , h2.GL_DATE source_88
69724: FROM xla_events_gt xet
69725: , PA_XLA_EXP_HEADER_V h2
69726: , PA_XLA_PROJECT_REF_V h3
69727: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
69728: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 69784: FROM xla_events_gt xet

69780: , l1.LINE_NUMBER source_33
69781: , l1.LINE_TYPE source_34
69782: , fvl34.meaning source_34_meaning
69783: , l1.LINE_NUM_REVERSED source_35
69784: FROM xla_events_gt xet
69785: , PA_XLA_CDL_LINES_V l1
69786: , fnd_lookup_values fvl34
69787: WHERE xet.event_id between x_first_event_id and x_last_event_id
69788: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 70616: FROM xla_events_gt xet

70612:
70613: ELSE null
70614: END source_value
70615: , null source_meaning
70616: FROM xla_events_gt xet
70617: , PA_XLA_EXP_HEADER_V h2
70618: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
70619: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
70620: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 70809: FROM xla_events_gt xet

70805: WHEN 15 THEN fvl34.meaning
70806:
70807: ELSE null
70808: END source_meaning
70809: FROM xla_events_gt xet
70810: , PA_XLA_CCDL_LINES_V l1
70811: , fnd_lookup_values fvl34
70812: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
70813: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 71027: FROM xla_events_gt xet

71023: ,xet.event_created_by
71024: ,xet.budgetary_control_flag
71025: , h2.EXPENDITURE_ITEM_ID source_32
71026: , h2.GL_DATE source_88
71027: FROM xla_events_gt xet
71028: , PA_XLA_EXP_HEADER_V h2
71029: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
71030: and xet.event_class_code = C_EVENT_CLASS_CODE
71031: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 71086: FROM xla_events_gt xet

71082: , fvl34.meaning source_34_meaning
71083: , l1.LINE_NUM_REVERSED source_35
71084: , l1.ENTERED_AMOUNT source_41
71085: , l1.ACCT_AMOUNT source_43
71086: FROM xla_events_gt xet
71087: , PA_XLA_CCDL_LINES_V l1
71088: , fnd_lookup_values fvl34
71089: WHERE xet.event_id between x_first_event_id and x_last_event_id
71090: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 71914: FROM xla_events_gt xet

71910:
71911: ELSE null
71912: END source_value
71913: , null source_meaning
71914: FROM xla_events_gt xet
71915: , PA_XLA_EXP_HEADER_V h2
71916: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
71917: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
71918: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 72107: FROM xla_events_gt xet

72103: WHEN 15 THEN fvl34.meaning
72104:
72105: ELSE null
72106: END source_meaning
72107: FROM xla_events_gt xet
72108: , PA_XLA_CCDL_LINES_V l1
72109: , fnd_lookup_values fvl34
72110: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
72111: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 72325: FROM xla_events_gt xet

72321: ,xet.event_created_by
72322: ,xet.budgetary_control_flag
72323: , h2.EXPENDITURE_ITEM_ID source_32
72324: , h2.GL_DATE source_88
72325: FROM xla_events_gt xet
72326: , PA_XLA_EXP_HEADER_V h2
72327: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
72328: and xet.event_class_code = C_EVENT_CLASS_CODE
72329: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 72384: FROM xla_events_gt xet

72380: , fvl34.meaning source_34_meaning
72381: , l1.LINE_NUM_REVERSED source_35
72382: , l1.ENTERED_AMOUNT source_41
72383: , l1.ACCT_AMOUNT source_43
72384: FROM xla_events_gt xet
72385: , PA_XLA_CCDL_LINES_V l1
72386: , fnd_lookup_values fvl34
72387: WHERE xet.event_id between x_first_event_id and x_last_event_id
72388: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 73236: FROM xla_events_gt xet

73232: ,275)
73233:
73234: ELSE null
73235: END source_meaning
73236: FROM xla_events_gt xet
73237: , PA_XLA_REVENUE_HEADERS_V h2
73238: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
73239: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73240: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 73448: FROM xla_events_gt xet

73444: WHEN 15 THEN fvl58.meaning
73445:
73446: ELSE null
73447: END source_meaning
73448: FROM xla_events_gt xet
73449: , PA_XLA_EVENT_TYPE_REF_V l1
73450: , PA_XLA_REVENUE_LINES_ADJ_V l3
73451: , fnd_lookup_values fvl58
73452: , (select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)

Line 73686: FROM xla_events_gt xet

73682: , h2.EVENT_ID source_42
73683: , h2.GL_DATE source_88
73684: , h2.UER_CCID source_92
73685: , h2.UBR_CCID source_93
73686: FROM xla_events_gt xet
73687: , PA_XLA_REVENUE_HEADERS_V h2
73688: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
73689: and xet.event_class_code = C_EVENT_CLASS_CODE
73690: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 73750: FROM xla_events_gt xet

73746: , l3.CR_REVENUE_FIRST_DIST_ID source_63
73747: , l3.PROJECT_ID source_64
73748: , l3.CR_REVENUE_SECOND_DIST_ID source_65
73749: , l3.PDR_DRAFT_REV_NUM_CREDITED source_66
73750: FROM xla_events_gt xet
73751: , PA_XLA_EVENT_TYPE_REF_V l1
73752: , PA_XLA_REVENUE_LINES_ADJ_V l3
73753: , fnd_lookup_values fvl58
73754: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 74778: FROM xla_events_gt xet

74774: ,275)
74775:
74776: ELSE null
74777: END source_meaning
74778: FROM xla_events_gt xet
74779: , PA_XLA_REVENUE_HEADERS_V h2
74780: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
74781: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74782: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 74960: FROM xla_events_gt xet

74956: WHEN 17 THEN fvl58.meaning
74957:
74958: ELSE null
74959: END source_meaning
74960: FROM xla_events_gt xet
74961: , PA_XLA_EVENT_TYPE_REF_V l1
74962: , PA_XLA_REVENUE_LINES_V l3
74963: , fnd_lookup_values fvl58
74964: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)

Line 75186: FROM xla_events_gt xet

75182: , h2.EVENT_ID source_42
75183: , h2.GL_DATE source_88
75184: , h2.UER_CCID source_92
75185: , h2.UBR_CCID source_93
75186: FROM xla_events_gt xet
75187: , PA_XLA_REVENUE_HEADERS_V h2
75188: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
75189: and xet.event_class_code = C_EVENT_CLASS_CODE
75190: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 75244: FROM xla_events_gt xet

75240: , l3.ENTERED_AMOUNT source_41
75241: , l3.ACCT_AMOUNT source_43
75242: , l1.REV_EVENT_TYPE_CLASSIFICATION source_58
75243: , fvl58.meaning source_58_meaning
75244: FROM xla_events_gt xet
75245: , PA_XLA_EVENT_TYPE_REF_V l1
75246: , PA_XLA_REVENUE_LINES_V l3
75247: , fnd_lookup_values fvl58
75248: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 76402: FROM xla_events_gt xet

76398: ,275)
76399:
76400: ELSE null
76401: END source_meaning
76402: FROM xla_events_gt xet
76403: , PA_XLA_EXP_HEADER_V h2
76404: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
76405: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
76406: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 76595: FROM xla_events_gt xet

76591: WHEN 17 THEN fvl34.meaning
76592:
76593: ELSE null
76594: END source_meaning
76595: FROM xla_events_gt xet
76596: , PA_XLA_CDL_LINES_V l1
76597: , fnd_lookup_values fvl34
76598: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
76599: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 76816: FROM xla_events_gt xet

76812: ,xet.budgetary_control_flag
76813: , h2.EXCHANGE_RATE_VARIANCE_FLAG source_21
76814: , h2.EXPENDITURE_ITEM_ID source_32
76815: , h2.GL_DATE source_88
76816: FROM xla_events_gt xet
76817: , PA_XLA_EXP_HEADER_V h2
76818: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
76819: and xet.event_class_code = C_EVENT_CLASS_CODE
76820: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 76875: FROM xla_events_gt xet

76871: , l1.LINE_NUMBER source_33
76872: , l1.LINE_TYPE source_34
76873: , fvl34.meaning source_34_meaning
76874: , l1.LINE_NUM_REVERSED source_35
76875: FROM xla_events_gt xet
76876: , PA_XLA_CDL_LINES_V l1
76877: , fnd_lookup_values fvl34
76878: WHERE xet.event_id between x_first_event_id and x_last_event_id
76879: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 77797: FROM xla_events_gt xet

77793: ,275)
77794:
77795: ELSE null
77796: END source_meaning
77797: FROM xla_events_gt xet
77798: , PA_XLA_EXP_HEADER_V h2
77799: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
77800: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77801: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 77990: FROM xla_events_gt xet

77986: WHEN 17 THEN fvl34.meaning
77987:
77988: ELSE null
77989: END source_meaning
77990: FROM xla_events_gt xet
77991: , PA_XLA_CDL_LINES_V l1
77992: , fnd_lookup_values fvl34
77993: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
77994: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 78211: FROM xla_events_gt xet

78207: ,xet.budgetary_control_flag
78208: , h2.EXCHANGE_RATE_VARIANCE_FLAG source_21
78209: , h2.EXPENDITURE_ITEM_ID source_32
78210: , h2.GL_DATE source_88
78211: FROM xla_events_gt xet
78212: , PA_XLA_EXP_HEADER_V h2
78213: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
78214: and xet.event_class_code = C_EVENT_CLASS_CODE
78215: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 78270: FROM xla_events_gt xet

78266: , l1.LINE_NUMBER source_33
78267: , l1.LINE_TYPE source_34
78268: , fvl34.meaning source_34_meaning
78269: , l1.LINE_NUM_REVERSED source_35
78270: FROM xla_events_gt xet
78271: , PA_XLA_CDL_LINES_V l1
78272: , fnd_lookup_values fvl34
78273: WHERE xet.event_id between x_first_event_id and x_last_event_id
78274: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 79183: FROM xla_events_gt xet

79179:
79180: ELSE null
79181: END source_value
79182: , null source_meaning
79183: FROM xla_events_gt xet
79184: , PA_XLA_EXP_HEADER_V h2
79185: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
79186: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
79187: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 79527: FROM xla_events_gt xet

79523: WHEN 31 THEN fvl70.meaning
79524:
79525: ELSE null
79526: END source_meaning
79527: FROM xla_events_gt xet
79528: , PA_XLA_CDL_LINES_V l1
79529: , fnd_lookup_values fvl34
79530: , fnd_lookup_values fvl70
79531: , (select rownum r from all_objects where rownum <= 48 and owner = p_apps_owner)

Line 79814: FROM xla_events_gt xet

79810: ,xet.budgetary_control_flag
79811: , h2.EXPENDITURE_ITEM_ID source_32
79812: , h2.SYSTEM_LINKAGE_FUNCTION source_37
79813: , h2.GL_DATE source_88
79814: FROM xla_events_gt xet
79815: , PA_XLA_EXP_HEADER_V h2
79816: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
79817: and xet.event_class_code = C_EVENT_CLASS_CODE
79818: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 79904: FROM xla_events_gt xet

79900: , l1.PO_FIRST_SYS_TRANS_ID source_84
79901: , l1.PO_SECOND_DIST_ID source_85
79902: , l1.ENC_ACCT_ENABLED source_86
79903: , l1.LIQUIDATE_ENCUM_FLAG source_87
79904: FROM xla_events_gt xet
79905: , PA_XLA_CDL_LINES_V l1
79906: , fnd_lookup_values fvl34
79907: , fnd_lookup_values fvl70
79908: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 81171: FROM xla_events_gt xet

81167:
81168: ELSE null
81169: END source_value
81170: , null source_meaning
81171: FROM xla_events_gt xet
81172: , PA_XLA_EXP_HEADER_V h2
81173: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
81174: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
81175: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 81520: FROM xla_events_gt xet

81516: WHEN 32 THEN fvl70.meaning
81517:
81518: ELSE null
81519: END source_meaning
81520: FROM xla_events_gt xet
81521: , PA_XLA_CDL_LINES_V l1
81522: , fnd_lookup_values fvl34
81523: , fnd_lookup_values fvl70
81524: , (select rownum r from all_objects where rownum <= 49 and owner = p_apps_owner)

Line 81809: FROM xla_events_gt xet

81805: ,xet.budgetary_control_flag
81806: , h2.EXPENDITURE_ITEM_ID source_32
81807: , h2.SYSTEM_LINKAGE_FUNCTION source_37
81808: , h2.GL_DATE source_88
81809: FROM xla_events_gt xet
81810: , PA_XLA_EXP_HEADER_V h2
81811: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
81812: and xet.event_class_code = C_EVENT_CLASS_CODE
81813: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 81900: FROM xla_events_gt xet

81896: , l1.PO_FIRST_SYS_TRANS_ID source_84
81897: , l1.PO_SECOND_DIST_ID source_85
81898: , l1.ENC_ACCT_ENABLED source_86
81899: , l1.LIQUIDATE_ENCUM_FLAG source_87
81900: FROM xla_events_gt xet
81901: , PA_XLA_CDL_LINES_V l1
81902: , fnd_lookup_values fvl34
81903: , fnd_lookup_values fvl70
81904: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 83189: FROM xla_events_gt xet

83185:
83186: ELSE null
83187: END source_value
83188: , null source_meaning
83189: FROM xla_events_gt xet
83190: , PA_XLA_EXP_HEADER_V h2
83191: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
83192: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
83193: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 83382: FROM xla_events_gt xet

83378: WHEN 17 THEN fvl34.meaning
83379:
83380: ELSE null
83381: END source_meaning
83382: FROM xla_events_gt xet
83383: , PA_XLA_CDL_LINES_V l1
83384: , fnd_lookup_values fvl34
83385: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
83386: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 83600: FROM xla_events_gt xet

83596: ,xet.event_created_by
83597: ,xet.budgetary_control_flag
83598: , h2.EXPENDITURE_ITEM_ID source_32
83599: , h2.GL_DATE source_88
83600: FROM xla_events_gt xet
83601: , PA_XLA_EXP_HEADER_V h2
83602: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
83603: and xet.event_class_code = C_EVENT_CLASS_CODE
83604: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 83659: FROM xla_events_gt xet

83655: , l1.LINE_NUMBER source_33
83656: , l1.LINE_TYPE source_34
83657: , fvl34.meaning source_34_meaning
83658: , l1.LINE_NUM_REVERSED source_35
83659: FROM xla_events_gt xet
83660: , PA_XLA_CDL_LINES_V l1
83661: , fnd_lookup_values fvl34
83662: WHERE xet.event_id between x_first_event_id and x_last_event_id
83663: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 84487: FROM xla_events_gt xet

84483:
84484: ELSE null
84485: END source_value
84486: , null source_meaning
84487: FROM xla_events_gt xet
84488: , PA_XLA_EXP_HEADER_V h2
84489: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
84490: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
84491: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 84680: FROM xla_events_gt xet

84676: WHEN 17 THEN fvl34.meaning
84677:
84678: ELSE null
84679: END source_meaning
84680: FROM xla_events_gt xet
84681: , PA_XLA_CDL_LINES_V l1
84682: , fnd_lookup_values fvl34
84683: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
84684: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 84898: FROM xla_events_gt xet

84894: ,xet.event_created_by
84895: ,xet.budgetary_control_flag
84896: , h2.EXPENDITURE_ITEM_ID source_32
84897: , h2.GL_DATE source_88
84898: FROM xla_events_gt xet
84899: , PA_XLA_EXP_HEADER_V h2
84900: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
84901: and xet.event_class_code = C_EVENT_CLASS_CODE
84902: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 84957: FROM xla_events_gt xet

84953: , l1.LINE_NUMBER source_33
84954: , l1.LINE_TYPE source_34
84955: , fvl34.meaning source_34_meaning
84956: , l1.LINE_NUM_REVERSED source_35
84957: FROM xla_events_gt xet
84958: , PA_XLA_CDL_LINES_V l1
84959: , fnd_lookup_values fvl34
84960: WHERE xet.event_id between x_first_event_id and x_last_event_id
84961: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 85785: FROM xla_events_gt xet

85781:
85782: ELSE null
85783: END source_value
85784: , null source_meaning
85785: FROM xla_events_gt xet
85786: , PA_XLA_EXP_HEADER_V h2
85787: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
85788: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
85789: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 85978: FROM xla_events_gt xet

85974: WHEN 17 THEN fvl34.meaning
85975:
85976: ELSE null
85977: END source_meaning
85978: FROM xla_events_gt xet
85979: , PA_XLA_CDL_LINES_V l1
85980: , fnd_lookup_values fvl34
85981: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
85982: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 86196: FROM xla_events_gt xet

86192: ,xet.event_created_by
86193: ,xet.budgetary_control_flag
86194: , h2.EXPENDITURE_ITEM_ID source_32
86195: , h2.GL_DATE source_88
86196: FROM xla_events_gt xet
86197: , PA_XLA_EXP_HEADER_V h2
86198: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
86199: and xet.event_class_code = C_EVENT_CLASS_CODE
86200: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 86255: FROM xla_events_gt xet

86251: , l1.LINE_NUMBER source_33
86252: , l1.LINE_TYPE source_34
86253: , fvl34.meaning source_34_meaning
86254: , l1.LINE_NUM_REVERSED source_35
86255: FROM xla_events_gt xet
86256: , PA_XLA_CDL_LINES_V l1
86257: , fnd_lookup_values fvl34
86258: WHERE xet.event_id between x_first_event_id and x_last_event_id
86259: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 87083: FROM xla_events_gt xet

87079:
87080: ELSE null
87081: END source_value
87082: , null source_meaning
87083: FROM xla_events_gt xet
87084: , PA_XLA_EXP_HEADER_V h2
87085: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
87086: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
87087: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 87276: FROM xla_events_gt xet

87272: WHEN 17 THEN fvl34.meaning
87273:
87274: ELSE null
87275: END source_meaning
87276: FROM xla_events_gt xet
87277: , PA_XLA_CDL_LINES_V l1
87278: , fnd_lookup_values fvl34
87279: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
87280: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 87494: FROM xla_events_gt xet

87490: ,xet.event_created_by
87491: ,xet.budgetary_control_flag
87492: , h2.EXPENDITURE_ITEM_ID source_32
87493: , h2.GL_DATE source_88
87494: FROM xla_events_gt xet
87495: , PA_XLA_EXP_HEADER_V h2
87496: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
87497: and xet.event_class_code = C_EVENT_CLASS_CODE
87498: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 87553: FROM xla_events_gt xet

87549: , l1.LINE_NUMBER source_33
87550: , l1.LINE_TYPE source_34
87551: , fvl34.meaning source_34_meaning
87552: , l1.LINE_NUM_REVERSED source_35
87553: FROM xla_events_gt xet
87554: , PA_XLA_CDL_LINES_V l1
87555: , fnd_lookup_values fvl34
87556: WHERE xet.event_id between x_first_event_id and x_last_event_id
87557: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 89106: (p_msg => '# of events in xla_events_gt: '

89102: ,p_level => C_LEVEL_STATEMENT
89103: ,p_module => l_log_module);
89104:
89105: trace
89106: (p_msg => '# of events in xla_events_gt: '
89107: ||xla_context_pkg.get_event_count_context
89108: ,p_level => C_LEVEL_STATEMENT
89109: ,p_module => l_log_module);
89110: