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_DTL_V

Line 5975: WHEN 1 THEN 'FV_BE_RPR_DTL_V'

5971: FROM (
5972: SELECT xet.event_id event_id
5973: , l1.line_number line_number
5974: , CASE r
5975: WHEN 1 THEN 'FV_BE_RPR_DTL_V'
5976: WHEN 2 THEN 'FV_BE_RPR_DTL_V'
5977: WHEN 3 THEN 'FV_BE_RPR_DTL_V'
5978: WHEN 4 THEN 'FV_BE_RPR_DTL_V'
5979: WHEN 5 THEN 'FV_BE_RPR_DTL_V'

Line 5976: WHEN 2 THEN 'FV_BE_RPR_DTL_V'

5972: SELECT xet.event_id event_id
5973: , l1.line_number line_number
5974: , CASE r
5975: WHEN 1 THEN 'FV_BE_RPR_DTL_V'
5976: WHEN 2 THEN 'FV_BE_RPR_DTL_V'
5977: WHEN 3 THEN 'FV_BE_RPR_DTL_V'
5978: WHEN 4 THEN 'FV_BE_RPR_DTL_V'
5979: WHEN 5 THEN 'FV_BE_RPR_DTL_V'
5980: WHEN 6 THEN 'FV_BE_RPR_DTL_V'

Line 5977: WHEN 3 THEN 'FV_BE_RPR_DTL_V'

5973: , l1.line_number line_number
5974: , CASE r
5975: WHEN 1 THEN 'FV_BE_RPR_DTL_V'
5976: WHEN 2 THEN 'FV_BE_RPR_DTL_V'
5977: WHEN 3 THEN 'FV_BE_RPR_DTL_V'
5978: WHEN 4 THEN 'FV_BE_RPR_DTL_V'
5979: WHEN 5 THEN 'FV_BE_RPR_DTL_V'
5980: WHEN 6 THEN 'FV_BE_RPR_DTL_V'
5981: WHEN 7 THEN 'FV_BE_RPR_DTL_V'

Line 5978: WHEN 4 THEN 'FV_BE_RPR_DTL_V'

5974: , CASE r
5975: WHEN 1 THEN 'FV_BE_RPR_DTL_V'
5976: WHEN 2 THEN 'FV_BE_RPR_DTL_V'
5977: WHEN 3 THEN 'FV_BE_RPR_DTL_V'
5978: WHEN 4 THEN 'FV_BE_RPR_DTL_V'
5979: WHEN 5 THEN 'FV_BE_RPR_DTL_V'
5980: WHEN 6 THEN 'FV_BE_RPR_DTL_V'
5981: WHEN 7 THEN 'FV_BE_RPR_DTL_V'
5982:

Line 5979: WHEN 5 THEN 'FV_BE_RPR_DTL_V'

5975: WHEN 1 THEN 'FV_BE_RPR_DTL_V'
5976: WHEN 2 THEN 'FV_BE_RPR_DTL_V'
5977: WHEN 3 THEN 'FV_BE_RPR_DTL_V'
5978: WHEN 4 THEN 'FV_BE_RPR_DTL_V'
5979: WHEN 5 THEN 'FV_BE_RPR_DTL_V'
5980: WHEN 6 THEN 'FV_BE_RPR_DTL_V'
5981: WHEN 7 THEN 'FV_BE_RPR_DTL_V'
5982:
5983: ELSE null

Line 5980: WHEN 6 THEN 'FV_BE_RPR_DTL_V'

5976: WHEN 2 THEN 'FV_BE_RPR_DTL_V'
5977: WHEN 3 THEN 'FV_BE_RPR_DTL_V'
5978: WHEN 4 THEN 'FV_BE_RPR_DTL_V'
5979: WHEN 5 THEN 'FV_BE_RPR_DTL_V'
5980: WHEN 6 THEN 'FV_BE_RPR_DTL_V'
5981: WHEN 7 THEN 'FV_BE_RPR_DTL_V'
5982:
5983: ELSE null
5984: END object_name

Line 5981: WHEN 7 THEN 'FV_BE_RPR_DTL_V'

5977: WHEN 3 THEN 'FV_BE_RPR_DTL_V'
5978: WHEN 4 THEN 'FV_BE_RPR_DTL_V'
5979: WHEN 5 THEN 'FV_BE_RPR_DTL_V'
5980: WHEN 6 THEN 'FV_BE_RPR_DTL_V'
5981: WHEN 7 THEN 'FV_BE_RPR_DTL_V'
5982:
5983: ELSE null
5984: END object_name
5985: , CASE r

Line 6032: , FV_BE_RPR_DTL_V l1

6028: ELSE null
6029: END source_value
6030: , null source_meaning
6031: FROM xla_events_gt xet
6032: , FV_BE_RPR_DTL_V l1
6033: , (select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
6034: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
6035: AND xet.event_class_code = C_EVENT_CLASS_CODE
6036: AND l1.event_id = xet.event_id

Line 6175: TYPE t_array_source_3 IS TABLE OF FV_BE_RPR_DTL_V.CR_ACCOUNT_SEGMENT_VALUE%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;
6178: TYPE t_array_source_7 IS TABLE OF FV_BE_RPR_DTL_V.DISTRIBUTION_TO_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
6179: TYPE t_array_source_12 IS TABLE OF FV_BE_RPR_DTL_V.TRANSACTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 6176: TYPE t_array_source_4 IS TABLE OF FV_BE_RPR_DTL_V.DR_ACCOUNT_SEGMENT_VALUE%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;
6178: TYPE t_array_source_7 IS TABLE OF FV_BE_RPR_DTL_V.DISTRIBUTION_TO_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
6179: TYPE t_array_source_12 IS TABLE OF FV_BE_RPR_DTL_V.TRANSACTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
6180: TYPE t_array_source_13 IS TABLE OF FV_BE_RPR_DTL_V.TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 6177: TYPE t_array_source_6 IS TABLE OF FV_BE_RPR_DTL_V.DISTRIBUTION_FROM_ACCOUNT%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;
6178: TYPE t_array_source_7 IS TABLE OF FV_BE_RPR_DTL_V.DISTRIBUTION_TO_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
6179: TYPE t_array_source_12 IS TABLE OF FV_BE_RPR_DTL_V.TRANSACTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
6180: TYPE t_array_source_13 IS TABLE OF FV_BE_RPR_DTL_V.TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
6181: TYPE t_array_source_14 IS TABLE OF FV_BE_RPR_DTL_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 6178: TYPE t_array_source_7 IS TABLE OF FV_BE_RPR_DTL_V.DISTRIBUTION_TO_ACCOUNT%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;
6178: TYPE t_array_source_7 IS TABLE OF FV_BE_RPR_DTL_V.DISTRIBUTION_TO_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
6179: TYPE t_array_source_12 IS TABLE OF FV_BE_RPR_DTL_V.TRANSACTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
6180: TYPE t_array_source_13 IS TABLE OF FV_BE_RPR_DTL_V.TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
6181: TYPE t_array_source_14 IS TABLE OF FV_BE_RPR_DTL_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
6182:

Line 6179: TYPE t_array_source_12 IS TABLE OF FV_BE_RPR_DTL_V.TRANSACTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

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;
6178: TYPE t_array_source_7 IS TABLE OF FV_BE_RPR_DTL_V.DISTRIBUTION_TO_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
6179: TYPE t_array_source_12 IS TABLE OF FV_BE_RPR_DTL_V.TRANSACTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
6180: TYPE t_array_source_13 IS TABLE OF FV_BE_RPR_DTL_V.TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
6181: TYPE t_array_source_14 IS TABLE OF FV_BE_RPR_DTL_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
6182:
6183: l_array_source_1 t_array_source_1;

Line 6180: TYPE t_array_source_13 IS TABLE OF FV_BE_RPR_DTL_V.TRANSACTION_TYPE_ID%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;
6178: TYPE t_array_source_7 IS TABLE OF FV_BE_RPR_DTL_V.DISTRIBUTION_TO_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
6179: TYPE t_array_source_12 IS TABLE OF FV_BE_RPR_DTL_V.TRANSACTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
6180: TYPE t_array_source_13 IS TABLE OF FV_BE_RPR_DTL_V.TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
6181: TYPE t_array_source_14 IS TABLE OF FV_BE_RPR_DTL_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
6182:
6183: l_array_source_1 t_array_source_1;
6184: l_array_source_2 t_array_source_2;

Line 6181: TYPE t_array_source_14 IS TABLE OF FV_BE_RPR_DTL_V.ACCOUNTED_AMOUNT%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;
6178: TYPE t_array_source_7 IS TABLE OF FV_BE_RPR_DTL_V.DISTRIBUTION_TO_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
6179: TYPE t_array_source_12 IS TABLE OF FV_BE_RPR_DTL_V.TRANSACTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
6180: TYPE t_array_source_13 IS TABLE OF FV_BE_RPR_DTL_V.TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
6181: TYPE t_array_source_14 IS TABLE OF FV_BE_RPR_DTL_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
6182:
6183: l_array_source_1 t_array_source_1;
6184: l_array_source_2 t_array_source_2;
6185: l_array_source_10 t_array_source_10;

Line 6281: , FV_BE_RPR_DTL_V l1

6277: , l1.TRANSACTION_TYPE source_12
6278: , l1.TRANSACTION_TYPE_ID source_13
6279: , l1.ACCOUNTED_AMOUNT source_14
6280: FROM xla_events_gt xet
6281: , FV_BE_RPR_DTL_V l1
6282: WHERE xet.event_id between x_first_event_id and x_last_event_id
6283: and xet.event_date between p_pad_start_date and p_pad_end_date
6284: and xet.event_class_code = C_EVENT_CLASS_CODE
6285: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id