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_HEADERS_V

Line 144460: WHEN 1 THEN 'CST_XLA_AWO_HEADERS_V'

144456: FROM (
144457: SELECT xet.event_id event_id
144458: , 0 line_number
144459: , CASE r
144460: WHEN 1 THEN 'CST_XLA_AWO_HEADERS_V'
144461: WHEN 2 THEN 'CST_XLA_AWO_HEADERS_V'
144462: WHEN 3 THEN 'CST_XLA_AWO_HEADERS_V'
144463: WHEN 4 THEN 'CST_XLA_AWO_HEADERS_V'
144464: WHEN 5 THEN 'CST_XLA_AWO_HEADERS_V'

Line 144461: WHEN 2 THEN 'CST_XLA_AWO_HEADERS_V'

144457: SELECT xet.event_id event_id
144458: , 0 line_number
144459: , CASE r
144460: WHEN 1 THEN 'CST_XLA_AWO_HEADERS_V'
144461: WHEN 2 THEN 'CST_XLA_AWO_HEADERS_V'
144462: WHEN 3 THEN 'CST_XLA_AWO_HEADERS_V'
144463: WHEN 4 THEN 'CST_XLA_AWO_HEADERS_V'
144464: WHEN 5 THEN 'CST_XLA_AWO_HEADERS_V'
144465: WHEN 6 THEN 'CST_XLA_AWO_HEADERS_V'

Line 144462: WHEN 3 THEN 'CST_XLA_AWO_HEADERS_V'

144458: , 0 line_number
144459: , CASE r
144460: WHEN 1 THEN 'CST_XLA_AWO_HEADERS_V'
144461: WHEN 2 THEN 'CST_XLA_AWO_HEADERS_V'
144462: WHEN 3 THEN 'CST_XLA_AWO_HEADERS_V'
144463: WHEN 4 THEN 'CST_XLA_AWO_HEADERS_V'
144464: WHEN 5 THEN 'CST_XLA_AWO_HEADERS_V'
144465: WHEN 6 THEN 'CST_XLA_AWO_HEADERS_V'
144466:

Line 144463: WHEN 4 THEN 'CST_XLA_AWO_HEADERS_V'

144459: , CASE r
144460: WHEN 1 THEN 'CST_XLA_AWO_HEADERS_V'
144461: WHEN 2 THEN 'CST_XLA_AWO_HEADERS_V'
144462: WHEN 3 THEN 'CST_XLA_AWO_HEADERS_V'
144463: WHEN 4 THEN 'CST_XLA_AWO_HEADERS_V'
144464: WHEN 5 THEN 'CST_XLA_AWO_HEADERS_V'
144465: WHEN 6 THEN 'CST_XLA_AWO_HEADERS_V'
144466:
144467: ELSE null

Line 144464: WHEN 5 THEN 'CST_XLA_AWO_HEADERS_V'

144460: WHEN 1 THEN 'CST_XLA_AWO_HEADERS_V'
144461: WHEN 2 THEN 'CST_XLA_AWO_HEADERS_V'
144462: WHEN 3 THEN 'CST_XLA_AWO_HEADERS_V'
144463: WHEN 4 THEN 'CST_XLA_AWO_HEADERS_V'
144464: WHEN 5 THEN 'CST_XLA_AWO_HEADERS_V'
144465: WHEN 6 THEN 'CST_XLA_AWO_HEADERS_V'
144466:
144467: ELSE null
144468: END object_name

Line 144465: WHEN 6 THEN 'CST_XLA_AWO_HEADERS_V'

144461: WHEN 2 THEN 'CST_XLA_AWO_HEADERS_V'
144462: WHEN 3 THEN 'CST_XLA_AWO_HEADERS_V'
144463: WHEN 4 THEN 'CST_XLA_AWO_HEADERS_V'
144464: WHEN 5 THEN 'CST_XLA_AWO_HEADERS_V'
144465: WHEN 6 THEN 'CST_XLA_AWO_HEADERS_V'
144466:
144467: ELSE null
144468: END object_name
144469: , CASE r

Line 144517: , CST_XLA_AWO_HEADERS_V h1

144513:
144514: ELSE null
144515: END source_meaning
144516: FROM xla_events_gt xet
144517: , CST_XLA_AWO_HEADERS_V h1
144518: , fnd_lookup_values fvl12
144519: , fnd_lookup_values fvl38
144520: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
144521: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

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

144789: --
144790: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
144791: --
144792:
144793: TYPE t_array_source_1 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ACCRUAL_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
144794: TYPE t_array_source_2 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ERV_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
144795: TYPE t_array_source_3 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_OFFSET_ACCOUNT_ID%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;

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

144790: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
144791: --
144792:
144793: TYPE t_array_source_1 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ACCRUAL_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
144794: TYPE t_array_source_2 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ERV_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
144795: TYPE t_array_source_3 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_OFFSET_ACCOUNT_ID%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;

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

144791: --
144792:
144793: TYPE t_array_source_1 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ACCRUAL_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
144794: TYPE t_array_source_2 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ERV_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
144795: TYPE t_array_source_3 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_OFFSET_ACCOUNT_ID%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:

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

144792:
144793: TYPE t_array_source_1 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ACCRUAL_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
144794: TYPE t_array_source_2 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ERV_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
144795: TYPE t_array_source_3 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_OFFSET_ACCOUNT_ID%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;

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

144793: TYPE t_array_source_1 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ACCRUAL_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
144794: TYPE t_array_source_2 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ERV_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
144795: TYPE t_array_source_3 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_OFFSET_ACCOUNT_ID%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;

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

144794: TYPE t_array_source_2 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ERV_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
144795: TYPE t_array_source_3 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_OFFSET_ACCOUNT_ID%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;

Line 144863: , CST_XLA_AWO_HEADERS_V h1

144859: , h1.WRITE_OFF_ID source_26
144860: , h1.TRANSFER_TO_GL_INDICATOR source_38
144861: , fvl38.meaning source_38_meaning
144862: FROM xla_events_gt xet
144863: , CST_XLA_AWO_HEADERS_V h1
144864: , fnd_lookup_values fvl12
144865: , fnd_lookup_values fvl38
144866: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
144867: and xet.event_class_code = C_EVENT_CLASS_CODE