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_000020_PKG dependencies on CST_XLA_AWO_LINES_V

Line 306632: WHEN 1 THEN 'CST_XLA_AWO_LINES_V'

306628: FROM (
306629: SELECT xet.event_id event_id
306630: , l2.line_number line_number
306631: , CASE r
306632: WHEN 1 THEN 'CST_XLA_AWO_LINES_V'
306633: WHEN 2 THEN 'CST_XLA_AWO_LINES_V'
306634: WHEN 3 THEN 'CST_XLA_AWO_LINES_V'
306635: WHEN 4 THEN 'CST_XLA_AWO_LINES_V'
306636: WHEN 5 THEN 'CST_XLA_AWO_LINES_V'

Line 306633: WHEN 2 THEN 'CST_XLA_AWO_LINES_V'

306629: SELECT xet.event_id event_id
306630: , l2.line_number line_number
306631: , CASE r
306632: WHEN 1 THEN 'CST_XLA_AWO_LINES_V'
306633: WHEN 2 THEN 'CST_XLA_AWO_LINES_V'
306634: WHEN 3 THEN 'CST_XLA_AWO_LINES_V'
306635: WHEN 4 THEN 'CST_XLA_AWO_LINES_V'
306636: WHEN 5 THEN 'CST_XLA_AWO_LINES_V'
306637: WHEN 6 THEN 'CST_XLA_AWO_LINES_V'

Line 306634: WHEN 3 THEN 'CST_XLA_AWO_LINES_V'

306630: , l2.line_number line_number
306631: , CASE r
306632: WHEN 1 THEN 'CST_XLA_AWO_LINES_V'
306633: WHEN 2 THEN 'CST_XLA_AWO_LINES_V'
306634: WHEN 3 THEN 'CST_XLA_AWO_LINES_V'
306635: WHEN 4 THEN 'CST_XLA_AWO_LINES_V'
306636: WHEN 5 THEN 'CST_XLA_AWO_LINES_V'
306637: WHEN 6 THEN 'CST_XLA_AWO_LINES_V'
306638: WHEN 7 THEN 'CST_XLA_AWO_LINES_V'

Line 306635: WHEN 4 THEN 'CST_XLA_AWO_LINES_V'

306631: , CASE r
306632: WHEN 1 THEN 'CST_XLA_AWO_LINES_V'
306633: WHEN 2 THEN 'CST_XLA_AWO_LINES_V'
306634: WHEN 3 THEN 'CST_XLA_AWO_LINES_V'
306635: WHEN 4 THEN 'CST_XLA_AWO_LINES_V'
306636: WHEN 5 THEN 'CST_XLA_AWO_LINES_V'
306637: WHEN 6 THEN 'CST_XLA_AWO_LINES_V'
306638: WHEN 7 THEN 'CST_XLA_AWO_LINES_V'
306639:

Line 306636: WHEN 5 THEN 'CST_XLA_AWO_LINES_V'

306632: WHEN 1 THEN 'CST_XLA_AWO_LINES_V'
306633: WHEN 2 THEN 'CST_XLA_AWO_LINES_V'
306634: WHEN 3 THEN 'CST_XLA_AWO_LINES_V'
306635: WHEN 4 THEN 'CST_XLA_AWO_LINES_V'
306636: WHEN 5 THEN 'CST_XLA_AWO_LINES_V'
306637: WHEN 6 THEN 'CST_XLA_AWO_LINES_V'
306638: WHEN 7 THEN 'CST_XLA_AWO_LINES_V'
306639:
306640: ELSE null

Line 306637: WHEN 6 THEN 'CST_XLA_AWO_LINES_V'

306633: WHEN 2 THEN 'CST_XLA_AWO_LINES_V'
306634: WHEN 3 THEN 'CST_XLA_AWO_LINES_V'
306635: WHEN 4 THEN 'CST_XLA_AWO_LINES_V'
306636: WHEN 5 THEN 'CST_XLA_AWO_LINES_V'
306637: WHEN 6 THEN 'CST_XLA_AWO_LINES_V'
306638: WHEN 7 THEN 'CST_XLA_AWO_LINES_V'
306639:
306640: ELSE null
306641: END object_name

Line 306638: WHEN 7 THEN 'CST_XLA_AWO_LINES_V'

306634: WHEN 3 THEN 'CST_XLA_AWO_LINES_V'
306635: WHEN 4 THEN 'CST_XLA_AWO_LINES_V'
306636: WHEN 5 THEN 'CST_XLA_AWO_LINES_V'
306637: WHEN 6 THEN 'CST_XLA_AWO_LINES_V'
306638: WHEN 7 THEN 'CST_XLA_AWO_LINES_V'
306639:
306640: ELSE null
306641: END object_name
306642: , CASE r

Line 306689: , CST_XLA_AWO_LINES_V l2

306685: ELSE null
306686: END source_value
306687: , null source_meaning
306688: FROM xla_events_gt xet
306689: , CST_XLA_AWO_LINES_V l2
306690: , (select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
306691: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
306692: AND xet.event_class_code = C_EVENT_CLASS_CODE
306693: AND l2.event_id = xet.event_id

Line 306834: TYPE t_array_source_88 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

306830: TYPE t_array_source_85 IS TABLE OF CST_XLA_AWO_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
306831: TYPE t_array_source_99 IS TABLE OF CST_XLA_AWO_HEADERS_V.WRITE_OFF_ID%TYPE INDEX BY BINARY_INTEGER;
306832: TYPE t_array_source_114 IS TABLE OF CST_XLA_AWO_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
306833:
306834: TYPE t_array_source_88 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
306835: TYPE t_array_source_91 IS TABLE OF CST_XLA_AWO_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
306836: TYPE t_array_source_92 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
306837: TYPE t_array_source_93 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
306838: TYPE t_array_source_94 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 306835: TYPE t_array_source_91 IS TABLE OF CST_XLA_AWO_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

306831: TYPE t_array_source_99 IS TABLE OF CST_XLA_AWO_HEADERS_V.WRITE_OFF_ID%TYPE INDEX BY BINARY_INTEGER;
306832: TYPE t_array_source_114 IS TABLE OF CST_XLA_AWO_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
306833:
306834: TYPE t_array_source_88 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
306835: TYPE t_array_source_91 IS TABLE OF CST_XLA_AWO_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
306836: TYPE t_array_source_92 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
306837: TYPE t_array_source_93 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
306838: TYPE t_array_source_94 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
306839: TYPE t_array_source_95 IS TABLE OF CST_XLA_AWO_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 306836: TYPE t_array_source_92 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

306832: TYPE t_array_source_114 IS TABLE OF CST_XLA_AWO_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
306833:
306834: TYPE t_array_source_88 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
306835: TYPE t_array_source_91 IS TABLE OF CST_XLA_AWO_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
306836: TYPE t_array_source_92 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
306837: TYPE t_array_source_93 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
306838: TYPE t_array_source_94 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
306839: TYPE t_array_source_95 IS TABLE OF CST_XLA_AWO_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
306840: TYPE t_array_source_98 IS TABLE OF CST_XLA_AWO_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 306837: TYPE t_array_source_93 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

306833:
306834: TYPE t_array_source_88 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
306835: TYPE t_array_source_91 IS TABLE OF CST_XLA_AWO_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
306836: TYPE t_array_source_92 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
306837: TYPE t_array_source_93 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
306838: TYPE t_array_source_94 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
306839: TYPE t_array_source_95 IS TABLE OF CST_XLA_AWO_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
306840: TYPE t_array_source_98 IS TABLE OF CST_XLA_AWO_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
306841:

Line 306838: TYPE t_array_source_94 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

306834: TYPE t_array_source_88 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
306835: TYPE t_array_source_91 IS TABLE OF CST_XLA_AWO_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
306836: TYPE t_array_source_92 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
306837: TYPE t_array_source_93 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
306838: TYPE t_array_source_94 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
306839: TYPE t_array_source_95 IS TABLE OF CST_XLA_AWO_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
306840: TYPE t_array_source_98 IS TABLE OF CST_XLA_AWO_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
306841:
306842: l_array_source_8 t_array_source_8;

Line 306839: TYPE t_array_source_95 IS TABLE OF CST_XLA_AWO_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

306835: TYPE t_array_source_91 IS TABLE OF CST_XLA_AWO_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
306836: TYPE t_array_source_92 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
306837: TYPE t_array_source_93 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
306838: TYPE t_array_source_94 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
306839: TYPE t_array_source_95 IS TABLE OF CST_XLA_AWO_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
306840: TYPE t_array_source_98 IS TABLE OF CST_XLA_AWO_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
306841:
306842: l_array_source_8 t_array_source_8;
306843: l_array_source_9 t_array_source_9;

Line 306840: TYPE t_array_source_98 IS TABLE OF CST_XLA_AWO_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;

306836: TYPE t_array_source_92 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
306837: TYPE t_array_source_93 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
306838: TYPE t_array_source_94 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
306839: TYPE t_array_source_95 IS TABLE OF CST_XLA_AWO_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
306840: TYPE t_array_source_98 IS TABLE OF CST_XLA_AWO_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
306841:
306842: l_array_source_8 t_array_source_8;
306843: l_array_source_9 t_array_source_9;
306844: l_array_source_10 t_array_source_10;

Line 306954: , CST_XLA_AWO_LINES_V l2

306950: , l2.CURRENCY_CONVERSION_TYPE source_94
306951: , l2.ACCOUNTED_AMOUNT source_95
306952: , l2.LINE_NUMBER source_98
306953: FROM xla_events_gt xet
306954: , CST_XLA_AWO_LINES_V l2
306955: WHERE xet.event_id between x_first_event_id and x_last_event_id
306956: and xet.event_date between p_pad_start_date and p_pad_end_date
306957: and xet.event_class_code = C_EVENT_CLASS_CODE
306958: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id