DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000004_PKG dependencies on AR_RECEIVABLES_TRX_ACT_S_V

Line 22458: WHEN 28 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'

22454: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'
22455: WHEN 25 THEN 'AR_CUST_TRX_LINES_L_V'
22456: WHEN 26 THEN 'AR_DISTRIBUTIONS_BASE_V'
22457: WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V'
22458: WHEN 28 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
22459: WHEN 29 THEN 'AR_DISTRIBUTIONS_L_V'
22460:
22461: ELSE null
22462: END object_name

Line 22601: , AR_RECEIVABLES_TRX_ACT_S_V l6

22597: FROM xla_events_gt xet
22598: , AR_CUST_TRX_LINES_L_V l2
22599: , AR_DISTRIBUTIONS_BASE_V l3
22600: , AR_DISTRIBUTIONS_L_V l4
22601: , AR_RECEIVABLES_TRX_ACT_S_V l6
22602: , AR_TRANSACTIONS_S_V l9
22603: , (select rownum r from all_objects where rownum <= 29 and owner = p_apps_owner)
22604: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
22605: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 22787: TYPE t_array_source_32 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;

22783: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
22784: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
22785: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
22786: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
22787: TYPE t_array_source_32 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
22788: TYPE t_array_source_33 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;
22789:
22790: l_array_source_2 t_array_source_2;
22791: l_array_source_3 t_array_source_3;

Line 22951: , AR_RECEIVABLES_TRX_ACT_S_V l6

22947: FROM xla_events_gt xet
22948: , AR_CUST_TRX_LINES_L_V l2
22949: , AR_DISTRIBUTIONS_BASE_V l3
22950: , AR_DISTRIBUTIONS_L_V l4
22951: , AR_RECEIVABLES_TRX_ACT_S_V l6
22952: , AR_TRANSACTIONS_S_V l9
22953: WHERE xet.event_id between x_first_event_id and x_last_event_id
22954: and xet.event_date between p_pad_start_date and p_pad_end_date
22955: and xet.event_class_code = C_EVENT_CLASS_CODE