[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
84: AND po.line_location_id = rcv.po_line_location_id
85: AND po.line_location_id = pol.line_location_id
86: AND rcv.transaction_type = p_type
87: -- AND rcv.transaction_id = NVL(aid.rcv_transaction_id,rcv.transaction_id)
88: -- and not exists (select 'x' from ap_invoice_distributions aid
89: -- where aid.rcv_transaction_id = rcv.transaction_id)
90: ORDER BY rcv.transaction_type,
91: rcv.transaction_date,
92: rcv.po_line_location_id;
192: v_invoice_num ap_selected_invoices.invoice_num%TYPE;
193: v_terms_id ap_invoices.terms_id%TYPE;
194: v_terms_date ap_invoices.terms_date%TYPE;
195: v_terms_type fv_terms_types.terms_type%TYPE;
196: v_po_distribution_id ap_invoice_distributions.po_distribution_id%TYPE;
197: v_transaction_type rcv_transactions.transaction_type%TYPE;
198: v_po_line_location_id rcv_transactions.po_line_location_id%TYPE;
199: v_transaction_date rcv_transactions.transaction_date%TYPE;
200: v_transaction_id rcv_transactions.transaction_id%TYPE;
397: /* Calculating due date for invoice which has po distribution */
398: v_rec_trxn_flag := 'N';
399:
400: SELECT SUM(quantity_invoiced) INTO v_quantity_billed
401: FROM ap_invoice_distributions
402: WHERE invoice_id = v_invoice_id;
403:
404: FND_FILE.PUT_LINE(FND_FILE.LOG,'Quantity Invoiced is: ' || v_quantity_billed);
405: