DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000017_PKG dependencies on AR_CM_BILL_TO_CUST_H_V

Line 68792: WHEN 5 THEN 'AR_CM_BILL_TO_CUST_H_V'

68788: WHEN 1 THEN 'AR_SYSTEM_PARAM_H_V'
68789: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
68790: WHEN 3 THEN 'AR_CREDIT_MEMO_H_V'
68791: WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'
68792: WHEN 5 THEN 'AR_CM_BILL_TO_CUST_H_V'
68793: WHEN 6 THEN 'AR_CM_BILL_SITE_USES_H_V'
68794:
68795: ELSE null
68796: END object_name

Line 68841: , AR_CM_BILL_TO_CUST_H_V h2

68837: END source_value
68838: , null source_meaning
68839: FROM xla_events_gt xet
68840: , AR_CM_BILL_SITE_USES_H_V h1
68841: , AR_CM_BILL_TO_CUST_H_V h2
68842: , AR_CREDIT_MEMO_H_V h5
68843: , AR_SYSTEM_PARAM_H_V h9
68844: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
68845: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 69191: TYPE t_array_source_60 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

69187: TYPE t_array_source_24 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
69188: TYPE t_array_source_25 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
69189: TYPE t_array_source_39 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
69190: TYPE t_array_source_54 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
69191: TYPE t_array_source_60 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
69192: TYPE t_array_source_61 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
69193:
69194: TYPE t_array_source_1 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
69195: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 69278: , AR_CM_BILL_TO_CUST_H_V h2

69274: , h2.CM_BILL_CUST_ACCOUNT_ID source_60
69275: , h1.CM_BILL_USES_SITE_USE_ID source_61
69276: FROM xla_events_gt xet
69277: , AR_CM_BILL_SITE_USES_H_V h1
69278: , AR_CM_BILL_TO_CUST_H_V h2
69279: , AR_CREDIT_MEMO_H_V h5
69280: , AR_SYSTEM_PARAM_H_V h9
69281: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
69282: and xet.event_class_code = C_EVENT_CLASS_CODE