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_09000_AAD_S_000015_PKG dependencies on DPP_XLA_INV_HEADERS_V

Line 6604: WHEN 1 THEN 'DPP_XLA_INV_HEADERS_V'

6600: FROM (
6601: SELECT xet.event_id event_id
6602: , 0 line_number
6603: , CASE r
6604: WHEN 1 THEN 'DPP_XLA_INV_HEADERS_V'
6605: WHEN 2 THEN 'DPP_XLA_INV_HEADERS_V'
6606: WHEN 3 THEN 'DPP_XLA_INV_HEADERS_V'
6607: WHEN 4 THEN 'DPP_XLA_INV_HEADERS_V'
6608: WHEN 5 THEN 'DPP_XLA_INV_HEADERS_V'

Line 6605: WHEN 2 THEN 'DPP_XLA_INV_HEADERS_V'

6601: SELECT xet.event_id event_id
6602: , 0 line_number
6603: , CASE r
6604: WHEN 1 THEN 'DPP_XLA_INV_HEADERS_V'
6605: WHEN 2 THEN 'DPP_XLA_INV_HEADERS_V'
6606: WHEN 3 THEN 'DPP_XLA_INV_HEADERS_V'
6607: WHEN 4 THEN 'DPP_XLA_INV_HEADERS_V'
6608: WHEN 5 THEN 'DPP_XLA_INV_HEADERS_V'
6609:

Line 6606: WHEN 3 THEN 'DPP_XLA_INV_HEADERS_V'

6602: , 0 line_number
6603: , CASE r
6604: WHEN 1 THEN 'DPP_XLA_INV_HEADERS_V'
6605: WHEN 2 THEN 'DPP_XLA_INV_HEADERS_V'
6606: WHEN 3 THEN 'DPP_XLA_INV_HEADERS_V'
6607: WHEN 4 THEN 'DPP_XLA_INV_HEADERS_V'
6608: WHEN 5 THEN 'DPP_XLA_INV_HEADERS_V'
6609:
6610: ELSE null

Line 6607: WHEN 4 THEN 'DPP_XLA_INV_HEADERS_V'

6603: , CASE r
6604: WHEN 1 THEN 'DPP_XLA_INV_HEADERS_V'
6605: WHEN 2 THEN 'DPP_XLA_INV_HEADERS_V'
6606: WHEN 3 THEN 'DPP_XLA_INV_HEADERS_V'
6607: WHEN 4 THEN 'DPP_XLA_INV_HEADERS_V'
6608: WHEN 5 THEN 'DPP_XLA_INV_HEADERS_V'
6609:
6610: ELSE null
6611: END object_name

Line 6608: WHEN 5 THEN 'DPP_XLA_INV_HEADERS_V'

6604: WHEN 1 THEN 'DPP_XLA_INV_HEADERS_V'
6605: WHEN 2 THEN 'DPP_XLA_INV_HEADERS_V'
6606: WHEN 3 THEN 'DPP_XLA_INV_HEADERS_V'
6607: WHEN 4 THEN 'DPP_XLA_INV_HEADERS_V'
6608: WHEN 5 THEN 'DPP_XLA_INV_HEADERS_V'
6609:
6610: ELSE null
6611: END object_name
6612: , CASE r

Line 6651: , DPP_XLA_INV_HEADERS_V h1

6647: ELSE null
6648: END source_value
6649: , null source_meaning
6650: FROM xla_events_gt xet
6651: , DPP_XLA_INV_HEADERS_V h1
6652: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
6653: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
6654: AND xet.event_class_code = C_EVENT_CLASS_CODE
6655: AND h1.event_id = xet.event_id

Line 6907: TYPE t_array_source_1 IS TABLE OF DPP_XLA_INV_HEADERS_V.PP_TXN_NUMBER%TYPE INDEX BY BINARY_INTEGER;

6903: --
6904: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
6905: --
6906:
6907: TYPE t_array_source_1 IS TABLE OF DPP_XLA_INV_HEADERS_V.PP_TXN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
6908: TYPE t_array_source_4 IS TABLE OF DPP_XLA_INV_HEADERS_V.PP_ACCRUAL_CCID%TYPE INDEX BY BINARY_INTEGER;
6909: TYPE t_array_source_8 IS TABLE OF DPP_XLA_INV_HEADERS_V.PP_COST_ADJ_CCID%TYPE INDEX BY BINARY_INTEGER;
6910: TYPE t_array_source_10 IS TABLE OF DPP_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
6911: TYPE t_array_source_18 IS TABLE OF DPP_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 6908: TYPE t_array_source_4 IS TABLE OF DPP_XLA_INV_HEADERS_V.PP_ACCRUAL_CCID%TYPE INDEX BY BINARY_INTEGER;

6904: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
6905: --
6906:
6907: TYPE t_array_source_1 IS TABLE OF DPP_XLA_INV_HEADERS_V.PP_TXN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
6908: TYPE t_array_source_4 IS TABLE OF DPP_XLA_INV_HEADERS_V.PP_ACCRUAL_CCID%TYPE INDEX BY BINARY_INTEGER;
6909: TYPE t_array_source_8 IS TABLE OF DPP_XLA_INV_HEADERS_V.PP_COST_ADJ_CCID%TYPE INDEX BY BINARY_INTEGER;
6910: TYPE t_array_source_10 IS TABLE OF DPP_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
6911: TYPE t_array_source_18 IS TABLE OF DPP_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
6912:

Line 6909: TYPE t_array_source_8 IS TABLE OF DPP_XLA_INV_HEADERS_V.PP_COST_ADJ_CCID%TYPE INDEX BY BINARY_INTEGER;

6905: --
6906:
6907: TYPE t_array_source_1 IS TABLE OF DPP_XLA_INV_HEADERS_V.PP_TXN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
6908: TYPE t_array_source_4 IS TABLE OF DPP_XLA_INV_HEADERS_V.PP_ACCRUAL_CCID%TYPE INDEX BY BINARY_INTEGER;
6909: TYPE t_array_source_8 IS TABLE OF DPP_XLA_INV_HEADERS_V.PP_COST_ADJ_CCID%TYPE INDEX BY BINARY_INTEGER;
6910: TYPE t_array_source_10 IS TABLE OF DPP_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
6911: TYPE t_array_source_18 IS TABLE OF DPP_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
6912:
6913: TYPE t_array_source_3 IS TABLE OF DPP_XLA_INV_LINES_V.ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 6910: TYPE t_array_source_10 IS TABLE OF DPP_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

6906:
6907: TYPE t_array_source_1 IS TABLE OF DPP_XLA_INV_HEADERS_V.PP_TXN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
6908: TYPE t_array_source_4 IS TABLE OF DPP_XLA_INV_HEADERS_V.PP_ACCRUAL_CCID%TYPE INDEX BY BINARY_INTEGER;
6909: TYPE t_array_source_8 IS TABLE OF DPP_XLA_INV_HEADERS_V.PP_COST_ADJ_CCID%TYPE INDEX BY BINARY_INTEGER;
6910: TYPE t_array_source_10 IS TABLE OF DPP_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
6911: TYPE t_array_source_18 IS TABLE OF DPP_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
6912:
6913: TYPE t_array_source_3 IS TABLE OF DPP_XLA_INV_LINES_V.ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
6914: TYPE t_array_source_9 IS TABLE OF DPP_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 6911: TYPE t_array_source_18 IS TABLE OF DPP_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

6907: TYPE t_array_source_1 IS TABLE OF DPP_XLA_INV_HEADERS_V.PP_TXN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
6908: TYPE t_array_source_4 IS TABLE OF DPP_XLA_INV_HEADERS_V.PP_ACCRUAL_CCID%TYPE INDEX BY BINARY_INTEGER;
6909: TYPE t_array_source_8 IS TABLE OF DPP_XLA_INV_HEADERS_V.PP_COST_ADJ_CCID%TYPE INDEX BY BINARY_INTEGER;
6910: TYPE t_array_source_10 IS TABLE OF DPP_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
6911: TYPE t_array_source_18 IS TABLE OF DPP_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
6912:
6913: TYPE t_array_source_3 IS TABLE OF DPP_XLA_INV_LINES_V.ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
6914: TYPE t_array_source_9 IS TABLE OF DPP_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
6915: TYPE t_array_source_11 IS TABLE OF DPP_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 6966: , DPP_XLA_INV_HEADERS_V h1

6962: , h1.PP_COST_ADJ_CCID source_8
6963: , h1.DISTRIBUTION_TYPE source_10
6964: , h1.TRANSFER_TO_GL_INDICATOR source_18
6965: FROM xla_events_gt xet
6966: , DPP_XLA_INV_HEADERS_V h1
6967: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
6968: and xet.event_class_code = C_EVENT_CLASS_CODE
6969: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
6970: