DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000006_PKG dependencies on AR_CM_LINES_L_V

Line 71695: WHEN 1 THEN 'AR_CM_LINES_L_V'

71691: FROM (
71692: SELECT xet.event_id event_id
71693: , l3.line_number line_number
71694: , CASE r
71695: WHEN 1 THEN 'AR_CM_LINES_L_V'
71696: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
71697: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
71698: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
71699: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

Line 71707: WHEN 13 THEN 'AR_CM_LINES_L_V'

71703: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
71704: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
71705: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
71706: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
71707: WHEN 13 THEN 'AR_CM_LINES_L_V'
71708: WHEN 14 THEN 'AR_CM_LINES_L_V'
71709: WHEN 15 THEN 'AR_CM_LINES_L_V'
71710:
71711: ELSE null

Line 71708: WHEN 14 THEN 'AR_CM_LINES_L_V'

71704: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
71705: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
71706: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
71707: WHEN 13 THEN 'AR_CM_LINES_L_V'
71708: WHEN 14 THEN 'AR_CM_LINES_L_V'
71709: WHEN 15 THEN 'AR_CM_LINES_L_V'
71710:
71711: ELSE null
71712: END object_name

Line 71709: WHEN 15 THEN 'AR_CM_LINES_L_V'

71705: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
71706: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
71707: WHEN 13 THEN 'AR_CM_LINES_L_V'
71708: WHEN 14 THEN 'AR_CM_LINES_L_V'
71709: WHEN 15 THEN 'AR_CM_LINES_L_V'
71710:
71711: ELSE null
71712: END object_name
71713: , CASE r

Line 71793: , AR_CM_LINES_L_V l4

71789: END source_value
71790: , null source_meaning
71791: FROM xla_events_gt xet
71792: , AR_CM_LINES_BASE_V l3
71793: , AR_CM_LINES_L_V l4
71794: , AR_DISTRIBUTIONS_L_V l6
71795: , AR_RECEIVABLES_TRX_ACT_S_V l7
71796: , (select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
71797: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 71948: TYPE t_array_source_2 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

71944: TYPE t_array_source_50 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
71945: TYPE t_array_source_51 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
71946: TYPE t_array_source_67 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
71947:
71948: TYPE t_array_source_2 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
71949: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
71950: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
71951: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
71952: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

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

71956: TYPE t_array_source_46 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
71957: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
71958: TYPE t_array_source_48 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
71959: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
71960: TYPE t_array_source_52 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
71961: TYPE t_array_source_53 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
71962: TYPE t_array_source_54 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
71963:
71964: l_array_source_12 t_array_source_12;

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

71957: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
71958: TYPE t_array_source_48 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
71959: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
71960: TYPE t_array_source_52 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
71961: TYPE t_array_source_53 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
71962: TYPE t_array_source_54 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
71963:
71964: l_array_source_12 t_array_source_12;
71965: l_array_source_18 t_array_source_18;

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

71958: TYPE t_array_source_48 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
71959: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
71960: TYPE t_array_source_52 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
71961: TYPE t_array_source_53 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
71962: TYPE t_array_source_54 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
71963:
71964: l_array_source_12 t_array_source_12;
71965: l_array_source_18 t_array_source_18;
71966: l_array_source_19 t_array_source_19;

Line 72089: , AR_CM_LINES_L_V l4

72085: , l4.CM_LINE_DIST_ACCOUNT_CLASS source_53
72086: , l4.CM_LINE_DIST_AMT source_54
72087: FROM xla_events_gt xet
72088: , AR_CM_LINES_BASE_V l3
72089: , AR_CM_LINES_L_V l4
72090: , AR_DISTRIBUTIONS_L_V l6
72091: , AR_RECEIVABLES_TRX_ACT_S_V l7
72092: WHERE xet.event_id between x_first_event_id and x_last_event_id
72093: and xet.event_date between p_pad_start_date and p_pad_end_date