[Home] [Help]
188: and aps.trx_date between start_date and nvl(end_date,
189: to_date('31-12-4712','DD-MM-YYYY'))
190: and fcc.enabled_flag = 'Y'
191: and hzca.cust_account_id = rct.bill_to_customer_id
192: and exists (select 'x' from fv_finance_chrg_cust_classes
193: where customer_class = hzca.customer_class_code
194: and enabled_flag = 'Y'
195: and charge_id = fcc.charge_id
196: and set_of_books_id = cv_sob_id)
2066: and exists (select 'x' from fv_cust_finance_chrgs
2067: where hzca.cust_account_id = customer_id
2068: and fcc.charge_id = charge_id
2069: and set_of_books_id = sob_id)
2070: and not exists (select 'x' from fv_finance_chrg_cust_classes
2071: where customer_class = hzca.customer_class_code
2072: and enabled_flag = 'Y'
2073: and charge_id = fcc.charge_id
2074: and set_of_books_id = sob_id));
2105: update fv_cust_finance_chrgs
2106: set waive_flag = 'Y'
2107: where customer_id = customer.customer_id
2108: and charge_id not in
2109: (select charge_id from fv_finance_chrg_cust_classes, hz_cust_Accounts hzca
2110: where hzca.cust_Account_id = customer.customer_id
2111: and customer_class = hzca.customer_class_code
2112: and enabled_flag = 'Y'
2113: and set_of_books_id = sob_id);
2129: and not exists (select 'x' from fv_cust_finance_chrgs
2130: where hzca.cust_account_id = customer_id
2131: and fcc.charge_id = charge_id
2132: and set_of_books_id = sob_id)
2133: and exists (select 'x' from fv_finance_chrg_cust_classes
2134: where customer_class = hzca.customer_class_code
2135: and enabled_flag = 'Y'
2136: and charge_id = fcc.charge_id
2137: and set_of_books_id = sob_id);