DBA Data[Home] [Help]

APPS.FV_STATUS_OF_OBLIGATIONS dependencies on AP_INVOICES

Line 62: v_invnum ap_invoices.invoice_num%type;

58: v_po_req_distribution_id
59: po_req_distributions.distribution_id%type ;
60: v_po_distribution_id po_distributions.po_distribution_id%type ;
61:
62: v_invnum ap_invoices.invoice_num%type;
63: v_invdate date;
64: v_invamt number;
65: v_invccid number;
66: v_reversal_flag Varchar2(1) ;

Line 190: ap_invoices api,

186: apd.amount,
187: apd.dist_code_combination_id,
188: apd.po_distribution_id ' || v_val_string
189: || ' from ap_invoice_distributions apd,
190: ap_invoices api,
191: gl_code_combinations glcc
192: where api.invoice_id = apd.invoice_id
193: and glcc.code_combination_id = apd.dist_code_combination_id
194: and (api.invoice_date between :b_from_period and :b_to_period)