[Home] [Help]
168: -- Added extra column to get the Trx_date(invoice_data) March 30, 1999 BG
169: -- rct.trx_date
170: -- bug 992498 commented out rct.trx_date
171: from ar_payment_schedules aps,
172: fv_invoice_finance_chrgs fifc,
173: fv_finance_charge_controls fcc,
174: fv_finance_charge_history fch,
175: ra_customer_trx rct,
176: hz_cust_accounts hzca
2137: and set_of_books_id = sob_id);
2138:
2139: statement_no := 'Invoice';
2140:
2141: insert into fv_invoice_finance_chrgs
2142: (customer_id, customer_trx_id, charge_id,waive_flag, created_by,
2143: creation_date,last_updated_by, last_update_date, set_of_books_id,org_id)
2144: select ract.bill_to_customer_id, ract.customer_trx_id, fcfc.charge_id,
2145: fcfc.waive_flag, 0 , assign_date, 0 , sysdate, sob_id, v_org_id
2157: and nvl(ract.interface_header_attribute3,'XX') not in (select charge_type
2158: from fv_finance_charge_controls
2159: where set_of_books_id = sob_id)
2160: and not exists (select 'x'
2161: from fv_invoice_finance_chrgs
2162: where ract.customer_trx_id = customer_trx_id
2163: and ract.bill_to_customer_id=customer_id
2164: and fcfc.charge_id = charge_id
2165: and set_of_books_id = sob_id);