DBA Data[Home] [Help]

APPS.XLA_08901_AAD_S_000002_BC_PKG dependencies on FV_BE_BA_FD_HDR_V

Line 4686: WHEN 1 THEN 'FV_BE_BA_FD_HDR_V'

4682: FROM (
4683: SELECT xet.event_id event_id
4684: , 0 line_number
4685: , CASE r
4686: WHEN 1 THEN 'FV_BE_BA_FD_HDR_V'
4687: WHEN 2 THEN 'FV_BE_BA_FD_HDR_V'
4688: WHEN 3 THEN 'FV_BE_BA_FD_HDR_V'
4689: WHEN 4 THEN 'FV_BE_BA_FD_HDR_V'
4690: WHEN 5 THEN 'FV_BE_BA_FD_HDR_V'

Line 4687: WHEN 2 THEN 'FV_BE_BA_FD_HDR_V'

4683: SELECT xet.event_id event_id
4684: , 0 line_number
4685: , CASE r
4686: WHEN 1 THEN 'FV_BE_BA_FD_HDR_V'
4687: WHEN 2 THEN 'FV_BE_BA_FD_HDR_V'
4688: WHEN 3 THEN 'FV_BE_BA_FD_HDR_V'
4689: WHEN 4 THEN 'FV_BE_BA_FD_HDR_V'
4690: WHEN 5 THEN 'FV_BE_BA_FD_HDR_V'
4691: WHEN 6 THEN 'FV_BE_BA_FD_HDR_V'

Line 4688: WHEN 3 THEN 'FV_BE_BA_FD_HDR_V'

4684: , 0 line_number
4685: , CASE r
4686: WHEN 1 THEN 'FV_BE_BA_FD_HDR_V'
4687: WHEN 2 THEN 'FV_BE_BA_FD_HDR_V'
4688: WHEN 3 THEN 'FV_BE_BA_FD_HDR_V'
4689: WHEN 4 THEN 'FV_BE_BA_FD_HDR_V'
4690: WHEN 5 THEN 'FV_BE_BA_FD_HDR_V'
4691: WHEN 6 THEN 'FV_BE_BA_FD_HDR_V'
4692: WHEN 7 THEN 'FV_BE_BA_FD_HDR_V'

Line 4689: WHEN 4 THEN 'FV_BE_BA_FD_HDR_V'

4685: , CASE r
4686: WHEN 1 THEN 'FV_BE_BA_FD_HDR_V'
4687: WHEN 2 THEN 'FV_BE_BA_FD_HDR_V'
4688: WHEN 3 THEN 'FV_BE_BA_FD_HDR_V'
4689: WHEN 4 THEN 'FV_BE_BA_FD_HDR_V'
4690: WHEN 5 THEN 'FV_BE_BA_FD_HDR_V'
4691: WHEN 6 THEN 'FV_BE_BA_FD_HDR_V'
4692: WHEN 7 THEN 'FV_BE_BA_FD_HDR_V'
4693:

Line 4690: WHEN 5 THEN 'FV_BE_BA_FD_HDR_V'

4686: WHEN 1 THEN 'FV_BE_BA_FD_HDR_V'
4687: WHEN 2 THEN 'FV_BE_BA_FD_HDR_V'
4688: WHEN 3 THEN 'FV_BE_BA_FD_HDR_V'
4689: WHEN 4 THEN 'FV_BE_BA_FD_HDR_V'
4690: WHEN 5 THEN 'FV_BE_BA_FD_HDR_V'
4691: WHEN 6 THEN 'FV_BE_BA_FD_HDR_V'
4692: WHEN 7 THEN 'FV_BE_BA_FD_HDR_V'
4693:
4694: ELSE null

Line 4691: WHEN 6 THEN 'FV_BE_BA_FD_HDR_V'

4687: WHEN 2 THEN 'FV_BE_BA_FD_HDR_V'
4688: WHEN 3 THEN 'FV_BE_BA_FD_HDR_V'
4689: WHEN 4 THEN 'FV_BE_BA_FD_HDR_V'
4690: WHEN 5 THEN 'FV_BE_BA_FD_HDR_V'
4691: WHEN 6 THEN 'FV_BE_BA_FD_HDR_V'
4692: WHEN 7 THEN 'FV_BE_BA_FD_HDR_V'
4693:
4694: ELSE null
4695: END object_name

Line 4692: WHEN 7 THEN 'FV_BE_BA_FD_HDR_V'

4688: WHEN 3 THEN 'FV_BE_BA_FD_HDR_V'
4689: WHEN 4 THEN 'FV_BE_BA_FD_HDR_V'
4690: WHEN 5 THEN 'FV_BE_BA_FD_HDR_V'
4691: WHEN 6 THEN 'FV_BE_BA_FD_HDR_V'
4692: WHEN 7 THEN 'FV_BE_BA_FD_HDR_V'
4693:
4694: ELSE null
4695: END object_name
4696: , CASE r

Line 4743: , FV_BE_BA_FD_HDR_V h2

4739: ELSE null
4740: END source_value
4741: , null source_meaning
4742: FROM xla_events_gt xet
4743: , FV_BE_BA_FD_HDR_V h2
4744: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
4745: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
4746: AND xet.event_class_code = C_EVENT_CLASS_CODE
4747: AND h2.event_id = xet.event_id

Line 5007: TYPE t_array_source_1 IS TABLE OF FV_BE_BA_FD_HDR_V.DOC_NUMBER%TYPE INDEX BY BINARY_INTEGER;

5003: --
5004: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
5005: --
5006:
5007: TYPE t_array_source_1 IS TABLE OF FV_BE_BA_FD_HDR_V.DOC_NUMBER%TYPE INDEX BY BINARY_INTEGER;
5008: TYPE t_array_source_2 IS TABLE OF FV_BE_BA_FD_HDR_V.BUDGET_LEVEL_ID%TYPE INDEX BY BINARY_INTEGER;
5009: TYPE t_array_source_8 IS TABLE OF FV_BE_BA_FD_HDR_V.DISTRIBUTION_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
5010: TYPE t_array_source_10 IS TABLE OF FV_BE_BA_FD_HDR_V.SOURCE%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;

Line 5008: TYPE t_array_source_2 IS TABLE OF FV_BE_BA_FD_HDR_V.BUDGET_LEVEL_ID%TYPE INDEX BY BINARY_INTEGER;

5004: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
5005: --
5006:
5007: TYPE t_array_source_1 IS TABLE OF FV_BE_BA_FD_HDR_V.DOC_NUMBER%TYPE INDEX BY BINARY_INTEGER;
5008: TYPE t_array_source_2 IS TABLE OF FV_BE_BA_FD_HDR_V.BUDGET_LEVEL_ID%TYPE INDEX BY BINARY_INTEGER;
5009: TYPE t_array_source_8 IS TABLE OF FV_BE_BA_FD_HDR_V.DISTRIBUTION_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
5010: TYPE t_array_source_10 IS TABLE OF FV_BE_BA_FD_HDR_V.SOURCE%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;

Line 5009: TYPE t_array_source_8 IS TABLE OF FV_BE_BA_FD_HDR_V.DISTRIBUTION_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

5005: --
5006:
5007: TYPE t_array_source_1 IS TABLE OF FV_BE_BA_FD_HDR_V.DOC_NUMBER%TYPE INDEX BY BINARY_INTEGER;
5008: TYPE t_array_source_2 IS TABLE OF FV_BE_BA_FD_HDR_V.BUDGET_LEVEL_ID%TYPE INDEX BY BINARY_INTEGER;
5009: TYPE t_array_source_8 IS TABLE OF FV_BE_BA_FD_HDR_V.DISTRIBUTION_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
5010: TYPE t_array_source_10 IS TABLE OF FV_BE_BA_FD_HDR_V.SOURCE%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;

Line 5010: TYPE t_array_source_10 IS TABLE OF FV_BE_BA_FD_HDR_V.SOURCE%TYPE INDEX BY BINARY_INTEGER;

5006:
5007: TYPE t_array_source_1 IS TABLE OF FV_BE_BA_FD_HDR_V.DOC_NUMBER%TYPE INDEX BY BINARY_INTEGER;
5008: TYPE t_array_source_2 IS TABLE OF FV_BE_BA_FD_HDR_V.BUDGET_LEVEL_ID%TYPE INDEX BY BINARY_INTEGER;
5009: TYPE t_array_source_8 IS TABLE OF FV_BE_BA_FD_HDR_V.DISTRIBUTION_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
5010: TYPE t_array_source_10 IS TABLE OF FV_BE_BA_FD_HDR_V.SOURCE%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:

Line 5011: TYPE t_array_source_15 IS TABLE OF FV_BE_BA_FD_HDR_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

5007: TYPE t_array_source_1 IS TABLE OF FV_BE_BA_FD_HDR_V.DOC_NUMBER%TYPE INDEX BY BINARY_INTEGER;
5008: TYPE t_array_source_2 IS TABLE OF FV_BE_BA_FD_HDR_V.BUDGET_LEVEL_ID%TYPE INDEX BY BINARY_INTEGER;
5009: TYPE t_array_source_8 IS TABLE OF FV_BE_BA_FD_HDR_V.DISTRIBUTION_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
5010: TYPE t_array_source_10 IS TABLE OF FV_BE_BA_FD_HDR_V.SOURCE%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;

Line 5012: TYPE t_array_source_16 IS TABLE OF FV_BE_BA_FD_HDR_V.DOC_ID%TYPE INDEX BY BINARY_INTEGER;

5008: TYPE t_array_source_2 IS TABLE OF FV_BE_BA_FD_HDR_V.BUDGET_LEVEL_ID%TYPE INDEX BY BINARY_INTEGER;
5009: TYPE t_array_source_8 IS TABLE OF FV_BE_BA_FD_HDR_V.DISTRIBUTION_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
5010: TYPE t_array_source_10 IS TABLE OF FV_BE_BA_FD_HDR_V.SOURCE%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;

Line 5013: TYPE t_array_source_17 IS TABLE OF FV_BE_BA_FD_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

5009: TYPE t_array_source_8 IS TABLE OF FV_BE_BA_FD_HDR_V.DISTRIBUTION_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
5010: TYPE t_array_source_10 IS TABLE OF FV_BE_BA_FD_HDR_V.SOURCE%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;

Line 5076: , FV_BE_BA_FD_HDR_V h2

5072: , h2.CURRENCY_CODE source_15
5073: , h2.DOC_ID source_16
5074: , h2.GL_DATE source_17
5075: FROM xla_events_gt xet
5076: , FV_BE_BA_FD_HDR_V h2
5077: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
5078: and xet.event_class_code = C_EVENT_CLASS_CODE
5079: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
5080: