DBA Data[Home] [Help]

APPS.FV_DUE_DATE_CALCULATION dependencies on AP_SELECTED_INVOICES

Line 190: -- AP_SELECTED_INVOICES table. The variable v_invoice_id is to be

186: CONNECT BY transaction_id = PRIOR parent_transaction_id
187: ORDER BY transaction_date desc;
188:
189: -- CURSOR c1_main_select selects a set of INVOICE_ID records from
190: -- AP_SELECTED_INVOICES table. The variable v_invoice_id is to be
191: -- used in CURSOR c2_accept.
192: v_invoice_id ap_selected_invoices.invoice_id%TYPE;
193: v_invoice_num ap_selected_invoices.invoice_num%TYPE;
194: v_terms_id ap_invoices.terms_id%TYPE;

Line 192: v_invoice_id ap_selected_invoices.invoice_id%TYPE;

188:
189: -- CURSOR c1_main_select selects a set of INVOICE_ID records from
190: -- AP_SELECTED_INVOICES table. The variable v_invoice_id is to be
191: -- used in CURSOR c2_accept.
192: v_invoice_id ap_selected_invoices.invoice_id%TYPE;
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;

Line 193: v_invoice_num ap_selected_invoices.invoice_num%TYPE;

189: -- CURSOR c1_main_select selects a set of INVOICE_ID records from
190: -- AP_SELECTED_INVOICES table. The variable v_invoice_id is to be
191: -- used in CURSOR c2_accept.
192: v_invoice_id ap_selected_invoices.invoice_id%TYPE;
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;