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_BC_PKG dependencies on CST_XLA_INV_LINES_V

Line 31404: WHEN 4 THEN 'CST_XLA_INV_LINES_V'

31400: , CASE r
31401: WHEN 1 THEN 'FV_XLA_CST_REF_V'
31402: WHEN 2 THEN 'FV_XLA_CST_REF_V'
31403: WHEN 3 THEN 'FV_XLA_CST_REF_V'
31404: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
31405: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
31406: WHEN 6 THEN 'FV_XLA_CST_REF_V'
31407: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
31408: WHEN 8 THEN 'CST_XLA_INV_LINES_V'

Line 31405: WHEN 5 THEN 'CST_XLA_INV_LINES_V'

31401: WHEN 1 THEN 'FV_XLA_CST_REF_V'
31402: WHEN 2 THEN 'FV_XLA_CST_REF_V'
31403: WHEN 3 THEN 'FV_XLA_CST_REF_V'
31404: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
31405: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
31406: WHEN 6 THEN 'FV_XLA_CST_REF_V'
31407: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
31408: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
31409: WHEN 9 THEN 'CST_XLA_INV_LINES_V'

Line 31407: WHEN 7 THEN 'CST_XLA_INV_LINES_V'

31403: WHEN 3 THEN 'FV_XLA_CST_REF_V'
31404: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
31405: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
31406: WHEN 6 THEN 'FV_XLA_CST_REF_V'
31407: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
31408: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
31409: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
31410: WHEN 10 THEN 'FV_XLA_CST_REF_V'
31411: WHEN 11 THEN 'CST_XLA_INV_LINES_V'

Line 31408: WHEN 8 THEN 'CST_XLA_INV_LINES_V'

31404: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
31405: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
31406: WHEN 6 THEN 'FV_XLA_CST_REF_V'
31407: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
31408: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
31409: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
31410: WHEN 10 THEN 'FV_XLA_CST_REF_V'
31411: WHEN 11 THEN 'CST_XLA_INV_LINES_V'
31412: WHEN 12 THEN 'CST_XLA_INV_LINES_V'

Line 31409: WHEN 9 THEN 'CST_XLA_INV_LINES_V'

31405: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
31406: WHEN 6 THEN 'FV_XLA_CST_REF_V'
31407: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
31408: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
31409: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
31410: WHEN 10 THEN 'FV_XLA_CST_REF_V'
31411: WHEN 11 THEN 'CST_XLA_INV_LINES_V'
31412: WHEN 12 THEN 'CST_XLA_INV_LINES_V'
31413: WHEN 13 THEN 'FV_XLA_CST_REF_V'

Line 31411: WHEN 11 THEN 'CST_XLA_INV_LINES_V'

31407: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
31408: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
31409: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
31410: WHEN 10 THEN 'FV_XLA_CST_REF_V'
31411: WHEN 11 THEN 'CST_XLA_INV_LINES_V'
31412: WHEN 12 THEN 'CST_XLA_INV_LINES_V'
31413: WHEN 13 THEN 'FV_XLA_CST_REF_V'
31414: WHEN 14 THEN 'FV_XLA_CST_REF_V'
31415: WHEN 15 THEN 'FV_XLA_CST_REF_V'

Line 31412: WHEN 12 THEN 'CST_XLA_INV_LINES_V'

31408: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
31409: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
31410: WHEN 10 THEN 'FV_XLA_CST_REF_V'
31411: WHEN 11 THEN 'CST_XLA_INV_LINES_V'
31412: WHEN 12 THEN 'CST_XLA_INV_LINES_V'
31413: WHEN 13 THEN 'FV_XLA_CST_REF_V'
31414: WHEN 14 THEN 'FV_XLA_CST_REF_V'
31415: WHEN 15 THEN 'FV_XLA_CST_REF_V'
31416: WHEN 16 THEN 'FV_XLA_CST_REF_V'

Line 31508: , CST_XLA_INV_LINES_V l2

31504: ELSE null
31505: END source_value
31506: , null source_meaning
31507: FROM xla_events_gt xet
31508: , CST_XLA_INV_LINES_V l2
31509: , FV_XLA_CST_REF_V l4
31510: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
31511: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
31512: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 31664: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

31660:
31661: TYPE t_array_source_1 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
31662: TYPE t_array_source_2 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
31663: TYPE t_array_source_5 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
31664: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
31665: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
31666: TYPE t_array_source_18 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_ANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
31667: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
31668: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 31665: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

31661: TYPE t_array_source_1 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
31662: TYPE t_array_source_2 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
31663: TYPE t_array_source_5 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
31664: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
31665: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
31666: TYPE t_array_source_18 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_ANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
31667: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
31668: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
31669: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 31667: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

31663: TYPE t_array_source_5 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
31664: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
31665: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
31666: TYPE t_array_source_18 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_ANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
31667: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
31668: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
31669: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
31670: TYPE t_array_source_24 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
31671: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 31668: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

31664: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
31665: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
31666: TYPE t_array_source_18 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_ANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
31667: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
31668: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
31669: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
31670: TYPE t_array_source_24 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
31671: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
31672: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 31669: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

31665: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
31666: TYPE t_array_source_18 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_ANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
31667: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
31668: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
31669: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
31670: TYPE t_array_source_24 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
31671: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
31672: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
31673: TYPE t_array_source_27 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 31671: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

31667: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
31668: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
31669: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
31670: TYPE t_array_source_24 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
31671: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
31672: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
31673: TYPE t_array_source_27 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;
31674: TYPE t_array_source_28 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_PAID_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;
31675: TYPE t_array_source_29 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNPAID_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 31672: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

31668: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
31669: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
31670: TYPE t_array_source_24 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
31671: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
31672: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
31673: TYPE t_array_source_27 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;
31674: TYPE t_array_source_28 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_PAID_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;
31675: TYPE t_array_source_29 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNPAID_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;
31676: TYPE t_array_source_32 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_RCV_SUB_LEDGER_ID%TYPE INDEX BY BINARY_INTEGER;

Line 31829: , CST_XLA_INV_LINES_V l2

31825: , l4.FEDERAL_UNPAID_UNEXP_OBG_AMT source_29
31826: , l4.FEDERAL_RCV_SUB_LEDGER_ID source_32
31827: , l4.FEDERAL_UNEXP_OBG_AMT source_34
31828: FROM xla_events_gt xet
31829: , CST_XLA_INV_LINES_V l2
31830: , FV_XLA_CST_REF_V l4
31831: WHERE xet.event_id between x_first_event_id and x_last_event_id
31832: and xet.event_date between p_pad_start_date and p_pad_end_date
31833: and xet.event_class_code = C_EVENT_CLASS_CODE