DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000009_PKG dependencies on AR_CM_BILL_TO_CUST_H_V

Line 70320: WHEN 6 THEN 'AR_CM_BILL_TO_CUST_H_V'

70316: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
70317: WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V'
70318: WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'
70319: WHEN 5 THEN 'AR_CREDIT_MEMO_H_V'
70320: WHEN 6 THEN 'AR_CM_BILL_TO_CUST_H_V'
70321: WHEN 7 THEN 'AR_CM_BILL_SITE_USES_H_V'
70322: WHEN 8 THEN 'AR_CREDIT_MEMO_H_V'
70323:
70324: ELSE null

Line 70378: , AR_CM_BILL_TO_CUST_H_V h2

70374: END source_value
70375: , null source_meaning
70376: FROM xla_events_gt xet
70377: , AR_CM_BILL_SITE_USES_H_V h1
70378: , AR_CM_BILL_TO_CUST_H_V h2
70379: , AR_CREDIT_MEMO_H_V h5
70380: , AR_SYSTEM_PARAM_H_V h8
70381: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
70382: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

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

70699: TYPE t_array_source_19 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
70700: TYPE t_array_source_20 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
70701: TYPE t_array_source_34 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
70702: TYPE t_array_source_46 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%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;

Line 70787: , AR_CM_BILL_TO_CUST_H_V h2

70783: , h1.CM_BILL_USES_SITE_USE_ID source_53
70784: , h5.CM_INVOICING_RULE_ID source_69
70785: FROM xla_events_gt xet
70786: , AR_CM_BILL_SITE_USES_H_V h1
70787: , AR_CM_BILL_TO_CUST_H_V h2
70788: , AR_CREDIT_MEMO_H_V h5
70789: , AR_SYSTEM_PARAM_H_V h8
70790: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
70791: and xet.event_class_code = C_EVENT_CLASS_CODE