APPS.FV_GEN_ARTRX_REIMB_PROC dependencies on RA_CUSTOMER_TRX_ALL

Line 17: g_customer_id NUMBER; --ra_customer_trx_all.bill_to_customer_id%TYPE;

13: g_log_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
14: g_module_name VARCHAR2(50) := 'fv.plsql.fv_gen_artrx_reimb_proc.';
15: g_errbuf VARCHAR2(500);
16: g_retcode NUMBER := 0;
17: g_customer_id NUMBER; --ra_customer_trx_all.bill_to_customer_id%TYPE;
18: g_currency VARCHAR2(30):='USD'; --ra_customer_trx_all.invoice_currency_code%TYPE;
19: g_coll_hdr_tbl ar_invoice_api_pub.trx_header_tbl_type;
20: g_rec_hdr_tbl ar_invoice_api_pub.trx_header_tbl_type;
21: g_coll_lines_tbl ar_invoice_api_pub.trx_line_tbl_type;

Line 18: g_currency VARCHAR2(30):='USD'; --ra_customer_trx_all.invoice_currency_code%TYPE;

14: g_module_name VARCHAR2(50) := 'fv.plsql.fv_gen_artrx_reimb_proc.';
15: g_errbuf VARCHAR2(500);
16: g_retcode NUMBER := 0;
17: g_customer_id NUMBER; --ra_customer_trx_all.bill_to_customer_id%TYPE;
18: g_currency VARCHAR2(30):='USD'; --ra_customer_trx_all.invoice_currency_code%TYPE;
19: g_coll_hdr_tbl ar_invoice_api_pub.trx_header_tbl_type;
20: g_rec_hdr_tbl ar_invoice_api_pub.trx_header_tbl_type;
21: g_coll_lines_tbl ar_invoice_api_pub.trx_line_tbl_type;
22: g_rec_lines_tbl ar_invoice_api_pub.trx_line_tbl_type;

Line 372: FROM fnd_flex_values_vl f, fnd_id_flex_segments segs, ra_customer_trx_all r,

368: log(C_STATE_LEVEL, l_module, 'Child values of g_advance_acc: '||l_adv_child);
369:
370: l_sql_agree_range :=
371: 'SELECT f.flex_value
372: FROM fnd_flex_values_vl f, fnd_id_flex_segments segs, ra_customer_trx_all r,
373: ra_cust_trx_types_all t
374: WHERE f.flex_value_set_id =segs.flex_value_set_id AND
375: segs.application_column_name = :g_reimb_agreement_segment AND
376: segs.application_id = 101 AND

Line 463: FROM ra_customer_trx_all

459:
460:
461: SELECT bill_to_customer_id
462: INTO g_customer_id
463: FROM ra_customer_trx_all
464: WHERE trx_number = g_agreement_num
465: AND invoice_currency_code = g_currency;
466:
467: EXCEPTION

Line 701: from ra_customer_trx_all rct,

697: l_reimb_agree_num:= g_agreement_num;
698: log(C_STATE_LEVEL, l_module, 'l_reimb_agree_num: '||l_reimb_agree_num);
699: BEGIN
700: Select rtt.name into l_terms
701: from ra_customer_trx_all rct,
702: ra_terms rtt
703: where rct.term_id=rtt.term_id
704: and rct.trx_number = l_reimb_agree_num
705: and rct.set_of_books_id = g_ledger_id;

Line 853: FROM ra_customer_trx_all rct,

849: -- As per FD the Reimbursible Agreement Trx will have only one Revenue Line.
850:
851: SELECT rctd.code_combination_id
852: into l_agreement_rev_ccid
853: FROM ra_customer_trx_all rct,
854: RA_CUST_TRX_LINE_GL_DIST_ALL rctd
855: WHERE rct.trx_number = p_agreement
856: AND rct.customer_trx_id = rctd.customer_trx_id
857: AND rctd.account_class = 'REV'