DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000007_PKG dependencies on AR_CM_LINES_L_V

Line 55838: WHEN 1 THEN 'AR_CM_LINES_L_V'

55834: FROM (
55835: SELECT xet.event_id event_id
55836: , l3.line_number line_number
55837: , CASE r
55838: WHEN 1 THEN 'AR_CM_LINES_L_V'
55839: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
55840: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
55841: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
55842: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

Line 55850: WHEN 13 THEN 'AR_CM_LINES_L_V'

55846: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
55847: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
55848: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
55849: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
55850: WHEN 13 THEN 'AR_CM_LINES_L_V'
55851: WHEN 14 THEN 'AR_CM_LINES_L_V'
55852: WHEN 15 THEN 'AR_CM_LINES_L_V'
55853:
55854: ELSE null

Line 55851: WHEN 14 THEN 'AR_CM_LINES_L_V'

55847: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
55848: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
55849: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
55850: WHEN 13 THEN 'AR_CM_LINES_L_V'
55851: WHEN 14 THEN 'AR_CM_LINES_L_V'
55852: WHEN 15 THEN 'AR_CM_LINES_L_V'
55853:
55854: ELSE null
55855: END object_name

Line 55852: WHEN 15 THEN 'AR_CM_LINES_L_V'

55848: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
55849: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
55850: WHEN 13 THEN 'AR_CM_LINES_L_V'
55851: WHEN 14 THEN 'AR_CM_LINES_L_V'
55852: WHEN 15 THEN 'AR_CM_LINES_L_V'
55853:
55854: ELSE null
55855: END object_name
55856: , CASE r

Line 55936: , AR_CM_LINES_L_V l4

55932: END source_value
55933: , null source_meaning
55934: FROM xla_events_gt xet
55935: , AR_CM_LINES_BASE_V l3
55936: , AR_CM_LINES_L_V l4
55937: , AR_DISTRIBUTIONS_L_V l6
55938: , AR_RECEIVABLES_TRX_ACT_S_V l7
55939: , (select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
55940: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 56091: TYPE t_array_source_9 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

56087: TYPE t_array_source_45 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
56088: TYPE t_array_source_46 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
56089: TYPE t_array_source_52 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
56090:
56091: TYPE t_array_source_9 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
56092: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
56093: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
56094: TYPE t_array_source_16 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
56095: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 56103: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

56099: TYPE t_array_source_41 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
56100: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
56101: TYPE t_array_source_43 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
56102: TYPE t_array_source_44 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
56103: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
56104: TYPE t_array_source_48 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
56105: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
56106:
56107: l_array_source_2 t_array_source_2;

Line 56104: TYPE t_array_source_48 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

56100: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
56101: TYPE t_array_source_43 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
56102: TYPE t_array_source_44 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
56103: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
56104: TYPE t_array_source_48 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
56105: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
56106:
56107: l_array_source_2 t_array_source_2;
56108: l_array_source_12 t_array_source_12;

Line 56105: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

56101: TYPE t_array_source_43 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
56102: TYPE t_array_source_44 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
56103: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
56104: TYPE t_array_source_48 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
56105: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
56106:
56107: l_array_source_2 t_array_source_2;
56108: l_array_source_12 t_array_source_12;
56109: l_array_source_13 t_array_source_13;

Line 56232: , AR_CM_LINES_L_V l4

56228: , l4.CM_LINE_DIST_ACCOUNT_CLASS source_48
56229: , l4.CM_LINE_DIST_AMT source_49
56230: FROM xla_events_gt xet
56231: , AR_CM_LINES_BASE_V l3
56232: , AR_CM_LINES_L_V l4
56233: , AR_DISTRIBUTIONS_L_V l6
56234: , AR_RECEIVABLES_TRX_ACT_S_V l7
56235: WHERE xet.event_id between x_first_event_id and x_last_event_id
56236: and xet.event_date between p_pad_start_date and p_pad_end_date