41: TYPE payment_details_rec IS RECORD (
42: child_id AP_SUPPLIERS.vendor_id%type,
43: parent_id AP_SUPPLIERS.parent_vendor_id%type,
44: invoice_id ap_invoices.invoice_id%type,
45: payment_id ap_invoice_payments.invoice_payment_id%type,
46: invoice_payment_amount ap_invoice_payments.amount%type,
47: discount_amount ap_invoice_payments.discount_taken%type);
48:
49: TYPE all_payments IS TABLE OF payment_details_rec INDEX BY BINARY_INTEGER;
42: child_id AP_SUPPLIERS.vendor_id%type,
43: parent_id AP_SUPPLIERS.parent_vendor_id%type,
44: invoice_id ap_invoices.invoice_id%type,
45: payment_id ap_invoice_payments.invoice_payment_id%type,
46: invoice_payment_amount ap_invoice_payments.amount%type,
47: discount_amount ap_invoice_payments.discount_taken%type);
48:
49: TYPE all_payments IS TABLE OF payment_details_rec INDEX BY BINARY_INTEGER;
50: all_payment_list all_payments;
43: parent_id AP_SUPPLIERS.parent_vendor_id%type,
44: invoice_id ap_invoices.invoice_id%type,
45: payment_id ap_invoice_payments.invoice_payment_id%type,
46: invoice_payment_amount ap_invoice_payments.amount%type,
47: discount_amount ap_invoice_payments.discount_taken%type);
48:
49: TYPE all_payments IS TABLE OF payment_details_rec INDEX BY BINARY_INTEGER;
50: all_payment_list all_payments;
51:
58: aipa.invoice_payment_id payment_id,
59: aipa.amount invoice_payment_amount,
60: aipa.discount_taken discount_amount
61: FROM ap_invoices aia,
62: ap_invoice_payments aipa,
63: ap_checks aca,
64: AP_SUPPLIERS pov,
65: AP_SUPPLIERS pov1,
66: -- Bug 5647413 Start