282: at shipment level should be defaulted from ap_product_setup table.
283: */
284: /* SELECT fsp.match_option
285: INTO x_invoice_match_option
286: FROM financials_system_parameters fsp;
287: end if;
288: */
289: SELECT aps.match_option
290: INTO x_invoice_match_option
639: inspection_required_flag
640: INTO X_receipt_required_flag_tmp,
641: X_inspection_required_flag_tmp
642: FROM mtl_system_items,
643: financials_system_parameters
644: WHERE inventory_item_id = X_item_id
645: AND organization_id = inventory_organization_id;
646:
647: -- bug 413511