DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000017_PKG dependencies on AR_RCT_SITE_USES_H_V

Line 79281: WHEN 13 THEN 'AR_RCT_SITE_USES_H_V'

79277: WHEN 9 THEN 'AR_SYSTEM_PARAM_H_V'
79278: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
79279: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
79280: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'
79281: WHEN 13 THEN 'AR_RCT_SITE_USES_H_V'
79282: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
79283: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
79284: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
79285: WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'

Line 79378: , AR_RCT_SITE_USES_H_V h6

79374: , null source_meaning
79375: FROM xla_events_gt xet
79376: , AR_CASH_RECEIPTS_H_V h1
79377: , AR_RCT_METHOD_H_V h5
79378: , AR_RCT_SITE_USES_H_V h6
79379: , AR_REMIT_BANK_ACCT_H_V h8
79380: , AR_SYSTEM_PARAM_H_V h9
79381: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
79382: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 79789: TYPE t_array_source_105 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

79785: TYPE t_array_source_25 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
79786: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_CASH_RECEIPT_ID%TYPE INDEX BY BINARY_INTEGER;
79787: TYPE t_array_source_92 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
79788: TYPE t_array_source_104 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
79789: TYPE t_array_source_105 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79790: TYPE t_array_source_106 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
79791: TYPE t_array_source_117 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79792: TYPE t_array_source_118 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79793: TYPE t_array_source_119 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;

Line 79924: , AR_RCT_SITE_USES_H_V h6

79920: , h1.RCT_TRX_ACCT_REVERSAL source_119
79921: FROM xla_events_gt xet
79922: , AR_CASH_RECEIPTS_H_V h1
79923: , AR_RCT_METHOD_H_V h5
79924: , AR_RCT_SITE_USES_H_V h6
79925: , AR_REMIT_BANK_ACCT_H_V h8
79926: , AR_SYSTEM_PARAM_H_V h9
79927: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
79928: and xet.event_class_code = C_EVENT_CLASS_CODE