DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000005_PKG dependencies on AR_CREDIT_MEMO_H_V

Line 69437: WHEN 3 THEN 'AR_CREDIT_MEMO_H_V'

69433: , 0 line_number
69434: , CASE r
69435: WHEN 1 THEN 'AR_SYSTEM_PARAM_H_V'
69436: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
69437: WHEN 3 THEN 'AR_CREDIT_MEMO_H_V'
69438: WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'
69439: WHEN 5 THEN 'AR_CM_BILL_TO_CUST_H_V'
69440: WHEN 6 THEN 'AR_CM_BILL_SITE_USES_H_V'
69441:

Line 69438: WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'

69434: , CASE r
69435: WHEN 1 THEN 'AR_SYSTEM_PARAM_H_V'
69436: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
69437: WHEN 3 THEN 'AR_CREDIT_MEMO_H_V'
69438: WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'
69439: WHEN 5 THEN 'AR_CM_BILL_TO_CUST_H_V'
69440: WHEN 6 THEN 'AR_CM_BILL_SITE_USES_H_V'
69441:
69442: ELSE null

Line 69489: , AR_CREDIT_MEMO_H_V h5

69485: , null source_meaning
69486: FROM xla_events_gt xet
69487: , AR_CM_BILL_SITE_USES_H_V h1
69488: , AR_CM_BILL_TO_CUST_H_V h2
69489: , AR_CREDIT_MEMO_H_V h5
69490: , AR_SYSTEM_PARAM_H_V h8
69491: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
69492: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69493: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 69828: TYPE t_array_source_32 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

69824: --
69825:
69826: TYPE t_array_source_7 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
69827: TYPE t_array_source_8 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
69828: TYPE t_array_source_32 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
69829: TYPE t_array_source_44 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
69830: 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;
69831: 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;
69832:

Line 69829: TYPE t_array_source_44 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

69825:
69826: TYPE t_array_source_7 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
69827: TYPE t_array_source_8 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
69828: TYPE t_array_source_32 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
69829: TYPE t_array_source_44 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
69830: 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;
69831: 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;
69832:
69833: TYPE t_array_source_1 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 69916: , AR_CREDIT_MEMO_H_V h5

69912: , h1.CM_BILL_USES_SITE_USE_ID source_51
69913: FROM xla_events_gt xet
69914: , AR_CM_BILL_SITE_USES_H_V h1
69915: , AR_CM_BILL_TO_CUST_H_V h2
69916: , AR_CREDIT_MEMO_H_V h5
69917: , AR_SYSTEM_PARAM_H_V h8
69918: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
69919: and xet.event_class_code = C_EVENT_CLASS_CODE
69920: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id