Pass check_id from ap_checks_all (aca) to ap_checks_pkg.get_posting_status to pick invoice payments which are not accounted.
ap_checks_pkg.get_posting_status(aca.check_id)
SELECT ffv1.flex_value parent_account ,ffvt1.description parent_account_desc ,ffv2.flex_value child_account ,ffvt2.description...
No comments:
Post a Comment