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

Line 67700: WHEN 2 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'

67696: SELECT xet.event_id event_id
67697: , 0 line_number
67698: , CASE r
67699: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
67700: WHEN 2 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
67701: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
67702: WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'
67703: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
67704: WHEN 6 THEN 'AR_ADJUSTMENTS_H_V'

Line 67764: , AR_RECEIVABLES_TRX_ACT_S_V h6

67760: FROM xla_events_gt xet
67761: , AR_ADJUSTMENTS_H_V h1
67762: , AR_BILL_TO_CUSTOMERS_S_V h2
67763: , AR_BILL_TO_SITE_USES_S_V h3
67764: , AR_RECEIVABLES_TRX_ACT_S_V h6
67765: , AR_TRANSACTIONS_S_V h7
67766: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
67767: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
67768: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 68054: TYPE t_array_source_23 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;

68050: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
68051: --
68052:
68053: TYPE t_array_source_8 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
68054: TYPE t_array_source_23 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
68055: TYPE t_array_source_32 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
68056: TYPE t_array_source_33 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
68057: TYPE t_array_source_34 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
68058: TYPE t_array_source_81 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 68134: , AR_RECEIVABLES_TRX_ACT_S_V h6

68130: FROM xla_events_gt xet
68131: , AR_ADJUSTMENTS_H_V h1
68132: , AR_BILL_TO_CUSTOMERS_S_V h2
68133: , AR_BILL_TO_SITE_USES_S_V h3
68134: , AR_RECEIVABLES_TRX_ACT_S_V h6
68135: , AR_TRANSACTIONS_S_V h7
68136: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
68137: and xet.event_class_code = C_EVENT_CLASS_CODE
68138: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 70457: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'

70453: , CASE r
70454: WHEN 1 THEN 'AR_CM_LINES_L_V'
70455: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
70456: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
70457: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
70458: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
70459: WHEN 6 THEN 'AR_CM_LINES_BASE_V'
70460: WHEN 7 THEN 'AR_CM_LINES_BASE_V'
70461: WHEN 8 THEN 'AR_CM_LINES_BASE_V'

Line 70554: , AR_RECEIVABLES_TRX_ACT_S_V l7

70550: FROM xla_events_gt xet
70551: , AR_CM_LINES_BASE_V l3
70552: , AR_CM_LINES_L_V l4
70553: , AR_DISTRIBUTIONS_L_V l6
70554: , AR_RECEIVABLES_TRX_ACT_S_V l7
70555: , (select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
70556: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
70557: AND xet.event_class_code = C_EVENT_CLASS_CODE
70558: AND l3.event_id = xet.event_id

Line 70710: TYPE t_array_source_23 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;

70706:
70707: TYPE t_array_source_9 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
70708: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
70709: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70710: TYPE t_array_source_23 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
70711: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
70712: TYPE t_array_source_44 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
70713: TYPE t_array_source_45 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
70714: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 70850: , AR_RECEIVABLES_TRX_ACT_S_V l7

70846: FROM xla_events_gt xet
70847: , AR_CM_LINES_BASE_V l3
70848: , AR_CM_LINES_L_V l4
70849: , AR_DISTRIBUTIONS_L_V l6
70850: , AR_RECEIVABLES_TRX_ACT_S_V l7
70851: WHERE xet.event_id between x_first_event_id and x_last_event_id
70852: and xet.event_date between p_pad_start_date and p_pad_end_date
70853: and xet.event_class_code = C_EVENT_CLASS_CODE
70854: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 79524: WHEN 10 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'

79520: WHEN 6 THEN 'FV_XLA_AR_REF_V'
79521: WHEN 7 THEN 'FV_XLA_AR_REF_V'
79522: WHEN 8 THEN 'AR_CUST_TRX_LINES_L_V'
79523: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
79524: WHEN 10 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
79525: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
79526: WHEN 12 THEN 'AR_DISTRIBUTIONS_L_V'
79527: WHEN 13 THEN 'AR_DISTRIBUTIONS_L_V'
79528: WHEN 14 THEN 'AR_DISTRIBUTIONS_L_V'

Line 79716: , AR_RECEIVABLES_TRX_ACT_S_V l8

79712: , AR_BILL_TO_CUSTOMERS_S_V l1
79713: , AR_CUST_TRX_LINES_L_V l3
79714: , AR_DISTRIBUTIONS_BASE_V l4
79715: , AR_DISTRIBUTIONS_L_V l5
79716: , AR_RECEIVABLES_TRX_ACT_S_V l8
79717: , AR_TRANSACTIONS_S_V l11
79718: , FV_XLA_AR_REF_V l12
79719: , (select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)
79720: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 79895: TYPE t_array_source_23 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;

79891: TYPE t_array_source_16 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
79892: TYPE t_array_source_17 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79893: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
79894: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
79895: TYPE t_array_source_23 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
79896: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
79897: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79898: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
79899: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 80114: , AR_RECEIVABLES_TRX_ACT_S_V l8

80110: , AR_BILL_TO_CUSTOMERS_S_V l1
80111: , AR_CUST_TRX_LINES_L_V l3
80112: , AR_DISTRIBUTIONS_BASE_V l4
80113: , AR_DISTRIBUTIONS_L_V l5
80114: , AR_RECEIVABLES_TRX_ACT_S_V l8
80115: , AR_TRANSACTIONS_S_V l11
80116: , FV_XLA_AR_REF_V l12
80117: WHERE xet.event_id between x_first_event_id and x_last_event_id
80118: and xet.event_date between p_pad_start_date and p_pad_end_date