DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000002_PKG dependencies on AR_CM_BILL_TO_CUST_H_V

Line 72455: WHEN 8 THEN 'AR_CM_BILL_TO_CUST_H_V'

72451: WHEN 4 THEN 'AR_SYSTEM_PARAM_H_V'
72452: WHEN 5 THEN 'AR_SYSTEM_PARAM_H_V'
72453: WHEN 6 THEN 'AR_CREDIT_MEMO_H_V'
72454: WHEN 7 THEN 'AR_CREDIT_MEMO_H_V'
72455: WHEN 8 THEN 'AR_CM_BILL_TO_CUST_H_V'
72456: WHEN 9 THEN 'AR_CM_BILL_SITE_USES_H_V'
72457:
72458: ELSE null
72459: END object_name

Line 72516: , AR_CM_BILL_TO_CUST_H_V h2

72512: END source_value
72513: , null source_meaning
72514: FROM xla_events_gt xet
72515: , AR_CM_BILL_SITE_USES_H_V h1
72516: , AR_CM_BILL_TO_CUST_H_V h2
72517: , AR_CREDIT_MEMO_H_V h5
72518: , AR_SYSTEM_PARAM_H_V h8
72519: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
72520: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 72861: TYPE t_array_source_72 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

72857: TYPE t_array_source_34 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
72858: TYPE t_array_source_35 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
72859: TYPE t_array_source_51 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
72860: TYPE t_array_source_66 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72861: TYPE t_array_source_72 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
72862: TYPE t_array_source_73 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
72863:
72864: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
72865: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 72952: , AR_CM_BILL_TO_CUST_H_V h2

72948: , h2.CM_BILL_CUST_ACCOUNT_ID source_72
72949: , h1.CM_BILL_USES_SITE_USE_ID source_73
72950: FROM xla_events_gt xet
72951: , AR_CM_BILL_SITE_USES_H_V h1
72952: , AR_CM_BILL_TO_CUST_H_V h2
72953: , AR_CREDIT_MEMO_H_V h5
72954: , AR_SYSTEM_PARAM_H_V h8
72955: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
72956: and xet.event_class_code = C_EVENT_CLASS_CODE