DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000005_PKG dependencies on AR_CM_LINES_L_V

Line 69567: WHEN 4 THEN 'AR_CM_LINES_L_V'

69563: , CASE r
69564: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
69565: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
69566: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
69567: WHEN 4 THEN 'AR_CM_LINES_L_V'
69568: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
69569: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
69570: WHEN 7 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
69571: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'

Line 69579: WHEN 16 THEN 'AR_CM_LINES_L_V'

69575: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
69576: WHEN 13 THEN 'AR_CM_LINES_BASE_V'
69577: WHEN 14 THEN 'AR_CM_LINES_BASE_V'
69578: WHEN 15 THEN 'AR_CM_LINES_BASE_V'
69579: WHEN 16 THEN 'AR_CM_LINES_L_V'
69580: WHEN 17 THEN 'AR_CM_LINES_L_V'
69581: WHEN 18 THEN 'AR_CM_LINES_L_V'
69582:
69583: ELSE null

Line 69580: WHEN 17 THEN 'AR_CM_LINES_L_V'

69576: WHEN 13 THEN 'AR_CM_LINES_BASE_V'
69577: WHEN 14 THEN 'AR_CM_LINES_BASE_V'
69578: WHEN 15 THEN 'AR_CM_LINES_BASE_V'
69579: WHEN 16 THEN 'AR_CM_LINES_L_V'
69580: WHEN 17 THEN 'AR_CM_LINES_L_V'
69581: WHEN 18 THEN 'AR_CM_LINES_L_V'
69582:
69583: ELSE null
69584: END object_name

Line 69581: WHEN 18 THEN 'AR_CM_LINES_L_V'

69577: WHEN 14 THEN 'AR_CM_LINES_BASE_V'
69578: WHEN 15 THEN 'AR_CM_LINES_BASE_V'
69579: WHEN 16 THEN 'AR_CM_LINES_L_V'
69580: WHEN 17 THEN 'AR_CM_LINES_L_V'
69581: WHEN 18 THEN 'AR_CM_LINES_L_V'
69582:
69583: ELSE null
69584: END object_name
69585: , CASE r

Line 69677: , AR_CM_LINES_L_V l4

69673: END source_value
69674: , null source_meaning
69675: FROM xla_events_gt xet
69676: , AR_CM_LINES_BASE_V l3
69677: , AR_CM_LINES_L_V l4
69678: , AR_DISTRIBUTIONS_L_V l6
69679: , AR_RECEIVABLES_TRX_ACT_S_V l7
69680: , AR_TRANSACTIONS_S_V l9
69681: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)

Line 69836: TYPE t_array_source_4 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

69832:
69833: TYPE t_array_source_1 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
69834: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
69835: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
69836: TYPE t_array_source_4 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
69837: TYPE t_array_source_5 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
69838: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
69839: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
69840: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 69848: TYPE t_array_source_52 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

69844: TYPE t_array_source_46 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
69845: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69846: TYPE t_array_source_48 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
69847: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
69848: TYPE t_array_source_52 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
69849: TYPE t_array_source_53 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
69850: TYPE t_array_source_54 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
69851:
69852: l_array_source_7 t_array_source_7;

Line 69849: TYPE t_array_source_53 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

69845: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69846: TYPE t_array_source_48 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
69847: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
69848: TYPE t_array_source_52 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
69849: TYPE t_array_source_53 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
69850: TYPE t_array_source_54 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
69851:
69852: l_array_source_7 t_array_source_7;
69853: l_array_source_8 t_array_source_8;

Line 69850: TYPE t_array_source_54 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

69846: TYPE t_array_source_48 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
69847: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
69848: TYPE t_array_source_52 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
69849: TYPE t_array_source_53 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
69850: TYPE t_array_source_54 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
69851:
69852: l_array_source_7 t_array_source_7;
69853: l_array_source_8 t_array_source_8;
69854: l_array_source_32 t_array_source_32;

Line 69979: , AR_CM_LINES_L_V l4

69975: , l4.CM_LINE_DIST_ACCOUNT_CLASS source_53
69976: , l4.CM_LINE_DIST_AMT source_54
69977: FROM xla_events_gt xet
69978: , AR_CM_LINES_BASE_V l3
69979: , AR_CM_LINES_L_V l4
69980: , AR_DISTRIBUTIONS_L_V l6
69981: , AR_RECEIVABLES_TRX_ACT_S_V l7
69982: , AR_TRANSACTIONS_S_V l9
69983: WHERE xet.event_id between x_first_event_id and x_last_event_id