[Home] [Help]
122: ,ap_invoice_distributions item
123: ,ap_invoices pp
124: ,ap_invoice_distributions ppdis
125: ,ap_checks chk
126: ,ap_invoice_payments aip
127: ,ap_invoice_lines apl
128: ,zx_lines zl
129: ,zx_lines_det_factors zldf
130: WHERE ( ( P_LEDGER_ID IS NULL AND P_COMPANY IS NULL AND inv.legal_entity_id = G_LE_ID )
857: zx_rates_b tax,
858: ap_invoices inv,
859: ap_invoice_distributions dis,
860: po_vendors ven,
861: ap_invoice_payments aip,
862: ap_checks_all chk,
863: ap_invoice_distributions acctinfo
864: WHERE ((p_ledger_id IS NULL
865: AND p_company IS NULL
1502: ,p_start_date DATE
1503: ,p_end_date DATE)
1504: IS
1505: SELECT SUM(nvl(p.invoice_base_amount, p.amount)) amount
1506: FROM ap_invoice_payments p
1507: WHERE p.invoice_id = p_invoice_id
1508: AND p.accounting_date BETWEEN p_start_date AND p_end_date;
1509:
1510: CURSOR c_get_prepay_amount ( p_invoice_id NUMBER
1704: IS
1705: SELECT SUM(nvl(dis.base_amount, dis.amount) * aip.discount_lost / p_real_inv_amt) amount
1706: FROM ap_invoice_distributions dis
1707: ,zx_rates_b tax
1708: ,ap_invoice_payments aip
1709: ,ap_invoices inv
1710: WHERE dis.line_type_lookup_code NOT IN ('TAX', 'PREPAY')
1711: AND inv.invoice_id = dis.invoice_id
1712: AND inv.invoice_id = aip.invoice_id
1722: IS
1723: SELECT SUM(nvl(dis.base_amount, dis.amount) * aip.discount_lost / p_real_inv_amt) amount
1724: FROM ap_invoice_distributions dis
1725: ,zx_rates_b tax
1726: ,ap_invoice_payments aip
1727: ,ap_invoices inv
1728: WHERE dis.line_type_lookup_code NOT IN ('TAX', 'PREPAY')
1729: AND inv.invoice_id = dis.invoice_id
1730: AND inv.invoice_id = aip.invoice_id
2023: ,p_start_date DATE
2024: ,p_end_date DATE)
2025: IS
2026: SELECT SUM(nvl(disc.discount_taken, 0)) discount_taken
2027: FROM ap_invoice_payments disc
2028: ,ap_checks chk
2029: WHERE disc.invoice_id = p_invoice_id
2030: AND disc.check_id = chk.check_id
2031: AND nvl(chk.future_pay_due_date, chk.check_date) BETWEEN