[Home] [Help]
166: G_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%TYPE;
167: G_exchange_rate ap_invoices.exchange_rate%TYPE;
168: G_precision fnd_currencies.precision%TYPE;
169: G_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;
170: G_system_allow_awt_flag ap_system_parameters.allow_awt_flag%TYPE;
171: G_site_allow_awt_flag po_vendor_sites.allow_awt_flag%TYPE;
172: G_transfer_flag ap_system_parameters.transfer_desc_flex_flag%TYPE;
173: G_allow_pa_override varchar2(1);
174: G_pa_expenditure_date_default varchar2(50);
183: G_invoice_date ap_invoices.invoice_date%TYPE;
184: G_expenditure_organization_id pa_exp_orgs_it.organization_id%TYPE;
185: G_asset_book_type_code fa_book_controls.book_type_code%TYPE;
186: G_inventory_organization_id financials_system_parameters.inventory_organization_id%TYPE;
187: G_allow_account_override ap_system_parameters.allow_flex_override_flag%TYPE;
188: G_encumbrance_flag financials_system_parameters.purch_encumbrance_flag%TYPE;
189: G_match_option po_line_locations.match_option%TYPE;
190: G_approval_workflow_flag ap_system_parameters.approval_workflow_flag%TYPE;
191: --G_Ussgl_Transaction_Code ap_invoices.ussgl_transaction_code%TYPE; - Bug 4277744
819: g_vendor_site_id,
820: g_source
821: /* Bug 5572876, using base tables */
822: FROM ap_invoices_all ai ,
823: ap_system_parameters_all asp,
824: ap_suppliers pv,
825: ap_supplier_sites_all pvs,
826: financials_system_params_all fsp,
827: fnd_currencies fc