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_BA_FD_DTL_V

Line 4814: WHEN 1 THEN 'FV_BE_BA_FD_DTL_V'

4810: FROM (
4811: SELECT xet.event_id event_id
4812: , l1.line_number line_number
4813: , CASE r
4814: WHEN 1 THEN 'FV_BE_BA_FD_DTL_V'
4815: WHEN 2 THEN 'FV_BE_BA_FD_DTL_V'
4816: WHEN 3 THEN 'FV_BE_BA_FD_DTL_V'
4817: WHEN 4 THEN 'FV_BE_BA_FD_DTL_V'
4818: WHEN 5 THEN 'FV_BE_BA_FD_DTL_V'

Line 4815: WHEN 2 THEN 'FV_BE_BA_FD_DTL_V'

4811: SELECT xet.event_id event_id
4812: , l1.line_number line_number
4813: , CASE r
4814: WHEN 1 THEN 'FV_BE_BA_FD_DTL_V'
4815: WHEN 2 THEN 'FV_BE_BA_FD_DTL_V'
4816: WHEN 3 THEN 'FV_BE_BA_FD_DTL_V'
4817: WHEN 4 THEN 'FV_BE_BA_FD_DTL_V'
4818: WHEN 5 THEN 'FV_BE_BA_FD_DTL_V'
4819: WHEN 6 THEN 'FV_BE_BA_FD_DTL_V'

Line 4816: WHEN 3 THEN 'FV_BE_BA_FD_DTL_V'

4812: , l1.line_number line_number
4813: , CASE r
4814: WHEN 1 THEN 'FV_BE_BA_FD_DTL_V'
4815: WHEN 2 THEN 'FV_BE_BA_FD_DTL_V'
4816: WHEN 3 THEN 'FV_BE_BA_FD_DTL_V'
4817: WHEN 4 THEN 'FV_BE_BA_FD_DTL_V'
4818: WHEN 5 THEN 'FV_BE_BA_FD_DTL_V'
4819: WHEN 6 THEN 'FV_BE_BA_FD_DTL_V'
4820: WHEN 7 THEN 'FV_BE_BA_FD_DTL_V'

Line 4817: WHEN 4 THEN 'FV_BE_BA_FD_DTL_V'

4813: , CASE r
4814: WHEN 1 THEN 'FV_BE_BA_FD_DTL_V'
4815: WHEN 2 THEN 'FV_BE_BA_FD_DTL_V'
4816: WHEN 3 THEN 'FV_BE_BA_FD_DTL_V'
4817: WHEN 4 THEN 'FV_BE_BA_FD_DTL_V'
4818: WHEN 5 THEN 'FV_BE_BA_FD_DTL_V'
4819: WHEN 6 THEN 'FV_BE_BA_FD_DTL_V'
4820: WHEN 7 THEN 'FV_BE_BA_FD_DTL_V'
4821:

Line 4818: WHEN 5 THEN 'FV_BE_BA_FD_DTL_V'

4814: WHEN 1 THEN 'FV_BE_BA_FD_DTL_V'
4815: WHEN 2 THEN 'FV_BE_BA_FD_DTL_V'
4816: WHEN 3 THEN 'FV_BE_BA_FD_DTL_V'
4817: WHEN 4 THEN 'FV_BE_BA_FD_DTL_V'
4818: WHEN 5 THEN 'FV_BE_BA_FD_DTL_V'
4819: WHEN 6 THEN 'FV_BE_BA_FD_DTL_V'
4820: WHEN 7 THEN 'FV_BE_BA_FD_DTL_V'
4821:
4822: ELSE null

Line 4819: WHEN 6 THEN 'FV_BE_BA_FD_DTL_V'

4815: WHEN 2 THEN 'FV_BE_BA_FD_DTL_V'
4816: WHEN 3 THEN 'FV_BE_BA_FD_DTL_V'
4817: WHEN 4 THEN 'FV_BE_BA_FD_DTL_V'
4818: WHEN 5 THEN 'FV_BE_BA_FD_DTL_V'
4819: WHEN 6 THEN 'FV_BE_BA_FD_DTL_V'
4820: WHEN 7 THEN 'FV_BE_BA_FD_DTL_V'
4821:
4822: ELSE null
4823: END object_name

Line 4820: WHEN 7 THEN 'FV_BE_BA_FD_DTL_V'

4816: WHEN 3 THEN 'FV_BE_BA_FD_DTL_V'
4817: WHEN 4 THEN 'FV_BE_BA_FD_DTL_V'
4818: WHEN 5 THEN 'FV_BE_BA_FD_DTL_V'
4819: WHEN 6 THEN 'FV_BE_BA_FD_DTL_V'
4820: WHEN 7 THEN 'FV_BE_BA_FD_DTL_V'
4821:
4822: ELSE null
4823: END object_name
4824: , CASE r

Line 4871: , FV_BE_BA_FD_DTL_V l1

4867: ELSE null
4868: END source_value
4869: , null source_meaning
4870: FROM xla_events_gt xet
4871: , FV_BE_BA_FD_DTL_V l1
4872: , (select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
4873: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
4874: AND xet.event_class_code = C_EVENT_CLASS_CODE
4875: AND l1.event_id = xet.event_id

Line 5015: TYPE t_array_source_3 IS TABLE OF FV_BE_BA_FD_DTL_V.CR_ACCOUNT_SEGMENT_VALUE%TYPE INDEX BY BINARY_INTEGER;

5011: TYPE t_array_source_15 IS TABLE OF FV_BE_BA_FD_HDR_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
5012: TYPE t_array_source_16 IS TABLE OF FV_BE_BA_FD_HDR_V.DOC_ID%TYPE INDEX BY BINARY_INTEGER;
5013: TYPE t_array_source_17 IS TABLE OF FV_BE_BA_FD_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
5014:
5015: TYPE t_array_source_3 IS TABLE OF FV_BE_BA_FD_DTL_V.CR_ACCOUNT_SEGMENT_VALUE%TYPE INDEX BY BINARY_INTEGER;
5016: TYPE t_array_source_4 IS TABLE OF FV_BE_BA_FD_DTL_V.DR_ACCOUNT_SEGMENT_VALUE%TYPE INDEX BY BINARY_INTEGER;
5017: TYPE t_array_source_5 IS TABLE OF FV_BE_BA_FD_DTL_V.INCREASE_DECREASE_FLAG%TYPE INDEX BY BINARY_INTEGER;
5018: TYPE t_array_source_9 IS TABLE OF FV_BE_BA_FD_DTL_V.FUND_DISTRIBUTION_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
5019: TYPE t_array_source_12 IS TABLE OF FV_BE_BA_FD_DTL_V.TRANSACTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 5016: TYPE t_array_source_4 IS TABLE OF FV_BE_BA_FD_DTL_V.DR_ACCOUNT_SEGMENT_VALUE%TYPE INDEX BY BINARY_INTEGER;

5012: TYPE t_array_source_16 IS TABLE OF FV_BE_BA_FD_HDR_V.DOC_ID%TYPE INDEX BY BINARY_INTEGER;
5013: TYPE t_array_source_17 IS TABLE OF FV_BE_BA_FD_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
5014:
5015: TYPE t_array_source_3 IS TABLE OF FV_BE_BA_FD_DTL_V.CR_ACCOUNT_SEGMENT_VALUE%TYPE INDEX BY BINARY_INTEGER;
5016: TYPE t_array_source_4 IS TABLE OF FV_BE_BA_FD_DTL_V.DR_ACCOUNT_SEGMENT_VALUE%TYPE INDEX BY BINARY_INTEGER;
5017: TYPE t_array_source_5 IS TABLE OF FV_BE_BA_FD_DTL_V.INCREASE_DECREASE_FLAG%TYPE INDEX BY BINARY_INTEGER;
5018: TYPE t_array_source_9 IS TABLE OF FV_BE_BA_FD_DTL_V.FUND_DISTRIBUTION_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
5019: TYPE t_array_source_12 IS TABLE OF FV_BE_BA_FD_DTL_V.TRANSACTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
5020: TYPE t_array_source_13 IS TABLE OF FV_BE_BA_FD_DTL_V.TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 5017: TYPE t_array_source_5 IS TABLE OF FV_BE_BA_FD_DTL_V.INCREASE_DECREASE_FLAG%TYPE INDEX BY BINARY_INTEGER;

5013: TYPE t_array_source_17 IS TABLE OF FV_BE_BA_FD_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
5014:
5015: TYPE t_array_source_3 IS TABLE OF FV_BE_BA_FD_DTL_V.CR_ACCOUNT_SEGMENT_VALUE%TYPE INDEX BY BINARY_INTEGER;
5016: TYPE t_array_source_4 IS TABLE OF FV_BE_BA_FD_DTL_V.DR_ACCOUNT_SEGMENT_VALUE%TYPE INDEX BY BINARY_INTEGER;
5017: TYPE t_array_source_5 IS TABLE OF FV_BE_BA_FD_DTL_V.INCREASE_DECREASE_FLAG%TYPE INDEX BY BINARY_INTEGER;
5018: TYPE t_array_source_9 IS TABLE OF FV_BE_BA_FD_DTL_V.FUND_DISTRIBUTION_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
5019: TYPE t_array_source_12 IS TABLE OF FV_BE_BA_FD_DTL_V.TRANSACTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
5020: TYPE t_array_source_13 IS TABLE OF FV_BE_BA_FD_DTL_V.TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
5021: TYPE t_array_source_14 IS TABLE OF FV_BE_BA_FD_DTL_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 5018: TYPE t_array_source_9 IS TABLE OF FV_BE_BA_FD_DTL_V.FUND_DISTRIBUTION_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

5014:
5015: TYPE t_array_source_3 IS TABLE OF FV_BE_BA_FD_DTL_V.CR_ACCOUNT_SEGMENT_VALUE%TYPE INDEX BY BINARY_INTEGER;
5016: TYPE t_array_source_4 IS TABLE OF FV_BE_BA_FD_DTL_V.DR_ACCOUNT_SEGMENT_VALUE%TYPE INDEX BY BINARY_INTEGER;
5017: TYPE t_array_source_5 IS TABLE OF FV_BE_BA_FD_DTL_V.INCREASE_DECREASE_FLAG%TYPE INDEX BY BINARY_INTEGER;
5018: TYPE t_array_source_9 IS TABLE OF FV_BE_BA_FD_DTL_V.FUND_DISTRIBUTION_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
5019: TYPE t_array_source_12 IS TABLE OF FV_BE_BA_FD_DTL_V.TRANSACTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
5020: TYPE t_array_source_13 IS TABLE OF FV_BE_BA_FD_DTL_V.TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
5021: TYPE t_array_source_14 IS TABLE OF FV_BE_BA_FD_DTL_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
5022:

Line 5019: TYPE t_array_source_12 IS TABLE OF FV_BE_BA_FD_DTL_V.TRANSACTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

5015: TYPE t_array_source_3 IS TABLE OF FV_BE_BA_FD_DTL_V.CR_ACCOUNT_SEGMENT_VALUE%TYPE INDEX BY BINARY_INTEGER;
5016: TYPE t_array_source_4 IS TABLE OF FV_BE_BA_FD_DTL_V.DR_ACCOUNT_SEGMENT_VALUE%TYPE INDEX BY BINARY_INTEGER;
5017: TYPE t_array_source_5 IS TABLE OF FV_BE_BA_FD_DTL_V.INCREASE_DECREASE_FLAG%TYPE INDEX BY BINARY_INTEGER;
5018: TYPE t_array_source_9 IS TABLE OF FV_BE_BA_FD_DTL_V.FUND_DISTRIBUTION_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
5019: TYPE t_array_source_12 IS TABLE OF FV_BE_BA_FD_DTL_V.TRANSACTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
5020: TYPE t_array_source_13 IS TABLE OF FV_BE_BA_FD_DTL_V.TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
5021: TYPE t_array_source_14 IS TABLE OF FV_BE_BA_FD_DTL_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
5022:
5023: l_array_source_1 t_array_source_1;

Line 5020: TYPE t_array_source_13 IS TABLE OF FV_BE_BA_FD_DTL_V.TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

5016: TYPE t_array_source_4 IS TABLE OF FV_BE_BA_FD_DTL_V.DR_ACCOUNT_SEGMENT_VALUE%TYPE INDEX BY BINARY_INTEGER;
5017: TYPE t_array_source_5 IS TABLE OF FV_BE_BA_FD_DTL_V.INCREASE_DECREASE_FLAG%TYPE INDEX BY BINARY_INTEGER;
5018: TYPE t_array_source_9 IS TABLE OF FV_BE_BA_FD_DTL_V.FUND_DISTRIBUTION_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
5019: TYPE t_array_source_12 IS TABLE OF FV_BE_BA_FD_DTL_V.TRANSACTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
5020: TYPE t_array_source_13 IS TABLE OF FV_BE_BA_FD_DTL_V.TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
5021: TYPE t_array_source_14 IS TABLE OF FV_BE_BA_FD_DTL_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
5022:
5023: l_array_source_1 t_array_source_1;
5024: l_array_source_2 t_array_source_2;

Line 5021: TYPE t_array_source_14 IS TABLE OF FV_BE_BA_FD_DTL_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

5017: TYPE t_array_source_5 IS TABLE OF FV_BE_BA_FD_DTL_V.INCREASE_DECREASE_FLAG%TYPE INDEX BY BINARY_INTEGER;
5018: TYPE t_array_source_9 IS TABLE OF FV_BE_BA_FD_DTL_V.FUND_DISTRIBUTION_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
5019: TYPE t_array_source_12 IS TABLE OF FV_BE_BA_FD_DTL_V.TRANSACTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
5020: TYPE t_array_source_13 IS TABLE OF FV_BE_BA_FD_DTL_V.TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
5021: TYPE t_array_source_14 IS TABLE OF FV_BE_BA_FD_DTL_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
5022:
5023: l_array_source_1 t_array_source_1;
5024: l_array_source_2 t_array_source_2;
5025: l_array_source_8 t_array_source_8;

Line 5123: , FV_BE_BA_FD_DTL_V l1

5119: , l1.TRANSACTION_TYPE source_12
5120: , l1.TRANSACTION_TYPE_ID source_13
5121: , l1.ACCOUNTED_AMOUNT source_14
5122: FROM xla_events_gt xet
5123: , FV_BE_BA_FD_DTL_V l1
5124: WHERE xet.event_id between x_first_event_id and x_last_event_id
5125: and xet.event_date between p_pad_start_date and p_pad_end_date
5126: and xet.event_class_code = C_EVENT_CLASS_CODE
5127: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id