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

Line 66548: WHEN 3 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'

66544: , 0 line_number
66545: , CASE r
66546: WHEN 1 THEN 'AR_ADJUSTMENTS_H_V'
66547: WHEN 2 THEN 'AR_ADJUSTMENTS_H_V'
66548: WHEN 3 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
66549: WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
66550: WHEN 5 THEN 'AR_BILL_TO_SITE_USES_S_V'
66551: WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
66552: WHEN 7 THEN 'AR_ADJUSTMENTS_H_V'

Line 66611: , AR_RECEIVABLES_TRX_ACT_S_V h6

66607: FROM xla_events_gt xet
66608: , AR_ADJUSTMENTS_H_V h1
66609: , AR_BILL_TO_CUSTOMERS_S_V h2
66610: , AR_BILL_TO_SITE_USES_S_V h3
66611: , AR_RECEIVABLES_TRX_ACT_S_V h6
66612: , AR_TRANSACTIONS_S_V h7
66613: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
66614: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
66615: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 66902: TYPE t_array_source_40 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;

66898: --
66899:
66900: TYPE t_array_source_1 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_NUMBER%TYPE INDEX BY BINARY_INTEGER;
66901: TYPE t_array_source_2 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
66902: TYPE t_array_source_40 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
66903: TYPE t_array_source_49 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
66904: TYPE t_array_source_50 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
66905: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
66906: TYPE t_array_source_117 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 66981: , AR_RECEIVABLES_TRX_ACT_S_V h6

66977: FROM xla_events_gt xet
66978: , AR_ADJUSTMENTS_H_V h1
66979: , AR_BILL_TO_CUSTOMERS_S_V h2
66980: , AR_BILL_TO_SITE_USES_S_V h3
66981: , AR_RECEIVABLES_TRX_ACT_S_V h6
66982: , AR_TRANSACTIONS_S_V h7
66983: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
66984: and xet.event_class_code = C_EVENT_CLASS_CODE
66985: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 72598: WHEN 7 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'

72594: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
72595: WHEN 4 THEN 'AR_CM_LINES_L_V'
72596: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
72597: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
72598: WHEN 7 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
72599: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
72600: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
72601: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
72602: WHEN 11 THEN 'AR_CM_LINES_BASE_V'

Line 72707: , AR_RECEIVABLES_TRX_ACT_S_V l7

72703: FROM xla_events_gt xet
72704: , AR_CM_LINES_BASE_V l3
72705: , AR_CM_LINES_L_V l4
72706: , AR_DISTRIBUTIONS_L_V l6
72707: , AR_RECEIVABLES_TRX_ACT_S_V l7
72708: , AR_TRANSACTIONS_S_V l9
72709: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
72710: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
72711: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 72870: TYPE t_array_source_40 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;

72866: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
72867: TYPE t_array_source_24 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
72868: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
72869: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72870: TYPE t_array_source_40 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
72871: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
72872: TYPE t_array_source_64 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
72873: TYPE t_array_source_65 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
72874: TYPE t_array_source_67 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 73018: , AR_RECEIVABLES_TRX_ACT_S_V l7

73014: FROM xla_events_gt xet
73015: , AR_CM_LINES_BASE_V l3
73016: , AR_CM_LINES_L_V l4
73017: , AR_DISTRIBUTIONS_L_V l6
73018: , AR_RECEIVABLES_TRX_ACT_S_V l7
73019: , AR_TRANSACTIONS_S_V l9
73020: WHERE xet.event_id between x_first_event_id and x_last_event_id
73021: and xet.event_date between p_pad_start_date and p_pad_end_date
73022: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 83404: WHEN 7 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'

83400: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
83401: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
83402: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
83403: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
83404: WHEN 7 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
83405: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
83406: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
83407: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
83408: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'

Line 83573: , AR_RECEIVABLES_TRX_ACT_S_V l7

83569: FROM xla_events_gt xet
83570: , AR_CUST_TRX_LINES_L_V l2
83571: , AR_DISTRIBUTIONS_BASE_V l3
83572: , AR_DISTRIBUTIONS_L_V l4
83573: , AR_RECEIVABLES_TRX_ACT_S_V l7
83574: , AR_TRANSACTIONS_S_V l10
83575: , (select rownum r from all_objects where rownum <= 30 and owner = p_apps_owner)
83576: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
83577: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 83746: TYPE t_array_source_40 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;

83742: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
83743: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
83744: TYPE t_array_source_33 IS TABLE OF AR_DISTRIBUTIONS_L_V.GAIN_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
83745: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
83746: TYPE t_array_source_40 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
83747: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
83748: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
83749: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
83750: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 83952: , AR_RECEIVABLES_TRX_ACT_S_V l7

83948: FROM xla_events_gt xet
83949: , AR_CUST_TRX_LINES_L_V l2
83950: , AR_DISTRIBUTIONS_BASE_V l3
83951: , AR_DISTRIBUTIONS_L_V l4
83952: , AR_RECEIVABLES_TRX_ACT_S_V l7
83953: , AR_TRANSACTIONS_S_V l10
83954: WHERE xet.event_id between x_first_event_id and x_last_event_id
83955: and xet.event_date between p_pad_start_date and p_pad_end_date
83956: and xet.event_class_code = C_EVENT_CLASS_CODE