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_LINES_V

Line 139606: WHEN 1 THEN 'CST_XLA_AWO_LINES_V'

139602: FROM (
139603: SELECT xet.event_id event_id
139604: , l2.line_number line_number
139605: , CASE r
139606: WHEN 1 THEN 'CST_XLA_AWO_LINES_V'
139607: WHEN 2 THEN 'CST_XLA_AWO_LINES_V'
139608: WHEN 3 THEN 'CST_XLA_AWO_LINES_V'
139609: WHEN 4 THEN 'CST_XLA_AWO_LINES_V'
139610: WHEN 5 THEN 'CST_XLA_AWO_LINES_V'

Line 139607: WHEN 2 THEN 'CST_XLA_AWO_LINES_V'

139603: SELECT xet.event_id event_id
139604: , l2.line_number line_number
139605: , CASE r
139606: WHEN 1 THEN 'CST_XLA_AWO_LINES_V'
139607: WHEN 2 THEN 'CST_XLA_AWO_LINES_V'
139608: WHEN 3 THEN 'CST_XLA_AWO_LINES_V'
139609: WHEN 4 THEN 'CST_XLA_AWO_LINES_V'
139610: WHEN 5 THEN 'CST_XLA_AWO_LINES_V'
139611: WHEN 6 THEN 'CST_XLA_AWO_LINES_V'

Line 139608: WHEN 3 THEN 'CST_XLA_AWO_LINES_V'

139604: , l2.line_number line_number
139605: , CASE r
139606: WHEN 1 THEN 'CST_XLA_AWO_LINES_V'
139607: WHEN 2 THEN 'CST_XLA_AWO_LINES_V'
139608: WHEN 3 THEN 'CST_XLA_AWO_LINES_V'
139609: WHEN 4 THEN 'CST_XLA_AWO_LINES_V'
139610: WHEN 5 THEN 'CST_XLA_AWO_LINES_V'
139611: WHEN 6 THEN 'CST_XLA_AWO_LINES_V'
139612: WHEN 7 THEN 'CST_XLA_AWO_LINES_V'

Line 139609: WHEN 4 THEN 'CST_XLA_AWO_LINES_V'

139605: , CASE r
139606: WHEN 1 THEN 'CST_XLA_AWO_LINES_V'
139607: WHEN 2 THEN 'CST_XLA_AWO_LINES_V'
139608: WHEN 3 THEN 'CST_XLA_AWO_LINES_V'
139609: WHEN 4 THEN 'CST_XLA_AWO_LINES_V'
139610: WHEN 5 THEN 'CST_XLA_AWO_LINES_V'
139611: WHEN 6 THEN 'CST_XLA_AWO_LINES_V'
139612: WHEN 7 THEN 'CST_XLA_AWO_LINES_V'
139613:

Line 139610: WHEN 5 THEN 'CST_XLA_AWO_LINES_V'

139606: WHEN 1 THEN 'CST_XLA_AWO_LINES_V'
139607: WHEN 2 THEN 'CST_XLA_AWO_LINES_V'
139608: WHEN 3 THEN 'CST_XLA_AWO_LINES_V'
139609: WHEN 4 THEN 'CST_XLA_AWO_LINES_V'
139610: WHEN 5 THEN 'CST_XLA_AWO_LINES_V'
139611: WHEN 6 THEN 'CST_XLA_AWO_LINES_V'
139612: WHEN 7 THEN 'CST_XLA_AWO_LINES_V'
139613:
139614: ELSE null

Line 139611: WHEN 6 THEN 'CST_XLA_AWO_LINES_V'

139607: WHEN 2 THEN 'CST_XLA_AWO_LINES_V'
139608: WHEN 3 THEN 'CST_XLA_AWO_LINES_V'
139609: WHEN 4 THEN 'CST_XLA_AWO_LINES_V'
139610: WHEN 5 THEN 'CST_XLA_AWO_LINES_V'
139611: WHEN 6 THEN 'CST_XLA_AWO_LINES_V'
139612: WHEN 7 THEN 'CST_XLA_AWO_LINES_V'
139613:
139614: ELSE null
139615: END object_name

Line 139612: WHEN 7 THEN 'CST_XLA_AWO_LINES_V'

139608: WHEN 3 THEN 'CST_XLA_AWO_LINES_V'
139609: WHEN 4 THEN 'CST_XLA_AWO_LINES_V'
139610: WHEN 5 THEN 'CST_XLA_AWO_LINES_V'
139611: WHEN 6 THEN 'CST_XLA_AWO_LINES_V'
139612: WHEN 7 THEN 'CST_XLA_AWO_LINES_V'
139613:
139614: ELSE null
139615: END object_name
139616: , CASE r

Line 139663: , CST_XLA_AWO_LINES_V l2

139659: ELSE null
139660: END source_value
139661: , null source_meaning
139662: FROM xla_events_gt xet
139663: , CST_XLA_AWO_LINES_V l2
139664: , (select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
139665: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
139666: AND xet.event_class_code = C_EVENT_CLASS_CODE
139667: AND l2.event_id = xet.event_id

Line 139808: TYPE t_array_source_15 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CODE%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;
139811: TYPE t_array_source_20 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
139812: TYPE t_array_source_21 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 139809: TYPE t_array_source_18 IS TABLE OF CST_XLA_AWO_LINES_V.ENTERED_AMOUNT%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;
139811: TYPE t_array_source_20 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
139812: TYPE t_array_source_21 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
139813: TYPE t_array_source_22 IS TABLE OF CST_XLA_AWO_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 139810: TYPE t_array_source_19 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_DATE%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;
139811: TYPE t_array_source_20 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
139812: TYPE t_array_source_21 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
139813: TYPE t_array_source_22 IS TABLE OF CST_XLA_AWO_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
139814: TYPE t_array_source_25 IS TABLE OF CST_XLA_AWO_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 139811: TYPE t_array_source_20 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_RATE%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;
139811: TYPE t_array_source_20 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
139812: TYPE t_array_source_21 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
139813: TYPE t_array_source_22 IS TABLE OF CST_XLA_AWO_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
139814: TYPE t_array_source_25 IS TABLE OF CST_XLA_AWO_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
139815:

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

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;
139811: TYPE t_array_source_20 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
139812: TYPE t_array_source_21 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
139813: TYPE t_array_source_22 IS TABLE OF CST_XLA_AWO_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
139814: TYPE t_array_source_25 IS TABLE OF CST_XLA_AWO_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
139815:
139816: l_array_source_1 t_array_source_1;

Line 139813: TYPE t_array_source_22 IS TABLE OF CST_XLA_AWO_LINES_V.ACCOUNTED_AMOUNT%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;
139811: TYPE t_array_source_20 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
139812: TYPE t_array_source_21 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
139813: TYPE t_array_source_22 IS TABLE OF CST_XLA_AWO_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
139814: TYPE t_array_source_25 IS TABLE OF CST_XLA_AWO_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
139815:
139816: l_array_source_1 t_array_source_1;
139817: l_array_source_2 t_array_source_2;

Line 139814: TYPE t_array_source_25 IS TABLE OF CST_XLA_AWO_LINES_V.LINE_NUMBER%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;
139811: TYPE t_array_source_20 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
139812: TYPE t_array_source_21 IS TABLE OF CST_XLA_AWO_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
139813: TYPE t_array_source_22 IS TABLE OF CST_XLA_AWO_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
139814: TYPE t_array_source_25 IS TABLE OF CST_XLA_AWO_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
139815:
139816: l_array_source_1 t_array_source_1;
139817: l_array_source_2 t_array_source_2;
139818: l_array_source_3 t_array_source_3;

Line 139928: , CST_XLA_AWO_LINES_V l2

139924: , l2.CURRENCY_CONVERSION_TYPE source_21
139925: , l2.ACCOUNTED_AMOUNT source_22
139926: , l2.LINE_NUMBER source_25
139927: FROM xla_events_gt xet
139928: , CST_XLA_AWO_LINES_V l2
139929: WHERE xet.event_id between x_first_event_id and x_last_event_id
139930: and xet.event_date between p_pad_start_date and p_pad_end_date
139931: and xet.event_class_code = C_EVENT_CLASS_CODE
139932: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id