DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000017_PKG dependencies on AR_RECEIVABLES_TRX_MISC_H_V

Line 77773: WHEN 8 THEN 'AR_RECEIVABLES_TRX_MISC_H_V'

77769: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
77770: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
77771: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
77772: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
77773: WHEN 8 THEN 'AR_RECEIVABLES_TRX_MISC_H_V'
77774: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
77775: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
77776: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
77777:

Line 77845: , AR_RECEIVABLES_TRX_MISC_H_V h5

77841: , null source_meaning
77842: FROM xla_events_gt xet
77843: , AR_CASH_RECEIPTS_H_V h1
77844: , AR_RCT_METHOD_H_V h4
77845: , AR_RECEIVABLES_TRX_MISC_H_V h5
77846: , AR_REMIT_BANK_ACCT_H_V h6
77847: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
77848: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77849: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 78145: TYPE t_array_source_91 IS TABLE OF AR_RECEIVABLES_TRX_MISC_H_V.MC_ACT_NAME%TYPE INDEX BY BINARY_INTEGER;

78141: TYPE t_array_source_11 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;
78142: TYPE t_array_source_12 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;
78143: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
78144: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_CASH_RECEIPT_ID%TYPE INDEX BY BINARY_INTEGER;
78145: TYPE t_array_source_91 IS TABLE OF AR_RECEIVABLES_TRX_MISC_H_V.MC_ACT_NAME%TYPE INDEX BY BINARY_INTEGER;
78146: TYPE t_array_source_117 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
78147: TYPE t_array_source_118 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
78148: TYPE t_array_source_119 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
78149:

Line 78229: , AR_RECEIVABLES_TRX_MISC_H_V h5

78225: , h1.RCT_TRX_ACCT_REVERSAL source_119
78226: FROM xla_events_gt xet
78227: , AR_CASH_RECEIPTS_H_V h1
78228: , AR_RCT_METHOD_H_V h4
78229: , AR_RECEIVABLES_TRX_MISC_H_V h5
78230: , AR_REMIT_BANK_ACCT_H_V h6
78231: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
78232: and xet.event_class_code = C_EVENT_CLASS_CODE
78233: and xet.event_status_code <> 'N' AND h5.event_id = xet.event_id