DBA Data[Home] [Help]

APPS.FV_DC_ASSIGN_FINANCE_CHRG dependencies on RA_CUST_TRX_TYPES

Line 1694: ra_cust_trx_types rctt,

1690: fv_invoice_finance_chrgs fifc,
1691: fv_finance_charge_controls fcc,
1692: fv_finance_charge_history fch,
1693: ra_customer_trx rct,
1694: ra_cust_trx_types rctt,
1695: hz_cust_site_uses_all rsua,
1696: fv_ar_fin_chrg_invoices fai
1697: WHERE (due_date + first_accrual + grace_period) <= l_accrue_as_of_date
1698: AND fifc.waive_flag = 'N'

Line 2398: ra_cust_trx_types rctt

2394: SYSDATE,
2395: g_login_id,
2396: g_request_id
2397: FROM ra_customer_trx ract,
2398: ra_cust_trx_types rctt
2399: WHERE ract.cust_trx_type_id = rctt.cust_trx_type_id
2400: AND ract.complete_flag = 'Y'
2401: --AND rctt.type IN ('DM','INV')
2402: AND( rctt.type ='INV' OR (rctt.type ='DM' AND NOT EXISTS

Line 2467: ra_cust_trx_types rctt,

2463: 'Y'
2464: FROM ra_customer_trx ract,
2465: fv_cust_finance_chrgs fcfc,
2466: fv_finance_charge_controls fcc,
2467: ra_cust_trx_types rctt,
2468: fv_finance_charge_grp_dtls fcgd,
2469: fv_finance_charge_grp_hdrs fcgh
2470: WHERE ract.bill_to_customer_id = fcfc.customer_id
2471: AND fcfc.set_of_books_id = g_set_of_books_id