DBA Data[Home] [Help]

APPS.FV_DUE_DATE_CALCULATION dependencies on AP_SELECTED_INVOICES

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

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

Line 191: v_invoice_id ap_selected_invoices.invoice_id%TYPE;

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

Line 192: v_invoice_num ap_selected_invoices.invoice_num%TYPE;

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