DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000008_PKG dependencies on AR_CM_BILL_TO_CUST_H_V

Line 55433: WHEN 6 THEN 'AR_CM_BILL_TO_CUST_H_V'

55429: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
55430: WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V'
55431: WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'
55432: WHEN 5 THEN 'AR_CREDIT_MEMO_H_V'
55433: WHEN 6 THEN 'AR_CM_BILL_TO_CUST_H_V'
55434: WHEN 7 THEN 'AR_CM_BILL_SITE_USES_H_V'
55435: WHEN 8 THEN 'AR_CREDIT_MEMO_H_V'
55436:
55437: ELSE null

Line 55491: , AR_CM_BILL_TO_CUST_H_V h2

55487: END source_value
55488: , null source_meaning
55489: FROM xla_events_gt xet
55490: , AR_CM_BILL_SITE_USES_H_V h1
55491: , AR_CM_BILL_TO_CUST_H_V h2
55492: , AR_CREDIT_MEMO_H_V h5
55493: , AR_SYSTEM_PARAM_H_V h8
55494: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
55495: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 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;

55812: TYPE t_array_source_11 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
55813: TYPE t_array_source_12 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
55814: TYPE t_array_source_25 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
55815: TYPE t_array_source_37 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%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;

Line 55900: , AR_CM_BILL_TO_CUST_H_V h2

55896: , h1.CM_BILL_USES_SITE_USE_ID source_44
55897: , h5.CM_INVOICING_RULE_ID source_50
55898: FROM xla_events_gt xet
55899: , AR_CM_BILL_SITE_USES_H_V h1
55900: , AR_CM_BILL_TO_CUST_H_V h2
55901: , AR_CREDIT_MEMO_H_V h5
55902: , AR_SYSTEM_PARAM_H_V h8
55903: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
55904: and xet.event_class_code = C_EVENT_CLASS_CODE