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

Line 68910: WHEN 2 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'

68906: SELECT xet.event_id event_id
68907: , 0 line_number
68908: , CASE r
68909: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
68910: WHEN 2 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
68911: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
68912: WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'
68913: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
68914: WHEN 6 THEN 'AR_ADJUSTMENTS_H_V'

Line 68974: , AR_RECEIVABLES_TRX_ACT_S_V h6

68970: FROM xla_events_gt xet
68971: , AR_ADJUSTMENTS_H_V h1
68972: , AR_BILL_TO_CUSTOMERS_S_V h2
68973: , AR_BILL_TO_SITE_USES_S_V h3
68974: , AR_RECEIVABLES_TRX_ACT_S_V h6
68975: , AR_TRANSACTIONS_S_V h7
68976: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
68977: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68978: AND xet.event_class_code = C_EVENT_CLASS_CODE

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

69260: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
69261: --
69262:
69263: TYPE t_array_source_16 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
69264: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
69265: TYPE t_array_source_30 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
69266: 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;
69267: TYPE t_array_source_32 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
69268: TYPE t_array_source_79 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 69344: , AR_RECEIVABLES_TRX_ACT_S_V h6

69340: FROM xla_events_gt xet
69341: , AR_ADJUSTMENTS_H_V h1
69342: , AR_BILL_TO_CUSTOMERS_S_V h2
69343: , AR_BILL_TO_SITE_USES_S_V h3
69344: , AR_RECEIVABLES_TRX_ACT_S_V h6
69345: , AR_TRANSACTIONS_S_V h7
69346: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
69347: and xet.event_class_code = C_EVENT_CLASS_CODE
69348: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 71698: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'

71694: , CASE r
71695: WHEN 1 THEN 'AR_CM_LINES_L_V'
71696: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
71697: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
71698: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
71699: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
71700: WHEN 6 THEN 'AR_CM_LINES_BASE_V'
71701: WHEN 7 THEN 'AR_CM_LINES_BASE_V'
71702: WHEN 8 THEN 'AR_CM_LINES_BASE_V'

Line 71795: , AR_RECEIVABLES_TRX_ACT_S_V l7

71791: FROM xla_events_gt xet
71792: , AR_CM_LINES_BASE_V l3
71793: , AR_CM_LINES_L_V l4
71794: , AR_DISTRIBUTIONS_L_V l6
71795: , AR_RECEIVABLES_TRX_ACT_S_V l7
71796: , (select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
71797: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
71798: AND xet.event_class_code = C_EVENT_CLASS_CODE
71799: AND l3.event_id = xet.event_id

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

71947:
71948: TYPE t_array_source_2 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
71949: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
71950: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
71951: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
71952: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
71953: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
71954: TYPE t_array_source_43 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
71955: TYPE t_array_source_45 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 72091: , AR_RECEIVABLES_TRX_ACT_S_V l7

72087: FROM xla_events_gt xet
72088: , AR_CM_LINES_BASE_V l3
72089: , AR_CM_LINES_L_V l4
72090: , AR_DISTRIBUTIONS_L_V l6
72091: , AR_RECEIVABLES_TRX_ACT_S_V l7
72092: WHERE xet.event_id between x_first_event_id and x_last_event_id
72093: and xet.event_date between p_pad_start_date and p_pad_end_date
72094: and xet.event_class_code = C_EVENT_CLASS_CODE
72095: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 80765: WHEN 10 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'

80761: WHEN 6 THEN 'FV_XLA_AR_REF_V'
80762: WHEN 7 THEN 'FV_XLA_AR_REF_V'
80763: WHEN 8 THEN 'FV_XLA_AR_REF_V'
80764: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
80765: WHEN 10 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
80766: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
80767: WHEN 12 THEN 'AR_DISTRIBUTIONS_L_V'
80768: WHEN 13 THEN 'AR_DISTRIBUTIONS_L_V'
80769: WHEN 14 THEN 'AR_DISTRIBUTIONS_L_V'

Line 80957: , AR_RECEIVABLES_TRX_ACT_S_V l8

80953: , AR_BILL_TO_CUSTOMERS_S_V l1
80954: , AR_CUST_TRX_LINES_L_V l3
80955: , AR_DISTRIBUTIONS_BASE_V l4
80956: , AR_DISTRIBUTIONS_L_V l5
80957: , AR_RECEIVABLES_TRX_ACT_S_V l8
80958: , AR_TRANSACTIONS_S_V l11
80959: , FV_XLA_AR_REF_V l12
80960: , (select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)
80961: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

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

81130: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
81131: TYPE t_array_source_10 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
81132: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
81133: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
81134: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
81135: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
81136: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
81137: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
81138: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 81349: , AR_RECEIVABLES_TRX_ACT_S_V l8

81345: , AR_BILL_TO_CUSTOMERS_S_V l1
81346: , AR_CUST_TRX_LINES_L_V l3
81347: , AR_DISTRIBUTIONS_BASE_V l4
81348: , AR_DISTRIBUTIONS_L_V l5
81349: , AR_RECEIVABLES_TRX_ACT_S_V l8
81350: , AR_TRANSACTIONS_S_V l11
81351: , FV_XLA_AR_REF_V l12
81352: WHERE xet.event_id between x_first_event_id and x_last_event_id
81353: and xet.event_date between p_pad_start_date and p_pad_end_date