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

Line 306494: WHEN 1 THEN 'CST_XLA_AWO_HEADERS_V'

306490: FROM (
306491: SELECT xet.event_id event_id
306492: , 0 line_number
306493: , CASE r
306494: WHEN 1 THEN 'CST_XLA_AWO_HEADERS_V'
306495: WHEN 2 THEN 'CST_XLA_AWO_HEADERS_V'
306496: WHEN 3 THEN 'CST_XLA_AWO_HEADERS_V'
306497: WHEN 4 THEN 'CST_XLA_AWO_HEADERS_V'
306498: WHEN 5 THEN 'CST_XLA_AWO_HEADERS_V'

Line 306495: WHEN 2 THEN 'CST_XLA_AWO_HEADERS_V'

306491: SELECT xet.event_id event_id
306492: , 0 line_number
306493: , CASE r
306494: WHEN 1 THEN 'CST_XLA_AWO_HEADERS_V'
306495: WHEN 2 THEN 'CST_XLA_AWO_HEADERS_V'
306496: WHEN 3 THEN 'CST_XLA_AWO_HEADERS_V'
306497: WHEN 4 THEN 'CST_XLA_AWO_HEADERS_V'
306498: WHEN 5 THEN 'CST_XLA_AWO_HEADERS_V'
306499: WHEN 6 THEN 'CST_XLA_AWO_HEADERS_V'

Line 306496: WHEN 3 THEN 'CST_XLA_AWO_HEADERS_V'

306492: , 0 line_number
306493: , CASE r
306494: WHEN 1 THEN 'CST_XLA_AWO_HEADERS_V'
306495: WHEN 2 THEN 'CST_XLA_AWO_HEADERS_V'
306496: WHEN 3 THEN 'CST_XLA_AWO_HEADERS_V'
306497: WHEN 4 THEN 'CST_XLA_AWO_HEADERS_V'
306498: WHEN 5 THEN 'CST_XLA_AWO_HEADERS_V'
306499: WHEN 6 THEN 'CST_XLA_AWO_HEADERS_V'
306500:

Line 306497: WHEN 4 THEN 'CST_XLA_AWO_HEADERS_V'

306493: , CASE r
306494: WHEN 1 THEN 'CST_XLA_AWO_HEADERS_V'
306495: WHEN 2 THEN 'CST_XLA_AWO_HEADERS_V'
306496: WHEN 3 THEN 'CST_XLA_AWO_HEADERS_V'
306497: WHEN 4 THEN 'CST_XLA_AWO_HEADERS_V'
306498: WHEN 5 THEN 'CST_XLA_AWO_HEADERS_V'
306499: WHEN 6 THEN 'CST_XLA_AWO_HEADERS_V'
306500:
306501: ELSE null

Line 306498: WHEN 5 THEN 'CST_XLA_AWO_HEADERS_V'

306494: WHEN 1 THEN 'CST_XLA_AWO_HEADERS_V'
306495: WHEN 2 THEN 'CST_XLA_AWO_HEADERS_V'
306496: WHEN 3 THEN 'CST_XLA_AWO_HEADERS_V'
306497: WHEN 4 THEN 'CST_XLA_AWO_HEADERS_V'
306498: WHEN 5 THEN 'CST_XLA_AWO_HEADERS_V'
306499: WHEN 6 THEN 'CST_XLA_AWO_HEADERS_V'
306500:
306501: ELSE null
306502: END object_name

Line 306499: WHEN 6 THEN 'CST_XLA_AWO_HEADERS_V'

306495: WHEN 2 THEN 'CST_XLA_AWO_HEADERS_V'
306496: WHEN 3 THEN 'CST_XLA_AWO_HEADERS_V'
306497: WHEN 4 THEN 'CST_XLA_AWO_HEADERS_V'
306498: WHEN 5 THEN 'CST_XLA_AWO_HEADERS_V'
306499: WHEN 6 THEN 'CST_XLA_AWO_HEADERS_V'
306500:
306501: ELSE null
306502: END object_name
306503: , CASE r

Line 306551: , CST_XLA_AWO_HEADERS_V h1

306547:
306548: ELSE null
306549: END source_meaning
306550: FROM xla_events_gt xet
306551: , CST_XLA_AWO_HEADERS_V h1
306552: , fnd_lookup_values fvl85
306553: , fnd_lookup_values fvl114
306554: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
306555: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 306827: TYPE t_array_source_8 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ACCRUAL_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

306823: --
306824: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
306825: --
306826:
306827: TYPE t_array_source_8 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ACCRUAL_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
306828: TYPE t_array_source_9 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ERV_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
306829: TYPE t_array_source_10 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_OFFSET_ACCOUNT_ID%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;

Line 306828: TYPE t_array_source_9 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ERV_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

306824: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
306825: --
306826:
306827: TYPE t_array_source_8 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ACCRUAL_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
306828: TYPE t_array_source_9 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ERV_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
306829: TYPE t_array_source_10 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_OFFSET_ACCOUNT_ID%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;

Line 306829: TYPE t_array_source_10 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_OFFSET_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

306825: --
306826:
306827: TYPE t_array_source_8 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ACCRUAL_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
306828: TYPE t_array_source_9 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ERV_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
306829: TYPE t_array_source_10 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_OFFSET_ACCOUNT_ID%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:

Line 306830: TYPE t_array_source_85 IS TABLE OF CST_XLA_AWO_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

306826:
306827: TYPE t_array_source_8 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ACCRUAL_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
306828: TYPE t_array_source_9 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ERV_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
306829: TYPE t_array_source_10 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_OFFSET_ACCOUNT_ID%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;

Line 306831: TYPE t_array_source_99 IS TABLE OF CST_XLA_AWO_HEADERS_V.WRITE_OFF_ID%TYPE INDEX BY BINARY_INTEGER;

306827: TYPE t_array_source_8 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ACCRUAL_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
306828: TYPE t_array_source_9 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ERV_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
306829: TYPE t_array_source_10 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_OFFSET_ACCOUNT_ID%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;

Line 306832: TYPE t_array_source_114 IS TABLE OF CST_XLA_AWO_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

306828: TYPE t_array_source_9 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ERV_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
306829: TYPE t_array_source_10 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_OFFSET_ACCOUNT_ID%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;

Line 306897: , CST_XLA_AWO_HEADERS_V h1

306893: , h1.WRITE_OFF_ID source_99
306894: , h1.TRANSFER_TO_GL_INDICATOR source_114
306895: , fvl114.meaning source_114_meaning
306896: FROM xla_events_gt xet
306897: , CST_XLA_AWO_HEADERS_V h1
306898: , fnd_lookup_values fvl85
306899: , fnd_lookup_values fvl114
306900: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
306901: and xet.event_class_code = C_EVENT_CLASS_CODE