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_LINES_V

Line 6722: WHEN 1 THEN 'DPP_XLA_INV_LINES_V'

6718: FROM (
6719: SELECT xet.event_id event_id
6720: , l2.line_number line_number
6721: , CASE r
6722: WHEN 1 THEN 'DPP_XLA_INV_LINES_V'
6723: WHEN 2 THEN 'DPP_XLA_INV_LINES_V'
6724: WHEN 3 THEN 'DPP_XLA_INV_LINES_V'
6725: WHEN 4 THEN 'DPP_XLA_INV_LINES_V'
6726: WHEN 5 THEN 'DPP_XLA_INV_LINES_V'

Line 6723: WHEN 2 THEN 'DPP_XLA_INV_LINES_V'

6719: SELECT xet.event_id event_id
6720: , l2.line_number line_number
6721: , CASE r
6722: WHEN 1 THEN 'DPP_XLA_INV_LINES_V'
6723: WHEN 2 THEN 'DPP_XLA_INV_LINES_V'
6724: WHEN 3 THEN 'DPP_XLA_INV_LINES_V'
6725: WHEN 4 THEN 'DPP_XLA_INV_LINES_V'
6726: WHEN 5 THEN 'DPP_XLA_INV_LINES_V'
6727:

Line 6724: WHEN 3 THEN 'DPP_XLA_INV_LINES_V'

6720: , l2.line_number line_number
6721: , CASE r
6722: WHEN 1 THEN 'DPP_XLA_INV_LINES_V'
6723: WHEN 2 THEN 'DPP_XLA_INV_LINES_V'
6724: WHEN 3 THEN 'DPP_XLA_INV_LINES_V'
6725: WHEN 4 THEN 'DPP_XLA_INV_LINES_V'
6726: WHEN 5 THEN 'DPP_XLA_INV_LINES_V'
6727:
6728: ELSE null

Line 6725: WHEN 4 THEN 'DPP_XLA_INV_LINES_V'

6721: , CASE r
6722: WHEN 1 THEN 'DPP_XLA_INV_LINES_V'
6723: WHEN 2 THEN 'DPP_XLA_INV_LINES_V'
6724: WHEN 3 THEN 'DPP_XLA_INV_LINES_V'
6725: WHEN 4 THEN 'DPP_XLA_INV_LINES_V'
6726: WHEN 5 THEN 'DPP_XLA_INV_LINES_V'
6727:
6728: ELSE null
6729: END object_name

Line 6726: WHEN 5 THEN 'DPP_XLA_INV_LINES_V'

6722: WHEN 1 THEN 'DPP_XLA_INV_LINES_V'
6723: WHEN 2 THEN 'DPP_XLA_INV_LINES_V'
6724: WHEN 3 THEN 'DPP_XLA_INV_LINES_V'
6725: WHEN 4 THEN 'DPP_XLA_INV_LINES_V'
6726: WHEN 5 THEN 'DPP_XLA_INV_LINES_V'
6727:
6728: ELSE null
6729: END object_name
6730: , CASE r

Line 6769: , DPP_XLA_INV_LINES_V l2

6765: ELSE null
6766: END source_value
6767: , null source_meaning
6768: FROM xla_events_gt xet
6769: , DPP_XLA_INV_LINES_V l2
6770: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
6771: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
6772: AND xet.event_class_code = C_EVENT_CLASS_CODE
6773: AND l2.event_id = xet.event_id

Line 6913: TYPE t_array_source_3 IS TABLE OF DPP_XLA_INV_LINES_V.ITEM_NUMBER%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;
6916: TYPE t_array_source_12 IS TABLE OF DPP_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
6917: TYPE t_array_source_13 IS TABLE OF DPP_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 6914: TYPE t_array_source_9 IS TABLE OF DPP_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%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;
6916: TYPE t_array_source_12 IS TABLE OF DPP_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
6917: TYPE t_array_source_13 IS TABLE OF DPP_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
6918:

Line 6915: TYPE t_array_source_11 IS TABLE OF DPP_XLA_INV_LINES_V.ENTERED_AMOUNT%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;
6916: TYPE t_array_source_12 IS TABLE OF DPP_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
6917: TYPE t_array_source_13 IS TABLE OF DPP_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
6918:
6919: l_array_source_1 t_array_source_1;

Line 6916: TYPE t_array_source_12 IS TABLE OF DPP_XLA_INV_LINES_V.CURRENCY_CODE%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;
6916: TYPE t_array_source_12 IS TABLE OF DPP_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
6917: TYPE t_array_source_13 IS TABLE OF DPP_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
6918:
6919: l_array_source_1 t_array_source_1;
6920: l_array_source_4 t_array_source_4;

Line 6917: TYPE t_array_source_13 IS TABLE OF DPP_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

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;
6916: TYPE t_array_source_12 IS TABLE OF DPP_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
6917: TYPE t_array_source_13 IS TABLE OF DPP_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
6918:
6919: l_array_source_1 t_array_source_1;
6920: l_array_source_4 t_array_source_4;
6921: l_array_source_8 t_array_source_8;

Line 7011: , DPP_XLA_INV_LINES_V l2

7007: , l2.ENTERED_AMOUNT source_11
7008: , l2.CURRENCY_CODE source_12
7009: , l2.ACCOUNTED_AMOUNT source_13
7010: FROM xla_events_gt xet
7011: , DPP_XLA_INV_LINES_V l2
7012: WHERE xet.event_id between x_first_event_id and x_last_event_id
7013: and xet.event_date between p_pad_start_date and p_pad_end_date
7014: and xet.event_class_code = C_EVENT_CLASS_CODE
7015: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id