Query to find AR Open Balance Of a Project in Oracle Fusion
WITH FUNCTION get_outstanding_amount ( p_payment_schedule_id IN NUMBER, p_as_of_date IN DATE, p_invoice_type IN VARCHAR2, p_amt_due_remaining IN NUMBER, p_amount_applied IN NUMBER, p_amount_adjusted IN NUMBER, p_amount_credited IN NUMBER, p_amount_in_dispute IN NUMBER, p_amount_adjusted_pending IN …
Read More