DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000009_PKG dependencies on AR_CM_LINES_L_V

Line 70454: WHEN 1 THEN 'AR_CM_LINES_L_V'

70450: FROM (
70451: SELECT xet.event_id event_id
70452: , l3.line_number line_number
70453: , CASE r
70454: WHEN 1 THEN 'AR_CM_LINES_L_V'
70455: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
70456: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
70457: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
70458: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

Line 70466: WHEN 13 THEN 'AR_CM_LINES_L_V'

70462: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
70463: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
70464: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
70465: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
70466: WHEN 13 THEN 'AR_CM_LINES_L_V'
70467: WHEN 14 THEN 'AR_CM_LINES_L_V'
70468: WHEN 15 THEN 'AR_CM_LINES_L_V'
70469:
70470: ELSE null

Line 70467: WHEN 14 THEN 'AR_CM_LINES_L_V'

70463: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
70464: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
70465: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
70466: WHEN 13 THEN 'AR_CM_LINES_L_V'
70467: WHEN 14 THEN 'AR_CM_LINES_L_V'
70468: WHEN 15 THEN 'AR_CM_LINES_L_V'
70469:
70470: ELSE null
70471: END object_name

Line 70468: WHEN 15 THEN 'AR_CM_LINES_L_V'

70464: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
70465: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
70466: WHEN 13 THEN 'AR_CM_LINES_L_V'
70467: WHEN 14 THEN 'AR_CM_LINES_L_V'
70468: WHEN 15 THEN 'AR_CM_LINES_L_V'
70469:
70470: ELSE null
70471: END object_name
70472: , CASE r

Line 70552: , AR_CM_LINES_L_V l4

70548: END source_value
70549: , null source_meaning
70550: FROM xla_events_gt xet
70551: , AR_CM_LINES_BASE_V l3
70552: , AR_CM_LINES_L_V l4
70553: , AR_DISTRIBUTIONS_L_V l6
70554: , AR_RECEIVABLES_TRX_ACT_S_V l7
70555: , (select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
70556: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

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

70703: TYPE t_array_source_52 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
70704: TYPE t_array_source_53 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
70705: TYPE t_array_source_69 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
70706:
70707: TYPE t_array_source_9 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
70708: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
70709: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70710: TYPE t_array_source_23 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
70711: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 70719: TYPE t_array_source_54 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

70715: TYPE t_array_source_48 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
70716: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
70717: TYPE t_array_source_50 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
70718: TYPE t_array_source_51 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
70719: TYPE t_array_source_54 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
70720: TYPE t_array_source_55 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70721: TYPE t_array_source_56 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
70722:
70723: l_array_source_2 t_array_source_2;

Line 70720: TYPE t_array_source_55 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

70716: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
70717: TYPE t_array_source_50 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
70718: TYPE t_array_source_51 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
70719: TYPE t_array_source_54 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
70720: TYPE t_array_source_55 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70721: TYPE t_array_source_56 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
70722:
70723: l_array_source_2 t_array_source_2;
70724: l_array_source_19 t_array_source_19;

Line 70721: TYPE t_array_source_56 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

70717: TYPE t_array_source_50 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
70718: TYPE t_array_source_51 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
70719: TYPE t_array_source_54 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
70720: TYPE t_array_source_55 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70721: TYPE t_array_source_56 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
70722:
70723: l_array_source_2 t_array_source_2;
70724: l_array_source_19 t_array_source_19;
70725: l_array_source_20 t_array_source_20;

Line 70848: , AR_CM_LINES_L_V l4

70844: , l4.CM_LINE_DIST_ACCOUNT_CLASS source_55
70845: , l4.CM_LINE_DIST_AMT source_56
70846: FROM xla_events_gt xet
70847: , AR_CM_LINES_BASE_V l3
70848: , AR_CM_LINES_L_V l4
70849: , AR_DISTRIBUTIONS_L_V l6
70850: , AR_RECEIVABLES_TRX_ACT_S_V l7
70851: WHERE xet.event_id between x_first_event_id and x_last_event_id
70852: and xet.event_date between p_pad_start_date and p_pad_end_date