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

Line 66738: WHEN 1 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'

66734: FROM (
66735: SELECT xet.event_id event_id
66736: , 0 line_number
66737: , CASE r
66738: WHEN 1 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
66739: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
66740: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
66741: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
66742: WHEN 5 THEN 'AR_ADJUSTMENTS_H_V'

Line 66798: , AR_RECEIVABLES_TRX_ACT_S_V h6

66794: FROM xla_events_gt xet
66795: , AR_ADJUSTMENTS_H_V h1
66796: , AR_BILL_TO_CUSTOMERS_S_V h2
66797: , AR_BILL_TO_SITE_USES_S_V h3
66798: , AR_RECEIVABLES_TRX_ACT_S_V h6
66799: , AR_TRANSACTIONS_S_V h7
66800: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
66801: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
66802: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 67087: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;

67083: --
67084: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
67085: --
67086:
67087: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
67088: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
67089: TYPE t_array_source_31 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
67090: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
67091: TYPE t_array_source_77 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 67165: , AR_RECEIVABLES_TRX_ACT_S_V h6

67161: FROM xla_events_gt xet
67162: , AR_ADJUSTMENTS_H_V h1
67163: , AR_BILL_TO_CUSTOMERS_S_V h2
67164: , AR_BILL_TO_SITE_USES_S_V h3
67165: , AR_RECEIVABLES_TRX_ACT_S_V h6
67166: , AR_TRANSACTIONS_S_V h7
67167: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
67168: and xet.event_class_code = C_EVENT_CLASS_CODE
67169: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 69570: WHEN 7 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'

69566: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
69567: WHEN 4 THEN 'AR_CM_LINES_L_V'
69568: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
69569: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
69570: WHEN 7 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
69571: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
69572: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
69573: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
69574: WHEN 11 THEN 'AR_CM_LINES_BASE_V'

Line 69679: , AR_RECEIVABLES_TRX_ACT_S_V l7

69675: FROM xla_events_gt xet
69676: , AR_CM_LINES_BASE_V l3
69677: , AR_CM_LINES_L_V l4
69678: , AR_DISTRIBUTIONS_L_V l6
69679: , AR_RECEIVABLES_TRX_ACT_S_V l7
69680: , AR_TRANSACTIONS_S_V l9
69681: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
69682: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69683: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 69839: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;

69835: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
69836: TYPE t_array_source_4 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
69837: TYPE t_array_source_5 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
69838: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
69839: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
69840: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
69841: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
69842: TYPE t_array_source_43 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
69843: TYPE t_array_source_45 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 69981: , AR_RECEIVABLES_TRX_ACT_S_V l7

69977: FROM xla_events_gt xet
69978: , AR_CM_LINES_BASE_V l3
69979: , AR_CM_LINES_L_V l4
69980: , AR_DISTRIBUTIONS_L_V l6
69981: , AR_RECEIVABLES_TRX_ACT_S_V l7
69982: , AR_TRANSACTIONS_S_V l9
69983: WHERE xet.event_id between x_first_event_id and x_last_event_id
69984: and xet.event_date between p_pad_start_date and p_pad_end_date
69985: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 78730: WHEN 13 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'

78726: WHEN 9 THEN 'FV_XLA_AR_REF_V'
78727: WHEN 10 THEN 'FV_XLA_AR_REF_V'
78728: WHEN 11 THEN 'FV_XLA_AR_REF_V'
78729: WHEN 12 THEN 'AR_DISTRIBUTIONS_L_V'
78730: WHEN 13 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
78731: WHEN 14 THEN 'AR_DISTRIBUTIONS_L_V'
78732: WHEN 15 THEN 'AR_DISTRIBUTIONS_L_V'
78733: WHEN 16 THEN 'AR_DISTRIBUTIONS_L_V'
78734: WHEN 17 THEN 'AR_DISTRIBUTIONS_L_V'

Line 78934: , AR_RECEIVABLES_TRX_ACT_S_V l7

78930: , AR_BILL_TO_CUSTOMERS_S_V l1
78931: , AR_CUST_TRX_LINES_L_V l3
78932: , AR_DISTRIBUTIONS_BASE_V l4
78933: , AR_DISTRIBUTIONS_L_V l5
78934: , AR_RECEIVABLES_TRX_ACT_S_V l7
78935: , AR_TRANSACTIONS_S_V l10
78936: , FV_XLA_AR_REF_V l11
78937: , (select rownum r from all_objects where rownum <= 38 and owner = p_apps_owner)
78938: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 79111: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;

79107: TYPE t_array_source_13 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
79108: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
79109: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79110: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
79111: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
79112: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
79113: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79114: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
79115: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 79324: , AR_RECEIVABLES_TRX_ACT_S_V l7

79320: , AR_BILL_TO_CUSTOMERS_S_V l1
79321: , AR_CUST_TRX_LINES_L_V l3
79322: , AR_DISTRIBUTIONS_BASE_V l4
79323: , AR_DISTRIBUTIONS_L_V l5
79324: , AR_RECEIVABLES_TRX_ACT_S_V l7
79325: , AR_TRANSACTIONS_S_V l10
79326: , FV_XLA_AR_REF_V l11
79327: WHERE xet.event_id between x_first_event_id and x_last_event_id
79328: and xet.event_date between p_pad_start_date and p_pad_end_date