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_00540_AAD_S_000014_PKG dependencies on OKL_SHR_EXTRACT_HDR_V

Line 15339: WHEN 7 THEN 'OKL_SHR_EXTRACT_HDR_V'

15335: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
15336: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
15337: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
15338: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
15339: WHEN 7 THEN 'OKL_SHR_EXTRACT_HDR_V'
15340: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
15341: WHEN 9 THEN 'OKL_CMN_EXTRACT_HDR_V'
15342:
15343: ELSE null

Line 15401: , OKL_SHR_EXTRACT_HDR_V h3

15397: END source_value
15398: , null source_meaning
15399: FROM xla_events_gt xet
15400: , OKL_CMN_EXTRACT_HDR_V h1
15401: , OKL_SHR_EXTRACT_HDR_V h3
15402: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
15403: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
15404: AND xet.event_class_code = C_EVENT_CLASS_CODE
15405: AND h1.event_id = xet.event_id

Line 15670: TYPE t_array_source_14 IS TABLE OF OKL_SHR_EXTRACT_HDR_V.TCN_ACCRUAL_REVERSAL_DATE%TYPE INDEX BY BINARY_INTEGER;

15666: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
15667: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
15668: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
15669: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
15670: TYPE t_array_source_14 IS TABLE OF OKL_SHR_EXTRACT_HDR_V.TCN_ACCRUAL_REVERSAL_DATE%TYPE INDEX BY BINARY_INTEGER;
15671: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
15672: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
15673:
15674: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 15737: , OKL_SHR_EXTRACT_HDR_V h3

15733: , h1.GL_DATE source_15
15734: , h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
15735: FROM xla_events_gt xet
15736: , OKL_CMN_EXTRACT_HDR_V h1
15737: , OKL_SHR_EXTRACT_HDR_V h3
15738: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
15739: and xet.event_class_code = C_EVENT_CLASS_CODE
15740: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
15741: AND h3.TCN_ID (+) = h1.TCN_ID