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_00200_AAD_S_000006_BC_PKG dependencies on PA_XLA_PROJECT_REF_V

Line 73898: WHEN 2 THEN 'PA_XLA_PROJECT_REF_V'

73894: SELECT xet.event_id event_id
73895: , l1.line_number line_number
73896: , CASE r
73897: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
73898: WHEN 2 THEN 'PA_XLA_PROJECT_REF_V'
73899: WHEN 3 THEN 'PA_XLA_TASK_REF_V'
73900: WHEN 4 THEN 'PA_XLA_EXP_ORG_REF_V'
73901: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
73902: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'

Line 73910: WHEN 14 THEN 'PA_XLA_PROJECT_REF_V'

73906: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
73907: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
73908: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
73909: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
73910: WHEN 14 THEN 'PA_XLA_PROJECT_REF_V'
73911: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
73912: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
73913: WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
73914: WHEN 18 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'

Line 74186: , PA_XLA_PROJECT_REF_V l3

74182: END source_meaning
74183: FROM xla_events_gt xet
74184: , PA_XLA_BC_PKT_AP_DETAIL_V l1
74185: , PA_XLA_EXP_ORG_REF_V l2
74186: , PA_XLA_PROJECT_REF_V l3
74187: , PA_XLA_TASK_REF_V l4
74188: , fnd_lookup_values fvl108
74189: , (select rownum r from all_objects where rownum <= 51 and owner = p_apps_owner)
74190: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

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

74328: --
74329:
74330:
74331: TYPE t_array_source_2 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DOCUMENT_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74332: TYPE t_array_source_3 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_NAME%TYPE INDEX BY BINARY_INTEGER;
74333: TYPE t_array_source_4 IS TABLE OF PA_XLA_TASK_REF_V.TASK_NUMBER%TYPE INDEX BY BINARY_INTEGER;
74334: TYPE t_array_source_5 IS TABLE OF PA_XLA_EXP_ORG_REF_V.EXPENDITURE_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
74335: TYPE t_array_source_14 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
74336: TYPE t_array_source_21 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 74344: TYPE t_array_source_84 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJ_BURDEN_DISPLAY_METHOD%TYPE INDEX BY BINARY_INTEGER;

74340: TYPE t_array_source_40 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
74341: TYPE t_array_source_41 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74342: TYPE t_array_source_57 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
74343: TYPE t_array_source_83 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
74344: TYPE t_array_source_84 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJ_BURDEN_DISPLAY_METHOD%TYPE INDEX BY BINARY_INTEGER;
74345: TYPE t_array_source_85 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
74346: TYPE t_array_source_86 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ALLOC_TO_APPLN_ID%TYPE INDEX BY BINARY_INTEGER;
74347: TYPE t_array_source_87 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ALLOC_TO_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
74348: TYPE t_array_source_88 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ALLOC_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 74559: , PA_XLA_PROJECT_REF_V l3

74555: , l1.PO_SECOND_DIST_ID source_121
74556: FROM xla_events_gt xet
74557: , PA_XLA_BC_PKT_AP_DETAIL_V l1
74558: , PA_XLA_EXP_ORG_REF_V l2
74559: , PA_XLA_PROJECT_REF_V l3
74560: , PA_XLA_TASK_REF_V l4
74561: , fnd_lookup_values fvl108
74562: WHERE xet.event_id between x_first_event_id and x_last_event_id
74563: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 80228: WHEN 2 THEN 'PA_XLA_PROJECT_REF_V'

80224: SELECT xet.event_id event_id
80225: , l1.line_number line_number
80226: , CASE r
80227: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
80228: WHEN 2 THEN 'PA_XLA_PROJECT_REF_V'
80229: WHEN 3 THEN 'PA_XLA_TASK_REF_V'
80230: WHEN 4 THEN 'PA_XLA_EXP_ORG_REF_V'
80231: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
80232: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'

Line 80241: WHEN 15 THEN 'PA_XLA_PROJECT_REF_V'

80237: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
80238: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
80239: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
80240: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
80241: WHEN 15 THEN 'PA_XLA_PROJECT_REF_V'
80242: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
80243: WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
80244: WHEN 18 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
80245: WHEN 19 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'

Line 80486: , PA_XLA_PROJECT_REF_V l3

80482: END source_meaning
80483: FROM xla_events_gt xet
80484: , PA_XLA_BC_PKT_AP_DETAIL_V l1
80485: , PA_XLA_EXP_ORG_REF_V l2
80486: , PA_XLA_PROJECT_REF_V l3
80487: , PA_XLA_TASK_REF_V l4
80488: , fnd_lookup_values fvl108
80489: , (select rownum r from all_objects where rownum <= 45 and owner = p_apps_owner)
80490: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

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

80628: --
80629:
80630:
80631: TYPE t_array_source_2 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DOCUMENT_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
80632: TYPE t_array_source_3 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_NAME%TYPE INDEX BY BINARY_INTEGER;
80633: TYPE t_array_source_4 IS TABLE OF PA_XLA_TASK_REF_V.TASK_NUMBER%TYPE INDEX BY BINARY_INTEGER;
80634: TYPE t_array_source_5 IS TABLE OF PA_XLA_EXP_ORG_REF_V.EXPENDITURE_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
80635: TYPE t_array_source_11 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
80636: TYPE t_array_source_14 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 80645: TYPE t_array_source_84 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJ_BURDEN_DISPLAY_METHOD%TYPE INDEX BY BINARY_INTEGER;

80641: TYPE t_array_source_40 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.INV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
80642: TYPE t_array_source_41 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.INV_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
80643: TYPE t_array_source_57 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
80644: TYPE t_array_source_83 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
80645: TYPE t_array_source_84 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJ_BURDEN_DISPLAY_METHOD%TYPE INDEX BY BINARY_INTEGER;
80646: TYPE t_array_source_85 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
80647: TYPE t_array_source_86 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ALLOC_TO_APPLN_ID%TYPE INDEX BY BINARY_INTEGER;
80648: TYPE t_array_source_87 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ALLOC_TO_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
80649: TYPE t_array_source_88 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ALLOC_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 80841: , PA_XLA_PROJECT_REF_V l3

80837: , l1.PA_SECOND_DIST_ID source_114
80838: FROM xla_events_gt xet
80839: , PA_XLA_BC_PKT_AP_DETAIL_V l1
80840: , PA_XLA_EXP_ORG_REF_V l2
80841: , PA_XLA_PROJECT_REF_V l3
80842: , PA_XLA_TASK_REF_V l4
80843: , fnd_lookup_values fvl108
80844: WHERE xet.event_id between x_first_event_id and x_last_event_id
80845: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 81893: WHEN 2 THEN 'PA_XLA_PROJECT_REF_V'

81889: SELECT xet.event_id event_id
81890: , l1.line_number line_number
81891: , CASE r
81892: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
81893: WHEN 2 THEN 'PA_XLA_PROJECT_REF_V'
81894: WHEN 3 THEN 'PA_XLA_TASK_REF_V'
81895: WHEN 4 THEN 'PA_XLA_EXP_ORG_REF_V'
81896: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
81897: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'

Line 81903: WHEN 12 THEN 'PA_XLA_PROJECT_REF_V'

81899: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
81900: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
81901: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
81902: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
81903: WHEN 12 THEN 'PA_XLA_PROJECT_REF_V'
81904: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
81905: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
81906: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
81907: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'

Line 82136: , PA_XLA_PROJECT_REF_V l3

82132: END source_meaning
82133: FROM xla_events_gt xet
82134: , PA_XLA_BC_PKT_AP_DETAIL_V l1
82135: , PA_XLA_EXP_ORG_REF_V l2
82136: , PA_XLA_PROJECT_REF_V l3
82137: , PA_XLA_TASK_REF_V l4
82138: , fnd_lookup_values fvl108
82139: , (select rownum r from all_objects where rownum <= 42 and owner = p_apps_owner)
82140: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

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

82278: --
82279:
82280:
82281: TYPE t_array_source_2 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DOCUMENT_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
82282: TYPE t_array_source_3 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_NAME%TYPE INDEX BY BINARY_INTEGER;
82283: TYPE t_array_source_4 IS TABLE OF PA_XLA_TASK_REF_V.TASK_NUMBER%TYPE INDEX BY BINARY_INTEGER;
82284: TYPE t_array_source_5 IS TABLE OF PA_XLA_EXP_ORG_REF_V.EXPENDITURE_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
82285: TYPE t_array_source_11 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
82286: TYPE t_array_source_14 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 82292: TYPE t_array_source_84 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJ_BURDEN_DISPLAY_METHOD%TYPE INDEX BY BINARY_INTEGER;

82288: TYPE t_array_source_30 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
82289: TYPE t_array_source_33 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
82290: TYPE t_array_source_57 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
82291: TYPE t_array_source_83 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
82292: TYPE t_array_source_84 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJ_BURDEN_DISPLAY_METHOD%TYPE INDEX BY BINARY_INTEGER;
82293: TYPE t_array_source_85 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
82294: TYPE t_array_source_86 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ALLOC_TO_APPLN_ID%TYPE INDEX BY BINARY_INTEGER;
82295: TYPE t_array_source_87 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ALLOC_TO_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
82296: TYPE t_array_source_88 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ALLOC_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 82482: , PA_XLA_PROJECT_REF_V l3

82478: , l1.PA_SECOND_DIST_ID source_114
82479: FROM xla_events_gt xet
82480: , PA_XLA_BC_PKT_AP_DETAIL_V l1
82481: , PA_XLA_EXP_ORG_REF_V l2
82482: , PA_XLA_PROJECT_REF_V l3
82483: , PA_XLA_TASK_REF_V l4
82484: , fnd_lookup_values fvl108
82485: WHERE xet.event_id between x_first_event_id and x_last_event_id
82486: and xet.event_date between p_pad_start_date and p_pad_end_date