APPS.XLA_00222_AAD_S_000002_PKG dependencies on AR_DRAWEE_SITE_USES_H_V

Line 68023: WHEN 7 THEN 'AR_DRAWEE_SITE_USES_H_V'

68019: WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V'
68020: WHEN 4 THEN 'AR_SYSTEM_PARAM_H_V'
68021: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
68022: WHEN 6 THEN 'AR_DRAWEE_CUSTOMERS_H_V'
68023: WHEN 7 THEN 'AR_DRAWEE_SITE_USES_H_V'
68024:
68025: ELSE null
68026: END object_name
68027: , CASE r

Line 68075: , AR_DRAWEE_SITE_USES_H_V h4

68071: END source_value
68072: , null source_meaning
68073: FROM xla_events_gt xet
68074: , AR_DRAWEE_CUSTOMERS_H_V h3
68075: , AR_DRAWEE_SITE_USES_H_V h4
68076: , AR_SYSTEM_PARAM_H_V h5
68077: , AR_TRANSACTIONS_S_V h6
68078: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
68079: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 68370: TYPE t_array_source_54 IS TABLE OF AR_DRAWEE_SITE_USES_H_V.DRAW_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

68366: TYPE t_array_source_34 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
68367: TYPE t_array_source_35 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
68368: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
68369: TYPE t_array_source_53 IS TABLE OF AR_DRAWEE_CUSTOMERS_H_V.DRAW_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
68370: TYPE t_array_source_54 IS TABLE OF AR_DRAWEE_SITE_USES_H_V.DRAW_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
68371:
68372: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
68373: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
68374: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 68440: , AR_DRAWEE_SITE_USES_H_V h4

68436: , h3.DRAW_CUST_ACCOUNT_ID source_53
68437: , h4.DRAW_SITE_SITE_USE_ID source_54
68438: FROM xla_events_gt xet
68439: , AR_DRAWEE_CUSTOMERS_H_V h3
68440: , AR_DRAWEE_SITE_USES_H_V h4
68441: , AR_SYSTEM_PARAM_H_V h5
68442: , AR_TRANSACTIONS_S_V h6
68443: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
68444: and xet.event_class_code = C_EVENT_CLASS_CODE