DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000004_PKG dependencies on AR_CUST_TRX_LINES_L_V

Line 22432: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

22428: SELECT xet.event_id event_id
22429: , l4.line_number line_number
22430: , CASE r
22431: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
22432: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
22433: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
22434: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
22435: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
22436: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

Line 22444: WHEN 14 THEN 'AR_CUST_TRX_LINES_L_V'

22440: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
22441: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
22442: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
22443: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
22444: WHEN 14 THEN 'AR_CUST_TRX_LINES_L_V'
22445: WHEN 15 THEN 'AR_TRANSACTIONS_S_V'
22446: WHEN 16 THEN 'AR_CUST_TRX_LINES_L_V'
22447: WHEN 17 THEN 'AR_TRANSACTIONS_S_V'
22448: WHEN 18 THEN 'AR_DISTRIBUTIONS_L_V'

Line 22446: WHEN 16 THEN 'AR_CUST_TRX_LINES_L_V'

22442: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
22443: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
22444: WHEN 14 THEN 'AR_CUST_TRX_LINES_L_V'
22445: WHEN 15 THEN 'AR_TRANSACTIONS_S_V'
22446: WHEN 16 THEN 'AR_CUST_TRX_LINES_L_V'
22447: WHEN 17 THEN 'AR_TRANSACTIONS_S_V'
22448: WHEN 18 THEN 'AR_DISTRIBUTIONS_L_V'
22449: WHEN 19 THEN 'AR_DISTRIBUTIONS_L_V'
22450: WHEN 20 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 22455: WHEN 25 THEN 'AR_CUST_TRX_LINES_L_V'

22451: WHEN 21 THEN 'AR_DISTRIBUTIONS_BASE_V'
22452: WHEN 22 THEN 'AR_DISTRIBUTIONS_L_V'
22453: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_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'

Line 22598: , AR_CUST_TRX_LINES_L_V l2

22594: ELSE null
22595: END source_value
22596: , null source_meaning
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

Line 22761: TYPE t_array_source_5 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

22757: TYPE t_array_source_39 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
22758: TYPE t_array_source_41 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
22759:
22760: TYPE t_array_source_1 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
22761: TYPE t_array_source_5 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
22762: TYPE t_array_source_6 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_REF_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
22763: TYPE t_array_source_7 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
22764: TYPE t_array_source_8 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
22765: TYPE t_array_source_9 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 22773: TYPE t_array_source_18 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

22769: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
22770: TYPE t_array_source_14 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
22771: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
22772: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
22773: TYPE t_array_source_18 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
22774: TYPE t_array_source_19 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
22775: TYPE t_array_source_20 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
22776: TYPE t_array_source_21 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
22777: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;

Line 22775: TYPE t_array_source_20 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

22771: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
22772: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
22773: TYPE t_array_source_18 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
22774: TYPE t_array_source_19 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
22775: TYPE t_array_source_20 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
22776: TYPE t_array_source_21 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
22777: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
22778: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
22779: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 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;

22780: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
22781: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
22782: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%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;

Line 22948: , AR_CUST_TRX_LINES_L_V l2

22944: , l3.DIST_TO_CUR_CONVERSION_TYPE source_31
22945: , l6.REC_ACT_TYPE source_32
22946: , l4.DIST_SOURCE_TABLE source_33
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