APPS.FV_IPAC dependencies on RA_CUSTOMER_TRX

Line 30: parm_currency ra_customer_trx.invoice_currency_code%TYPE;

26: parm_customer_category hz_parties.category_code%TYPE;
27: parm_customer_id hz_parties.party_id%TYPE;
28: parm_trx_date_low DATE;
29: parm_trx_date_high DATE;
30: parm_currency ra_customer_trx.invoice_currency_code%TYPE;
31: parm_contact_name fv_ipac_trx_all.cnt_nm%TYPE;
32: parm_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
33: parm_org_id fv_operating_units.org_id%TYPE;
34: parm_contact_ph_no VARCHAR2(17);

Line 66: v_invoice_currency ra_customer_trx.invoice_currency_code%TYPE;

62: v_trx_excpt_cat fv_ipac_trx_all.exception_category%TYPE;
63: v_trx_exception fv_ipac_trx_all.exception_category%TYPE;
64: v_bulk_exception fv_ipac_trx_all.bulk_exception%TYPE;
65: v_pay_flag VARCHAR2(1) ;
66: v_invoice_currency ra_customer_trx.invoice_currency_code%TYPE;
67: -- Variables to populate who columns
68: v_created_by NUMBER(15);
69: v_creation_date DATE;
70: v_last_updated_by NUMBER(15);

Line 99: ra_customer_trx rct,

95: rsu.Cust_Acct_site_ID bill_to_address_id,
96: rct.invoice_currency_code
97: FROM hz_parties hzp,
98: hz_cust_accounts hzca,
99: ra_customer_trx rct,
100: ra_cust_trx_types rtt,
101: HZ_CUST_SITE_USES rsu ,
102: ar_remit_to_addresses_v arem,
103: fv_facts_customers_v ffc

Line 160: FROM ra_customer_trx_lines rctl,

156: fu.user_name,
157: rgld.percent,
158: rgld.account_class,
159: rctl.customer_trx_line_id
160: FROM ra_customer_trx_lines rctl,
161: ra_cust_trx_line_gl_dist rgld,
162: fnd_user fu,
163: ar_payment_schedules arp
164: WHERE rgld.customer_trx_id = p_customer_trx_id

Line 291: ra_customer_trx rct

287: fit.sender_do_sym,
288: fit.sender_alc,
289: rct.comments comments
290: FROM fv_ipac_trx_all fit,
291: ra_customer_trx rct
292: WHERE fit.org_id = v_org_id
293: AND fit.set_of_books_id = v_set_of_books_id
294: AND fit.customer_trx_id = p_cust_trx_id
295: AND fit.customer_trx_id = rct.customer_trx_id

Line 1213: v_commitment_id ra_customer_trx_all.initial_customer_trx_id%TYPE;

1209: l_valid_flag VARCHAR2(1);
1210: l_ignore_budgetary_flag VARCHAR2(1);
1211: l_drcr_acct Gl_Ussgl_Account_Pairs.dr_account_segment_value%TYPE;
1212: trx_rec fv_ipac_trx_all%ROWTYPE;
1213: v_commitment_id ra_customer_trx_all.initial_customer_trx_id%TYPE;
1214: l_sgl_acct_num gl_code_combinations.segment1%TYPE;
1215: l_module_name VARCHAR2(200) ;
1216: l_bill_to_address_id Number;
1217: BEGIN

Line 1275: FROM Ra_Customer_Trx

1271: trx_rec.contract_no := NULL;
1272: ELSE
1273: SELECT trx_number
1274: INTO trx_rec.contract_no
1275: FROM Ra_Customer_Trx
1276: WHERE customer_trx_id = v_commitment_id;
1277: END IF;
1278: Fv_Utility.Log_Mesg(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Processing Transaction:'||trx_rec.trx_number);
1279: SELECT SUM(amount_due_original),

Line 1604: ra_customer_trx rct

1600: fit.trn_set_id ||
1601: RPAD(NVL(SUBSTR(rct.ct_reference, 1, 8), '' ''), 8, '' '')||
1602: RPAD('' '',2)
1603: FROM fv_ipac_trx fit,
1604: ra_customer_trx rct
1605: WHERE fit.set_of_books_id = :b_set_of_books_id
1606: AND rct.customer_trx_id = fit.customer_trx_id
1607: AND fit.processed_flag = ''N''
1608: AND fit.exclude_flag = ''N''

Line 1920: FROM ra_customer_trx_lines racust,

1916: l_is_line_no:=TRUE;
1917:
1918: SELECT racust.line_number
1919: INTO l_trx_line_no
1920: FROM ra_customer_trx_lines racust,
1921: ar_distributions ardist,
1922: xla_distribution_links xladist
1923: WHERE
1924: xladist.ae_header_id = xla_acnt_rec.ae_header_id

Line 2186: from ra_customer_trx_all

2182: begin
2183: select PAYMENT_TRXN_EXTENSION_ID
2184: into
2185: l_payment_trxn_extension_id
2186: from ra_customer_trx_all
2187: where CUSTOMER_TRX_ID = trx_receipt_rec.customer_trx_id;
2188:
2189: exception
2190: WHEN NO_DATA_FOUND THEN