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_00201_AAD_S_000005_BC_PKG dependencies on XLA_EVENTS_GT

Line 48501: FROM xla_events_gt xet

48497:
48498: ELSE null
48499: END source_value
48500: , null source_meaning
48501: FROM xla_events_gt xet
48502: , PA_XLA_BC_PKT_PO_HEADER_V h2
48503: ,(select rownum r from all_objects where rownum <= 1 and owner = p_apps_owner)
48504: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
48505: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 48834: FROM xla_events_gt xet

48830: WHEN 8 THEN fvl14.meaning
48831:
48832: ELSE null
48833: END source_meaning
48834: FROM xla_events_gt xet
48835: , PA_XLA_BC_PKT_PO_DETAIL_V l1
48836: , PA_XLA_PROJECT_REF_V l3
48837: , PA_XLA_TASK_REF_V l4
48838: , fnd_lookup_values fvl14

Line 49107: FROM xla_events_gt xet

49103: ,xet.reference_date_4
49104: ,xet.event_created_by
49105: ,xet.budgetary_control_flag
49106: , h2.GL_DATE source_79
49107: FROM xla_events_gt xet
49108: , PA_XLA_BC_PKT_PO_HEADER_V h2
49109: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
49110: and xet.event_class_code = C_EVENT_CLASS_CODE
49111: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 49194: FROM xla_events_gt xet

49190: , l1.PA_ENTITY_CODE source_70
49191: , l1.PA_FIRST_DIST_ID source_71
49192: , l1.PA_FIRST_SYS_TRANS_ID source_72
49193: , l1.PA_SECOND_DIST_ID source_73
49194: FROM xla_events_gt xet
49195: , PA_XLA_BC_PKT_PO_DETAIL_V l1
49196: , PA_XLA_PROJECT_REF_V l3
49197: , PA_XLA_TASK_REF_V l4
49198: , fnd_lookup_values fvl14

Line 51013: FROM xla_events_gt xet

51009:
51010: ELSE null
51011: END source_value
51012: , null source_meaning
51013: FROM xla_events_gt xet
51014: , PO_EXTRACT_HEADER_V h3
51015: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
51016: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
51017: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 51231: FROM xla_events_gt xet

51227:
51228: ELSE null
51229: END source_value
51230: , null source_meaning
51231: FROM xla_events_gt xet
51232: , PO_DISTS_REF_V l1
51233: , PO_EXTRACT_DETAIL_V l2
51234: , (select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
51235: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 51467: FROM xla_events_gt xet

51463: , h3.PO_NUMBER source_2
51464: , h3.PO_HEADER_ID source_52
51465: , h3.GL_DATE source_79
51466: , h3.ENCUMBRANCE_TYPE_ID source_80
51467: FROM xla_events_gt xet
51468: , PO_EXTRACT_HEADER_V h3
51469: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
51470: and xet.event_class_code = C_EVENT_CLASS_CODE
51471: and xet.event_status_code <> 'N' AND h3.event_id = xet.event_id

Line 51532: FROM xla_events_gt xet

51528: , l1.CURRENCY_CONVERSION_RATE source_63
51529: , l1.CURRENCY_CONVERSION_TYPE source_64
51530: , l2.BACKING_REQ_ENC_CHANGED source_65
51531: , l2.ADJUSTMENT_STATUS source_75
51532: FROM xla_events_gt xet
51533: , PO_DISTS_REF_V l1
51534: , PO_EXTRACT_DETAIL_V l2
51535: WHERE xet.event_id between x_first_event_id and x_last_event_id
51536: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 52811: FROM xla_events_gt xet

52807:
52808: ELSE null
52809: END source_value
52810: , null source_meaning
52811: FROM xla_events_gt xet
52812: , PO_EXTRACT_HEADER_V h3
52813: , PO_RELEASES_REF_V h4
52814: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
52815: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 53020: FROM xla_events_gt xet

53016:
53017: ELSE null
53018: END source_value
53019: , null source_meaning
53020: FROM xla_events_gt xet
53021: , PO_DISTS_REF_V l1
53022: , PO_EXTRACT_DETAIL_V l2
53023: , (select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
53024: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 53255: FROM xla_events_gt xet

53251: , h4.PO_RELEASE_NUMBER source_8
53252: , h3.PO_RELEASE_ID source_66
53253: , h3.GL_DATE source_79
53254: , h3.ENCUMBRANCE_TYPE_ID source_80
53255: FROM xla_events_gt xet
53256: , PO_EXTRACT_HEADER_V h3
53257: , PO_RELEASES_REF_V h4
53258: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
53259: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 53319: FROM xla_events_gt xet

53315: , l1.CURRENCY_CONVERSION_DATE source_62
53316: , l1.CURRENCY_CONVERSION_RATE source_63
53317: , l1.CURRENCY_CONVERSION_TYPE source_64
53318: , l2.ADJUSTMENT_STATUS source_75
53319: FROM xla_events_gt xet
53320: , PO_DISTS_REF_V l1
53321: , PO_EXTRACT_DETAIL_V l2
53322: WHERE xet.event_id between x_first_event_id and x_last_event_id
53323: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 54445: FROM xla_events_gt xet

54441:
54442: ELSE null
54443: END source_value
54444: , null source_meaning
54445: FROM xla_events_gt xet
54446: , PA_XLA_BC_PKT_PO_HEADER_V h2
54447: ,(select rownum r from all_objects where rownum <= 1 and owner = p_apps_owner)
54448: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
54449: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 54778: FROM xla_events_gt xet

54774: WHEN 8 THEN fvl14.meaning
54775:
54776: ELSE null
54777: END source_meaning
54778: FROM xla_events_gt xet
54779: , PA_XLA_BC_PKT_PO_DETAIL_V l1
54780: , PA_XLA_PROJECT_REF_V l3
54781: , PA_XLA_TASK_REF_V l4
54782: , fnd_lookup_values fvl14

Line 55051: FROM xla_events_gt xet

55047: ,xet.reference_date_4
55048: ,xet.event_created_by
55049: ,xet.budgetary_control_flag
55050: , h2.GL_DATE source_79
55051: FROM xla_events_gt xet
55052: , PA_XLA_BC_PKT_PO_HEADER_V h2
55053: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
55054: and xet.event_class_code = C_EVENT_CLASS_CODE
55055: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 55138: FROM xla_events_gt xet

55134: , l1.PA_ENTITY_CODE source_70
55135: , l1.PA_FIRST_DIST_ID source_71
55136: , l1.PA_FIRST_SYS_TRANS_ID source_72
55137: , l1.PA_SECOND_DIST_ID source_73
55138: FROM xla_events_gt xet
55139: , PA_XLA_BC_PKT_PO_DETAIL_V l1
55140: , PA_XLA_PROJECT_REF_V l3
55141: , PA_XLA_TASK_REF_V l4
55142: , fnd_lookup_values fvl14

Line 57067: FROM xla_events_gt xet

57063:
57064: ELSE null
57065: END source_value
57066: , null source_meaning
57067: FROM xla_events_gt xet
57068: , PO_REQ_EXTRACT_HEADER_V h2
57069: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
57070: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
57071: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 57265: FROM xla_events_gt xet

57261:
57262: ELSE null
57263: END source_value
57264: , null source_meaning
57265: FROM xla_events_gt xet
57266: , PO_REQ_EXTRACT_DETAIL_V l1
57267: , PO_REQ_LINES_REF_V l3
57268: , (select rownum r from all_objects where rownum <= 21 and owner = p_apps_owner)
57269: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 57493: FROM xla_events_gt xet

57489: , h2.REQ_NUMBER source_10
57490: , h2.REQ_ID source_76
57491: , h2.GL_DATE source_79
57492: , h2.ENCUMBRANCE_TYPE_ID source_80
57493: FROM xla_events_gt xet
57494: , PO_REQ_EXTRACT_HEADER_V h2
57495: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
57496: and xet.event_class_code = C_EVENT_CLASS_CODE
57497: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 57554: FROM xla_events_gt xet

57550: , l3.CURRENCY_CONVERSION_TYPE source_64
57551: , l1.ADJUSTMENT_STATUS source_75
57552: , l1.REQ_ENCUM_UPG_OPTION source_77
57553: , l1.REQ_UPG_ENC_TYPE_ID source_78
57554: FROM xla_events_gt xet
57555: , PO_REQ_EXTRACT_DETAIL_V l1
57556: , PO_REQ_LINES_REF_V l3
57557: WHERE xet.event_id between x_first_event_id and x_last_event_id
57558: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 58412: FROM xla_events_gt xet

58408:
58409: ELSE null
58410: END source_value
58411: , null source_meaning
58412: FROM xla_events_gt xet
58413: , PA_XLA_BC_PKT_REQ_HEADER_V h2
58414: ,(select rownum r from all_objects where rownum <= 1 and owner = p_apps_owner)
58415: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
58416: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 58715: FROM xla_events_gt xet

58711: WHEN 7 THEN fvl14.meaning
58712:
58713: ELSE null
58714: END source_meaning
58715: FROM xla_events_gt xet
58716: , PA_XLA_BC_PKT_REQ_DETAIL_V l1
58717: , PA_XLA_PROJECT_REF_V l3
58718: , PA_XLA_TASK_REF_V l4
58719: , fnd_lookup_values fvl14

Line 58976: FROM xla_events_gt xet

58972: ,xet.reference_date_4
58973: ,xet.event_created_by
58974: ,xet.budgetary_control_flag
58975: , h2.GL_DATE source_79
58976: FROM xla_events_gt xet
58977: , PA_XLA_BC_PKT_REQ_HEADER_V h2
58978: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
58979: and xet.event_class_code = C_EVENT_CLASS_CODE
58980: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 59057: FROM xla_events_gt xet

59053: , l1.PA_FIRST_DIST_ID source_71
59054: , l1.PA_FIRST_SYS_TRANS_ID source_72
59055: , l1.PA_SECOND_DIST_ID source_73
59056: , l1.DOCUMENT_DISTRIBUTION_TYPE source_74
59057: FROM xla_events_gt xet
59058: , PA_XLA_BC_PKT_REQ_DETAIL_V l1
59059: , PA_XLA_PROJECT_REF_V l3
59060: , PA_XLA_TASK_REF_V l4
59061: , fnd_lookup_values fvl14

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

60378: ,p_level => C_LEVEL_STATEMENT
60379: ,p_module => l_log_module);
60380:
60381: trace
60382: (p_msg => '# of events in xla_events_gt: '
60383: ||xla_context_pkg.get_event_count_context
60384: ,p_level => C_LEVEL_STATEMENT
60385: ,p_module => l_log_module);
60386: