eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FUN_RECIPIENT_WF dependencies on GL_LEDGERS

Line 2671: gl_ledgers l

2667: ,b.gl_date
2668: FROM fun_trx_batches b,
2669: fun_trx_headers t,
2670: fun_trx_types_vl y,
2671: gl_ledgers l
2672: WHERE b.batch_id = t.batch_id
2673: AND b.trx_type_id = y.trx_type_id
2674: AND t.to_ledger_id = l.ledger_id
2675: AND t.trx_id = p_trx_id;

Line 2723: l_to_coa_id gl_ledgers.chart_of_accounts_id%TYPE;

2719: l_init_count NUMBER;
2720: l_reci_count NUMBER;
2721: l_to_bsv VARCHAR2(30);
2722:
2723: l_to_coa_id gl_ledgers.chart_of_accounts_id%TYPE;
2724: l_from_coa_id gl_ledgers.chart_of_accounts_id%TYPE;
2725: l_invoice_flag fun_trx_headers.invoice_flag%TYPE;
2726: l_insert_flag VARCHAR2(1) := 'N';
2727:

Line 2724: l_from_coa_id gl_ledgers.chart_of_accounts_id%TYPE;

2720: l_reci_count NUMBER;
2721: l_to_bsv VARCHAR2(30);
2722:
2723: l_to_coa_id gl_ledgers.chart_of_accounts_id%TYPE;
2724: l_from_coa_id gl_ledgers.chart_of_accounts_id%TYPE;
2725: l_invoice_flag fun_trx_headers.invoice_flag%TYPE;
2726: l_insert_flag VARCHAR2(1) := 'N';
2727:
2728: BEGIN

Line 2895: from gl_ledgers l

2891: END IF;
2892:
2893: SELECT l.chart_of_accounts_id
2894: INTO l_from_coa_id
2895: from gl_ledgers l
2896: WHERE l.ledger_id = l_trx_dtl_rec.from_ledger_id;
2897:
2898: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2899: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'l_from_coa_id = ' || l_from_coa_id);

Line 3356: from gl_ledgers l

3352:
3353:
3354: SELECT l.chart_of_accounts_id
3355: INTO l_to_coa_id
3356: from gl_ledgers l
3357: WHERE l.ledger_id = l_trx_dtl_rec.to_ledger_id;
3358:
3359: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3360: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'recipient coa id = ' || l_to_coa_id);

Line 3910: gl_ledgers l

3906: ,b.gl_date
3907: FROM fun_trx_batches b,
3908: fun_trx_headers t,
3909: fun_trx_types_vl y,
3910: gl_ledgers l
3911: WHERE b.batch_id = t.batch_id
3912: AND b.trx_type_id = y.trx_type_id
3913: AND t.to_ledger_id = l.ledger_id
3914: AND t.trx_id = p_trx_id;