DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000002_PKG dependencies on AR_CM_LINES_L_V

Line 72595: WHEN 4 THEN 'AR_CM_LINES_L_V'

72591: , CASE r
72592: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
72593: WHEN 2 THEN 'AR_TRANSACTIONS_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'

Line 72607: WHEN 16 THEN 'AR_CM_LINES_L_V'

72603: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
72604: WHEN 13 THEN 'AR_CM_LINES_BASE_V'
72605: WHEN 14 THEN 'AR_CM_LINES_BASE_V'
72606: WHEN 15 THEN 'AR_CM_LINES_BASE_V'
72607: WHEN 16 THEN 'AR_CM_LINES_L_V'
72608: WHEN 17 THEN 'AR_CM_LINES_L_V'
72609: WHEN 18 THEN 'AR_CM_LINES_L_V'
72610:
72611: ELSE null

Line 72608: WHEN 17 THEN 'AR_CM_LINES_L_V'

72604: WHEN 13 THEN 'AR_CM_LINES_BASE_V'
72605: WHEN 14 THEN 'AR_CM_LINES_BASE_V'
72606: WHEN 15 THEN 'AR_CM_LINES_BASE_V'
72607: WHEN 16 THEN 'AR_CM_LINES_L_V'
72608: WHEN 17 THEN 'AR_CM_LINES_L_V'
72609: WHEN 18 THEN 'AR_CM_LINES_L_V'
72610:
72611: ELSE null
72612: END object_name

Line 72609: WHEN 18 THEN 'AR_CM_LINES_L_V'

72605: WHEN 14 THEN 'AR_CM_LINES_BASE_V'
72606: WHEN 15 THEN 'AR_CM_LINES_BASE_V'
72607: WHEN 16 THEN 'AR_CM_LINES_L_V'
72608: WHEN 17 THEN 'AR_CM_LINES_L_V'
72609: WHEN 18 THEN 'AR_CM_LINES_L_V'
72610:
72611: ELSE null
72612: END object_name
72613: , CASE r

Line 72705: , AR_CM_LINES_L_V l4

72701: END source_value
72702: , null source_meaning
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)

Line 72867: TYPE t_array_source_24 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

72863:
72864: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
72865: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%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;

Line 72879: TYPE t_array_source_74 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

72875: TYPE t_array_source_68 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
72876: TYPE t_array_source_69 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
72877: TYPE t_array_source_70 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
72878: TYPE t_array_source_71 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
72879: TYPE t_array_source_74 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
72880: TYPE t_array_source_75 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72881: TYPE t_array_source_76 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
72882:
72883: l_array_source_7 t_array_source_7;

Line 72880: TYPE t_array_source_75 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

72876: TYPE t_array_source_69 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
72877: TYPE t_array_source_70 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
72878: TYPE t_array_source_71 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
72879: TYPE t_array_source_74 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
72880: TYPE t_array_source_75 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72881: TYPE t_array_source_76 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
72882:
72883: l_array_source_7 t_array_source_7;
72884: l_array_source_8 t_array_source_8;

Line 72881: TYPE t_array_source_76 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

72877: TYPE t_array_source_70 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
72878: TYPE t_array_source_71 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
72879: TYPE t_array_source_74 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
72880: TYPE t_array_source_75 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72881: TYPE t_array_source_76 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
72882:
72883: l_array_source_7 t_array_source_7;
72884: l_array_source_8 t_array_source_8;
72885: l_array_source_9 t_array_source_9;

Line 73016: , AR_CM_LINES_L_V l4

73012: , l4.CM_LINE_DIST_ACCOUNT_CLASS source_75
73013: , l4.CM_LINE_DIST_AMT source_76
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