APPS.INV_CACHE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 17

      SELECT *
	INTO org_rec
	FROM MTL_PARAMETERS
	WHERE organization_id = p_organization_id;

Line: 42

      SELECT *
	INTO org_rec
	FROM MTL_PARAMETERS
	WHERE organization_code = p_organization_code;

Line: 69

      SELECT *
	INTO item_rec
	FROM MTL_SYSTEM_ITEMS
	WHERE organization_id = p_organization_id
	AND inventory_item_id = p_item_id;

Line: 97

      SELECT *
	INTO tosub_rec
	FROM MTL_SECONDARY_INVENTORIES
	WHERE organization_id = p_organization_id
	AND secondary_inventory_name = p_subinventory_code;

Line: 125

      SELECT *
	INTO fromsub_rec
	FROM MTL_SECONDARY_INVENTORIES
	WHERE organization_id = p_organization_id
	AND secondary_inventory_name = p_subinventory_code;

Line: 150

      SELECT *
	INTO mmtt_rec
	FROM MTL_MATERIAL_TRANSACTIONS_TEMP
	WHERE transaction_temp_id = p_transaction_temp_id;

Line: 174

      SELECT *
	INTO mol_rec
	FROM MTL_TXN_REQUEST_LINES
	WHERE line_id = p_line_id;

Line: 198

      SELECT *
	INTO mtrh_rec
	FROM MTL_TXN_REQUEST_HEADERS
	WHERE header_id = p_header_id;

Line: 222

      SELECT *
	INTO wdd_rec
	FROM WSH_DELIVERY_DETAILS
	WHERE move_order_line_id = p_move_order_line_id;

Line: 256

      SELECT *
	INTO mso_rec
	FROM mtl_sales_orders
	WHERE segment1 = l_order_number
	AND segment2 = l_order_type
	AND segment3 = l_order_source ;

Line: 297

      SELECT *
	INTO  mso_rec
	FROM mtl_sales_orders
	WHERE sales_order_id = p_salesorder_id ;

Line: 328

      SELECT *
	INTO mtt_rec
	FROM MTL_TRANSACTION_TYPES
	WHERE transaction_type_id = p_transaction_type_id;

Line: 420

      SELECT *
	INTO oola_rec
	FROM oe_order_lines_all
	WHERE line_id = p_order_line_id;

Line: 454

      SELECT *
	INTO wpb_rec
	FROM wsh_picking_batches
	WHERE batch_id = p_batch_id;

Line: 461

      SELECT *
	INTO wpb_rec
	FROM wsh_picking_batches
	WHERE name = p_request_number;

Line: 490

       SELECT *
       INTO loc_rec
       FROM MTL_ITEM_LOCATIONS
       WHERE inventory_location_id = p_locator_id
       AND organization_id = p_organization_id;

Line: 532

      SELECT status_id
      INTO moqd_rec.status_id
      FROM MTL_ONHAND_QUANTITIES_DETAIL
      WHERE inventory_item_id = p_inventory_item_id
      AND organization_id = p_organization_id
      AND subinventory_code = p_sub_code
      AND nvl( locator_id, -9999) =nvl(p_loc_id, -9999)
      AND nvl(lot_number, '@@@@') = nvl(p_lot_number, '@@@@')
      AND nvl(lpn_id, -9999) = nvl(p_lpn_id, -9999)
      AND rownum  = 1;