DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000007_PKG dependencies on AR_CM_BILL_TO_CUST_H_V

Line 55704: WHEN 6 THEN 'AR_CM_BILL_TO_CUST_H_V'

55700: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
55701: WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V'
55702: WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'
55703: WHEN 5 THEN 'AR_CREDIT_MEMO_H_V'
55704: WHEN 6 THEN 'AR_CM_BILL_TO_CUST_H_V'
55705: WHEN 7 THEN 'AR_CM_BILL_SITE_USES_H_V'
55706: WHEN 8 THEN 'AR_CREDIT_MEMO_H_V'
55707:
55708: ELSE null

Line 55762: , AR_CM_BILL_TO_CUST_H_V h2

55758: END source_value
55759: , null source_meaning
55760: FROM xla_events_gt xet
55761: , AR_CM_BILL_SITE_USES_H_V h1
55762: , AR_CM_BILL_TO_CUST_H_V h2
55763: , AR_CREDIT_MEMO_H_V h5
55764: , AR_SYSTEM_PARAM_H_V h8
55765: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
55766: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 56087: TYPE t_array_source_45 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

56083: TYPE t_array_source_12 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
56084: TYPE t_array_source_13 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
56085: TYPE t_array_source_27 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
56086: TYPE t_array_source_39 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
56087: TYPE t_array_source_45 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
56088: TYPE t_array_source_46 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
56089: TYPE t_array_source_52 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
56090:
56091: TYPE t_array_source_9 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 56171: , AR_CM_BILL_TO_CUST_H_V h2

56167: , h1.CM_BILL_USES_SITE_USE_ID source_46
56168: , h5.CM_INVOICING_RULE_ID source_52
56169: FROM xla_events_gt xet
56170: , AR_CM_BILL_SITE_USES_H_V h1
56171: , AR_CM_BILL_TO_CUST_H_V h2
56172: , AR_CREDIT_MEMO_H_V h5
56173: , AR_SYSTEM_PARAM_H_V h8
56174: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
56175: and xet.event_class_code = C_EVENT_CLASS_CODE