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.

[Home] [Help]

APPS.XLA_00222_AAD_S_000004_PKG dependencies on AR_TRANSACTIONS_S_V

Line 22445: WHEN 15 THEN 'AR_TRANSACTIONS_S_V'

22441: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
22442: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
22443: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
22444: WHEN 14 THEN 'AR_CUST_TRX_LINES_L_V'
22445: WHEN 15 THEN 'AR_TRANSACTIONS_S_V'
22446: WHEN 16 THEN 'AR_CUST_TRX_LINES_L_V'
22447: WHEN 17 THEN 'AR_TRANSACTIONS_S_V'
22448: WHEN 18 THEN 'AR_DISTRIBUTIONS_L_V'
22449: WHEN 19 THEN 'AR_DISTRIBUTIONS_L_V'

Line 22447: WHEN 17 THEN 'AR_TRANSACTIONS_S_V'

22443: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
22444: WHEN 14 THEN 'AR_CUST_TRX_LINES_L_V'
22445: WHEN 15 THEN 'AR_TRANSACTIONS_S_V'
22446: WHEN 16 THEN 'AR_CUST_TRX_LINES_L_V'
22447: WHEN 17 THEN 'AR_TRANSACTIONS_S_V'
22448: WHEN 18 THEN 'AR_DISTRIBUTIONS_L_V'
22449: WHEN 19 THEN 'AR_DISTRIBUTIONS_L_V'
22450: WHEN 20 THEN 'AR_DISTRIBUTIONS_BASE_V'
22451: WHEN 21 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 22602: , AR_TRANSACTIONS_S_V l9

22598: , AR_CUST_TRX_LINES_L_V l2
22599: , AR_DISTRIBUTIONS_BASE_V l3
22600: , AR_DISTRIBUTIONS_L_V l4
22601: , AR_RECEIVABLES_TRX_ACT_S_V l6
22602: , AR_TRANSACTIONS_S_V l9
22603: , (select rownum r from all_objects where rownum <= 29 and owner = p_apps_owner)
22604: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
22605: AND xet.event_class_code = C_EVENT_CLASS_CODE
22606: AND l3.event_id = xet.event_id

Line 22774: TYPE t_array_source_19 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

22770: TYPE t_array_source_14 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
22771: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
22772: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
22773: TYPE t_array_source_18 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
22774: TYPE t_array_source_19 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
22775: TYPE t_array_source_20 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
22776: TYPE t_array_source_21 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
22777: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
22778: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;

Line 22776: TYPE t_array_source_21 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;

22772: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
22773: TYPE t_array_source_18 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
22774: TYPE t_array_source_19 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
22775: TYPE t_array_source_20 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
22776: TYPE t_array_source_21 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
22777: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
22778: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
22779: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
22780: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 22952: , AR_TRANSACTIONS_S_V l9

22948: , AR_CUST_TRX_LINES_L_V l2
22949: , AR_DISTRIBUTIONS_BASE_V l3
22950: , AR_DISTRIBUTIONS_L_V l4
22951: , AR_RECEIVABLES_TRX_ACT_S_V l6
22952: , AR_TRANSACTIONS_S_V l9
22953: WHERE xet.event_id between x_first_event_id and x_last_event_id
22954: and xet.event_date between p_pad_start_date and p_pad_end_date
22955: and xet.event_class_code = C_EVENT_CLASS_CODE
22956: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id