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_00222_AAD_S_000007_PKG dependencies on AR_RECEIVABLES_TRX_ACT_S_V

Line 53084: WHEN 2 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'

53080: SELECT xet.event_id event_id
53081: , 0 line_number
53082: , CASE r
53083: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
53084: WHEN 2 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
53085: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
53086: WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'
53087: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
53088: WHEN 6 THEN 'AR_ADJUSTMENTS_H_V'

Line 53148: , AR_RECEIVABLES_TRX_ACT_S_V h6

53144: FROM xla_events_gt xet
53145: , AR_ADJUSTMENTS_H_V h1
53146: , AR_BILL_TO_CUSTOMERS_S_V h2
53147: , AR_BILL_TO_SITE_USES_S_V h3
53148: , AR_RECEIVABLES_TRX_ACT_S_V h6
53149: , AR_TRANSACTIONS_S_V h7
53150: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
53151: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
53152: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 53438: TYPE t_array_source_16 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;

53434: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
53435: --
53436:
53437: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
53438: TYPE t_array_source_16 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
53439: TYPE t_array_source_25 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
53440: TYPE t_array_source_26 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
53441: TYPE t_array_source_27 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
53442: TYPE t_array_source_73 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 53518: , AR_RECEIVABLES_TRX_ACT_S_V h6

53514: FROM xla_events_gt xet
53515: , AR_ADJUSTMENTS_H_V h1
53516: , AR_BILL_TO_CUSTOMERS_S_V h2
53517: , AR_BILL_TO_SITE_USES_S_V h3
53518: , AR_RECEIVABLES_TRX_ACT_S_V h6
53519: , AR_TRANSACTIONS_S_V h7
53520: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
53521: and xet.event_class_code = C_EVENT_CLASS_CODE
53522: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 55841: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'

55837: , CASE r
55838: WHEN 1 THEN 'AR_CM_LINES_L_V'
55839: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
55840: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
55841: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
55842: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
55843: WHEN 6 THEN 'AR_CM_LINES_BASE_V'
55844: WHEN 7 THEN 'AR_CM_LINES_BASE_V'
55845: WHEN 8 THEN 'AR_CM_LINES_BASE_V'

Line 55938: , AR_RECEIVABLES_TRX_ACT_S_V l7

55934: FROM xla_events_gt xet
55935: , AR_CM_LINES_BASE_V l3
55936: , AR_CM_LINES_L_V l4
55937: , AR_DISTRIBUTIONS_L_V l6
55938: , AR_RECEIVABLES_TRX_ACT_S_V l7
55939: , (select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
55940: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
55941: AND xet.event_class_code = C_EVENT_CLASS_CODE
55942: AND l3.event_id = xet.event_id

Line 56094: TYPE t_array_source_16 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;

56090:
56091: TYPE t_array_source_9 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
56092: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
56093: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
56094: TYPE t_array_source_16 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
56095: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
56096: TYPE t_array_source_37 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
56097: TYPE t_array_source_38 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
56098: TYPE t_array_source_40 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 56234: , AR_RECEIVABLES_TRX_ACT_S_V l7

56230: FROM xla_events_gt xet
56231: , AR_CM_LINES_BASE_V l3
56232: , AR_CM_LINES_L_V l4
56233: , AR_DISTRIBUTIONS_L_V l6
56234: , AR_RECEIVABLES_TRX_ACT_S_V l7
56235: WHERE xet.event_id between x_first_event_id and x_last_event_id
56236: and xet.event_date between p_pad_start_date and p_pad_end_date
56237: and xet.event_class_code = C_EVENT_CLASS_CODE
56238: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 64492: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'

64488: , CASE r
64489: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
64490: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
64491: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
64492: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
64493: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
64494: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
64495: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
64496: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'

Line 64654: , AR_RECEIVABLES_TRX_ACT_S_V l7

64650: FROM xla_events_gt xet
64651: , AR_CUST_TRX_LINES_L_V l2
64652: , AR_DISTRIBUTIONS_BASE_V l3
64653: , AR_DISTRIBUTIONS_L_V l4
64654: , AR_RECEIVABLES_TRX_ACT_S_V l7
64655: , AR_TRANSACTIONS_S_V l10
64656: , (select rownum r from all_objects where rownum <= 28 and owner = p_apps_owner)
64657: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
64658: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 64824: TYPE t_array_source_16 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;

64820:
64821: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
64822: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
64823: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
64824: TYPE t_array_source_16 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
64825: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
64826: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64827: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
64828: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 65027: , AR_RECEIVABLES_TRX_ACT_S_V l7

65023: FROM xla_events_gt xet
65024: , AR_CUST_TRX_LINES_L_V l2
65025: , AR_DISTRIBUTIONS_BASE_V l3
65026: , AR_DISTRIBUTIONS_L_V l4
65027: , AR_RECEIVABLES_TRX_ACT_S_V l7
65028: , AR_TRANSACTIONS_S_V l10
65029: WHERE xet.event_id between x_first_event_id and x_last_event_id
65030: and xet.event_date between p_pad_start_date and p_pad_end_date
65031: and xet.event_class_code = C_EVENT_CLASS_CODE