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 PA_XLA_PROJECT_REF_V

Line 48573: WHEN 1 THEN 'PA_XLA_PROJECT_REF_V'

48569: FROM (
48570: SELECT xet.event_id event_id
48571: , l1.line_number line_number
48572: , CASE r
48573: WHEN 1 THEN 'PA_XLA_PROJECT_REF_V'
48574: WHEN 2 THEN 'PA_XLA_TASK_REF_V'
48575: WHEN 3 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
48576: WHEN 4 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
48577: WHEN 5 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'

Line 48581: WHEN 9 THEN 'PA_XLA_PROJECT_REF_V'

48577: WHEN 5 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
48578: WHEN 6 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
48579: WHEN 7 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
48580: WHEN 8 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
48581: WHEN 9 THEN 'PA_XLA_PROJECT_REF_V'
48582: WHEN 10 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
48583: WHEN 11 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
48584: WHEN 12 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
48585: WHEN 13 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'

Line 48836: , PA_XLA_PROJECT_REF_V l3

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
48839: , (select rownum r from all_objects where rownum <= 46 and owner = p_apps_owner)
48840: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 48980: TYPE t_array_source_3 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_NAME%TYPE INDEX BY BINARY_INTEGER;

48976: --
48977:
48978: TYPE t_array_source_79 IS TABLE OF PA_XLA_BC_PKT_PO_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
48979:
48980: TYPE t_array_source_3 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_NAME%TYPE INDEX BY BINARY_INTEGER;
48981: TYPE t_array_source_4 IS TABLE OF PA_XLA_TASK_REF_V.TASK_NAME%TYPE INDEX BY BINARY_INTEGER;
48982: TYPE t_array_source_5 IS TABLE OF PA_XLA_BC_PKT_PO_DETAIL_V.EXPENDITURE_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
48983: TYPE t_array_source_6 IS TABLE OF PA_XLA_BC_PKT_PO_DETAIL_V.EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
48984: TYPE t_array_source_9 IS TABLE OF PA_XLA_BC_PKT_PO_DETAIL_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 48988: TYPE t_array_source_15 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJ_BURDEN_DISPLAY_METHOD%TYPE INDEX BY BINARY_INTEGER;

48984: TYPE t_array_source_9 IS TABLE OF PA_XLA_BC_PKT_PO_DETAIL_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
48985: TYPE t_array_source_11 IS TABLE OF PA_XLA_BC_PKT_PO_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
48986: TYPE t_array_source_13 IS TABLE OF PA_XLA_BC_PKT_PO_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
48987: TYPE t_array_source_14 IS TABLE OF PA_XLA_BC_PKT_PO_DETAIL_V.BURDEN_COST_FLAG%TYPE INDEX BY BINARY_INTEGER;
48988: TYPE t_array_source_15 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJ_BURDEN_DISPLAY_METHOD%TYPE INDEX BY BINARY_INTEGER;
48989: TYPE t_array_source_16 IS TABLE OF PA_XLA_BC_PKT_PO_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
48990: TYPE t_array_source_17 IS TABLE OF PA_XLA_BC_PKT_PO_DETAIL_V.ALLOC_TO_APPLN_ID%TYPE INDEX BY BINARY_INTEGER;
48991: TYPE t_array_source_18 IS TABLE OF PA_XLA_BC_PKT_PO_DETAIL_V.ALLOC_TO_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
48992: TYPE t_array_source_19 IS TABLE OF PA_XLA_BC_PKT_PO_DETAIL_V.ALLOC_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 49196: , PA_XLA_PROJECT_REF_V l3

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
49199: WHERE xet.event_id between x_first_event_id and x_last_event_id
49200: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 54517: WHEN 1 THEN 'PA_XLA_PROJECT_REF_V'

54513: FROM (
54514: SELECT xet.event_id event_id
54515: , l1.line_number line_number
54516: , CASE r
54517: WHEN 1 THEN 'PA_XLA_PROJECT_REF_V'
54518: WHEN 2 THEN 'PA_XLA_TASK_REF_V'
54519: WHEN 3 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
54520: WHEN 4 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
54521: WHEN 5 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'

Line 54525: WHEN 9 THEN 'PA_XLA_PROJECT_REF_V'

54521: WHEN 5 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
54522: WHEN 6 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
54523: WHEN 7 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
54524: WHEN 8 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
54525: WHEN 9 THEN 'PA_XLA_PROJECT_REF_V'
54526: WHEN 10 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
54527: WHEN 11 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
54528: WHEN 12 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
54529: WHEN 13 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'

Line 54780: , PA_XLA_PROJECT_REF_V l3

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
54783: , (select rownum r from all_objects where rownum <= 46 and owner = p_apps_owner)
54784: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 54924: TYPE t_array_source_3 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_NAME%TYPE INDEX BY BINARY_INTEGER;

54920: --
54921:
54922: TYPE t_array_source_79 IS TABLE OF PA_XLA_BC_PKT_PO_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
54923:
54924: TYPE t_array_source_3 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_NAME%TYPE INDEX BY BINARY_INTEGER;
54925: TYPE t_array_source_4 IS TABLE OF PA_XLA_TASK_REF_V.TASK_NAME%TYPE INDEX BY BINARY_INTEGER;
54926: TYPE t_array_source_5 IS TABLE OF PA_XLA_BC_PKT_PO_DETAIL_V.EXPENDITURE_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
54927: TYPE t_array_source_6 IS TABLE OF PA_XLA_BC_PKT_PO_DETAIL_V.EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
54928: TYPE t_array_source_9 IS TABLE OF PA_XLA_BC_PKT_PO_DETAIL_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 54932: TYPE t_array_source_15 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJ_BURDEN_DISPLAY_METHOD%TYPE INDEX BY BINARY_INTEGER;

54928: TYPE t_array_source_9 IS TABLE OF PA_XLA_BC_PKT_PO_DETAIL_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
54929: TYPE t_array_source_11 IS TABLE OF PA_XLA_BC_PKT_PO_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
54930: TYPE t_array_source_13 IS TABLE OF PA_XLA_BC_PKT_PO_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
54931: TYPE t_array_source_14 IS TABLE OF PA_XLA_BC_PKT_PO_DETAIL_V.BURDEN_COST_FLAG%TYPE INDEX BY BINARY_INTEGER;
54932: TYPE t_array_source_15 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJ_BURDEN_DISPLAY_METHOD%TYPE INDEX BY BINARY_INTEGER;
54933: TYPE t_array_source_16 IS TABLE OF PA_XLA_BC_PKT_PO_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
54934: TYPE t_array_source_17 IS TABLE OF PA_XLA_BC_PKT_PO_DETAIL_V.ALLOC_TO_APPLN_ID%TYPE INDEX BY BINARY_INTEGER;
54935: TYPE t_array_source_18 IS TABLE OF PA_XLA_BC_PKT_PO_DETAIL_V.ALLOC_TO_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
54936: TYPE t_array_source_19 IS TABLE OF PA_XLA_BC_PKT_PO_DETAIL_V.ALLOC_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 55140: , PA_XLA_PROJECT_REF_V l3

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
55143: WHERE xet.event_id between x_first_event_id and x_last_event_id
55144: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 58484: WHEN 1 THEN 'PA_XLA_PROJECT_REF_V'

58480: FROM (
58481: SELECT xet.event_id event_id
58482: , l1.line_number line_number
58483: , CASE r
58484: WHEN 1 THEN 'PA_XLA_PROJECT_REF_V'
58485: WHEN 2 THEN 'PA_XLA_TASK_REF_V'
58486: WHEN 3 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
58487: WHEN 4 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
58488: WHEN 5 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'

Line 58491: WHEN 8 THEN 'PA_XLA_PROJECT_REF_V'

58487: WHEN 4 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
58488: WHEN 5 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
58489: WHEN 6 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
58490: WHEN 7 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
58491: WHEN 8 THEN 'PA_XLA_PROJECT_REF_V'
58492: WHEN 9 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
58493: WHEN 10 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
58494: WHEN 11 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
58495: WHEN 12 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'

Line 58717: , PA_XLA_PROJECT_REF_V l3

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
58720: , (select rownum r from all_objects where rownum <= 40 and owner = p_apps_owner)
58721: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 58861: TYPE t_array_source_3 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_NAME%TYPE INDEX BY BINARY_INTEGER;

58857: --
58858:
58859: TYPE t_array_source_79 IS TABLE OF PA_XLA_BC_PKT_REQ_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
58860:
58861: TYPE t_array_source_3 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_NAME%TYPE INDEX BY BINARY_INTEGER;
58862: TYPE t_array_source_4 IS TABLE OF PA_XLA_TASK_REF_V.TASK_NAME%TYPE INDEX BY BINARY_INTEGER;
58863: TYPE t_array_source_5 IS TABLE OF PA_XLA_BC_PKT_REQ_DETAIL_V.EXPENDITURE_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
58864: TYPE t_array_source_6 IS TABLE OF PA_XLA_BC_PKT_REQ_DETAIL_V.EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
58865: TYPE t_array_source_11 IS TABLE OF PA_XLA_BC_PKT_REQ_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 58868: TYPE t_array_source_15 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJ_BURDEN_DISPLAY_METHOD%TYPE INDEX BY BINARY_INTEGER;

58864: TYPE t_array_source_6 IS TABLE OF PA_XLA_BC_PKT_REQ_DETAIL_V.EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
58865: TYPE t_array_source_11 IS TABLE OF PA_XLA_BC_PKT_REQ_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
58866: TYPE t_array_source_13 IS TABLE OF PA_XLA_BC_PKT_REQ_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
58867: TYPE t_array_source_14 IS TABLE OF PA_XLA_BC_PKT_REQ_DETAIL_V.BURDEN_COST_FLAG%TYPE INDEX BY BINARY_INTEGER;
58868: TYPE t_array_source_15 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJ_BURDEN_DISPLAY_METHOD%TYPE INDEX BY BINARY_INTEGER;
58869: TYPE t_array_source_16 IS TABLE OF PA_XLA_BC_PKT_REQ_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
58870: TYPE t_array_source_17 IS TABLE OF PA_XLA_BC_PKT_REQ_DETAIL_V.ALLOC_TO_APPLN_ID%TYPE INDEX BY BINARY_INTEGER;
58871: TYPE t_array_source_18 IS TABLE OF PA_XLA_BC_PKT_REQ_DETAIL_V.ALLOC_TO_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
58872: TYPE t_array_source_19 IS TABLE OF PA_XLA_BC_PKT_REQ_DETAIL_V.ALLOC_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 59059: , PA_XLA_PROJECT_REF_V l3

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
59062: WHERE xet.event_id between x_first_event_id and x_last_event_id
59063: and xet.event_date between p_pad_start_date and p_pad_end_date