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_08901_AAD_S_000002_BC_PKG dependencies on FV_BE_RPR_HDR_V

Line 5852: WHEN 1 THEN 'FV_BE_RPR_HDR_V'

5848: FROM (
5849: SELECT xet.event_id event_id
5850: , 0 line_number
5851: , CASE r
5852: WHEN 1 THEN 'FV_BE_RPR_HDR_V'
5853: WHEN 2 THEN 'FV_BE_RPR_HDR_V'
5854: WHEN 3 THEN 'FV_BE_RPR_HDR_V'
5855: WHEN 4 THEN 'FV_BE_RPR_HDR_V'
5856: WHEN 5 THEN 'FV_BE_RPR_HDR_V'

Line 5853: WHEN 2 THEN 'FV_BE_RPR_HDR_V'

5849: SELECT xet.event_id event_id
5850: , 0 line_number
5851: , CASE r
5852: WHEN 1 THEN 'FV_BE_RPR_HDR_V'
5853: WHEN 2 THEN 'FV_BE_RPR_HDR_V'
5854: WHEN 3 THEN 'FV_BE_RPR_HDR_V'
5855: WHEN 4 THEN 'FV_BE_RPR_HDR_V'
5856: WHEN 5 THEN 'FV_BE_RPR_HDR_V'
5857: WHEN 6 THEN 'FV_BE_RPR_HDR_V'

Line 5854: WHEN 3 THEN 'FV_BE_RPR_HDR_V'

5850: , 0 line_number
5851: , CASE r
5852: WHEN 1 THEN 'FV_BE_RPR_HDR_V'
5853: WHEN 2 THEN 'FV_BE_RPR_HDR_V'
5854: WHEN 3 THEN 'FV_BE_RPR_HDR_V'
5855: WHEN 4 THEN 'FV_BE_RPR_HDR_V'
5856: WHEN 5 THEN 'FV_BE_RPR_HDR_V'
5857: WHEN 6 THEN 'FV_BE_RPR_HDR_V'
5858:

Line 5855: WHEN 4 THEN 'FV_BE_RPR_HDR_V'

5851: , CASE r
5852: WHEN 1 THEN 'FV_BE_RPR_HDR_V'
5853: WHEN 2 THEN 'FV_BE_RPR_HDR_V'
5854: WHEN 3 THEN 'FV_BE_RPR_HDR_V'
5855: WHEN 4 THEN 'FV_BE_RPR_HDR_V'
5856: WHEN 5 THEN 'FV_BE_RPR_HDR_V'
5857: WHEN 6 THEN 'FV_BE_RPR_HDR_V'
5858:
5859: ELSE null

Line 5856: WHEN 5 THEN 'FV_BE_RPR_HDR_V'

5852: WHEN 1 THEN 'FV_BE_RPR_HDR_V'
5853: WHEN 2 THEN 'FV_BE_RPR_HDR_V'
5854: WHEN 3 THEN 'FV_BE_RPR_HDR_V'
5855: WHEN 4 THEN 'FV_BE_RPR_HDR_V'
5856: WHEN 5 THEN 'FV_BE_RPR_HDR_V'
5857: WHEN 6 THEN 'FV_BE_RPR_HDR_V'
5858:
5859: ELSE null
5860: END object_name

Line 5857: WHEN 6 THEN 'FV_BE_RPR_HDR_V'

5853: WHEN 2 THEN 'FV_BE_RPR_HDR_V'
5854: WHEN 3 THEN 'FV_BE_RPR_HDR_V'
5855: WHEN 4 THEN 'FV_BE_RPR_HDR_V'
5856: WHEN 5 THEN 'FV_BE_RPR_HDR_V'
5857: WHEN 6 THEN 'FV_BE_RPR_HDR_V'
5858:
5859: ELSE null
5860: END object_name
5861: , CASE r

Line 5904: , FV_BE_RPR_HDR_V h2

5900: ELSE null
5901: END source_value
5902: , null source_meaning
5903: FROM xla_events_gt xet
5904: , FV_BE_RPR_HDR_V h2
5905: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
5906: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
5907: AND xet.event_class_code = C_EVENT_CLASS_CODE
5908: AND h2.event_id = xet.event_id

Line 6168: TYPE t_array_source_1 IS TABLE OF FV_BE_RPR_HDR_V.DOC_NUMBER%TYPE INDEX BY BINARY_INTEGER;

6164: --
6165: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
6166: --
6167:
6168: TYPE t_array_source_1 IS TABLE OF FV_BE_RPR_HDR_V.DOC_NUMBER%TYPE INDEX BY BINARY_INTEGER;
6169: TYPE t_array_source_2 IS TABLE OF FV_BE_RPR_HDR_V.BUDGET_LEVEL_ID%TYPE INDEX BY BINARY_INTEGER;
6170: TYPE t_array_source_10 IS TABLE OF FV_BE_RPR_HDR_V.SOURCE%TYPE INDEX BY BINARY_INTEGER;
6171: TYPE t_array_source_11 IS TABLE OF FV_BE_RPR_HDR_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
6172: TYPE t_array_source_15 IS TABLE OF FV_BE_RPR_HDR_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 6169: TYPE t_array_source_2 IS TABLE OF FV_BE_RPR_HDR_V.BUDGET_LEVEL_ID%TYPE INDEX BY BINARY_INTEGER;

6165: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
6166: --
6167:
6168: TYPE t_array_source_1 IS TABLE OF FV_BE_RPR_HDR_V.DOC_NUMBER%TYPE INDEX BY BINARY_INTEGER;
6169: TYPE t_array_source_2 IS TABLE OF FV_BE_RPR_HDR_V.BUDGET_LEVEL_ID%TYPE INDEX BY BINARY_INTEGER;
6170: TYPE t_array_source_10 IS TABLE OF FV_BE_RPR_HDR_V.SOURCE%TYPE INDEX BY BINARY_INTEGER;
6171: TYPE t_array_source_11 IS TABLE OF FV_BE_RPR_HDR_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
6172: TYPE t_array_source_15 IS TABLE OF FV_BE_RPR_HDR_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
6173: TYPE t_array_source_17 IS TABLE OF FV_BE_RPR_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 6170: TYPE t_array_source_10 IS TABLE OF FV_BE_RPR_HDR_V.SOURCE%TYPE INDEX BY BINARY_INTEGER;

6166: --
6167:
6168: TYPE t_array_source_1 IS TABLE OF FV_BE_RPR_HDR_V.DOC_NUMBER%TYPE INDEX BY BINARY_INTEGER;
6169: TYPE t_array_source_2 IS TABLE OF FV_BE_RPR_HDR_V.BUDGET_LEVEL_ID%TYPE INDEX BY BINARY_INTEGER;
6170: TYPE t_array_source_10 IS TABLE OF FV_BE_RPR_HDR_V.SOURCE%TYPE INDEX BY BINARY_INTEGER;
6171: TYPE t_array_source_11 IS TABLE OF FV_BE_RPR_HDR_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
6172: TYPE t_array_source_15 IS TABLE OF FV_BE_RPR_HDR_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
6173: TYPE t_array_source_17 IS TABLE OF FV_BE_RPR_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
6174:

Line 6171: TYPE t_array_source_11 IS TABLE OF FV_BE_RPR_HDR_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;

6167:
6168: TYPE t_array_source_1 IS TABLE OF FV_BE_RPR_HDR_V.DOC_NUMBER%TYPE INDEX BY BINARY_INTEGER;
6169: TYPE t_array_source_2 IS TABLE OF FV_BE_RPR_HDR_V.BUDGET_LEVEL_ID%TYPE INDEX BY BINARY_INTEGER;
6170: TYPE t_array_source_10 IS TABLE OF FV_BE_RPR_HDR_V.SOURCE%TYPE INDEX BY BINARY_INTEGER;
6171: TYPE t_array_source_11 IS TABLE OF FV_BE_RPR_HDR_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
6172: TYPE t_array_source_15 IS TABLE OF FV_BE_RPR_HDR_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
6173: TYPE t_array_source_17 IS TABLE OF FV_BE_RPR_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
6174:
6175: TYPE t_array_source_3 IS TABLE OF FV_BE_RPR_DTL_V.CR_ACCOUNT_SEGMENT_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 6172: TYPE t_array_source_15 IS TABLE OF FV_BE_RPR_HDR_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

6168: TYPE t_array_source_1 IS TABLE OF FV_BE_RPR_HDR_V.DOC_NUMBER%TYPE INDEX BY BINARY_INTEGER;
6169: TYPE t_array_source_2 IS TABLE OF FV_BE_RPR_HDR_V.BUDGET_LEVEL_ID%TYPE INDEX BY BINARY_INTEGER;
6170: TYPE t_array_source_10 IS TABLE OF FV_BE_RPR_HDR_V.SOURCE%TYPE INDEX BY BINARY_INTEGER;
6171: TYPE t_array_source_11 IS TABLE OF FV_BE_RPR_HDR_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
6172: TYPE t_array_source_15 IS TABLE OF FV_BE_RPR_HDR_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
6173: TYPE t_array_source_17 IS TABLE OF FV_BE_RPR_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
6174:
6175: TYPE t_array_source_3 IS TABLE OF FV_BE_RPR_DTL_V.CR_ACCOUNT_SEGMENT_VALUE%TYPE INDEX BY BINARY_INTEGER;
6176: TYPE t_array_source_4 IS TABLE OF FV_BE_RPR_DTL_V.DR_ACCOUNT_SEGMENT_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 6173: TYPE t_array_source_17 IS TABLE OF FV_BE_RPR_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

6169: TYPE t_array_source_2 IS TABLE OF FV_BE_RPR_HDR_V.BUDGET_LEVEL_ID%TYPE INDEX BY BINARY_INTEGER;
6170: TYPE t_array_source_10 IS TABLE OF FV_BE_RPR_HDR_V.SOURCE%TYPE INDEX BY BINARY_INTEGER;
6171: TYPE t_array_source_11 IS TABLE OF FV_BE_RPR_HDR_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
6172: TYPE t_array_source_15 IS TABLE OF FV_BE_RPR_HDR_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
6173: TYPE t_array_source_17 IS TABLE OF FV_BE_RPR_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
6174:
6175: TYPE t_array_source_3 IS TABLE OF FV_BE_RPR_DTL_V.CR_ACCOUNT_SEGMENT_VALUE%TYPE INDEX BY BINARY_INTEGER;
6176: TYPE t_array_source_4 IS TABLE OF FV_BE_RPR_DTL_V.DR_ACCOUNT_SEGMENT_VALUE%TYPE INDEX BY BINARY_INTEGER;
6177: TYPE t_array_source_6 IS TABLE OF FV_BE_RPR_DTL_V.DISTRIBUTION_FROM_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 6234: , FV_BE_RPR_HDR_V h2

6230: , h2.TRANSACTION_ID source_11
6231: , h2.CURRENCY_CODE source_15
6232: , h2.GL_DATE source_17
6233: FROM xla_events_gt xet
6234: , FV_BE_RPR_HDR_V h2
6235: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
6236: and xet.event_class_code = C_EVENT_CLASS_CODE
6237: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
6238: