DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000008_PKG dependencies on AR_CM_BILL_SITE_USES_H_V

Line 55434: WHEN 7 THEN 'AR_CM_BILL_SITE_USES_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
55438: END object_name

Line 55490: , AR_CM_BILL_SITE_USES_H_V h1

55486: ELSE null
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)

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

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;
55821: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 55899: , AR_CM_BILL_SITE_USES_H_V h1

55895: , h2.CM_BILL_CUST_ACCOUNT_ID source_43
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