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

Line 144598: WHEN 1 THEN 'CST_XLA_AWO_LINES_V'

144594: FROM (
144595: SELECT xet.event_id event_id
144596: , l2.line_number line_number
144597: , CASE r
144598: WHEN 1 THEN 'CST_XLA_AWO_LINES_V'
144599: WHEN 2 THEN 'CST_XLA_AWO_LINES_V'
144600: WHEN 3 THEN 'CST_XLA_AWO_LINES_V'
144601: WHEN 4 THEN 'CST_XLA_AWO_LINES_V'
144602: WHEN 5 THEN 'CST_XLA_AWO_LINES_V'

Line 144599: WHEN 2 THEN 'CST_XLA_AWO_LINES_V'

144595: SELECT xet.event_id event_id
144596: , l2.line_number line_number
144597: , CASE r
144598: WHEN 1 THEN 'CST_XLA_AWO_LINES_V'
144599: WHEN 2 THEN 'CST_XLA_AWO_LINES_V'
144600: WHEN 3 THEN 'CST_XLA_AWO_LINES_V'
144601: WHEN 4 THEN 'CST_XLA_AWO_LINES_V'
144602: WHEN 5 THEN 'CST_XLA_AWO_LINES_V'
144603: WHEN 6 THEN 'CST_XLA_AWO_LINES_V'

Line 144600: WHEN 3 THEN 'CST_XLA_AWO_LINES_V'

144596: , l2.line_number line_number
144597: , CASE r
144598: WHEN 1 THEN 'CST_XLA_AWO_LINES_V'
144599: WHEN 2 THEN 'CST_XLA_AWO_LINES_V'
144600: WHEN 3 THEN 'CST_XLA_AWO_LINES_V'
144601: WHEN 4 THEN 'CST_XLA_AWO_LINES_V'
144602: WHEN 5 THEN 'CST_XLA_AWO_LINES_V'
144603: WHEN 6 THEN 'CST_XLA_AWO_LINES_V'
144604: WHEN 7 THEN 'CST_XLA_AWO_LINES_V'

Line 144601: WHEN 4 THEN 'CST_XLA_AWO_LINES_V'

144597: , CASE r
144598: WHEN 1 THEN 'CST_XLA_AWO_LINES_V'
144599: WHEN 2 THEN 'CST_XLA_AWO_LINES_V'
144600: WHEN 3 THEN 'CST_XLA_AWO_LINES_V'
144601: WHEN 4 THEN 'CST_XLA_AWO_LINES_V'
144602: WHEN 5 THEN 'CST_XLA_AWO_LINES_V'
144603: WHEN 6 THEN 'CST_XLA_AWO_LINES_V'
144604: WHEN 7 THEN 'CST_XLA_AWO_LINES_V'
144605:

Line 144602: WHEN 5 THEN 'CST_XLA_AWO_LINES_V'

144598: WHEN 1 THEN 'CST_XLA_AWO_LINES_V'
144599: WHEN 2 THEN 'CST_XLA_AWO_LINES_V'
144600: WHEN 3 THEN 'CST_XLA_AWO_LINES_V'
144601: WHEN 4 THEN 'CST_XLA_AWO_LINES_V'
144602: WHEN 5 THEN 'CST_XLA_AWO_LINES_V'
144603: WHEN 6 THEN 'CST_XLA_AWO_LINES_V'
144604: WHEN 7 THEN 'CST_XLA_AWO_LINES_V'
144605:
144606: ELSE null

Line 144603: WHEN 6 THEN 'CST_XLA_AWO_LINES_V'

144599: WHEN 2 THEN 'CST_XLA_AWO_LINES_V'
144600: WHEN 3 THEN 'CST_XLA_AWO_LINES_V'
144601: WHEN 4 THEN 'CST_XLA_AWO_LINES_V'
144602: WHEN 5 THEN 'CST_XLA_AWO_LINES_V'
144603: WHEN 6 THEN 'CST_XLA_AWO_LINES_V'
144604: WHEN 7 THEN 'CST_XLA_AWO_LINES_V'
144605:
144606: ELSE null
144607: END object_name

Line 144604: WHEN 7 THEN 'CST_XLA_AWO_LINES_V'

144600: WHEN 3 THEN 'CST_XLA_AWO_LINES_V'
144601: WHEN 4 THEN 'CST_XLA_AWO_LINES_V'
144602: WHEN 5 THEN 'CST_XLA_AWO_LINES_V'
144603: WHEN 6 THEN 'CST_XLA_AWO_LINES_V'
144604: WHEN 7 THEN 'CST_XLA_AWO_LINES_V'
144605:
144606: ELSE null
144607: END object_name
144608: , CASE r

Line 144655: , CST_XLA_AWO_LINES_V l2

144651: ELSE null
144652: END source_value
144653: , null source_meaning
144654: FROM xla_events_gt xet
144655: , CST_XLA_AWO_LINES_V l2
144656: , (select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
144657: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
144658: AND xet.event_class_code = C_EVENT_CLASS_CODE
144659: AND l2.event_id = xet.event_id

Line 144800: TYPE t_array_source_15 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

144796: TYPE t_array_source_12 IS TABLE OF CST_XLA_AWO_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
144797: TYPE t_array_source_26 IS TABLE OF CST_XLA_AWO_HEADERS_V.WRITE_OFF_ID%TYPE INDEX BY BINARY_INTEGER;
144798: TYPE t_array_source_38 IS TABLE OF CST_XLA_AWO_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
144799:
144800: TYPE t_array_source_15 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
144801: TYPE t_array_source_18 IS TABLE OF CST_XLA_AWO_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
144802: TYPE t_array_source_19 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
144803: TYPE t_array_source_20 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
144804: TYPE t_array_source_21 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 144801: TYPE t_array_source_18 IS TABLE OF CST_XLA_AWO_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

144797: TYPE t_array_source_26 IS TABLE OF CST_XLA_AWO_HEADERS_V.WRITE_OFF_ID%TYPE INDEX BY BINARY_INTEGER;
144798: TYPE t_array_source_38 IS TABLE OF CST_XLA_AWO_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
144799:
144800: TYPE t_array_source_15 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
144801: TYPE t_array_source_18 IS TABLE OF CST_XLA_AWO_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
144802: TYPE t_array_source_19 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
144803: TYPE t_array_source_20 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
144804: TYPE t_array_source_21 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
144805: TYPE t_array_source_22 IS TABLE OF CST_XLA_AWO_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 144802: TYPE t_array_source_19 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

144798: TYPE t_array_source_38 IS TABLE OF CST_XLA_AWO_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
144799:
144800: TYPE t_array_source_15 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
144801: TYPE t_array_source_18 IS TABLE OF CST_XLA_AWO_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
144802: TYPE t_array_source_19 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
144803: TYPE t_array_source_20 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
144804: TYPE t_array_source_21 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
144805: TYPE t_array_source_22 IS TABLE OF CST_XLA_AWO_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
144806: TYPE t_array_source_25 IS TABLE OF CST_XLA_AWO_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 144803: TYPE t_array_source_20 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

144799:
144800: TYPE t_array_source_15 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
144801: TYPE t_array_source_18 IS TABLE OF CST_XLA_AWO_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
144802: TYPE t_array_source_19 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
144803: TYPE t_array_source_20 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
144804: TYPE t_array_source_21 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
144805: TYPE t_array_source_22 IS TABLE OF CST_XLA_AWO_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
144806: TYPE t_array_source_25 IS TABLE OF CST_XLA_AWO_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
144807:

Line 144804: TYPE t_array_source_21 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

144800: TYPE t_array_source_15 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
144801: TYPE t_array_source_18 IS TABLE OF CST_XLA_AWO_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
144802: TYPE t_array_source_19 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
144803: TYPE t_array_source_20 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
144804: TYPE t_array_source_21 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
144805: TYPE t_array_source_22 IS TABLE OF CST_XLA_AWO_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
144806: TYPE t_array_source_25 IS TABLE OF CST_XLA_AWO_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
144807:
144808: l_array_source_1 t_array_source_1;

Line 144805: TYPE t_array_source_22 IS TABLE OF CST_XLA_AWO_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

144801: TYPE t_array_source_18 IS TABLE OF CST_XLA_AWO_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
144802: TYPE t_array_source_19 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
144803: TYPE t_array_source_20 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
144804: TYPE t_array_source_21 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
144805: TYPE t_array_source_22 IS TABLE OF CST_XLA_AWO_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
144806: TYPE t_array_source_25 IS TABLE OF CST_XLA_AWO_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
144807:
144808: l_array_source_1 t_array_source_1;
144809: l_array_source_2 t_array_source_2;

Line 144806: TYPE t_array_source_25 IS TABLE OF CST_XLA_AWO_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;

144802: TYPE t_array_source_19 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
144803: TYPE t_array_source_20 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
144804: TYPE t_array_source_21 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
144805: TYPE t_array_source_22 IS TABLE OF CST_XLA_AWO_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
144806: TYPE t_array_source_25 IS TABLE OF CST_XLA_AWO_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
144807:
144808: l_array_source_1 t_array_source_1;
144809: l_array_source_2 t_array_source_2;
144810: l_array_source_3 t_array_source_3;

Line 144920: , CST_XLA_AWO_LINES_V l2

144916: , l2.CURRENCY_CONVERSION_TYPE source_21
144917: , l2.ACCOUNTED_AMOUNT source_22
144918: , l2.LINE_NUMBER source_25
144919: FROM xla_events_gt xet
144920: , CST_XLA_AWO_LINES_V l2
144921: WHERE xet.event_id between x_first_event_id and x_last_event_id
144922: and xet.event_date between p_pad_start_date and p_pad_end_date
144923: and xet.event_class_code = C_EVENT_CLASS_CODE
144924: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id