DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000006_PKG dependencies on AR_CM_BILL_TO_CUST_H_V

Line 71561: WHEN 6 THEN 'AR_CM_BILL_TO_CUST_H_V'

71557: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
71558: WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V'
71559: WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'
71560: WHEN 5 THEN 'AR_CREDIT_MEMO_H_V'
71561: WHEN 6 THEN 'AR_CM_BILL_TO_CUST_H_V'
71562: WHEN 7 THEN 'AR_CM_BILL_SITE_USES_H_V'
71563: WHEN 8 THEN 'AR_CREDIT_MEMO_H_V'
71564:
71565: ELSE null

Line 71619: , AR_CM_BILL_TO_CUST_H_V h2

71615: END source_value
71616: , null source_meaning
71617: FROM xla_events_gt xet
71618: , AR_CM_BILL_SITE_USES_H_V h1
71619: , AR_CM_BILL_TO_CUST_H_V h2
71620: , AR_CREDIT_MEMO_H_V h5
71621: , AR_SYSTEM_PARAM_H_V h8
71622: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
71623: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 71944: TYPE t_array_source_50 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

71940: TYPE t_array_source_18 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
71941: TYPE t_array_source_19 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
71942: TYPE t_array_source_32 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
71943: TYPE t_array_source_44 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
71944: TYPE t_array_source_50 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
71945: TYPE t_array_source_51 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
71946: TYPE t_array_source_67 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
71947:
71948: TYPE t_array_source_2 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 72028: , AR_CM_BILL_TO_CUST_H_V h2

72024: , h1.CM_BILL_USES_SITE_USE_ID source_51
72025: , h5.CM_INVOICING_RULE_ID source_67
72026: FROM xla_events_gt xet
72027: , AR_CM_BILL_SITE_USES_H_V h1
72028: , AR_CM_BILL_TO_CUST_H_V h2
72029: , AR_CREDIT_MEMO_H_V h5
72030: , AR_SYSTEM_PARAM_H_V h8
72031: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
72032: and xet.event_class_code = C_EVENT_CLASS_CODE