DBA Data[Home] [Help]

APPS.FUN_REPORT_PVT dependencies on FUN_TRX_BATCHES

Line 6: initiator_id FUN_TRX_BATCHES.initiator_id%TYPE,

2: /* $Header: FUNVRPTS.pls 120.2 2005/04/03 13:39:36 apbalakr noship $ */
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),

Line 8: batch_number_from FUN_TRX_BATCHES.batch_number%TYPE,

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),
12: batch_date_from VARCHAR2(30),

Line 9: batch_number_to FUN_TRX_BATCHES.batch_number%TYPE,

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),
12: batch_date_from VARCHAR2(30),
13: batch_date_to VARCHAR2(30),

Line 14: batch_status FUN_TRX_BATCHES.status%TYPE,

10: gl_date_from VARCHAR2(30),
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,

Line 16: trx_type_id FUN_TRX_BATCHES.trx_type_id%TYPE,

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
20: );

Line 17: currency_code FUN_TRX_BATCHES.currency_code%TYPE,

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
20: );
21:

Line 35: batch_number_from FUN_TRX_BATCHES.batch_number%TYPE,

31: trading_ledger gl_ledgers.ledger_id%type,
32: gl_date_from VARCHAR2(30),
33: gl_date_to VARCHAR2(30),
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,

Line 36: batch_number_to FUN_TRX_BATCHES.batch_number%TYPE,

32: gl_date_from VARCHAR2(30),
33: gl_date_to VARCHAR2(30),
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,

Line 37: batch_status FUN_TRX_BATCHES.status%TYPE,

33: gl_date_to VARCHAR2(30),
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,

Line 39: trx_type_id FUN_TRX_BATCHES.trx_type_id%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),
43: rec_account_to varchar2(100),

Line 40: currency_code FUN_TRX_BATCHES.currency_code%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),
43: rec_account_to varchar2(100),
44: pay_account_from varchar2(100),