DBA Data[Home] [Help]

APPS.FUN_REPORT_PVT dependencies on FUN_TRX_HEADERS

Line 7: recipient_id FUN_TRX_HEADERS.recipient_id%TYPE,

3:
4: TYPE summaryreport_para_rec_type IS RECORD(
5: batch_type FND_LOOKUPS.lookup_code%TYPE,
6: initiator_id FUN_TRX_BATCHES.initiator_id%TYPE,
7: recipient_id FUN_TRX_HEADERS.recipient_id%TYPE,
8: batch_number_from FUN_TRX_BATCHES.batch_number%TYPE,
9: batch_number_to FUN_TRX_BATCHES.batch_number%TYPE,
10: gl_date_from VARCHAR2(30),
11: gl_date_to VARCHAR2(30),

Line 15: transaction_status FUN_TRX_HEADERS.status%TYPE,

11: gl_date_to VARCHAR2(30),
12: batch_date_from VARCHAR2(30),
13: batch_date_to VARCHAR2(30),
14: batch_status FUN_TRX_BATCHES.status%TYPE,
15: transaction_status FUN_TRX_HEADERS.status%TYPE,
16: trx_type_id FUN_TRX_BATCHES.trx_type_id%TYPE,
17: currency_code FUN_TRX_BATCHES.currency_code%TYPE,
18: invoice_flag FUN_TRX_HEADERS.invoice_flag%TYPE,
19: ar_invoice_number FUN_TRX_HEADERS.ar_invoice_number%TYPE

Line 18: invoice_flag FUN_TRX_HEADERS.invoice_flag%TYPE,

14: batch_status FUN_TRX_BATCHES.status%TYPE,
15: transaction_status FUN_TRX_HEADERS.status%TYPE,
16: trx_type_id FUN_TRX_BATCHES.trx_type_id%TYPE,
17: currency_code FUN_TRX_BATCHES.currency_code%TYPE,
18: invoice_flag FUN_TRX_HEADERS.invoice_flag%TYPE,
19: ar_invoice_number FUN_TRX_HEADERS.ar_invoice_number%TYPE
20: );
21:
22:

Line 19: ar_invoice_number FUN_TRX_HEADERS.ar_invoice_number%TYPE

15: transaction_status FUN_TRX_HEADERS.status%TYPE,
16: trx_type_id FUN_TRX_BATCHES.trx_type_id%TYPE,
17: currency_code FUN_TRX_BATCHES.currency_code%TYPE,
18: invoice_flag FUN_TRX_HEADERS.invoice_flag%TYPE,
19: ar_invoice_number FUN_TRX_HEADERS.ar_invoice_number%TYPE
20: );
21:
22:
23: TYPE accountreport_para_rec_type IS RECORD(

Line 38: transaction_status FUN_TRX_HEADERS.status%TYPE,

34: batch_type FND_LOOKUPS.lookup_code%TYPE,
35: batch_number_from FUN_TRX_BATCHES.batch_number%TYPE,
36: batch_number_to FUN_TRX_BATCHES.batch_number%TYPE,
37: batch_status FUN_TRX_BATCHES.status%TYPE,
38: transaction_status FUN_TRX_HEADERS.status%TYPE,
39: trx_type_id FUN_TRX_BATCHES.trx_type_id%TYPE,
40: currency_code FUN_TRX_BATCHES.currency_code%TYPE,
41: account_type FND_LOOKUPS.lookup_code%TYPE,
42: rec_account_from varchar2(100),

Line 52: ar_invoice_number FUN_TRX_HEADERS.ar_invoice_number%TYPE

48: rec_dist_acc_from varchar2(100),
49: rec_dist_acc_to varchar2(100),
50: coa_initiator gl_ledgers.chart_of_accounts_id%TYPE,
51: coa_recipient gl_ledgers.chart_of_accounts_id%TYPE,
52: ar_invoice_number FUN_TRX_HEADERS.ar_invoice_number%TYPE
53: );
54:
55:
56: PROCEDURE build_summary_outquery(