[Home] [Help]
23: ap_invoices api,
24: ap_terms apt,
25: ap_terms_lines apl,
26: fv_terms_types fvt,
27: --ap_invoice_distributions aid,
28: ap_payment_schedules aps
29: WHERE api.cancelled_amount IS NULL
30: AND api.invoice_type_lookup_code <> 'INTEREST'
31: AND ap_invoices_pkg.get_approval_status(
73: rcv.transaction_date,
74: rcv.po_header_id,
75: rcv.shipment_header_id
76: --pol.quantity_billed
77: FROM ap_invoice_distributions aid,
78: rcv_transactions rcv,
79: po_line_locations pol,
80: po_distributions po
81: WHERE aid.invoice_id = p_invoice_id
85: AND po.line_location_id = pol.line_location_id
86: AND rcv.transaction_type = p_type
87: AND NVL(aid.REVERSAL_FLAG,'N') <> 'Y' --Bug 7646039
88: -- AND rcv.transaction_id = NVL(aid.rcv_transaction_id,rcv.transaction_id)
89: -- and not exists (select 'x' from ap_invoice_distributions aid
90: -- where aid.rcv_transaction_id = rcv.transaction_id)
91: ORDER BY rcv.transaction_type,
92: rcv.transaction_date,
93: rcv.po_line_location_id;
193: v_invoice_num ap_selected_invoices.invoice_num%TYPE;
194: v_terms_id ap_invoices.terms_id%TYPE;
195: v_terms_date ap_invoices.terms_date%TYPE;
196: v_terms_type fv_terms_types.terms_type%TYPE;
197: v_po_distribution_id ap_invoice_distributions.po_distribution_id%TYPE;
198: v_transaction_type rcv_transactions.transaction_type%TYPE;
199: v_po_line_location_id rcv_transactions.po_line_location_id%TYPE;
200: v_transaction_date rcv_transactions.transaction_date%TYPE;
201: v_transaction_id rcv_transactions.transaction_id%TYPE;
404: /* Calculating due date for invoice which has po distribution */
405: v_rec_trxn_flag := 'N';
406:
407: SELECT SUM(quantity_invoiced) INTO v_quantity_billed
408: FROM ap_invoice_distributions
409: WHERE invoice_id = v_invoice_id;
410:
411: FND_FILE.PUT_LINE(FND_FILE.LOG,'Quantity Invoiced is: ' || v_quantity_billed);
412: