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

Line 63049: WHEN 1 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'

63045: FROM (
63046: SELECT xet.event_id event_id
63047: , 0 line_number
63048: , CASE r
63049: WHEN 1 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
63050: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
63051: WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
63052: WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
63053: WHEN 5 THEN 'AR_ADJUSTMENTS_H_V'

Line 63109: , AR_RECEIVABLES_TRX_ACT_S_V h6

63105: FROM xla_events_gt xet
63106: , AR_ADJUSTMENTS_H_V h1
63107: , AR_BILL_TO_CUSTOMERS_S_V h2
63108: , AR_BILL_TO_SITE_USES_S_V h3
63109: , AR_RECEIVABLES_TRX_ACT_S_V h6
63110: , AR_TRANSACTIONS_S_V h7
63111: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
63112: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
63113: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 63398: TYPE t_array_source_28 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;

63394: --
63395: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
63396: --
63397:
63398: TYPE t_array_source_28 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
63399: TYPE t_array_source_37 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
63400: TYPE t_array_source_38 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
63401: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
63402: TYPE t_array_source_107 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 63476: , AR_RECEIVABLES_TRX_ACT_S_V h6

63472: FROM xla_events_gt xet
63473: , AR_ADJUSTMENTS_H_V h1
63474: , AR_BILL_TO_CUSTOMERS_S_V h2
63475: , AR_BILL_TO_SITE_USES_S_V h3
63476: , AR_RECEIVABLES_TRX_ACT_S_V h6
63477: , AR_TRANSACTIONS_S_V h7
63478: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
63479: and xet.event_class_code = C_EVENT_CLASS_CODE
63480: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 68923: WHEN 7 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'

68919: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
68920: WHEN 4 THEN 'AR_CM_LINES_L_V'
68921: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
68922: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
68923: WHEN 7 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
68924: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
68925: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
68926: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
68927: WHEN 11 THEN 'AR_CM_LINES_BASE_V'

Line 69038: , AR_RECEIVABLES_TRX_ACT_S_V l8

69034: , AR_CM_LINES_BASE_V l3
69035: , AR_CM_LINES_L_V l4
69036: , AR_CUST_TRX_LINES_L_V l6
69037: , AR_DISTRIBUTIONS_L_V l7
69038: , AR_RECEIVABLES_TRX_ACT_S_V l8
69039: , AR_TRANSACTIONS_S_V l10
69040: , (select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
69041: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69042: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 69200: TYPE t_array_source_28 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;

69196: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
69197: TYPE t_array_source_14 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
69198: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
69199: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
69200: TYPE t_array_source_28 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
69201: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
69202: TYPE t_array_source_52 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
69203: TYPE t_array_source_53 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
69204: TYPE t_array_source_55 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 69346: , AR_RECEIVABLES_TRX_ACT_S_V l8

69342: , AR_CM_LINES_BASE_V l3
69343: , AR_CM_LINES_L_V l4
69344: , AR_CUST_TRX_LINES_L_V l6
69345: , AR_DISTRIBUTIONS_L_V l7
69346: , AR_RECEIVABLES_TRX_ACT_S_V l8
69347: , AR_TRANSACTIONS_S_V l10
69348: WHERE xet.event_id between x_first_event_id and x_last_event_id
69349: and xet.event_date between p_pad_start_date and p_pad_end_date
69350: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 79460: WHEN 6 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'

79456: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
79457: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
79458: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
79459: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
79460: WHEN 6 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
79461: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
79462: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
79463: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
79464: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'

Line 79484: WHEN 30 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'

79480: WHEN 26 THEN 'AR_DISTRIBUTIONS_L_V'
79481: WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V'
79482: WHEN 28 THEN 'AR_DISTRIBUTIONS_BASE_V'
79483: WHEN 29 THEN 'AR_DISTRIBUTIONS_L_V'
79484: WHEN 30 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
79485:
79486: ELSE null
79487: END object_name
79488: , CASE r

Line 79630: , AR_RECEIVABLES_TRX_ACT_S_V l7

79626: FROM xla_events_gt xet
79627: , AR_CUST_TRX_LINES_L_V l2
79628: , AR_DISTRIBUTIONS_BASE_V l3
79629: , AR_DISTRIBUTIONS_L_V l4
79630: , AR_RECEIVABLES_TRX_ACT_S_V l7
79631: , AR_TRANSACTIONS_S_V l10
79632: , (select rownum r from all_objects where rownum <= 30 and owner = p_apps_owner)
79633: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
79634: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 79800: TYPE t_array_source_28 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;

79796: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
79797: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79798: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
79799: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
79800: TYPE t_array_source_28 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
79801: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
79802: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79803: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
79804: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 79824: TYPE t_array_source_103 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_NAME%TYPE INDEX BY BINARY_INTEGER;

79820: TYPE t_array_source_99 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
79821: TYPE t_array_source_100 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79822: TYPE t_array_source_101 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79823: TYPE t_array_source_102 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;
79824: TYPE t_array_source_103 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_NAME%TYPE INDEX BY BINARY_INTEGER;
79825:
79826: l_array_source_8 t_array_source_8;
79827: l_array_source_9 t_array_source_9;
79828: l_array_source_10 t_array_source_10;

Line 80003: , AR_RECEIVABLES_TRX_ACT_S_V l7

79999: FROM xla_events_gt xet
80000: , AR_CUST_TRX_LINES_L_V l2
80001: , AR_DISTRIBUTIONS_BASE_V l3
80002: , AR_DISTRIBUTIONS_L_V l4
80003: , AR_RECEIVABLES_TRX_ACT_S_V l7
80004: , AR_TRANSACTIONS_S_V l10
80005: WHERE xet.event_id between x_first_event_id and x_last_event_id
80006: and xet.event_date between p_pad_start_date and p_pad_end_date
80007: and xet.event_class_code = C_EVENT_CLASS_CODE