[Home] [Help]
167: G_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%TYPE;
168: G_exchange_rate ap_invoices.exchange_rate%TYPE;
169: G_precision fnd_currencies.precision%TYPE;
170: G_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;
171: G_system_allow_awt_flag ap_system_parameters.allow_awt_flag%TYPE;
172: G_site_allow_awt_flag po_vendor_sites.allow_awt_flag%TYPE;
173: G_transfer_flag ap_system_parameters.transfer_desc_flex_flag%TYPE;
174: G_allow_pa_override varchar2(1);
175: G_pa_expenditure_date_default varchar2(50);
184: G_invoice_date ap_invoices.invoice_date%TYPE;
185: G_expenditure_organization_id pa_exp_orgs_it.organization_id%TYPE;
186: G_asset_book_type_code fa_book_controls.book_type_code%TYPE;
187: G_inventory_organization_id financials_system_parameters.inventory_organization_id%TYPE;
188: G_allow_account_override ap_system_parameters.allow_flex_override_flag%TYPE;
189: G_encumbrance_flag financials_system_parameters.purch_encumbrance_flag%TYPE;
190: G_match_option po_line_locations.match_option%TYPE;
191: G_approval_workflow_flag ap_system_parameters.approval_workflow_flag%TYPE;
192: --G_Ussgl_Transaction_Code ap_invoices.ussgl_transaction_code%TYPE; - Bug 4277744
910: g_source,
911: g_pay_awt_group_id --bug 9689194
912: /* Bug 5572876, using base tables */
913: FROM ap_invoices_all ai ,
914: ap_system_parameters_all asp,
915: ap_suppliers pv,
916: ap_supplier_sites_all pvs,
917: financials_system_params_all fsp,
918: fnd_currencies fc