DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000008_PKG dependencies on AR_CM_LINES_L_V

Line 55567: WHEN 1 THEN 'AR_CM_LINES_L_V'

55563: FROM (
55564: SELECT xet.event_id event_id
55565: , l3.line_number line_number
55566: , CASE r
55567: WHEN 1 THEN 'AR_CM_LINES_L_V'
55568: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
55569: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
55570: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
55571: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

Line 55579: WHEN 13 THEN 'AR_CM_LINES_L_V'

55575: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
55576: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
55577: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
55578: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
55579: WHEN 13 THEN 'AR_CM_LINES_L_V'
55580: WHEN 14 THEN 'AR_CM_LINES_L_V'
55581: WHEN 15 THEN 'AR_CM_LINES_L_V'
55582:
55583: ELSE null

Line 55580: WHEN 14 THEN 'AR_CM_LINES_L_V'

55576: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
55577: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
55578: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
55579: WHEN 13 THEN 'AR_CM_LINES_L_V'
55580: WHEN 14 THEN 'AR_CM_LINES_L_V'
55581: WHEN 15 THEN 'AR_CM_LINES_L_V'
55582:
55583: ELSE null
55584: END object_name

Line 55581: WHEN 15 THEN 'AR_CM_LINES_L_V'

55577: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
55578: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
55579: WHEN 13 THEN 'AR_CM_LINES_L_V'
55580: WHEN 14 THEN 'AR_CM_LINES_L_V'
55581: WHEN 15 THEN 'AR_CM_LINES_L_V'
55582:
55583: ELSE null
55584: END object_name
55585: , CASE r

Line 55665: , AR_CM_LINES_L_V l4

55661: END source_value
55662: , null source_meaning
55663: FROM xla_events_gt xet
55664: , AR_CM_LINES_BASE_V l3
55665: , AR_CM_LINES_L_V l4
55666: , AR_DISTRIBUTIONS_L_V l6
55667: , AR_RECEIVABLES_TRX_ACT_S_V l7
55668: , (select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
55669: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

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

55816: TYPE t_array_source_43 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
55817: TYPE t_array_source_44 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
55818: TYPE t_array_source_50 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
55819:
55820: TYPE t_array_source_2 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
55821: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
55822: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55823: TYPE t_array_source_14 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
55824: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 55832: TYPE t_array_source_45 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

55828: TYPE t_array_source_39 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
55829: TYPE t_array_source_40 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
55830: TYPE t_array_source_41 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
55831: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
55832: TYPE t_array_source_45 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
55833: TYPE t_array_source_46 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55834: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
55835:
55836: l_array_source_5 t_array_source_5;

Line 55833: TYPE t_array_source_46 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

55829: TYPE t_array_source_40 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
55830: TYPE t_array_source_41 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
55831: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
55832: TYPE t_array_source_45 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
55833: TYPE t_array_source_46 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55834: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
55835:
55836: l_array_source_5 t_array_source_5;
55837: l_array_source_11 t_array_source_11;

Line 55834: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

55830: TYPE t_array_source_41 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
55831: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
55832: TYPE t_array_source_45 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
55833: TYPE t_array_source_46 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55834: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
55835:
55836: l_array_source_5 t_array_source_5;
55837: l_array_source_11 t_array_source_11;
55838: l_array_source_12 t_array_source_12;

Line 55961: , AR_CM_LINES_L_V l4

55957: , l4.CM_LINE_DIST_ACCOUNT_CLASS source_46
55958: , l4.CM_LINE_DIST_AMT source_47
55959: FROM xla_events_gt xet
55960: , AR_CM_LINES_BASE_V l3
55961: , AR_CM_LINES_L_V l4
55962: , AR_DISTRIBUTIONS_L_V l6
55963: , AR_RECEIVABLES_TRX_ACT_S_V l7
55964: WHERE xet.event_id between x_first_event_id and x_last_event_id
55965: and xet.event_date between p_pad_start_date and p_pad_end_date