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_00707_AAD_S_000007_PKG dependencies on CST_XLA_AWO_HEADERS_V

Line 139468: WHEN 1 THEN 'CST_XLA_AWO_HEADERS_V'

139464: FROM (
139465: SELECT xet.event_id event_id
139466: , 0 line_number
139467: , CASE r
139468: WHEN 1 THEN 'CST_XLA_AWO_HEADERS_V'
139469: WHEN 2 THEN 'CST_XLA_AWO_HEADERS_V'
139470: WHEN 3 THEN 'CST_XLA_AWO_HEADERS_V'
139471: WHEN 4 THEN 'CST_XLA_AWO_HEADERS_V'
139472: WHEN 5 THEN 'CST_XLA_AWO_HEADERS_V'

Line 139469: WHEN 2 THEN 'CST_XLA_AWO_HEADERS_V'

139465: SELECT xet.event_id event_id
139466: , 0 line_number
139467: , CASE r
139468: WHEN 1 THEN 'CST_XLA_AWO_HEADERS_V'
139469: WHEN 2 THEN 'CST_XLA_AWO_HEADERS_V'
139470: WHEN 3 THEN 'CST_XLA_AWO_HEADERS_V'
139471: WHEN 4 THEN 'CST_XLA_AWO_HEADERS_V'
139472: WHEN 5 THEN 'CST_XLA_AWO_HEADERS_V'
139473: WHEN 6 THEN 'CST_XLA_AWO_HEADERS_V'

Line 139470: WHEN 3 THEN 'CST_XLA_AWO_HEADERS_V'

139466: , 0 line_number
139467: , CASE r
139468: WHEN 1 THEN 'CST_XLA_AWO_HEADERS_V'
139469: WHEN 2 THEN 'CST_XLA_AWO_HEADERS_V'
139470: WHEN 3 THEN 'CST_XLA_AWO_HEADERS_V'
139471: WHEN 4 THEN 'CST_XLA_AWO_HEADERS_V'
139472: WHEN 5 THEN 'CST_XLA_AWO_HEADERS_V'
139473: WHEN 6 THEN 'CST_XLA_AWO_HEADERS_V'
139474:

Line 139471: WHEN 4 THEN 'CST_XLA_AWO_HEADERS_V'

139467: , CASE r
139468: WHEN 1 THEN 'CST_XLA_AWO_HEADERS_V'
139469: WHEN 2 THEN 'CST_XLA_AWO_HEADERS_V'
139470: WHEN 3 THEN 'CST_XLA_AWO_HEADERS_V'
139471: WHEN 4 THEN 'CST_XLA_AWO_HEADERS_V'
139472: WHEN 5 THEN 'CST_XLA_AWO_HEADERS_V'
139473: WHEN 6 THEN 'CST_XLA_AWO_HEADERS_V'
139474:
139475: ELSE null

Line 139472: WHEN 5 THEN 'CST_XLA_AWO_HEADERS_V'

139468: WHEN 1 THEN 'CST_XLA_AWO_HEADERS_V'
139469: WHEN 2 THEN 'CST_XLA_AWO_HEADERS_V'
139470: WHEN 3 THEN 'CST_XLA_AWO_HEADERS_V'
139471: WHEN 4 THEN 'CST_XLA_AWO_HEADERS_V'
139472: WHEN 5 THEN 'CST_XLA_AWO_HEADERS_V'
139473: WHEN 6 THEN 'CST_XLA_AWO_HEADERS_V'
139474:
139475: ELSE null
139476: END object_name

Line 139473: WHEN 6 THEN 'CST_XLA_AWO_HEADERS_V'

139469: WHEN 2 THEN 'CST_XLA_AWO_HEADERS_V'
139470: WHEN 3 THEN 'CST_XLA_AWO_HEADERS_V'
139471: WHEN 4 THEN 'CST_XLA_AWO_HEADERS_V'
139472: WHEN 5 THEN 'CST_XLA_AWO_HEADERS_V'
139473: WHEN 6 THEN 'CST_XLA_AWO_HEADERS_V'
139474:
139475: ELSE null
139476: END object_name
139477: , CASE r

Line 139525: , CST_XLA_AWO_HEADERS_V h1

139521:
139522: ELSE null
139523: END source_meaning
139524: FROM xla_events_gt xet
139525: , CST_XLA_AWO_HEADERS_V h1
139526: , fnd_lookup_values fvl12
139527: , fnd_lookup_values fvl38
139528: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
139529: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 139801: TYPE t_array_source_1 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ACCRUAL_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

139797: --
139798: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
139799: --
139800:
139801: TYPE t_array_source_1 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ACCRUAL_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
139802: TYPE t_array_source_2 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ERV_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
139803: TYPE t_array_source_3 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_OFFSET_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
139804: TYPE t_array_source_12 IS TABLE OF CST_XLA_AWO_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
139805: TYPE t_array_source_26 IS TABLE OF CST_XLA_AWO_HEADERS_V.WRITE_OFF_ID%TYPE INDEX BY BINARY_INTEGER;

Line 139802: TYPE t_array_source_2 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ERV_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

139798: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
139799: --
139800:
139801: TYPE t_array_source_1 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ACCRUAL_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
139802: TYPE t_array_source_2 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ERV_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
139803: TYPE t_array_source_3 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_OFFSET_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
139804: TYPE t_array_source_12 IS TABLE OF CST_XLA_AWO_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
139805: TYPE t_array_source_26 IS TABLE OF CST_XLA_AWO_HEADERS_V.WRITE_OFF_ID%TYPE INDEX BY BINARY_INTEGER;
139806: TYPE t_array_source_38 IS TABLE OF CST_XLA_AWO_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 139803: TYPE t_array_source_3 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_OFFSET_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

139799: --
139800:
139801: TYPE t_array_source_1 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ACCRUAL_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
139802: TYPE t_array_source_2 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ERV_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
139803: TYPE t_array_source_3 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_OFFSET_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
139804: TYPE t_array_source_12 IS TABLE OF CST_XLA_AWO_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
139805: TYPE t_array_source_26 IS TABLE OF CST_XLA_AWO_HEADERS_V.WRITE_OFF_ID%TYPE INDEX BY BINARY_INTEGER;
139806: TYPE t_array_source_38 IS TABLE OF CST_XLA_AWO_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
139807:

Line 139804: TYPE t_array_source_12 IS TABLE OF CST_XLA_AWO_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

139800:
139801: TYPE t_array_source_1 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ACCRUAL_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
139802: TYPE t_array_source_2 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ERV_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
139803: TYPE t_array_source_3 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_OFFSET_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
139804: TYPE t_array_source_12 IS TABLE OF CST_XLA_AWO_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
139805: TYPE t_array_source_26 IS TABLE OF CST_XLA_AWO_HEADERS_V.WRITE_OFF_ID%TYPE INDEX BY BINARY_INTEGER;
139806: TYPE t_array_source_38 IS TABLE OF CST_XLA_AWO_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
139807:
139808: TYPE t_array_source_15 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 139805: TYPE t_array_source_26 IS TABLE OF CST_XLA_AWO_HEADERS_V.WRITE_OFF_ID%TYPE INDEX BY BINARY_INTEGER;

139801: TYPE t_array_source_1 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ACCRUAL_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
139802: TYPE t_array_source_2 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ERV_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
139803: TYPE t_array_source_3 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_OFFSET_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
139804: TYPE t_array_source_12 IS TABLE OF CST_XLA_AWO_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
139805: TYPE t_array_source_26 IS TABLE OF CST_XLA_AWO_HEADERS_V.WRITE_OFF_ID%TYPE INDEX BY BINARY_INTEGER;
139806: TYPE t_array_source_38 IS TABLE OF CST_XLA_AWO_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
139807:
139808: TYPE t_array_source_15 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
139809: TYPE t_array_source_18 IS TABLE OF CST_XLA_AWO_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 139806: TYPE t_array_source_38 IS TABLE OF CST_XLA_AWO_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

139802: TYPE t_array_source_2 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ERV_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
139803: TYPE t_array_source_3 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_OFFSET_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
139804: TYPE t_array_source_12 IS TABLE OF CST_XLA_AWO_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
139805: TYPE t_array_source_26 IS TABLE OF CST_XLA_AWO_HEADERS_V.WRITE_OFF_ID%TYPE INDEX BY BINARY_INTEGER;
139806: TYPE t_array_source_38 IS TABLE OF CST_XLA_AWO_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
139807:
139808: TYPE t_array_source_15 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
139809: TYPE t_array_source_18 IS TABLE OF CST_XLA_AWO_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
139810: TYPE t_array_source_19 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 139871: , CST_XLA_AWO_HEADERS_V h1

139867: , h1.WRITE_OFF_ID source_26
139868: , h1.TRANSFER_TO_GL_INDICATOR source_38
139869: , fvl38.meaning source_38_meaning
139870: FROM xla_events_gt xet
139871: , CST_XLA_AWO_HEADERS_V h1
139872: , fnd_lookup_values fvl12
139873: , fnd_lookup_values fvl38
139874: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
139875: and xet.event_class_code = C_EVENT_CLASS_CODE