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_IA_EXTRACT_HDR_V

Line 21326: WHEN 1 THEN 'OKL_IA_EXTRACT_HDR_V'

21322: FROM (
21323: SELECT xet.event_id event_id
21324: , 0 line_number
21325: , CASE r
21326: WHEN 1 THEN 'OKL_IA_EXTRACT_HDR_V'
21327: WHEN 2 THEN 'OKL_IA_EXTRACT_HDR_V'
21328: WHEN 3 THEN 'OKL_IA_EXTRACT_HDR_V'
21329: WHEN 4 THEN 'OKL_IA_EXTRACT_HDR_V'
21330: WHEN 5 THEN 'OKL_IA_EXTRACT_HDR_V'

Line 21327: WHEN 2 THEN 'OKL_IA_EXTRACT_HDR_V'

21323: SELECT xet.event_id event_id
21324: , 0 line_number
21325: , CASE r
21326: WHEN 1 THEN 'OKL_IA_EXTRACT_HDR_V'
21327: WHEN 2 THEN 'OKL_IA_EXTRACT_HDR_V'
21328: WHEN 3 THEN 'OKL_IA_EXTRACT_HDR_V'
21329: WHEN 4 THEN 'OKL_IA_EXTRACT_HDR_V'
21330: WHEN 5 THEN 'OKL_IA_EXTRACT_HDR_V'
21331: WHEN 6 THEN 'OKL_IA_EXTRACT_HDR_V'

Line 21328: WHEN 3 THEN 'OKL_IA_EXTRACT_HDR_V'

21324: , 0 line_number
21325: , CASE r
21326: WHEN 1 THEN 'OKL_IA_EXTRACT_HDR_V'
21327: WHEN 2 THEN 'OKL_IA_EXTRACT_HDR_V'
21328: WHEN 3 THEN 'OKL_IA_EXTRACT_HDR_V'
21329: WHEN 4 THEN 'OKL_IA_EXTRACT_HDR_V'
21330: WHEN 5 THEN 'OKL_IA_EXTRACT_HDR_V'
21331: WHEN 6 THEN 'OKL_IA_EXTRACT_HDR_V'
21332: WHEN 7 THEN 'OKL_IA_EXTRACT_HDR_V'

Line 21329: WHEN 4 THEN 'OKL_IA_EXTRACT_HDR_V'

21325: , CASE r
21326: WHEN 1 THEN 'OKL_IA_EXTRACT_HDR_V'
21327: WHEN 2 THEN 'OKL_IA_EXTRACT_HDR_V'
21328: WHEN 3 THEN 'OKL_IA_EXTRACT_HDR_V'
21329: WHEN 4 THEN 'OKL_IA_EXTRACT_HDR_V'
21330: WHEN 5 THEN 'OKL_IA_EXTRACT_HDR_V'
21331: WHEN 6 THEN 'OKL_IA_EXTRACT_HDR_V'
21332: WHEN 7 THEN 'OKL_IA_EXTRACT_HDR_V'
21333: WHEN 8 THEN 'OKL_IA_EXTRACT_HDR_V'

Line 21330: WHEN 5 THEN 'OKL_IA_EXTRACT_HDR_V'

21326: WHEN 1 THEN 'OKL_IA_EXTRACT_HDR_V'
21327: WHEN 2 THEN 'OKL_IA_EXTRACT_HDR_V'
21328: WHEN 3 THEN 'OKL_IA_EXTRACT_HDR_V'
21329: WHEN 4 THEN 'OKL_IA_EXTRACT_HDR_V'
21330: WHEN 5 THEN 'OKL_IA_EXTRACT_HDR_V'
21331: WHEN 6 THEN 'OKL_IA_EXTRACT_HDR_V'
21332: WHEN 7 THEN 'OKL_IA_EXTRACT_HDR_V'
21333: WHEN 8 THEN 'OKL_IA_EXTRACT_HDR_V'
21334:

Line 21331: WHEN 6 THEN 'OKL_IA_EXTRACT_HDR_V'

21327: WHEN 2 THEN 'OKL_IA_EXTRACT_HDR_V'
21328: WHEN 3 THEN 'OKL_IA_EXTRACT_HDR_V'
21329: WHEN 4 THEN 'OKL_IA_EXTRACT_HDR_V'
21330: WHEN 5 THEN 'OKL_IA_EXTRACT_HDR_V'
21331: WHEN 6 THEN 'OKL_IA_EXTRACT_HDR_V'
21332: WHEN 7 THEN 'OKL_IA_EXTRACT_HDR_V'
21333: WHEN 8 THEN 'OKL_IA_EXTRACT_HDR_V'
21334:
21335: ELSE null

Line 21332: WHEN 7 THEN 'OKL_IA_EXTRACT_HDR_V'

21328: WHEN 3 THEN 'OKL_IA_EXTRACT_HDR_V'
21329: WHEN 4 THEN 'OKL_IA_EXTRACT_HDR_V'
21330: WHEN 5 THEN 'OKL_IA_EXTRACT_HDR_V'
21331: WHEN 6 THEN 'OKL_IA_EXTRACT_HDR_V'
21332: WHEN 7 THEN 'OKL_IA_EXTRACT_HDR_V'
21333: WHEN 8 THEN 'OKL_IA_EXTRACT_HDR_V'
21334:
21335: ELSE null
21336: END object_name

Line 21333: WHEN 8 THEN 'OKL_IA_EXTRACT_HDR_V'

21329: WHEN 4 THEN 'OKL_IA_EXTRACT_HDR_V'
21330: WHEN 5 THEN 'OKL_IA_EXTRACT_HDR_V'
21331: WHEN 6 THEN 'OKL_IA_EXTRACT_HDR_V'
21332: WHEN 7 THEN 'OKL_IA_EXTRACT_HDR_V'
21333: WHEN 8 THEN 'OKL_IA_EXTRACT_HDR_V'
21334:
21335: ELSE null
21336: END object_name
21337: , CASE r

Line 21388: , OKL_IA_EXTRACT_HDR_V h2

21384: ELSE null
21385: END source_value
21386: , null source_meaning
21387: FROM xla_events_gt xet
21388: , OKL_IA_EXTRACT_HDR_V h2
21389: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
21390: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
21391: AND xet.event_class_code = C_EVENT_CLASS_CODE
21392: AND h2.event_id = xet.event_id

Line 21651: TYPE t_array_source_3 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TEH_INV_AGRMNT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

21647: --
21648: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
21649: --
21650:
21651: TYPE t_array_source_3 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TEH_INV_AGRMNT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
21652: TYPE t_array_source_4 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_INV_AGRMNT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
21653: TYPE t_array_source_10 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
21654: TYPE t_array_source_11 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
21655: TYPE t_array_source_12 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 21652: TYPE t_array_source_4 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_INV_AGRMNT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;

21648: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
21649: --
21650:
21651: TYPE t_array_source_3 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TEH_INV_AGRMNT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
21652: TYPE t_array_source_4 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_INV_AGRMNT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
21653: TYPE t_array_source_10 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
21654: TYPE t_array_source_11 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
21655: TYPE t_array_source_12 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
21656: TYPE t_array_source_13 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 21653: TYPE t_array_source_10 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

21649: --
21650:
21651: TYPE t_array_source_3 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TEH_INV_AGRMNT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
21652: TYPE t_array_source_4 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_INV_AGRMNT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
21653: TYPE t_array_source_10 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
21654: TYPE t_array_source_11 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
21655: TYPE t_array_source_12 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
21656: TYPE t_array_source_13 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
21657: TYPE t_array_source_15 IS TABLE OF OKL_IA_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 21654: TYPE t_array_source_11 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

21650:
21651: TYPE t_array_source_3 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TEH_INV_AGRMNT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
21652: TYPE t_array_source_4 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_INV_AGRMNT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
21653: TYPE t_array_source_10 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
21654: TYPE t_array_source_11 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
21655: TYPE t_array_source_12 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
21656: TYPE t_array_source_13 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
21657: TYPE t_array_source_15 IS TABLE OF OKL_IA_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
21658: TYPE t_array_source_16 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 21655: TYPE t_array_source_12 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

21651: TYPE t_array_source_3 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TEH_INV_AGRMNT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
21652: TYPE t_array_source_4 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_INV_AGRMNT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
21653: TYPE t_array_source_10 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
21654: TYPE t_array_source_11 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
21655: TYPE t_array_source_12 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
21656: TYPE t_array_source_13 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
21657: TYPE t_array_source_15 IS TABLE OF OKL_IA_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
21658: TYPE t_array_source_16 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
21659:

Line 21656: TYPE t_array_source_13 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

21652: TYPE t_array_source_4 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_INV_AGRMNT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
21653: TYPE t_array_source_10 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
21654: TYPE t_array_source_11 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
21655: TYPE t_array_source_12 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
21656: TYPE t_array_source_13 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
21657: TYPE t_array_source_15 IS TABLE OF OKL_IA_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
21658: TYPE t_array_source_16 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
21659:
21660: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 21657: TYPE t_array_source_15 IS TABLE OF OKL_IA_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

21653: TYPE t_array_source_10 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
21654: TYPE t_array_source_11 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
21655: TYPE t_array_source_12 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
21656: TYPE t_array_source_13 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
21657: TYPE t_array_source_15 IS TABLE OF OKL_IA_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
21658: TYPE t_array_source_16 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
21659:
21660: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
21661: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 21658: TYPE t_array_source_16 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

21654: TYPE t_array_source_11 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
21655: TYPE t_array_source_12 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
21656: TYPE t_array_source_13 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
21657: TYPE t_array_source_15 IS TABLE OF OKL_IA_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
21658: TYPE t_array_source_16 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
21659:
21660: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
21661: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
21662: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 21720: , OKL_IA_EXTRACT_HDR_V h2

21716: , h2.TCN_CURR_CONVERSION_TYPE source_13
21717: , h2.GL_DATE source_15
21718: , h2.TCN_ACCOUNTING_REVERSAL_FLAG source_16
21719: FROM xla_events_gt xet
21720: , OKL_IA_EXTRACT_HDR_V h2
21721: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
21722: and xet.event_class_code = C_EVENT_CLASS_CODE
21723: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
21724: